[Reload]

Howdy,

First off, i must admit that i have an EXTREMLEY limited knowledge of PHP, and with the help of a couple of people, i have just managed to knock together a PHP script for a new site im developing.

The problem is, ive got everything done, bar one part, that im truly stuck on:

PHP Code:

// update DB 

$sql  = "UPDATE radioshows "; 

$sql .= "SET show_name = '{$_POST['show_name']}', show_day = '{$_POST['show_day']}', show_time = '{$_POST['show_time']}', dj_name = '{$_POST['dj_name']}', dj_picture = '{$_POST['dj_picture']}' "; 

$sql .= "WHERE show_id = '{$_GET['show_id']}'"; 

if (mysql_query($sql)) { 

    // DB updated correctly 

    ... 

} else { 

    // DB not updated - an error has occurred 

    ... 

} 

?> 

Basically, i need to fill in the dots. When the process has completed, i need it to forward to a page with a success or error message. Any ideas?

Cheers,

Lee

[mdhall]

Try this...

if (mysql_query($sql)) {
// DB updated correctly
echo "Update Successful";
} else {
// DB not updated - an error has occurred
echo "Update Unsucsessful";
}


Or try...


if (mysql_query($sql)) {
// DB updated correctly
header ("location: success.php");
} else {
// DB not updated - an error has occurred
header ("location: failure.php");
}

Success.php & failure.php would be new pages to redirect to.

[Reload]

Hmmm, dosent seem to be working.

http://www.reloaddesigns.co.uk/kewli....php?show_id=5

The 'Update Unsuccesful' shows up straight away for some reason.

Any ideas?

Cheers, Lee

[mdhall]

I noticed in some areas of your update, you use $_POST, but for the last item you use $_GET. Not sure if it makes a difference.

[Reload]

I had to use the $_GET function, as the page is generated from a row ID in the previous page. I have no idea how to get around this :S

Cheers, Lee