Display results from db?

[bizchris2001]

I've been RTFM and Searched for over an hour, I think I'm close to an answer here but can't seem to get it. I'm connecting to my db, and this much works:

<?
mysql_select_db('MyDB');
$user_query = mysql_query("select Type from tbl_flowers");
echo mysql_num_rows($user_query);

However, I don't just want to count the rows (it's just that's all I could get to work :p) - I want to display the results (in this case, Rose, Tulip, Chrysanthemum, etc.) Here's where it breaks down - are either of these close to correct? Thanks!

Chris

echo $user_query;  <----which returns "Resource id #2" for some reason

OR

mysql_fetch_array($user_query);  <-------
echo $user_query["Type"];  <---- these two lines display nothing

?>

P.S.- Hi Tekky, I know you're going to see this. 😃

[laserlight]

<?php
//assume DB server has been connected to
mysql_select_db('MyDB'); //select the appropriate DB
//now send the query
$user_query = mysql_query("select Type from tbl_flowers");
//loop through the result set
//mysql_fetch_assoc() can also be used in this case
while ($row = mysql_fetch_array($user_query)) {
	echo $row['Type'] . '<br>';
}
?>

[bizchris2001]

Beautiful, that did it exactly! Thanks - so you always need to loop when retrieving results? Also, I made it a dropdown just for fun:

<select>
<option>
<?
mysql_select_db('MyDb');
$user_query = mysql_query("select Type from tbl_flowers");
while ($row = mysql_fetch_array($user_query)) {
echo $row['Type'] . '<option>';
}
?>
</option>
</select>

(I realize I didn't close however many options there may be)
What if I wanted to add an input so a user could change a db value they chose from the dropdown (ie, "change Rose to _____")? I think finishing my research on writing to dbs will get the job done, but just in case, any tips to help me avoid the pitfalls? Thanks!

Chris 🙂

I'll mark this thread resolved as I got a great solution, but would like to hear suggestions on the above questions as well.

[laserlight]

if your result set only consists of 1 row, you dont need to loop.

as for your question, I suggest that you just try and see 🙂

[drawmack]

please mark resolved threads as resolved. Also if you go here: http://www.php.net they have the php manual online with a search feature.

[laserlight]

drawmack, you have to read the post too :p

I've been RTFM and Searched for over an hour

he did say he was going to mark it resolved, guess he forgot :o

[bizchris2001]

Okay, sure I've got <40 posts, but my reputation is still on the line - I did mark it Resolved! Sheesh, now Tekky and Laser have been stewing for days thinking I'm a slacker.

Maybe I wasn't logged in when I marked it Resolved? I just tested and it seemed like like it got marked, but I wasn't signed in at the time. Anyway, here goes... (covers eyes)