Hi,
I have created the databases (db_ch03-1.php and db_ch03-2.php) as per pages 87 to 89 but keep getting an error message when i try and run it from my browser. The message i get is "Table 'movie' already exists"

I have checked and triple checked that i have entered correct code and just can't seem to find what is causing this error.

Please please help me !!

I think you're ok with this error. Once you run the script, the table is created. If you run it again, you will get the table exists error.

If you're comfortable at the MySql prompt enter this:

Mysql>use moviesite;
MySql> show tables;

You should see your tables listed. Then try:

MySql> describe movie;

You should see the table and all of it's columns. Then try:

MySql> select * from movie;

You should see all of the movie table 's data.

If you need to run the script again, first do this:

MySql> drop table movie;

This will erase the table and all of it's data. You can then run your script again and it should work error free.

BTW, if you don't know about using MySql prompt, write back. It can also be done through php. It's just more cumbersome.

Let me know how it goes.
Regards,
Boz

Boz,

Thanks a million - It works now.

Yippeee