MySQL

Chris_Evans

Hello,
After some time with messing about with MySQL, I finally got it working! The problem I now face is that I am either doing something wrong here or I can't connect to the MySQL server on windows (my home computer) for some reason or another. The following is the code I am using:

PHP:

<html>
<body>

<?php
$db = mysql_connect("localhost", "root");

mysql_select_db("mydb",$db);

$result = mysql_query("select * from employes",$db);

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

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

printf("Address: %s<br>\n", mysql_result($result,0,"last"));

printf("Position: %s<br>\n", mysql_result($result,0,"position"));

?>

</body>
</html>

Once I run this code I get the following error within IE6:

IE6 Error:

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\PHP\mysqlconnect.php on line 11
First Name:

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\PHP\mysqlconnect.php on line 13
Last Name:

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\PHP\mysqlconnect.php on line 15
Address:

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\PHP\mysqlconnect.php on line 17
Position:

If anybody could help me, I would be very grateful.

Thank you in advance,

Chris Evans

run2web

Originally posted by Chris_Evans
$db = mysql_connect("localhost", "root");

I am not sure if this is the problem but try using

$db = mysql_connect("localhost");

The other fields are for username and password so if your user name isn't root then it may not be able to connect.

Chris_Evans

Hi run2web,
I have just tried changing it to that yet it still doesn't work and it still comes up with the same errors. I know that MySQL is running and I have checked that the database, tables and data exist. The last thing I can think of is that it isn't connecting for some reason to the MySQL server. I am running Windows XP, is there anything I have to do on it other than installing it to get PHP to connect to it. Or is there anything I have to do to PHP to get it to connect to the MySQL server?

Thank you in advance,

Chris Evans

run2web

I am assuming that you have MySQLAdmin running in the background.

I honestly don't know why it won't connect.

Check this line:

$result = mysql_query("select * from employes",$db);

Is it employes or employees and I don't think that you need ,$db in your select statement. Remove that and see what happens.

Also, check to make sure that this is the correct statement for this line:

printf("Address: %s<br>\n", mysql_result($result,0,"last"));

shouldn't it be

printf("Address: %s<br>\n", mysql_result($result,0,"address"));

???

Chris_Evans

Hello again!
OK, I am happy now! I think that is a lesson we should all learn from (perhaps me more than anyone!). Read through what you write! Those two mistakes fixed the connection! I am really pleased that you pointed them out to me and I thank you so much new2web for what you have done! 🙂

Thank you for your help,

Chris Evans

run2web

Anytime, glad it worked! 😃

marconi8

why i cannot connect to server where is installed mysql

mysql is normally installed, user has host permisions like 'any'
i can connect trough odbc to remote .mysqll.server

thanks for helping