Real Estate Forums

Coding HTML, ASP, PHP, JAVA MYSQL and more. All coding questions should be asked here.

Reply
 
Thread Tools Display Modes
Old 05-05-2009, 01:15 PM
FairwayandIsle's Avatar
FairwayandIsle FairwayandIsle is offline
Real Estate Web Guru
 
Join Date: Sep 2006
Location: Sunset Beach, NC
Posts: 447
FairwayandIsle is on a distinguished road
Default SQL Searches

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
Reply With Quote
Old 05-05-2009, 01:30 PM
RESteve's Avatar
RESteve RESteve is offline
Moderator
 
Join Date: Sep 2005
Location: Houston, TX
Posts: 2,032
RESteve is on a distinguished road
Default Re: SQL Searches

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.

Last edited by RESteve; 05-05-2009 at 01:45 PM.
Reply With Quote
Old 05-05-2009, 01:39 PM
FairwayandIsle's Avatar
FairwayandIsle FairwayandIsle is offline
Real Estate Web Guru
 
Join Date: Sep 2006
Location: Sunset Beach, NC
Posts: 447
FairwayandIsle is on a distinguished road
Default Re: SQL Searches

Thanks Steve - I will check out those places.

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

Quote:
Originally Posted by RESteve View Post
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.
__________________
Coarine Maloy, EBA
Fairway & Isle, LLC

Fairway & Isle | Calabash, NC Real Estate | Sunset Beach, NC Real Estate
Reply With Quote
Old 05-18-2009, 03:42 PM
yoyo yoyo is offline
Advancing Webmaster
 
Join Date: Oct 2007
Posts: 52
yoyo is on a distinguished road
Default Re: SQL Searches

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

http://www.w3schools.com/sql/default.asp
Reply With Quote
Old 07-22-2009, 03:20 AM
nitinjain nitinjain is offline
New real estate webmaster
 
Join Date: Jul 2009
Posts: 10
nitinjain is on a distinguished road
Post Re: SQL Searches

Quote:
Originally Posted by yoyo View Post
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.
Reply With Quote
Old 05-19-2009, 12:36 PM
tcr tcr is offline
New real estate webmaster
 
Join Date: May 2009
Location: Canada
Posts: 19
tcr is on a distinguished road
Default Re: SQL Searches

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.
Reply With Quote
Old 08-03-2009, 02:41 PM
FairwayandIsle's Avatar
FairwayandIsle FairwayandIsle is offline
Real Estate Web Guru
 
Join Date: Sep 2006
Location: Sunset Beach, NC
Posts: 447
FairwayandIsle is on a distinguished road
Default Re: SQL Searches

Quote:
Originally Posted by tcr View Post
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
__________________
Coarine Maloy, EBA
Fairway & Isle, LLC

Fairway & Isle | Calabash, NC Real Estate | Sunset Beach, NC Real Estate
Reply With Quote
Old 07-18-2009, 08:43 AM
LRE LRE is offline
Advancing Webmaster
 
Join Date: Dec 2008
Posts: 72
LRE is on a distinguished road
Default Re: SQL Searches

you can also find a lot of documentation on http://dev.mysql.com/doc/ about mysql.
__________________
Property in Costa Brava
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Saved searches from Snippets? MikeNY Work Orders 6 01-06-2009 06:49 PM
Saved Searches Email Bruce Swedal Denver REW CMS 2 Questions 7 12-23-2008 07:44 PM


Real Estate Webmasters on Facebook

For our members

Main Sections

IDX Coverage Areas

You can find us at

Spiders Welcome

All times are GMT -7. The time now is 05:59 AM.


Powered by vBulletin®
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.