perficut Posted December 20, 2007 Share Posted December 20, 2007 I'm trying to lear mysql and php integration and would like a little help on my next task. I want to open a data file which has names and addresses, and create a list of name of names first, last based on a specific address (more specifically) their state. Ideally what I want, is a map of the us, and when someone click on a particluar state, the file will read the database and find all the members from that state, and display their first and last name, and their city. Database has about 15 different fields, including FirstName, LastName, City, State, Zip, and several more. I think if I can get a little help on just opening the data file, searching for a particular state, then displaying the appropriate fields in a list form, I can probably handle the rest. Thanks. Quote Link to comment Share on other sites More sharing options...
trq Posted December 20, 2007 Share Posted December 20, 2007 Your question is a little confusing. What is this data file your speaking of? Don't you want to use mysql to store the data? Quote Link to comment Share on other sites More sharing options...
MadTechie Posted December 20, 2007 Share Posted December 20, 2007 I can probably handle the rest. rest of what? i don't really see a question ! i think you want 2 tables and want to search one.. this is the basics of SQL.. but again i can't see the part your stuck on ! Quote Link to comment Share on other sites More sharing options...
JasonLewis Posted December 20, 2007 Share Posted December 20, 2007 the OP mentions SQL at the start.. i don't really see another mention. But like thorpe said, the OP mentions a data file(?) Quote Link to comment Share on other sites More sharing options...
perficut Posted December 25, 2007 Author Share Posted December 25, 2007 Sorry for the confusion, maybe I'm using the wrong terminolog. I have a MYSQL database called members. I would like to have a map of the US on my web page. When someone clicks a hot spot over a particular state, then a php file is run, opening the members datafile and creating a list of members from that state. Quote Link to comment Share on other sites More sharing options...
blueman378 Posted December 25, 2007 Share Posted December 25, 2007 well you could have it so that it links to a page, eg showstate.php?state=statename and have your php code on the page and then have your mysql query and the where statment can be $_get['$state'] or something similar Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.