php&mySQL: Reading and re-writing database entries?

[mxlabs]

Hello DP!

Is it me or are there very few GOOD php+mysql tutorials... I spent 2 hours reading now and still didnt figure out how to a) read an entry and b) re-write it.

I mean... all I'd need is a simple table with all sql commands and how they are used. anything like that available?

Brian

[digitalpoint]

The MySQL functions in PHP can be found at:

http://www.php.net/manual/en/ref.mysql.php

Or if you want to be fancier, these are going to replace them at some point:

http://www.php.net/manual/en/ref.mysqli.php

But that does not teach you SQL. For SQL, the MySQL manual is a pretty good reference:

http://dev.mysql.com/doc/mysql/en/index.html

[mxlabs]

I just need some overview of common sql queries. The last link you provided looks like the right one...

The only problem is that I don't know where to start reading because I don't know the commands ;)

[digitalpoint]

You probably would want just the SQL syntax section...

http://dev.mysql.com/doc/mysql/en/SQL_Syntax.html

For reading data, it's SELECT, for updating existing data it's UPDATE, for adding new data, it's INSERT, etc...

[Help Desk]

You need to know basic SQL. Just look for those tutorials.