User Profile

Collapse

Profile Sidebar

Collapse
ebflute
ebflute
Last Activity: May 23 '11, 04:29 PM
Joined: Dec 30 '10
Location: San Francisco Bay Area
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ebflute
    replied to MySQL Error: You have an error in your SQL syntax;
    in MySQL
    There was an error in the way the cookie was being set and the problem has been fixed in the application--I had to hire an experienced developer. Thank you for attempting to help me. I appreciate it.
    See more | Go to post

      Leave a comment:

    • ebflute
      replied to MySQL Error: You have an error in your SQL syntax;
      in MySQL
      Is this the code that will help determine the problem?

      Forgive me if this isn't what you are asking for as I am not an expert in MySQL. I went to the page in question and found this relevant PHP code:

      Code:
      <?php
			// Get filters
			$year = (isset($_SESSION['year'])) ? $_SESSION['year'] : '';
			$city = (isset($_SESSION['city'])) ? $_SESSION['city'] : '';
			$county = (isset($_SESSION['county']))
      ...
      See more | Go to post

        Leave a comment:

      • ebflute
        started a topic MySQL Error: You have an error in your SQL syntax;
        in MySQL

        MySQL Error: You have an error in your SQL syntax;

        What is wrong with my SQL statement? I moved this application from a PHP4 server to a PHP5 server with a higher version of MySQL. It was working on the old server but now I am getting an error in the syntax.

        Code:
        MySQL Error: 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 24
        Code:
        SQL Statement: SELECT * FROM agency WHERE date_time
        ...
        See more | Go to post
        No activity results to display
        Show More
        Working...