[Resolved] updating a table

harlequeen

I have a page where information from 2 tables is displayed in a form so the user can amend the information. The code used is below and that seems to get the information I want.

$amendbooking = mysql_query("SELECT * FROM Bookings LEFT JOIN Rooms ON
 Bookings.BOOKING_ID = Rooms.Bookings_BOOKING_ID WHERE BOOKING_ID='$BOOKING_ID'" );

while ($myrow = mysql_fetch_array($amendbooking)) 

{
mysql_close();

Then, after amending the information is sent via the save button and actions the following

or die ("Sorry - could not connect to the guests database");

$BOOKING_ID=$HTTP_POST_VARS['BOOKING_ID'];
$Guests_Guest_ID=$HTTP_POST_VARS['Guests_Guest_ID'];
$DATE_FROM=$HTTP_POST_VARS['DATE_FROM'];
$DATE_TO=$HTTP_POST_VARS['DATE_TO'];
$NO_OF_PEOPLE=$HTTP_POST_VARS['NO_OF_PEOPLE'];
$Room_Type=$HTTP_POST_VARS['Room_Type'];



$query =("UPDATE Bookings SET Guests_Guest_ID='$Guests_Guest_ID', DATE_FROM='$DATE_FROM', DATE_TO='$DATE_TO', NO_OF_PEOPLE='$NO_OF_PEOPLE' WHERE BOOKING_ID='$BOOKING_ID'");
$result=mysql_query($query);
if ($result) {
header('Location: amendresult.php?confirm=Success');
}//end if result
else {
echo "<b>ERROR: unable to post - Try Logging in again</b>";
}//end else

All this is on one page. I am getting a 'Success' report on the next page, but the database is not being updated.

I also tried echoing the variable values to the screen, just after the $Room_Type=$HTTP_POST_VARS['Room_Type']; line

I have been looking at this all morning and can't see why it won't update.

Any help would be appreciated.

kkobashi

I also tried echoing the variable values to the screen, just after the $Room_Type=$HTTP_POST_VARS['Room_Type']; line

And... what was the result? Were the values set to what you expected? If not, there's your problem.

Maybe try using $_POST instead. HTTP_POST is old school.

harlequeen

the variables didn't pass anything back to the screen.

I will try the $_POST method.

Cheers

kkobashi

Originally posted by harlequeen
the variables didn't pass anything back to the screen.

I will try the $_POST method.

Cheers

If the variables didnt pass anything back to the screen, that should clue you in on something... that its not a database problem.

I believe $HTTP_POST_VARS requires you to declare them as global at the point of usage.

But I don't use it anymore as $POST and $GET get me what I want and are already global.

For example:

function foo()
{
global $HTTP_POST_VAR;

echo $HTTP_POST_VAR["blah"];
}

function foo2()
{
echo $_POST["blah"];
}

foo2() doesnt require me to list blah as global.

harlequeen

Have just tried $_POST and I do not get as far as the 'success' output.

I have changed back to $HTTP_POST for the timebeing as I have another page which is working OK, doing similar things using that.

I suddenly realised that I hadn't included the BOOKING_ID variable in the form itself. Duh....

I can now update the bookings table, but have yet to work out how to update the second table.

Cheers