[RESOLVED] MySQL errors

djdaz

Can anyone see an error in the following code?

	$data_insert = mysql_query("INSERT INTO forum_posts p, forum_topics t SET p.username='$username',p.subject='$subject',p.message='$message',p.dati='$dati',t.forumid='$forumid',t.startedby='$username',t.subject='$subject',t.dati='$dati'");

Thanks

devinemke

why look for the error? why not have mysql tell you what the error is via [man]mysql_error[/man]?

djdaz

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 'p, forum_topics t SET p.username='djdaz',p.subject='Hiya!',p.mes

I cant see wahts wrong.

nemonoman

What verison of MySQL are you using? Multilple table inserts are a 4.1+ feature.

Hint: SELECT VERSION();

djdaz

MySQL 4.1.10a-nt running on localhost as root@localhost

According to phpMyAdmin

devinemke

is "forum_posts p" a valid table name or table name alias?

nemonoman

DOH!
You can do multi-table UPDATES in 4.1, but not multi-table INSERTS.

You'll need to do a single insert for each table.

djdaz

gah i was afriad of that.

Thanks for the help people