MySQL out of date?
Posted: Wed Sep 14, 2005 6:00 am
Hey I have a MySQL code wich works perfectly in my webserver, but on the webserver where it has to be run I get an error:
I suspect that it has something to do with the version of MySQL wich is 3.23.57: http://www.mohawk-studios.com/info.php
Im I right, was it not yet supported in that version to do things like that (I couldn't find an answer on the internet) or am I doing something wrong?
The code is as follows: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 'SELECT rem_girl_id FROM son_remember WHERE rem
Code: Select all
mysql_query("
SELECT *
FROM
son_girls
WHERE
girl_id NOT IN
(
SELECT rem_girl_id
FROM son_remember
WHERE
rem_ip='$remote_ip'
)
")or die("".mysql_error());Im I right, was it not yet supported in that version to do things like that (I couldn't find an answer on the internet) or am I doing something wrong?