Menu
Community /Pin to ProfileBookmark
@NogDogMar 17.2007 — #You're using "loopies" as an alias for the CAST() of the Score column, but that casting won't be done until [i]after[/i] the WHERE clause has identified an applicable row; so that means that while the WHERE clause is processing there is not yet a "loopies" value. So if the casting is necessary to do the ">" comparison, you'll need to use the same CAST() call in the WHERE clause:
What am I doing wrong ?
Hi I am having problems with the folloing statment:
[CODE]
$Exist = “SELECT CAST(Score AS UNSIGNED) AS loopies FROM playerstats WHERE id_Player=’16’ AND loopies > ’49′”;
I keep getting the error that “loopies” is a unknown column. But when I run the statment in my DB admin software the column has been created.
What am I doing wrong and what do I do to correct it?
Sign in
to post a comment3 Comments(s) ↴
0
@NogDogMar 17.2007 — #You're using "loopies" as an alias for the CAST() of the Score column, but that casting won't be done until [i]after[/i] the WHERE clause has identified an applicable row; so that means that while the WHERE clause is processing there is not yet a "loopies" value. So if the casting is necessary to do the ">" comparison, you'll need to use the same CAST() call in the WHERE clause:[code=php]
$Exist = "SELECT CAST(Score AS UNSIGNED) AS loopies FROM playerstats WHERE id_Player='16' AND CAST(Score AS UNSIGNED) > '49'";
[/code]