[SOLVED] PHP Query Help

[Canman2005]

Hi all

 

I have the following query

 

SELECT SUM(x.type_price) AS total FROM (SELECT DISTINCT type_uid, type_price FROM cart_log WHERE `unique_id`= '76202714-20081115-1239-125853-15364793' AND `type_type` = 4) AS X

 

but getting error

 

#1109 - Unknown table 'x' in field list

 

Any ideas?

[Mchl]

x and X are not the same for MySQL

[Canman2005]

Ok, but running it through a php QUERY gives me

 

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in

 

even if rows exist that contain data

[Barand]

x and X are not the same for MySQL

 

works for winXP

 

http://www.phpfreaks.com/forums/index.php/topic,225481.msg1039874.html#msg1039874

[Canman2005]

Sorry for double posting Barand

 

I'm a little bit lost on what you mean, I have done that QUERY and it runs fine locally on my test server, but on a live server I get that error.

 

Not too sure what you mean by "x and X are not the same for MySQL"

 

any help would be appreciated

[Barand]

try changing x to X in the query. Some Op systems are case sensitive.

 

PS What does mysql_error() give?

[Canman2005]

and by magic it works

 

thanks man

[Barand]

I did suggest the X/x might be case sensitive in your original thread