Problems with connecting to local MySQL

Anon

Hello.
I have installed Apache, php4 and MySQL on my Win ME PC. It was all working fine, I could create and fill tables with PHPMyAdmin.
But than I tried to access the Database with the following script:

<?
$link = mysql_connect("localhost", "root");
mysql_select_db("database",$link);
$query = mysql_query("SELECT * FROM table",$link);
$anz = mysql_affected_rows($query);
echo $anz;
?>

The Output is as follows:
Warning: Supplied resource is not a valid MySQL-Link resource in c:\windows\desktop\local_www\test2.php on line 5

I checked the syntax, tried with pconnect, with other usernames and more. But nothing worked.

Can anyone help me here?

CU Dragir

dmduclove

I think, on line 5: $anz is a array.
So that,you try again: echo $anz[0];
0 = the first name column.
1 = the second name column.
Best Regards.
Do Minh Duc

Dragir wrote:

<?
$link = mysql_connect("localhost", "root");
mysql_select_db("database",$link);
$query = mysql_query("SELECT * FROM table",$link);
$anz = mysql_affected_rows($query);
echo $anz;
?>

The Output is as follows:
Warning: Supplied resource is not a valid MySQL-Link resource in c:\windows\desktop\local_www\test2.php on line 5

I checked the syntax, tried with pconnect, with other usernames and more. But nothing worked.

Can anyone help me here?

CU Dragir

Anon

Add an "or die" to your query.

$query = mysql_query("SELECT * FROM table",$link) or die (mysql_error());

I mostly get the error you specify when my query is not returning anything. Echoing an array without a location will normally just give you a blank, not a mysql resource error.

You also need a password in your $link line I believe:
$link = mysql_connect("localhost", "root");

Change to:

$link = mysql_connect($dbhost, $dbuser, $dbpass);

In fact, try adding the password first before the "or die".

Anon

I will try the first one.
The one with the password is not true, in fact it would be enough to use the connect function without any parameter.

Anon

First the problem is in this line:
$anz = mysql_affected_rows($query);

2nd $anz is no array.

But thanx for the answer anyway.

RiboZz

<?
$link = mysql_connect("localhost", "root");
mysql_select_db("database",$link);
$query = mysql_query("SELECT * FROM table",$link);
$anz = mysql_affected_rows($link);
echo $anz;
?>

$anz = mysql_affected_rows($query); ==>> $anz = mysql_affected_rows($link);

mysql_affected_rows expects db link, not a result resource 🙂

Piranha

It is good that you search first, but if you don't find an answer please start a new topic to avoid confusion.

Anyway, you should be able to get the number of affected rows without the $link:

$anz = mysql_affected_rows();

To get errors you can add or die(mysql_error()) in the end of the query:

$query = mysql_query("SELECT * FROM table",$link) or die(mysql_error());

Is it only this that causes problems or is everything with the database?