Peter,<br><br>It sounds like PHP is the problem here... that query should be working. Have you tried to echo when you run the query to see if something funny is happening with the quotes?<br><br><div><span class="gmail_quote">
On 1/31/07, <b class="gmail_sendername">Peter Fogg</b> <<a href="mailto:peter.fogg@sbcglobal.net">peter.fogg@sbcglobal.net</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Good evening all,<br><br>The following query results in a mysql error if executed by PHP but<br>succeeds if entered into the SQL window of phpMyAdmin:<br><br>SELECT eventID, venueID, title, summary, eventType, eventSubtype,
<br>eventStartDate, eventStartTime, admissionPrice FROM events WHERE (title<br>LIKE '%a%') ORDER BY title ASC<br><br>ERROR 1: 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 '' at line 1.
<br><br>The server is an iMac OS 10.3.9, MySQL 5.0.16-standard, PHP Version<br>5.0.4.<br><br>Peter -<br><br></blockquote></div><br><br clear="all"><br>-- <br>Matthew Gallizzi