Hello,

something is wrong in chapter 3 since even when I used the downloaded
code(s) I still got the same problem.

on pages 94 and 95 we create the file (createmovie.php) then we create
(moviedata.php) and within this last file we are connecting to the database (moviesite) although I think we should be connecting to the one that we have just created (createmovie.php).

When I run (createmovie) or the (moviesite) I get the following message:
(Table Movie already exists)

and when I run the moviedata I get the following:
Duplicate entry '1' for key 1

EVEN WHEN I USED the downloaded codes!

this seems is effecting me in chapter 4:

in the examples table1 and table2

I'm getting the following:
(
Unknown column 'movie_name' in 'field list'
)

I'm really feeling stuck here since all the coming examples in this
toutorial depends on each other.

So does any body has any idea what is going on here?

Thanx

Maram:(

It sounds like you're trying to create the movie databases/tables, when they already exist in MySQL. Either don't try to recreate them, or drop them and start over.

Change you createmovie.php file create table statement to

$movie = CREATE TABLE IF NOT EXISTS movie( etc...
then if the table already exists you done get a die error.

The name of the database created by running createmovie.php is "moviesite"

In the moviedata.php file the tables are populated the first time each segment is completed without error. The next time you run the file your are trying tp populate with data that has the same primary key id. Since these keys have to be unique you can't have another record with the same id.

This is the point I am at in doing the examples so I don't yet know how to handle this type of error. I suppose you should just ignore the error and not insert the record and continue execution of remaining code.

Hope this helps.