Jump to content


Photo

select box + SQL


  • Please log in to reply
3 replies to this topic

#1 Possibility

Possibility
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 21 August 2003 - 12:11 PM

I am trying to make a select box that automatically displays and updates the names of the strategies, and when clicked takes you to that respective strat.

// Create a table.print ("<TABLE WIDTH="60%" BORDER=1 BORDERCOLOR=#000000 CELLSPACING=0 CELLPADDING=4 ALIGN=CENTER  class=content>n" );  print ("<TR ALIGN=CENTER VALIGN=TOP>n" );  print ("<TD ALIGN=left VALIGN=TOP colspan=2>   <form action="egyptian2.php" method=post>    <select name="Display" id="Display">  while($row = mysql_fetch_array($result)) {       echo \'<option value="\', $row[God], \'">\' , $row[God], \'</option>\';    }    </select>    <input type="submit" name="Display" value="Display"> </TD>n" );print ("</TR>n" );

Look here:

http://www.the-barra...m/egyptian2.php

No strat names are displayed (strat and god are switched around, for some reason)

#2 pallevillesen

pallevillesen
  • Members
  • PipPipPip
  • Advanced Member
  • 135 posts
  • LocationDenmark

Posted 21 August 2003 - 12:39 PM

Typo in code...

CHeck the resulting page source....

 <form action="egyptian2.php" method=post>    <select name="Display" id="Display">  while( = mysql_fetch_array()) {       echo \'<option value="\', , \'">\' , , \'</option>\';    }    </select>    <input type="submit" name="Display" value="Display">

P.
Palle Villesen, www.birc.dk [br]Bioinformatics Research Center

#3 Possibility

Possibility
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 21 August 2003 - 02:38 PM

<form action="egyptian2.php" method=post>    <select name="Display" id="Display"> while( = mysql_fetch_array()) {       echo \'<option value="\', $row[God], \'">\' , $row[God], \'</option>\';    }    </select>    <input type="submit" name="Display" value="Display">

Doesn\'t work :(

Once I fixed the parse errors it still didn\'t show any results.

#4 Possibility

Possibility
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 21 August 2003 - 06:00 PM

When I was displaying the data on a previous system, I would use $Row[God] (not in a select box, just for setting up the title/information of the text results) and it would display properly. I just looked at the source code, and found this where the select box is (even though this doesn\'t show up on the page)

<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/home/the-barr/public_html/aom/egyptian2.php</b> on line <b>38</b><br />

Line 38 is:

  while($row = mysql_fetch_array($result)) {

To put it in context:

<table WIDTH="60%" BORDER=1 BORDERCOLOR=#000000 CELLSPACING=0 CELLPADDING=4 ALIGN=CENTER  class=content>    <tr align="center" valign="top">    <td align="center" valign="top" colspan="2">    <form action="egyptian2.php" method="post">    <select name="Display" id="Display"> <br /><b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/home/the-barr/public_html/aom/egyptian2.php</b> on line <b>38</b><br />    </select>    <input type="submit" name="Display" value="Display">    </td> </tr> <tr align="center" valign="top"> <td align="center" valign="top" colspan="2">Egyptian Strategies</td> </tr> </table>

I have changed the code to this:

//... Code above ?>    <tr align="center" valign="top">    <td align="center" valign="top" colspan="2">    <form action="egyptian2.php" method="post">    <select name="Display" id="Display"> <?php    while($row = mysql_fetch_array($result)) {       echo \'<option value="\', $row[\'God\'], \'">\' , $row[\'God\'], \'</option>\';    } ?>    </select>    <input type="submit" name="Display" value="Display">    </td> </tr> <tr align="center" valign="top"> <td align="center" valign="top" colspan="2">Egyptian Strategies</td> </tr> <?php //..CODE below





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users