Forms

[ci_liam]

hi need some help
i have some forms in dreamweaver, one has a list box i want to capture items in one particular column of a table in my mysql database so that they appear in the list/menu box. how do i go about it?
🙂

[LarsLai]

hi!
try something like this:

echo "<select name='mylistbox'>";
$sql = "SELECT yourfield From yourdatabase";
$result = mysql_query($sql, $conn)
 or die(mysql_error());
while($row = mysql_fetch_array($result)) {
 echo "<option>" . $row[0] . "</option>";
}
echo "</select>";

[chyan]

echo "<select name='yourname' size='1'>

$query="select * from your table";
if(!($result=mysql_query($query,$db))){
echo mysql_error();
exit;
}
echo ("<option value=->-\n");
while ($row=mysql_fetch_array($result)){
echo ("<option value=$row[0]>$row[1]\n");
}

echo "</select>";

[ci_liam]

thanks for your help but just wondering whether you;d explain to me the line:
$result = mysql_query($sql, $conn)
what does $sql, $conn stand for? my data base is called "cat " and the server is called "everest".

[chyan]

$conn is your database connection
$sql is your query to database

but you must connect to mysql before you can used the database
you can used example below for your script

$Host="everest";

$User="yourDBusername";
$Password="yourDBpassword";
$DBName="cat";

if(!$conn=mysql_connect($Host, $User, $Password))
{
echo mysql_error();
exit;
}

mysql_select_db($DBname,$conn);

[ci_liam]

hi thanks so much for your enormous help,
i have yet another problem i keep getting this error on my php pages. am a bit frustrated coz i just can't see what the problem is. please help 🙁

thanks in advance.

Warning: main(Connections/ci_liam.php): failed to open stream: No such file or directory in C:\Inetpub\wwwroot\CI_LIAM\dnotes.php on line 1

Fatal error: main(): Failed opening required 'Connections/ci_liam.php' (include_path='.;c:\php4\pear') in C:\Inetpub\wwwroot\CI_LIAM\dnotes.php on line 1

I think it has something to do with a particular folder i don't have please jumpstart my intelligence for me, someone!

[chyan]

Warning: main(Connections/ci_liam.php): failed to open stream: No such file or directory in C:\Inetpub\wwwroot\CI_LIAM\dnotes.php on line 1

you shall check whether the file ('Connections/ci_liam.php') is present on your server directory

that error massage appears because file that you point at dnotes.php could not be found.

or maybe your wron syntax, i guess, try change it to 'connections\ci_liam.php'