Riparian Posted December 24, 2010 Share Posted December 24, 2010 Desperate for some help with this one ! Can someone please tell me what is wrong with this ... it work 90% of the time but then it kicks it out for no reason I can see. in this example t027a exists and is in_stock. 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 'where model_number RLIKE 't027[a-z]' and in_stock='T'' at line 1 Cheers Quote Link to comment https://forums.phpfreaks.com/topic/222596-help-with-syntax/ Share on other sites More sharing options...
PFMaBiSmAd Posted December 24, 2010 Share Posted December 24, 2010 The error is occurring before the WHERE. You would need to post what the query is up to that point. Best guess is you are dynamically putting some variable into the query and it is either empty or contains something that breaks the sql syntax. Quote Link to comment https://forums.phpfreaks.com/topic/222596-help-with-syntax/#findComment-1151176 Share on other sites More sharing options...
Riparian Posted December 24, 2010 Author Share Posted December 24, 2010 Thank you. You are spot on. Bloody spiders are accessing the page and the dynamic '$use_table' is empty and hence not valid. Thanks again Cheers Quote Link to comment https://forums.phpfreaks.com/topic/222596-help-with-syntax/#findComment-1151189 Share on other sites More sharing options...
PFMaBiSmAd Posted December 24, 2010 Share Posted December 24, 2010 You must validate ALL external data. If you are dynamically putting the table name into your query from external data without validating what it is, some hacker has probably already gotten all your data. Quote Link to comment https://forums.phpfreaks.com/topic/222596-help-with-syntax/#findComment-1151209 Share on other sites More sharing options...
Riparian Posted December 25, 2010 Author Share Posted December 25, 2010 Sorry... when you say validating the data can you expand on that just a bit ? If it is dynamic and a hacker puts a different table name then an error occurs and I would have thought that the query is not executed? Cheers Quote Link to comment https://forums.phpfreaks.com/topic/222596-help-with-syntax/#findComment-1151311 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.