[Tatyana]

Hi all,

I'm not exactly a programmer, I'm a web designer, but I'm really interested in database-driven websites and would like to have it all clear. Most of all I would like to learn about how to connect a database table to a webpage - does any of you know about a site/article/tutorial/whatever on this subject?

I'd appreciate any suggestions! Thanks!

Tatyana

[darkcarnival]

well to connect to a db is really simple heres how to do it:

PHP Code:

$db_connection = mysql_connect ($DB_HOST, $DB_USER, $DB_PASS) or die ('Could not connect to MySQL: ' . mysql_error());



mysql_select_db ($DB_NAME) or die ('Could not select database: ' . mysql_error());



$query = "SELECT * FROM tablename 

hope this helps

[RynO]

There's a book i read that really helped me with this stuff.

'PHP and MySQL Web Development' By Luke Welling and Laura Thomson. It's a very good book.

[fyrestrtr]

You can buy a book, or you can check out the following sites for tutorials

http://www.phpfreaks.com (hear lots of good things about these people)
http://www.zend.com/zend/tut/ (excellent tutorial website from Zend -- a company formed by the guys that wrote the PHP3 engine)
http://www.php.net/mysql (list of functions to connect to mysql databases using PHP)
http://www.w3schools.com
http://www.google.com/search?q=php+mysql+tutorials
<plug type="shameless">
http://www.meidomus.com (Disclaimer : This is my website, and I wrote the tutorials on it. If you have a comment about it, leave me a message )
</plug>

[darkcarnival]

?I also know a very good book that helped me program my very 1st site:

Core PHP programming by leon

and for mysql i got:

Mysql by Larry

both helped me program my 1st program and isnt that expensive

[Tatyana]

Thanks to all of you!