January 30th, 2016, 04:00 AM
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
January 30th, 2016, 04:29 AM
We can't do much until you post the SQL queries, and probably also the code that generates them.
Comments on this post
January 31st, 2016, 12:53 PM
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.