Need help with MySQL, i'm a complete NOOB!

[phpmaniac]

Hey Guys,

I recently got the Build Your Own Database Driven Website with PHP and MySQL. I read all the installation instructions, installed PHP 5.0 on windows XP pro. MySQL 4.0 aswell.

I wrote a load of code, but it either returns a blank page when I put: @$dbcnx = @mysql_connect
or it says:

Fatal error: Call to undefined function mysql_connect() in c:\program files\apache group\Apache\htdocs\php\jokelist.php on line 9
when I take out the '@'.

What should I do, should I change config settings? whats wrong? HELP!

Thanks for your time,

Regards, PHPMANIAC

[Nick]

I'm not sure how the book does it, but I would do it like this:

$dbc = mysql_connect("localhost", "username", "password")or die("Could not connect to the database: " . mysql_error());
mysql_select_db("database");
[...]
$Query = "";
$Result = mysql_query($Query, $dbc); 

Though I usually don't even assign the connection to a var as I only have one connection open on my site.

[phpmaniac]

How would you do it then? (if you don't assign to vars)

Thanks for your help aswell I will try it out now.

Regards, PHPManiac