When submitting a form to insert/replace data into my database with
values loaded from the previos page I show that everything is entered
except for these fields: Why? I am using version mysql-3.23.32-1.7
| Field | Type | Null | Key | Default |
Extra |
rating | varchar(5) | YES | | NULL
| |
instrumental | char(1) | | | N
| |
favorite | char(2) | YES | | N
| |
Here are some sample values I entered:
Rating: ***
instrumental: N
Favorite: N
Here is the REPLACE part:
$query = "REPLACE INTO songs VALUES ('$id',
'$songname','$instrumental','$beat','$mood','$rating','$favorite','$video',
'$album_id', '$movie', '$newfilename', '$bitrate')";
Here is the form part
<TR><TD align="right">Rating: </TD><TD><input type=text name='rating'
value="<? echo $rating; ?>"><br></TD></TR>
<TR><TD align="right">Favorite: </TD><TD><input type=text
name='favorite' value="<? echo $favorite; ?>"><br></TD></TR>
I am using urlencode on the previos page to pass the previos values:
$instrumental=urlencode($instrumental);
and they click on this link which is where the values get assigned and
they appear in the form:
When I submit it shows the values of each variable and they are correct
a
href='updatesongrecord.php?id=$id&songname=$songname&instrumental=$instrumental&beat=$beat&mood=$mood&rating=$rating&favorite=$favorite&video=$video&album_id=$album_id&movie=$movie&newfilename=$newfilename'>";
?><b>Update Song Record:</b> <? echo "$ID"; ?></TD>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php