Printing query result from MySQL

Hi Muddasir and welcome to TSDN,

I have taken a look at your code and whilst you have done the mysql_query, you appear to be missing the fetch.. This maybe due to you snippet missing the relevent line of code. If that the case, can you post the code with the query and result processing logic.. If its not the case a broad pointer would be to take a look at mysql_result and mysql_fetch functions in the php.net manual..

Hope this helps

Purple

i dont know why i am unable to print the result of that query.......shall i use mysql_fetch()

<?php
include("datastore.php");

$cat=$_POST["category"];


$query = "select * from search";
$result=mysql_query($query);
$num=mysql_numrows($result);


$flag=0;
$i=0;

while($i<$num)
{
$cat_var=mysql_result($result,$i,"category_name");

If($cat==$cat_var)

$flag=1;
$i++;
}

if ($flag==1)
{

$query = "SELECT product_name FROM search WHERE category_name=$cat";

$result=mysql_query($query);
echo "the result is:'$res'";

}
else
{

echo "no reult found";

}
?>

i dont know why i am unable to print the result of that query.......shall i use mysql_fetch()

Please wrap your codings with relevant [code] tags.

Thanks Ajaxrand - took me a little longer to work out

many thanks Purple and Ajaxrand
its working now..
u guys are great
thanks once again

many thanks Purple and Ajaxrand
its working now..
u guys are great
thanks once again

You are welcome Muddasir and keep in touch with TSDN !

Purple, I appreciate your Post
Thanks,
Ajaxrand

If you find yourself doing more work with PHP and MySQL, you may want to take a look at the article I wrote on building a MySQL class to make performing these common functions much more accessible.