MySQL WinNT Problem

Anon

Hi-

I'm running mysql on winNT4.0 and am running into a weird problem with one of my tables in my database. I can connect and query from other tables just fine. This one however gives me a problem and it doesn't report any errors. My query code is as follows:

if (!($result = mysql_db_query("database1","SELECT user_id,posted,header,comment FROM comments WHERE cat='".$type."' AND entry_id='".$new_photo[0]."' ORDER BY posted DESC LIMIT 10"))) {
echo "internal error ".mysql_errno().":".mysql_error();
exit();
}

I also have a problem when I try to insert into this table with the following code:

if (!($result = mysql_db_query("hotpicks","INSERT INTO comments (cat,entry_id,user_id,posted,header,comment)
VALUES ('$type','$id','$userid',NOW(),'$header','$comments')"))) {
echo "internal error ".mysql_errno().":".mysql_error();
exit();
}

This gives me the same problem. The output I get from this is just "internal error" which is the string I wrote. I don't get any mysql error output.

Again this is the only table causeing the problem. I tried re-creating it with no luck.

Thanks in advance-

andy

Anon

have you used the correct
1. mysql_connect
2. mysql_select_db string ?

the query is acting on some default database, use the mysql_select_db function to set it to whatever db you want. check the manual pages to see how to make a connection.

eg from the php pages follows.

<?php
$link = mysql_connect("mysql_host", "mysql_login", "mysql_password")
or die ("Could not connect");
print ("Connected successfully");
mysql_select_db ("my_database")
or die ("Could not select database");

$query = "SELECT * FROM my_table";
$result = mysql_query ($query)
    or die ("Query failed");

// printing HTML result

print "<table>\n";
while($line = mysql_fetch_array($result)){
	print "\t<tr>\n";
	while(list($col_name, $col_value) = each($line)){
		print "\t\t<td>$col_value</td>\n";
	}
	print "\t</tr>\n";
}
print "</table>\n";

mysql_close($link);

Anon

also try to check the $result in a different manner. eg.

$result = mysql_query($query);
if($result)
{
..
}
else
{
..
}

try to simplify your code...

cheers.
nilesh.