[RESOLVED] Quick code problem

[ld0121]

Hi everyone,

Im looking to select data from gzdata1 check approval = 0 and check that ident = $trimmed. My attempt at the code is below and is not working..... help :o)

	$query = "select * from gzdata1 where approval like \"0\" where  ident like '$trimmed' ";

Any help would be great

Thanks
Lee

[cheerio]

 $query = "select * from gzdata1 where approval like \"0\" where  ident like '$trimmed' "; 

do you want it to search for "0" WITH QUOTES, or just plain 0?

[ld0121]

just a plain 0

[iNFERiON]

Two things are wrong. You use WHERE two times, you should use AND instead.
Also you are using LIKE on an integer field, while you only want to check if it is 0 or not, you should use = instead.
LIKE only works to search for text or large integers (at least I think so, never tried the last), preferably with wildcards for example:

$query = "SELECT * FROM `movies` WHERE title LIKE '%Matrix%'";

Try this instead:

$query = "SELECT * FROM `gzdata1` WHERE approval=0 AND ident='$trimmed'";

[ld0121]

many thanks