Chapter 4-Error message

[email protected] · January 14th, 2010, 05:31 PM

After the changes, this is the error message, always the same:

Unknown column 'movie_runnig_time' in 'field list'

Now the code is the next:

Code:

<?php
$db = mysql_connect('localhost', 'bp6am', 'bp6ampass') or
    die ('Unable to connect. Check your connection parameters.');
mysql_select_db('moviesite', $db) or die(mysql_error($db));

// modifica la tabella movie aggiungendo i campi per durata, incassi e costi
//$query = 'ALTER TABLE movie ADD COLUMN (
//      movie_running_time TINYINT UNSIGNED NULL,
//       movie_cost         DECIMAL(4,1)     NULL,
//       movie_takings      DECIMAL(4,1)     NULL)';
//mysql_query($query, $db) or die (mysql_error($db));

// inserisce i nuovi dati nella tabella movie
$query = 'UPDATE movie SET
        movie_runnig_time=101,
        movie_cost=81,
        movie_takings=242.6
    WHERE
        movie_id=1';
mysql_query($query, $db) or die(mysql_error($db));

$query = 'UPDATE movie SET
        movie_running_time=89,
        movie_cost=10,
        movie_takings=10.8
    WHERE
        movie_id=2';
mysql_query($query, $db) or die(mysql_error($db));

$query = 'UPDATE movie SET
        movie_running_time=134,
        movie_cost=NULL,
        movie_takings=33.2
    WHERE
        movie_id=3';
mysql_query($query, $db) or die(mysql_error($db));

echo 'Movie database successfully updated!';
?>

HELP

s.c. · January 14th, 2010, 05:50 PM

Your code will continue to fail if you do not fix runnig to running.

You have a typographical error in your code that is causing the problem. Until you fix that, your code will continue to fail at the same point.

Hopefully the site translated this correctly...
Lei ha un errore tipografico nel suo codice che causa il problema. FinchÃ© lei ciÃ² ripara, il suo codice continuerÃ a fallire allo stesso punto.

Code:

<?php
$db = mysql_connect('localhost', 'bp6am', 'bp6ampass') or
    die ('Unable to connect. Check your connection parameters.');
mysql_select_db('moviesite', $db) or die(mysql_error($db));

// modifica la tabella movie aggiungendo i campi per durata, incassi e costi
//$query = 'ALTER TABLE movie ADD COLUMN (
//      movie_running_time TINYINT UNSIGNED NULL,
//       movie_cost         DECIMAL(4,1)     NULL,
//       movie_takings      DECIMAL(4,1)     NULL)';
//mysql_query($query, $db) or die (mysql_error($db));

// inserisce i nuovi dati nella tabella movie
$query = 'UPDATE movie SET
        movie_running_time=101,   <<<<<<<<<<<<<<<<<<<<<<<<<<<<< FIX THIS!
        movie_cost=81,
        movie_takings=242.6
    WHERE
        movie_id=1';

[email protected] · January 14th, 2010, 06:10 PM

OK!
I AM SO STUPID...
Now this is the message:
Movie database successfully updated!

WOW! THANK YOU SO MUCH... YOU ARE THE BEST!

s.c. · January 14th, 2010, 06:16 PM

No problem, it is all part of programming...

Have a good day.