I am hoping someone can help with this query as I am at a loss.
I have written this query
SELECT ID, CompanyName
INNER JOIN wireCompanyIndex ON wires.ID = wireid
AND wires.CompanyName LIKE "%Wire & Tube Search Ltd%"
LIMIT 0 , 30
On a site that I am developing and it works perfectly in Firefox bringing be back exactly what I expect to get from the Database no problems. However, where I try the same feature in Chrome or Safari I get nothing back. Not a blank page but a reload of the form that has just been processed to generate the query (using $_GET)
Hope someone can help me with this it's driving me round the twist.
It nothing to do with the browser not running the query, more likely to be the form and action thats not being sent properly.
Can you post the form code and $_GET query parameters?
Thanks for that.
I have put the controller PHP and the form into two separate pastie documents I hope that is ok (obviously deleted out connection settings - although they do work nicely).
http://www.pastie.org/2648801 - The Controller
http://www.pastie.org/2648818 - The From
Hope this can shed some light on the problem. I am a new PHP Developer so know there are some holes in this as I am still finding my feet.
Ah sorry just realised you do not have all the info.
If in my form I choose a country it all works lovely - on everything.
If however I leave it as Please Select it does not work
You may need to add an 'action' to the form as some browsers wont act without it.
action="<?php echo $_SERVER['PHP_SELF']; ?>"
That said I just ran a quick test in Chrome on the Mac and it picked it up without it.
Add an action and see what happens.
Hmmm no still no a happy camper with that - sorry. Still giving me the same result.
Would you like the URL so you know the site I am talking about?
Sure, PM me if you dont want it broadcast