Query syntax error help

[John Lester]

Originally Posted by kh99

Having said all that, a couple of the queries posted above *are* missing a space - there needs to be a space before inserting the table prefix but not after, as Simon explained, but the query above is missing a space after LIKE.

I hope this helps - I'm afraid it might just be more confusing.

Ok so can I just not use the spaces like so;

$db->query_write("CREATE TABLE IF NOT EXISTS ".TABLE_PREFIX."unsub_subscribethread LIKE ".TABLE_PREFIX."subscribethread");

Or do I have to have a space before the first TABLE_PREFIX like so;

$db->query_write("CREATE TABLE IF NOT EXISTS " .TABLE_PREFIX."unsub_subscribethread LIKE ".TABLE_PREFIX."subscribethread");

It's the mixed use of spaces and non spaces that doesn't make sense (at least to me at this point )