Fetching rows from table and show them in a dropbox

Shadeless

Some1 wrote some code earlier today, and i tried the code myself, but somehow i have done something wrong. At the line where while starts i get an error. The code is for getting rows from 1 field out of a table from a mysql database

I am newbie, so i probaly am just forgetting something stupid. I would be realy happy of some1 could help me by taking a small peek on the code,

the code:

<?php printf("<form method=post action=test.php");

$usr = "root";
$pwd = "";
$db = "knowledgebase";
$host = "localhost";

mysql_connect($host,$usr,$pwd);

$sql_result = mysql_query("SELECT xrd FROM category");

while ($myrow = mysql_fetch_array($sql_result)) {

$category = $myrow["category"];
$option_block .= "<OPTION value=\"$category\">$category</OPTION>";
;
}

<?
echo "Submitted value:".$category;

<b><font face=Verdana, Arial, Helvetica, sans-serif size=3>Category:</b></font>
<form name="testForm" action="test.php">
<SELECT name="Category">

<?php echo "$option_block"; ?>

</SELECT><BR>
<input type="submit" value="Send">
</form>

with kind regards,

Shadeless

hrosas

Hi I see that you didn't select a db with:
bool mysql_select_db ( string database_name [, resource link_identifier])
as you didn't select adb the query is not working, and that's
why you get an error. It'd bew nice if you post you error next time you have a problem, and add an user to you database. hope that work.

Hector

http://www.oksonora.com

theeper

Also, for you associative array of results to be proper, I think you will need to use a wildcard in your SELECT query.

Something like this ...
$sql_result = mysql_query("SELECT * FROM category");

Or else use mysql_fetch_row() down farther in your script and use a numerical array.

zalath

Actually, listing the fields will do as well for the associative array. A query like SELECT xrd FROM category will only assing a value to $myrow["xrd"], but it's still an associative array.

Shadeless

thx guys, yes i only now notice i was so stupid to forget a db selection.

thx will try it 🙂

ow yes next time i will post the error to, sorry for that

Shadeless

the error's are fixed 🙂 so at least i'm helped with that.

Only the dropbox stays empty.

The field i want to select the rows out of, is called xrd. i get 6 empty spaces for it.

Is the $category wrong or something?..

hrosas

I hope you have fixed your problem but if not here's a hint.

your problem is your query, you only select the field xdr but never the field category, if you want to select the field xdr you should use $xdr = myrow["xdr"], and it's avaylable because in your query you did SELECT xdr FROM ------ if you want to add the fields category to the query just write SELECT xdr, category FROM ....
Hope that helps.