how to assign number values on select

[ddtpmyra]

How can I assgined value to each row of my query result?
Example Book=1; Fruits=2; Animals=3
OR is there other way to do it?

thanks for your help!

echo "<tr><td><b>Categories:</b></td>"; 
            $res=mysql_query("select cat_name  from categories order by cat_name"); 
            if(mysql_num_rows($res)==0){ 
            echo "there is no data in table.."; 
            } else { 
            echo "
 
            <td width='100%'><select name=\"catname\" id=\"catname\" value=\"$catname\" >"; 
                        for($i=0;$i<mysql_num_rows($res);$i++) { 
                        $row=mysql_fetch_assoc($res); 
                        echo"<option value=\"$row[cat_name]\""; 
                        if($catname==$row[cat_name]) 
                        echo "selected"; 
                        echo ">$row[cat_name]</option>"; 
                        } 
                        echo "</select><br></td></tr>"; 
            } 

[TheServant]

Where does the number come from? Is it in your database? Does it change (dynamic)?

If it's in your database, you could select it with your cat_name and include that in your loop.
If it's dynamic then you need a function in your loop to work out which one it is.

I couldn't really make out from your code what you are referring to. Do you want your value for each option to be a number instead of a name?

[Atli]

Hey.

What column in your table serves as a Primary Key?

Ideally, the Primary Key would be an integer with Auto_Increment.
That creates a "row number" column which you can use if you need a number to go along with a row.