[SOLVED] resource id 4

[contra10]

i can't seem to do a simple query and i don't know what I'm missing

 

<?php
$querye = "SELECT * FROM `deal` WHERE `category` = 'Outdoor' and `time` = '704'";
$result = mysql_query($querye) or die(mysql_error());
echo "$result";
?>

[akitchin]

you'll need to brush up on some manual literature: mysql_query

 

mysql_query() returns a resource identifier, which in essence is just a handle or pointer to the actual resultset. in order to retrieve that resultset, you'll need to run one of the fetching functions on it. take your pick:

 

mysql_fetch_array

mysql_result

mysql_fetch_assoc

mysql_fetch_object

[Maq]

You need to actually extract the data by using functions such as mysql_fetch_array, mysql_fetch_row etc...

 

$querye = "SELECT * FROM `deal` WHERE `category` = 'Outdoor' and `time` = '704'";
$result = mysql_query($querye) or die(mysql_error());
while($row = mysql_fetch_array($result)) {
   echo $row['field_name'] . "
";
}
?>

[contra10]

i used mysql_fetch_assoc() before but i think i know what i did wrong thxs