Jump to content


Photo

Please help very inept programmer! - connection problems


  • Please log in to reply
2 replies to this topic

#1 Fearpig

Fearpig
  • Members
  • PipPipPip
  • Advanced Member
  • 195 posts

Posted 25 July 2006 - 03:32 PM


Hi guys any help with this would be appreciated.... I'm just starting out in PHP and I have a webserver with IIS 6, PHP and MySQL. I've set up a database with 1 table and I'm trying to pull some very basic data out but I'm having problems establishing a connection.

Here are the details and the error message. Can anyone see the problem or suggest a way to start checking things?

Database: TelephoneList
Table: TelephoneNumbers
Username: root
Password: password


Here's my PHP page:

<html>
<head>
</head>
<body>
<?php

$db = mysql_connect("localhost", "root", "password");

mysql_select_db("Telephonelist",$db);

$result = mysql_query("SELECT * FROM telephonenumbers",$db);

printf("First Name: %s<br>\n", mysql_result($result,0,"first_name"));

?>
</body>
</html>

...and here's the error it gives:

Fatal error: Call to undefined function mysql_connect() in D:\Intranet v3\php_telephone_list\index.php on line 7


Cheers guys!

"Whats wrong with the cat?" - Mrs Schrödinger

#2 trq

trq
  • Staff Alumni
  • Advanced Member
  • 31,041 posts

Posted 25 July 2006 - 03:38 PM

mysql support is not enabled in your php installation. What steps did you follow to install php?

#3 Fearpig

Fearpig
  • Members
  • PipPipPip
  • Advanced Member
  • 195 posts

Posted 25 July 2006 - 03:59 PM

Aaaahhhhh!  :D

I didn't really just raced through the install! Cheers Thorpe I'll go away and check my PHP install.
"Whats wrong with the cat?" - Mrs Schrödinger




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users