[DimensionX]

Hi,

I'm trying to make a dropdown box pull it's contents from a table called client but the page isn't loading it just goes blank and without the dropdown it loads fine so I've obviously messed this up, it connects to the database ok but just doesn't like what i did with the drop down.

PHP Code:

<td>Referred by:</td><td><select name="referredBy" tabindex="11">

            <option value="">Please select a client or the value None</option>

            <option value="None">None</option>

            

            <?php

            //Assign the query

            $query = "SELECT * FROM client ORDER BY clientId ASC";



            //Execute the query

            $result = mysql_query( $query );

            if(!$result){

                die ("Could not query the database: <br />". mysql_error());

            }

            

            while ($result_row = mysql_fetch_array($result, MYSQL_ASSOC)){

            {

                echo '<option value="' . $result_row["clientId"] . '">'. $result_row["clientId"] . ' ' .                   $result_row["firstName"] . ' ' . $result_row["surName"]  . '</option>';

            }

            

            ?>

            </select></td>

any help would be greatly appreciated, I'm still really new at php so I'm sorry if my code isn't clearly laid out.

thanks

[DimensionX]

I found the solution after going through many many sites and getting nothing then coming back and combing through this one and finally finding the solution lol, I had to adapt it a bit but it works:

PHP Code:

<table>

        <tr>

            <td>Referred by:</td><td><select name="referredBy" tabindex="11">

            <option value="">Please select a client or the value None</option>

            <option value="None">None</option>

            

            <?php

            //Assign the query

            $query="SELECT `clientId`, `firstName`, 'surName' FROM `client` ORDER BY `clientId` ASC";



            //Execute the query

            $result = mysql_query( $query );

            if(!$result){

                die ("Could not query the database: <br />". mysql_error());

            }

            

            while ($data=mysql_fetch_assoc($result)){

                

                echo "<option value = \"{$data[clientId]}\" >{$data[clientId]} {$data[firstName]} {$data[surName]}</option>\n";

            } 

            ?>

            </select></td>

        </tr>

    </table>

Now I'm still not quite sure, I mean I'm glad it works but I'ld like to understand the code. why is there a slash here \"{$data[clientId]}\" ....or is it a combination fo the \ and " that allows a quote to be used without interrupting the code? I understand the rest just not that bit.

[Jcbones]

Originally Posted by DimensionX

I found the solution after going through many many sites and getting nothing then coming back and combing through this one and finally finding the solution lol, I had to adapt it a bit but it works:

PHP Code:

<table>

        <tr>

            <td>Referred by:</td><td><select name="referredBy" tabindex="11">

            <option value="">Please select a client or the value None</option>

            <option value="None">None</option>

            

            <?php

            //Assign the query

            $query="SELECT `clientId`, `firstName`, 'surName' FROM `client` ORDER BY `clientId` ASC";



            //Execute the query

            $result = mysql_query( $query );

            if(!$result){

                die ("Could not query the database: <br />". mysql_error());

            }

            

            while ($data=mysql_fetch_assoc($result)){

                

                echo "<option value = \"{$data[clientId]}\" >{$data[clientId]} {$data[firstName]} {$data[surName]}</option>\n";

            } 

            ?>

            </select></td>

        </tr>

    </table>

Now I'm still not quite sure, I mean I'm glad it works but I'ld like to understand the code. why is there a slash here \"{$data[clientId]}\" ....or is it a combination fo the \ and " that allows a quote to be used without interrupting the code? I understand the rest just not that bit.

Sorry I missed your post.

You are correct in the the slash \ escapes the ". if the echo statement starts with a single quote ' you would not have to escape the double quote " and vice versa.

The fun is when your trying to build multiple select boxes from a query... but if you search hard enough, you can find that too.

or,

http://www.hotscripts.com/forums/php...ic-titles.html