Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 First time connecting to MSSQL but Error

Author  Topic 

zamaan
Starting Member

19 Posts

Posted - 2006-04-15 : 02:11:15
Hi.

i am in my early days on intergrating MY Sql with PHP.
My windows 2000 server has bought PHP and MYsql installed.

When i attempt to connect to the mysql server using the forllowing PHP code
the below error message appears.

"Fatal error: Call to undefined function mysql_connect() in E:\Web_Server\php\con_mysql.php on line 2"

my php code is as follows.

[php]
<?php
$link = mysql_connect('MYSERVER', 'admin', '123456');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>
[/php]


What could be the problem?

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-04-15 : 05:03:21
don't know anything about php but
does the function mysql_connect exists?


--------------------
keeping it simple...
Go to Top of Page

zamaan
Starting Member

19 Posts

Posted - 2006-04-15 : 05:49:19
Yes ofcause.
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-04-15 : 06:09:55
post the code so we can take a look where the error is invoked

--------------------
keeping it simple...
Go to Top of Page

zamaan
Starting Member

19 Posts

Posted - 2006-04-15 : 10:44:04
Hi jen.

same code is working on my webserver (godaddy). but in win2k local intranet it produses an error.

would it be a problem in php configuration?. coz this php built in function "mysql_connect()" is not identified by the server. see the error message again in my first post..



Go to Top of Page

nr
SQLTeam MVY

12543 Posts

Posted - 2006-04-15 : 11:09:41
You might be better off asking in a PHP or mysql forum ratherthan sql server (PHP probably).
It is saying that it can't find mysql_connect so where should it find it?

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

zamaan
Starting Member

19 Posts

Posted - 2006-04-15 : 11:58:51
Yes jen.

i put this same thread here and seems getting some positive results.
http://www.webmasterworld.com/forum88/12527.htm

Go to Top of Page
   

- Advertisement -