i have a problem with my homework,
have an error like this :
"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 'order o, detail_order d, member m, buku b WHERE o.id_order=d.id_' at line 5"
$QOrder=mysql_query("SELECT o.id_order, o.tanggal, o.status,
b.isbn, b.judul, b.harga,
m.nama, m.alamat, m.Kota
FROM order o, detail_order d, member m, buku b
") OR DIE(mysql_error());
Just a guess: it might consider "order" to be a reserved word (such as in an ORDER BY expression), so try wrapping it in `back-quotes` to tell the SQL parser it's an identifier.
06-05-2012, 11:33 AM
I would not even guess. ORDER is a reserved word and could not be used as a table name.
Same goes for member. On some SQL databases (depend on version) it is a reserved word.
Rename tables, period.
make it as your habbit to use naming convention such as table name looks like this tbl_NAME_of_your_choice.