homepage Welcome to WebmasterWorld Guest from 54.166.228.100
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
MySQL LIKE code not working in safari browser
MySQL LIKE code not working in safari browser
AimyThomas




msg:4494070
 4:21 am on Sep 12, 2012 (gmt 0)

Hello,

I am looking for database

PHP Code:

SELECT * FROM table_name WHERE event LIKE '%" . $search . "%' OR date LIKE '%. $search . "%'

This works fine in Firefox and in IE, but when i try it in safari, it seems to pull up the right results but then straight away changes and gives me all the results from the table. I am sure it has soomething to do with the LIKE operator because when i tried

This script works fine in Firefox and in Chrom, but when i try it in safari browser, it seems to pull up the right results but then as the crow flies away changes and gives me all the results from the table.

I am sure it has something to do with the LIKE coad because when i tried

SELECT * FROM table_name WHERE date = (the date i was trying to search for)

Kindly provide me solutions

Thanks in advance

 

phranque




msg:4494107
 7:10 am on Sep 12, 2012 (gmt 0)

the database query occurs on your server, not in your browser.
therefore you should look for a safari-specific problem in in the document served, not in the query.

does your html document have a DTD specification?
have you validated the html?

lostdreamer




msg:4494169
 9:25 am on Sep 12, 2012 (gmt 0)

How are you giving the query the $search variable?

When you say that you first get the correct list, but in safari it will then refresh and show all rows, I'm thinking you're using javascript (ajax call?) or something?

If this is the case, it could very well be that it first gives the right $search variable, but than (for some reason) it does another call without the $search variable, thus returning all rows.

phranque




msg:4494177
 9:50 am on Sep 12, 2012 (gmt 0)

I'm thinking you're using javascript (ajax call?) or something?


not javascript.
from the OP:
PHP Code:

lostdreamer




msg:4494216
 10:51 am on Sep 12, 2012 (gmt 0)

@ phranque

Of course the QUERY is in php ;)
but as I said, this:

This script works fine in Firefox and in Chrom, but when i try it in safari browser, it seems to pull up the right results but then as the crow flies away changes and gives me all the results from the table.

leads me to believe there is some javascript involved in the frontend.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved