Re: Indepth Tutorial... need help.

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" <mattz@zurnet.com> To: <php-db@lists.php.net> 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 mattz@zurnet.com 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 mattz@zurnet.com 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