On Wed, 1 Sep 2004, Pete Holsberg wrote:
> On Wed, 1 Sep 2004, Torsten Roehr wrote:
> > "Pete Holsberg" <[EMAIL PROTECTED]> wrote in message
> > news:[EMAIL PROTECTED]
> > >
> > > 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.
> > > 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?
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php