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!

Expand|Select|Wrap|Line Numbers

 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.

how to assign number values on select

re: how to assign number values on select

re: how to assign number values on select

/bytes/development

/bytes/it

/bytes/about