query is returning 0 results when there should be results

Paul_Ferrie

Hi guys,

Very strange i thought i had this working earlier.

I tested this in phpmyadmin and it worked fine.

//Would be sent from flash, used for testing
$theID="(letID=4)+(letID=60)+(letID=61)+(letID=3)+(letID=5)+(letID=6)";
$query = "SELECT * FROM scLets WHERE '$theID'";
$result = mysql_query($query);
if (!$result) {
    fail("Couldn't list Lets from database");
}
$letCount = mysql_num_rows($result);

$letCount returns 0

But if i do it this way

$query = "SELECT * FROM scLets WHERE (letID=4)+(letID=60)+(letID=61)+ (letID=3)+(letID=5)+(letID=6)";
$result = mysql_query($query);
if (!$result) {
    fail("Couldn't list Lets from database");
}
$letCount = mysql_num_rows($result);

It works fine :S

I need to be able to build the letID list.

Anyone.

Cheers

devinemke

your quotes are screwing up the query

Paul_Ferrie

oh i like that helps!

if your talking about the quotes within the first query i did remove them, got error "couldnt list lets form db"

Also tried

$query = "SELECT * FROM scLets WHERE".$theID;

nicknax

query is wrong, you haven't specified what.

$query = "SELECT * FROM scLets WHERE".$theID;

WHERE theid is what?

A valid query is...

$query = "SELECT * FROM petstable WHERE pet = dog";

hth

Paul_Ferrie

Hey nicknax, try reading all posts on this topic before you make our own!

Fandan

Weedpacket

Some suggestions that could help you debug this can be found in this thread. Using [man]mysql_error[/man] could help as well.