[SOLVED] Number of Rows

[cheechm]

So I have this code

mysql_num_rows($result)

 

Say I get a number of 3. How do I echo "1" "2" "3", as I am using a select box.

[pocobueno1388]

Is this what you want?

 

<?php

$num = mysql_num_rows($result);

echo '<select name="name">';

for ($i=1; $i<$num; $i++){
   echo "<option>$i</option>";
}

echo '</select>';

?>

[munsiem]

I agree with the post before me, but are you asking for results 1, 2, and 3? 

 

This is how I would do so (if that is the question)...

 

<?

 

# Assuming you have already created the MYSQL Statement...

 

$results = mysql_num_rows($mysql_result);

 

echo("<select name='name_here'>");

 

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

 

extract($row);

 

echo("<option>$result_name</option>");

 

}

 

echo("</select>");

 

?>