syntax assistance required.

[blue-genie]

here's my select statement

SELECT COUNT(*) as count FROM gamestats WHERE statsPlayerID=1 AND statsGameID = 119

 

if i run this in the sql window of xampp returns 2 - which is correct

 

 

then i try do this

 

<?php

session_start();

include 'config.php';

include 'opendb.php';

 

 

    $playerid = $_REQUEST['pID'];

    $gameid = $_REQUEST['gID'];

//"SELECT COUNT(*) as played FROM gamestats WHERE statsPlayerID = '".$player."' AND gamestats.statsGameID = '".$gameid."'")) {

 

 

$result = mysql_query("SELECT COUNT(*) as count FROM gamestats WHERE statsPlayerID=".$playeridID." AND statsGameID = '".$gameid."'") or die ('Error: '.mysql_error ());

 

 

$row = mysql_fetch_array($result,MYSQL_ASSOC);

echo $row[count];

 

?>

 

and the result is

 

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND statsGameID = ''' at line 1

 

 

[GenuineSounds]

Shouldn't you use _get instead of _request?

[blue-genie]

i've been using request all along. someone told me to use request (cant' remember why)

 

just tried changing it to GET - same error

[GenuineSounds]

result = mysql_query("SELECT COUNT(*) as count FROM gamestats WHERE statsPlayerID=".$playeridID." AND statsGameID = '".$gameid."'") or die ('Error: '.mysql_error ());

 

into

 

result = mysql_query("SELECT COUNT(*) as count FROM gamestats WHERE statsPlayerID=\".$playeridID.\" AND statsGameID = \".$gameid.\"") or die ('Error: '.mysql_error ());

 

I think that's right...

[mattal999]

  Quote

result = mysql_query("SELECT COUNT(*) as count FROM gamestats WHERE statsPlayerID=".$playeridID." AND statsGameID = '".$gameid."'") or die ('Error: '.mysql_error ());

 

into

 

result = mysql_query("SELECT COUNT(*) as count FROM gamestats WHERE statsPlayerID=\".$playeridID.\" AND statsGameID = \".$gameid.\"") or die ('Error: '.mysql_error ());

 

I think that's right...

That would just escape the quotes and cause WHERE statsPlayerID=".1." which isn't really what he wants

 

You're using the wrong variable name by the way. Easy mistake to make. You use $playeridID in the query, which should be $playerid.

[blue-genie]

I managed to change it to now throw an error anymore

 

$result = mysql_query("SELECT COUNT(*) as count FROM gamestats WHERE statsGameID = '".$gameid."' AND statsPlayerID = '".playerid."'") or die ('Error: '.mysql_error ());

 

what is odd though is that if I hard code my variables into this query it returns 2 but if i use my variables as above it returns 0.

i am highly confused. (not a php developer - do flash but am trying to fix this)

[GenuineSounds]

LOL right when I was posting that you did all by yourself '".$playerid."'

[blue-genie]

i found the problem (bar the typos) but I don't understand why.

when i hard coded the values as strings it worked but when i ran it through the browser with querystring or via flash it didn't work because I was casting the values in flash as Numbers - in the database they were varchars.

 

changed them to strings in flash and bobs my uncle it works - strange!

 

any thoughts?