For a SQL tutorial, I would recommend that you get yourself a copy of Joe Celko's "SQL for smarties". Best investment I ever made. Everything you need to know is there.
Bon courage! ----- Original Message ----- From: "Matt Zur" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 03, 2002 3:08 PM Subject: Re: [PHP-DB] Indepth Tutorial... need help. > Right well that's what I'm asking I need a tutorial and haven't found a > good one. > > -Matt > > Rasmus Lerdorf wrote: > > Most of this stuff is actually just SQL and has little to do with PHP. So > > look for an SQL tutorial. From the PHP side all you need to know is > > mysql_connect(), mysql_select_db(), mysql_query() and mysql_fetch_row().'' > > > > All queries are sent to the database via mysql_query(). It doesn't matter > > to PHP if you are adding, deleting, modifying, searching, sorting, > > filtering, or whatever. You just put the SQL code in the mysql_query() > > call. > > > > -Rasmus > > > > On Tue, 3 Sep 2002, Matt Zur wrote: > > > > > >>Can someone point me in the direction of an online tutorial for php > >>mysql that covers the following: > >> > >>- Teaches me how to use php to access mysql > >>- Creating a db that is structured to be efficient > >>- How to add, modify, and delete records in a database > >>- How to search for records > >>- How to filter records > >>- How to sort records, by a certain field, alphabetical, descending etc. > >>- Indexes - how to create them, how to keep the updated with changes in > >>the db a beginners look to in-depth approach. > >> > >>Yes I've visited PHP.net, and mysql.com. I need a dumbed down version > >>that pretty much holds my hand and is very detailed. I've searched the > >>net for a while now, and all the tutorials I have found... although > >>simple... they don't go in-depth and move on to more advanced features. > >> > >>Any help at all will be greatly appreciated. > >> > >>-Matt > >> > >> > >>-- > >>Matt Zur > >>[EMAIL PROTECTED] > >>http://www.zurnet.com > >> > >>Need a Web Site??? - Visit... www.zurnet.com > >> > >>1997 - 2002 - 5th Anniversary!!! > >> > >> > >>-- > >>PHP Database Mailing List (http://www.php.net/) > >>To unsubscribe, visit: http://www.php.net/unsub.php > >> > > > > > > > -- > Matt Zur > [EMAIL PROTECTED] > http://www.zurnet.com > > Need a Web Site??? - Visit... www.zurnet.com > > 1997 - 2002 - 5th Anniversary!!! > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php