Question on mysql query.

[creek16]

Hi there! I'm using a query which will find a specific item in the DB. how do I assign it to a variable?

 

This is my query:

$qacatc = mysql_query("SELECT category_code FROM tblAssetType WHERE type_description ='$at' ");

Now the result is only one specific string. How will assign the result to a variable?

 

something like this:

$result = $qacatc; //This line does not work. Just to clarify what I want.

 

Is there other way than using this:

while($row = mysql_fetch_array($qacatc))
{
     $result = $row['category_code'];
} 

 

Thanks in advance!

[mikosiko]

mysql_result() is an alternative

 

pay attention to the "Description" notes