Table 'food.data' doesn't exist

[natodd]

I have XAMPP 1.5.5 installed on a Windows 2003 Server. I setup a php page with an HTML form to submit data to my database called food. When I attempt to submit an entry into the db, I get the following:

Code: Select all

Table 'food.data' doesn't exist

I'm not sure why it has the .data tagged on it. I verified that I am using the correct case and I also confirmed that it is in the default path. PHPmyAdmin finds the db ok and is able to make changes, however my php page has problems finding it. When I search the machine itself for food.data it isn't found. What it finds are:

food.frm
food.MYD
food.MYI

and these are all located in the food directory here:

C:\Program Files\xampp\mysql\data\food

Any help on why I'm getting this error is much appreciated.

Thanks,

Nate

[Wiedmann]

PHPmyAdmin finds the db ok and is able to make changes, however my php page has problems finding it.

Then your PHP script have an error...