I have php4 and mysql running on apache. I built a database of clients so that the info can be entered and updated on a webpage. Under the phone and fax columns, only the fax is updated, while both have exactly the same parameters (varchar20):
The form contains the following:
<tr><td>*Phone:</td><td><input type="Text" size=20 name="Phone"
value="<?php echo $Phone?>"></td></tr>
<tr><td>Fax:</td><td><input type="Text" name="Fax" size=20 value=http://www.phpbuilder.com/board/archive/index.php/"<?php echo
$Fax?>"></td></tr>
I checked elsewhere on all the stuff relevant to phone and fax. They are all
using the same approach. However, only the fax number is updated with new
entries and updates. The phone column always turned up blank.
Here's part of the program:
{
$sql = "INSERT INTO dbase (Fname, Lname,Userid, Password,
Email,Phone,Fax,Address,City,State,Country,Zip)
VALUES
('$Fname','$Lname','$Userid','$Password','$Email','$Phone','$Fax','$Address'
,
'$City', '$State','$Country', '$Zip'
)";
$result = mysql_query($sql);
.....
Very puzzling. Any advice?
Lawrence
The form contains the following:
<tr><td>*Phone:</td><td><input type="Text" size=20 name="Phone"
value="<?php echo $Phone?>"></td></tr>
<tr><td>Fax:</td><td><input type="Text" name="Fax" size=20 value=http://www.phpbuilder.com/board/archive/index.php/"<?php echo
$Fax?>"></td></tr>
I checked elsewhere on all the stuff relevant to phone and fax. They are all
using the same approach. However, only the fax number is updated with new
entries and updates. The phone column always turned up blank.
Here's part of the program:
{
$sql = "INSERT INTO dbase (Fname, Lname,Userid, Password,
Email,Phone,Fax,Address,City,State,Country,Zip)
VALUES
('$Fname','$Lname','$Userid','$Password','$Email','$Phone','$Fax','$Address'
,
'$City', '$State','$Country', '$Zip'
)";
$result = mysql_query($sql);
.....
Very puzzling. Any advice?
Lawrence