Help with assigning results from database query

QSDragon

Hi,
I have perform a select query on my database -

$results = mysql_query("SELECT product FROM $table WHERE category = 'cpu'") OR die("Bugger no work!");

There are a number of rows and I want to be able to make a select menu in html with the options that come from the database, one for each row.

This is the following html.
$html="<select name='cpu'>
<option>$cpu1</option>
<option>$cpu2</option>
<option>$cpu3</option>
<select>";
echo $html
which creates the html output for the browers for the select menu.
I have this while loop that goes over each row
while($row = mysql_fetch_array($results)){}
and in each row i need to assign the product that comes from the database into on of the values to go into the select menu.
but I don't know how i can do this.
😕
I have tried different methods but usally it all rights over the same value.. eg. i have this to collect the product and place it into the value $cpu1
$cpu1 = $row['product'];
but i need to be able to do multi of these for each row?
Can someone please assist. Its rather complex.
Thanks
Ben

harlowhair

$html="<select name='cpu'>

while($row=mysql_fetch_array($result))
{
$html .= "<option>" . $row['product'] . "</option>";
}

$html .= "</select>";

Oh yeah, .= means 'append'

QSDragon

I tried something similar....
but the while loop is inside the "" so it won't run it will output in html when you echo it.. so when you view the page it you will see the while loop text on the page.
But thanks anyway 🙂
maybe if you know how to get the while loop to be run like it is meant to inside the "".
?

harlowhair

$html="<select name='cpu'>

while($row=mysql_fetch_array($result))
{
$html .= "<option>" . $row['product'] . "</option>";
}

$html .= "</select>";

The first line should read

$html="<select name='cpu'>";

That way the while loop is outside of the quotes, and simply appends to the string contained in $html every time.

Alternatively, you could just print each time, which is how i normally approach this problem:

print("<select name='cpu'>");

while($row=mysql_fetch_array($result))
{
print("<option>" . $row['product'] . "</option>");
}
print("</select>");

QSDragon

wooo... I was just going over the same thing and i was coming back to post my success...
sorta the same thing you did...
heres many results
$html = "<select name'cpu'>";
while($row=mysql_fetch_array($results)){
$cpu = $row["product"];
$html .= "<option>$cpu</option>";
}
$html .= "</select>";
echo $html;

Thanks gave me the idea to do that! 🙂
had a dance 🙂 finallllyyyyy figured it out thanks again 🙂