[SOLVED] SOOO SIMPLE AM I??

[beedie]

<?php
$query = "SELECT * FROM products WHERE business_id = '{$_GET['id']}'";
$result = mysql_query($query) or die(mysql_error());
if($result){
    echo 'yes';

$row = mysql_fetch_assoc($result);
echo $row['business_id'];
}
?>

 

output

 

yes

 

WHy doesn't it see the results it says are there?

 

[cooldude832]

saying

if($result)

 

means that the query didn't fail to run

it does not mean the query returned rows

 

the php function mysql_num_rows  will return if you have a return >0

 

the

 

if($result)

 

is pointless because the page will stop execution if the query returns a failure because of the (or die(mysql_error()))

[beedie]

You are right thanks

it was empty

small but important detail!?!