Re: Re: Newbie Questions

On Wed, 1 Sep 2004, Pete Holsberg wrote: > On Wed, 1 Sep 2004, Torsten Roehr wrote: > > > "Pete Holsberg" <pjh@mccc.edu> wrote in message > > > > news:Pine.GSO.4.10.10409011359210.7843-100000@tecoma.mccc.edu... > > > > > > 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. My ISP has it availble. > > > 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 Um, I looked there and it's overwhelming! > > > 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. Thanks. > > > 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! :-) I think I need just a little push in the right direction. After I send the above SELECT command, how do I get the result to appear on a web page? Thanks.