Query Not Executing Correctly

[Anonymous]

I have the following query which returns a "Query Empty" error:

$Query = mysql_query("SELECT * FROM events 
WHERE EventCode == 'PMJ'; 
ORDER BY EventTime DESC"); 
$Data = mysql_query($Query) or die("Error: " . mysql_error());
while($row = mysql_fetch_array($Query))

Can anyone see what I can't...? I've checked and double checked and it seems OK and there's definately data in the table.

 

[Anonymous]

it shud be WHERE EventCode = 'PMJ' not WHERE EventCode == 'PMJ'

 

[Anonymous]

I've changed it now but still no joy...

If I execute this against the databse it returns some records:

SELECT * FROM events
WHERE EventCode = 'PMJ';

But this query:

$Query = mysql_query SELECT * FROM events
WHERE EventCode = 'PMJ';

Says unexpected T_STRING


Grrr...

 

[Anonymous]

have u actually coded as
$Query = mysql_query ("SELECT * FROM events
WHERE EventCode = 'PMJ' ");

also please check ur connection string

 

[Anonymous]

Thanks mate.

I've been looking at that damn query all morning...!