Not to mention if this is written for v 5 then you need to wrap your joins in () -----Original Message----- From: Jan G.B. [mailto:ro0ot.w00t@xxxxxxxxxxxxxx] Sent: Sunday, March 15, 2009 9:47 AM To: PJ Cc: Daniel Brown; php-general@xxxxxxxxxxxxx Subject: Re: left join does not work, why? 2009/3/15 PJ <af.gourmet@xxxxxxxxxxxx>: > Daniel Brown wrote: >> On Sat, Mar 14, 2009 at 19:51, PJ <af.gourmet@xxxxxxxxxxxx> wrote: >> >>> $sql1 = "SELECT b.id, b.title, b.sub_title, b.descr, b.comment, >>> b.bk_cover, b.copyright, b.ISBN, b.language, b.sellers, c.publisher, <--- >>> CONCAT_WS(' ', first_name, last_name) AS Author >>> FROM book AS b >>> LEFT JOIN book_author AS ab ON b.id = ab.bookID >>> LEFT JOIN author AS a ON ab.authID=a.id >>> LEFT JOIN book_publisher as abc ON b.id = abc.bookID // <--- >>> LEFT JOIN publishers AS c ON abc.publishers_id = c.id // <--- >>> ORDER BY title ASC "; >>> $result1 = mysql_query($sql1, $db); >>> $bookCount = mysql_num_rows($result1); > The error reported now is to check the syntax near the commented out lines. > So, what is going on here? I understood that when the lines are > commented out they are not lprocessed. > When I deleted the commented out lines the errors went away. > This does not make sense and obviously could be very misleading in > debugging. > *How* are you commenting out? Mysql accepts /* such comments */, so if you want to transform a line in your SQL query string into a comment, you gotta do it that way. so this is just wrong: $x = " select * // from foo from bar"; and that query would be valid "SELECT this/*, that*/ from x" -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php __________ Information from ESET Smart Security, version of virus signature database 3937 (20090314) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 3937 (20090314) __________ The message was checked by ESET Smart Security. http://www.eset.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
