need help

[hingis_rules]

Hey

After connecting to the database, not getting any errors I try to run

$res = mysql_query ("SELECT COUNT(*) FROM infotbl",$c);
if (!$res)
	{
		print "error #: ".mysql_errno();	
		print "<br>error: ".mysql_error();
	}
	else	
	{
		if ($row= mysql_fetch_row ($res))
			print "There are ".$row[0]. "records in the database";
	}

to see how many records therer are and I get

error #: 1146
error: Table 'maindb.infotbl' doesn't exist

When I use phpMyAdmin, I find out that table does exist. And has 5 records. That I enterted usign phpMyAdmin for testing.

I aslo get that error when I try to run query like

$res = mysql_query ("INSERT INTO infotbl (f_name,l_name) VALUES ('Fred','Flinstone')",$c);
if (!$res)
	{
		print "error #: ".mysql_errno();	
		print "<br>error: ".mysql_error();
	}
	else	
	{
		if ($row= mysql_fetch_row ($res))
			print "There are ".$row[0]. "records in the database";
	}

What could be the problem that is causing this error.

Thanks

[cgraz]

error: Table 'maindb.infotbl' doesn't exist

This tells you that the database is maindb and the table is infotbl. Make sure that infotbl is in the database maindb, and not another database. That's the only reason I could see for you having this problem from what you wrote.

Cgraz

[hingis_rules]

Yes the table " infotbl" is in the 'maindb' database, beause I created it by using phpMyAdmin.

In the "Run SQL query/queries on database maindb :" text area i typed

CREATE TABLE infotbl (
f_name varchar(20) NOT NULL default '',
l_name varchar(50) NOT NULL default '',
email_address varchar(100) NOT NULL,
password varchar(12) NOT NULL
}

and click the GO button to create the table. After creating the table I tried running the PHP code and ran into that error. Thinking that the table can't be found because there is no data, I ran phpMyAdmin and added 5 test entries. Then ran the PHP code again and got the same error.

I don't understand why that PHP code can't find the table when it does exist.

Any suggestions??

Thanks

[cgraz]

Try a SELECT

// make database connection here

$query = mysql_query("SELECT * FROM infotbl") or die(mysql_error());

echo "There are " . mysql_num_rows($query) . "rows<br>";

while($row = mysql_fetch_array($query)) {
   print $row["0"] . "<br>"; // or print a few fields here.
}

What does that print?

Cgraz

[hingis_rules]

Table 'maindb.infotbl' doesn't exist

[cgraz]

I have no idea. I'd have to play around with it. That's the best advice I can give you. Just play around with it. Delete the table and create a new one and try that.

Cgraz

[hingis_rules]

still get the error even after deleting and creating a new table.

[WizyWyg]

are you sure you're connecting to the corred db?