chptr9 pg262 error with charlist.php

bodenzord · January 5th, 2005, 10:03 PM

congrats!!! i'm glad to hear it.

midnightsteel · January 29th, 2005, 05:18 PM

Quote:

quote:Originally posted by jaygee
I'm trying to run charlist.php on page 263 and get the following
error message displayed.

You have an error in your SQL syntax near 'ON c.id = pk.char_id AND p.id = pk.power_id' at line 2

The line from the code, reproduced below, is the same as the book and
the downloaded code.

$sql = "SELECT c.id, p.power FROM char_main c JOIN char_power p JOIN
char_power_link pk ON c.id = pk.char_id AND p.id = pk.power_id";

I've even tried running the query from the mysql monitor and get the same result. I used phpMyAdmin to create the database and the tables since I couldn't get the make_table.php to run either!

I'm running under Linux Version 2.4.18-5, PHP Version 4.1.2,
MySQL version 3.23.49 and Apache version 1.3.23.

Thanks in advance for any help.

Does anyone know the code for the old version to get this to work?

paulohanlon · August 11th, 2005, 10:45 AM

I've had the same problem too. One way round it is to replace the JOIN..ON with FROM...WHERE
e.g.
SELECT c.id, p.power FROM char_main c, char_power p, char_power_link pk WHERE c.id = pk.char_id AND p.id = pk.power_id
...which appears to produce the desired results...

However, I am waiting for my guru to come back to me to let me know the correct JOIN syntax.

...In the meantime, if anyone knows the correct syntax then please let me know (I am using MySQL 3.23.59)