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!

__________________
Coarine Maloy, EBA
Fairway & Isle, LLC

Fairway & Isle | Calabash, NC Real Estate | Sunset Beach, NC Real Estate

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

__________________
Steve Castaneda, Realtor

Specializing in Houston Real Estate. Feel free to browse Houston homes for sale or read about Real Estate Technology for agents.

Thanks Steve - I will check out those places.

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

__________________
Coarine Maloy, EBA
Fairway & Isle, LLC

Fairway & Isle | Calabash, NC Real Estate | Sunset Beach, NC Real Estate

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.

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.

__________________
TransCanada Rentals
Apartments for Rent in Canada | Submit a Property Rental FREE in Canada | The Housing Block

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

__________________
Coarine Maloy, EBA
Fairway & Isle, LLC

Fairway & Isle | Calabash, NC Real Estate | Sunset Beach, NC Real Estate

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

__________________
Property in Costa Brava