table name problem

[aman21]

getting the following error message

Table 'sbstud.EComm_Customer' doesn't exist

using the following code

---

$conn = mysql_connect("ipaddress","sbstud","steve6");

mysql_select_db("sbstud",$conn);

$result = mysql_query("SELECT first_name FROM EComm_Customer") or die(mysql_error());

---

the table EComm_Customer is in the database, but php looks for the fully qualified name. When I run the query within my PHP client, the records are retrieved.

I don't need the db name "sbstud" added to the table name in the select statement.

thanks

andy

[PHPdev]

I beleive this comes from the mysql_query() function it fully qualifies the tables and fields in the query.

My only sudgestion is to check your spelling very carefully. Generaly when I get this error it is because I have missed typed something...

sorry dont have more

PHPdev