IF EXISTS in MySQL 4.0x???

MasterMan194

Hi,
I'm now fidling with databases. Instaled the trio MySQL 4.0.24. PHPMyAdmin 2.8.0.3 and PHP 4.4.6, everything with Abyss X1 v2.4.
But i get an error when i do:

IF(EXISTS (SELECT * FROM examples WHERE name='".$name."')
 PRINT '".$name." exists'
 ELSE PRINT '".$name." does''t exists')") or die(mysql_error());

The error says "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 'IF EXISTS (SELECT *...".
So i'm thinking MySQL 4.0.24 can't do IF statements or EXISTS statements like this.
Then how can i procede? Upgrade to PHP 5 + MySQL 5?
Any ideas?
Thanks.

AbyssUnderground

IF(EXISTS (SELECT * FROM examples WHERE name='".$name."')

missing ")" on the end. It should be

IF(EXISTS (SELECT * FROM examples WHERE name='".$name."'))

Try that.

pkSML

It looks as if your SQL query is mixed with PHP code. That's invalid syntax.
You have to make your SQL query, assigning its response to a PHP variable. Then you have to make the data available to print in your PHP script (by using a fetch array command). Then you can print the data from that array.
You might try reading the tutorial at http://www.tizag.com/mysqlTutorial/

MasterMan194

Sorry, confused it with PHP code.
Look:


mysql> SELECT * FROM example WHERE age=25;
+----+------------+------+
| id | name       | age  |
+----+------------+------+
|  1 | joao vitor |   25 |
+----+------------+------+
1 row in set (0.01 sec)
mysql>

It works, but...


mysql> IF EXISTS ( SELECT * FROM example WHERE age=25 )
    -> PRINT 'age exists'
    -> ELSE
    -> PRINT 'age doesnt exists';
ERROR 1064: You have an error in your SQL syntax.  Check the manual that corresp
onds to your MySQL server version for the right syntax to use near 'IF EXISTS (
SELECT * FROM example WHERE age=25 )
PRINT 'age exi
mysql>

It doesn't.
Now that's command line in windows xp.
The documentation only talks about [IF EXISTS] in various DROP commands, not SELECT or INSERT or anything else :(