Re: web script doesn't work on update of database
| From: | John W. Holmes | Date: | Tue, 27 Apr 2004 15:03:58 +0000 |
| Subject: | Re: web script doesn't work on update of database | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-184764@lists.php.net to get a copy of this message | ||
From: "Chip Wiegand" <chip.wiegand@simrad.com>
> I make any change or no
> change and the data in 3 particular fields (e_month, e_day, e_year) is
> always reset to zeros.
[snip]
> // update the database record
> $result = mysql_query("update $database_table
> set month='$month', day='$day', year='$year',
> e_month='$emonth',
> e_day='$eday', e_year='$eyear', venue='$venue',
> location='$location',
> details='$details', artist_id='$the_artist_id'
> where show_id = '$the_id'",$db)
> or die_now("<h2>Could not change show</h2>");
What does a print_r($_POST) show for the values submitted for month, day and
year? If you print this query out to the screen, what are the values?
---John Holmes...