|
|
Posted by Jeff North on 06/17/07 21:44
On Sun, 17 Jun 2007 06:28:25 -0700, in comp.lang.php
sooseong.ng@gmail.com
<1182086905.448400.179110@a26g2000pre.googlegroups.com> wrote:
>| Hi,
>|
>| I am a newbie and recently just delved into the scripting world of
>| PHP. Currently I am doing
>| a webform that consists many fields. I have three combobox with state
>| selection which
>| will retrieve the items from a database table called state. The
>| dumbest and direct way would
>| be creating a connection and querying the data each time, which means
>| three connections
>| connected just to querying same piece of information. I am wondering
>| if it is possible to
>| refactor them into using one connection to query the states, and
>| assign the value to each
>| combobox. Then i will need not to query thrice. Any idea?
You are probably using
q1 = SELECT ID,Field1 FROM table
q2 = SELECT ID,Field2 FROM table
q3 = SEELCT ID,Field3 FROM table
You can join these into a single query
q = SELCT ID, Field1,Field2,Field3 FROM table
then build your comboboxs using only the required field(s).
---------------------------------------------------------------
jnorthau@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------
Navigation:
[Reply to this message]
|