I'd endorse "SQL for Smarties", plus just about anything else JC has written on SQL.
Another good book is "The Practical SQL Handbook" by Bowman, Emerson & Darnovsky, ISBN 0-202-44787-8 For a tutorial have a look at Julie Meloni's at http://www.thickbook.com. They are "single issue" tutorial, aredevloped progressively and quite clear. A new user must read the section of the manual which deals with variables. The way PHP creates variables automatically can be a bit confusing to the newcomer. Hope this helps - Miles Thompson At 04:49 PM 9/3/2002 +0200, Ignatius Reilly wrote: >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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
