Printing query result from MySQL

[Muddasir]

i am having problem in printing the query result from MySQL db...

actually i am developing a very simple search module.
when the user select category from the given categories in drop down list....the coresponding product against that category shuld be displayed....

table= search

fields

product_id, product_name, category_name, price

<?
$cat=$_POST['category']
 
$query = "SELECT product_name FROM search WHERE category_name=$cat";
 
$result=mysql_query($query);
 
echo "the products are:'$res'";
 
?>

[Please use CODE tags when posting source code. Thanks! --pbmods]

[Purple]

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

[Muddasir]

<?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()

[ak1dnar]

<?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()

# Rest of the code
$query = "SELECT product_name FROM search WHERE category_name='$cat'";// Make sure to use ' ' if this $cat is not a int value. 
 
$result=mysql_query($query);
while($result_row = mysql_fetch_assoc($result))
{
echo "the result is :".$result_row['product_name']."<br>";
}
# Rest of the code
 

Please wrap your codings with relevant [code] tags.

[Purple]

Thanks Ajaxrand - took me a little longer to work out

[Muddasir]

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

[ak1dnar]

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

[Motoma]

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.