Not a Valid Link Index?

[Anon]

Hi there,

I have a script that is supposed to connect to a dabase and do an INSERT statement. However, the damned thing isn't working for reasons I cannot comprehend.

All of the connecting works fine, without any errors. However, when I run the query, it throws this error:

Warning: 0 is not a MySQL link index in /usr/local/etc/httpd/vhosts/thudbuster.com/htdocs/store/robot.php on line 168

The query is:

mysql_query($sql);

There's nothing wrong with the SQL code; I tried it from the command line and it worked perfectly.

Huh? My link is simply what I got from a statement like so:

$db = mysql_connect("localhost","MYUSER","MYPASS");

What gives?

[Anon]

It's telling you that you don't have a connection. You need to check that $db isn't 0. If it is then mysql_connect failed for some reason.

If you turn on full error reporting:
error_reporting(15);
Then you should see why you aren't getting a database connection.

[Anon]

Hi,

$result = mysql_query($query,$link_id) or die(mysql_error($link_id));

You have to pass the $link_id too.

hope it works.

-m.

[yelvington]

Nope. The link identifier is clearly documented as optional.

[Anon]

oops, thx.

then maybe we can try and see if a connection is being established at all :

if (!$link_id = mysql_connect($sqlhost,$sqluser,$sqlpass))
{
die("Could not establish link");
}

-m.