hair has been pulled out - any ideas ??

stuartc1

can anyone see why this is not working ?

$db2 = mysql_connect("localhost", "root", "xxxxx");
mysql_select_db("prod",$db2);

$edref = "aaaaa" // this is the value. ive checked

$qry = mysql_query("SELECT * FROM br_comp WHERE ref = '$edref'", $db2);
while($row = mysql_fetch_array($qry)){
$ref_code = $row["ref"];
$source = $row["source"];
$subject = $row["subject"];
$compname = $row["compname"];
$submit = $row["submit"];
$url_string = "&update=yes";
}

error: Supplied argument is not a valid MySQL-Link resource

I have ran the SQL direct to MySQL and its fine (returns 1 result), the case is fine ??

mrmufin

Perhaps if you made your query look something like:

mysql_query("SELECT * FROM br_comp WHERE ref = '$edref'", $db2);

instead of:

mysql_query("SELECT * FROM br_comp WHERE ref = '$edref', $db2");

you'd get better results...?

stuartc1

ye, sorry just noticed that in my post .

that's not the problem however. I typed that part of my post by hand.

here is a paste of the actual code in full:

$db2 = mysql_connect("localhost", "root", "xxxxx");
mysql_select_db("prod",$db2);

if (isset($edref)) {
$qry = mysql_query("SELECT * FROM br_comp WHERE ref = '$edref'", $db2);
while($row = mysql_fetch_array($qry)){
$ref_code = $row["ref"];
$source = $row["source"];
$subject = $row["subject"];
$compname = $row["compname"];
$submit = $row["submit"];
$url_string = "&update=yes";
}
} else {
$ref_code = "";
$source = "";
$subject = "";
$compname = "";
$submit = "";
$url_string = "";
}

mrmufin

The throw some debugging capabilities in there:

$query = "SELECT * FROM br_comp WHERE ref = '$edref'";
$result = mysql_query($query, $db2);
if(!$result) {
	echo "Query $query failed: " . mysql_error();
}
if(!mysql_num_rows($result)) {
	echo "Query $query returned no rows.";
} else {
	while($row = mysql_fetch_array($result)) {
		// do the result processing here...
	}
}

stuartc1

cheers anyway...

i've actually made a total @$nt of it. it turns out the connection strings were locked up in some other if..else statement and were not getting read.:rolleyes: