Re: Newbie Questions

Hi Peter, please see my comments below: "Pete Holsberg" <pjh@mccc.edu> wrote in message news:Pine.GSO.4.10.10409011359210.7843-100000@tecoma.mccc.edu... > I'm just getting started with PHP and MySQL (how do you say > that, my ess kew wll, my sequel, ???). "my ess kew wll" is the correct pronounciation - after all you know how to spell SQL, don't you? ;) > > I have a background with C programming and many years ago, > I played with dBASE. > > I want to set up a directory with the following fields: > > surname > firstname > spousename > housenumber > street > phone > email (contents is either an email address or a minus sign) IMHO a great way to get started with MySQL is installing/using phpMyAdmin. It's a web frontend administartion interface. It makes creating/editing tables and records quite easy and will also show the SQL commands - so you can learn from them. You can get it here: http://www.phpmyadmin.net/ Put it into a *protected* directory on your server. You only have to put your MySQL access values into the config file and off you go. > > I'd like to present a webpage to give the view these > choices: > > 1) viewing the entire directory sorted by surname > 2) viewing the entire directory sorted by street and then > by housenumber, i.e., by address > 3) viewing all of the entire records of all who meet a > simple criterion: piece of an email address (eg, "comcast" > would list everyone that had comcast in the eail field), > piece of and of the names or streets, etc. Read yourself through the manual of the mysql functions: http://de3.php.net/manual/en/function.mysql-connect.php > > I have "PHP and MySQL for Dummies". The only thing I > haven't seen that (I think) I need for the above is how to > sort on two fields. This is easily done by seperating the columns by comma: SELECT * FROM table ORDER BY surname, firstname This will first sort by surname and within equal surnames by firstname. > > Can anyone help me get started? It seems like a pretty easy > things to do. Perhaps if someone has already done this, > they might share their stuff with me. I'm much better at > hacking away at other people's stuff than developing my own > from scratch! :-) Best regards, Torsten Roehr