Jump to content


Photo

mysql database help


  • Please log in to reply
1 reply to this topic

#1 ramram

ramram
  • New Members
  • Pip
  • Newbie
  • 8 posts

Posted 01 August 2006 - 06:11 AM

OK. SO this will a my very first project. It's very simple but since I do not know any mysql stuff.

I need to make a database with following three items.

1) City Name
2) Country in which city is located in.
3) City's Zip Code

That will be the MySQL part.

On the php section. I want to make a search.php page in which you can type any of the above and it will return a small table with all of the values.

For example.
If in my database. there were:
San Fransisco, California, 95001
San Jose, California, 95111
new york city, new york, 10111

and in the search.php's search box if I was to type 10111. The results will return me New York City, New Youk, 10111.


Contact me for more info. Thanks and have a peaceful day.


#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 02 August 2006 - 02:35 PM

Sounds simple enough... you'll need to make a DB table with the appropriate columns, as you've decribed.  Your PHP code can contain a simple MySQL query to pull back this information and display it nicely.  There are many tutorials around that can help you with these basic steps.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users