SQL Searches

[FairwayandIsle]

As a side project I work on my husbands company website, and he has asked to to add a store locator. I have some of the basics done however I am having a real hard time with the SQL Search part I am not sure how to add it to the code to make it work.

Does anyone have any experience with this type of thing?

Thanks for any help!

[RESteve]

When I was learning how to build SQL queries, I found that using PHPMyAdmin to actually perform the search manually, then studying the code it outputted, helped me tremendously.

I'd recommend a couple places to learn about this though:

Lynda.com
Nettuts.com

[FairwayandIsle]

Thanks Steve - I will check out those places.

This is a great idea... never thought to do that.

When I was learning how to build SQL queries, I found that using PHPMyAdmin to actually perform the search manually, then studying the code it outputted, helped me tremendously.

[yoyo]

W3Schools is a handy reference. And they have some demos that you can mess around with.

http://www.w3schools.com/sql/default.asp

[tcr]

when i visited your site, my anti-virus (avast!) blocked it stating it was an attack site .. now i'm sure this is not the case, but i will try and attach some screenshots for you to see.

what programming language are you using, ie. PHP, ASP, etc.? perhaps i can help.

[LRE]

you can also find a lot of documentation on http://dev.mysql.com/doc/ about mysql.

[nitinjain]

W3Schools is a handy reference. And they have some demos that you can mess around with.

http://www.w3schools.com/sql/default.asp

yep you are right. if i get any doubt in any platform first i would refer to the w3schools. Really very good portal to have the consolidate information on all the languages. Hats of to the team.

[FairwayandIsle]

when i visited your site, my anti-virus (avast!) blocked it stating it was an attack site .. now i'm sure this is not the case, but i will try and attach some screenshots for you to see.

what programming language are you using, ie. PHP, ASP, etc.? perhaps i can help.

Sorry for the long hiatus... but I had to fix the hack problem (which is fixed now) before I could move onto the SQL issue.

I am using PHP. I would appreciate any and all help