||- Resource id#2

[sfullman]

I get the following mysql_error when trying to connect to a database:

Resource id#2

Can anyone tell me what that means?

Here is the sql string:

select CompanyName, Address1, City, State, ZipCode, Z4, Phone, Fax from akma.company where City = 'Anchorage' order by CompanyName ASC limit 0, 75;

Thanks,
Sam Fullman

[mattw]

The cause for this normally is that you are trying to echo out what you got back from the mysql_query command. if you are doing this:

$query = "select CompanyName, Address1, City, State, ZipCode, Z4, Phone, Fax from akma.company where City = 'Anchorage' order by CompanyName ASC limit 0, 75"
$result = mysql_query($query);
echo $result;

then that is wrong...

you need to do something like this:

$query = "select CompanyName, Address1, City, State, ZipCode, Z4, Phone, Fax from akma.company where City = 'Anchorage' order by CompanyName ASC limit 0, 75"
$result = mysql_query($query);
$row = mysql_fetch_array($result)
foreach($row as $key => $value) {
echo $key . " - " . $value . "<BR>\n";
}

If that isn't the problem, forgive me 🙂 and please post what you are doing so that we can figure out where the problem lies..

Matt Wade
codewalkers.com

[sfullman]

Actually I figured it out.

$dbcnx2 = mysql_connect("localhost", "admin", "********");
$queryResult = mysql_query($sqlString) or die(mysql_error());
echo $queryResult . "<br>";

Resource id#2 actually means a good connection, I had no data installed for that query.

Sam