#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2016
    Posts
    1
    Rep Power
    0

    2 tables almost identical but one throws an error


    as above faulty table throws error

    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 1

    both use the same script except for the table name

    both tables are identical apart but the working one is complete, the other has one field empty, which is just a char field and should have not effect on the thing

    working one britishsteam.com/php_lner/my_lner.php

    dud one britishsteam.com/php_lner/my_lner1.php

    II cannot find any reason for this so any help would be much appreaciated

    regards topshed
  2. #2
  3. Forgotten Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Mar 2007
    Location
    Washington, USA
    Posts
    16,192
    Rep Power
    9644
    We can't do much until you post the SQL queries, and probably also the code that generates them.

    Comments on this post

    • r937 agrees
  4. #3
  5. No Profile Picture
    Super Moderator
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Jun 2009
    Location
    Hartford, WI
    Posts
    1,455
    Rep Power
    70
    Echo your query to the page. Does it look the way you want it to?
    Last edited by Triple_Nothing; February 3rd, 2016 at 07:32 AM.
    He who knows not that he knows not is a fool, ignore him. He who knows that he knows not is ignorant, teach him. He who knows not that he knows is asleep, awaken him. He who knows that he knows is a leader, follow him.

IMN logo majestic logo threadwatch logo seochat tools logo