current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

My table reservation is formed of the following fields: hour ,minute,day,month,name,table,rnumber

When I execute the query as follows:

$query = "select * from reservation";

$result = $db->query($query);
$row = $result->fetch_assoc();

It works perfectly.

However when I change the query to be 

$query = "select * from reservation where table like '%1%'";

I get a blank result and the following error in apache log:

Mon Aug 08 20:17:19 2011] [error] [client ::1] PHP Fatal error: Call to a member function fetch_assoc() on a non-object in /srv/http/reservation.php on line 43, referer: http://localhost/

And if I change it to the following:

  $query = "select * from reservation where 'table'=1";

I get 0 as result. (table is INT)

A second question is, am I using up to date syntax? I've seen most people use mysql_query().

share|improve this question
add comment

4 Answers

up vote 3 down vote accepted

table is a reserved word. Better not using it; whatever, the correct syntax ofr your query is using the back quotes:

 $query = "select * from reservation where `table` = 1";
share|improve this answer
 
It worked! Thank you :) –  patokun Aug 8 '11 at 17:42
add comment
up vote 1 down vote

table is MySQL reserved word. If you want to use it in query as column name, you need to put it in backticks (not single quotes like you did):

$query = "select * from reservation where `table`=1";
share|improve this answer
add comment
up vote 0 down vote 
do a $db->query($query) or die(mysql_error());

$result is probably false due to a SQL error.

I'm assuming you can't do a like on an int field (never tried), this should let you know why MySQL is rejecting your statement.

share|improve this answer
add comment
up vote 0 down vote

To answer your second question, your code is MORE up to date than other people who use mysql_query. You appear to be using mysqli, which is a good thing. mysql_query et al. have been obsolete for years now and are not recommended for any new projects.

share|improve this answer
 
Yeah it's probably because I'm new to php/mysql and looked up an up to date book to learn from. Thank you for the feedback! –  patokun Aug 8 '11 at 18:24
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.