query problem
Posted: Fri Aug 18, 2006 12:00 pm
I built the php page on my personal server and it runs fine.
I then added it to the website server that has php and mysql installed.
database name: sbaker
table name: shows
when i run
it seems to add the database name to the table name so the mysql_error is
TABLE 'sbaker.SHOWS' doesn't exist.
help?
I then added it to the website server that has php and mysql installed.
database name: sbaker
table name: shows
when i run
Code: Select all
$display = mysql_query("SELECT * FROM SHOWS WHERE DATE >= '$todays_date' ORDER BY Date");
if (!$display) {
echo mysql_error();
exit();
}TABLE 'sbaker.SHOWS' doesn't exist.
help?