contra10 Posted July 23, 2009 Share Posted July 23, 2009 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"; ?> Quote Link to comment https://forums.phpfreaks.com/topic/167129-solved-resource-id-4/ Share on other sites More sharing options...
akitchin Posted July 23, 2009 Share Posted July 23, 2009 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 Quote Link to comment https://forums.phpfreaks.com/topic/167129-solved-resource-id-4/#findComment-881223 Share on other sites More sharing options...
Maq Posted July 23, 2009 Share Posted July 23, 2009 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'] . " "; } ?> Quote Link to comment https://forums.phpfreaks.com/topic/167129-solved-resource-id-4/#findComment-881226 Share on other sites More sharing options...
contra10 Posted July 23, 2009 Author Share Posted July 23, 2009 i used mysql_fetch_assoc() before but i think i know what i did wrong thxs Quote Link to comment https://forums.phpfreaks.com/topic/167129-solved-resource-id-4/#findComment-881240 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.