"Daniel Clark" <[EMAIL PROTECTED]> wrote on 04/06/2004 03:27:34 PM:
> I think you need a WHERE clause for the UPDATE, otherwise it will update
> ALL the records.
>
> e.g. WHERE OwnerName='$result'
>
> Then perhaps a redirect to another page.
Thanks for the reminder. I set that, and found the problem that caused the
page to not load at all - no closing double-quote on the update statement.
Now the page loads properly but when I press the submit button nothing
happens, it's a dead button.
----------------------------------------------
if(isset($submit)):
$query1 = "update warranty set
VesselName='$vessel',OwnerName='$owner',OwnerStreet='$address',OwnerCity='$city',OwnerState='$state',OwnerZip='$zip',OwnerCountry='$country',DateInstalled='$DateInstalled',DealerName='$Dealer',DealerStreet='$DealerAddress',DealerCity='$DealerCity',DealerState='$DealerState',DealerZip='$DealerZip',DealerCountry='$DealerCountry',Model='$Parts',SN='$PartsSN',VesselType='$vesseltype',VesselLength='$length',InstalledOn='$construction',VesselTypeOther='$vesseltypeother')
where OwnerName = $OwnerName";
$result1 = mysql_query($query1);
mysql_query($query1);
else:
$query = "select * from warranty WHERE OwnerName='$result'";
$results = mysql_query($query);
$row = mysql_fetch_array($results);
?>
... lots of code ...
<p><center><input type="submit" name="submit" value="Update
Data"></center></p>
... more code ...
</table>
<?
endif;
?>
</body>
</html>
-------------------------------------------------
I don't see any reason for the submit button to not work at all. What
should I look for now?
Thanks for the help,
Chip
> > I probably need to use if(isset($submit)): and an update statement,
but my
> > attempt just causes the web page to display completely blank. This is
what
> > I tried -
> >
> > if(isset($submit)):
> > $query1 = "update warranty set
> > VesselName='$vessel',OwnerName='$owner',OwnerStreet='$address',
> OwnerCity='$city',OwnerState='$state',OwnerZip='$zip',
> OwnerCountry='$country',DateInstalled='$DateInstalled',
> DealerName='$Dealer',DealerStreet='$DealerAddress',
> DealerCity='$DealerCity',DealerState='$DealerState',
> DealerZip='$DealerZip',DealerCountry='$DealerCountry',
> Model='$Parts',SN='$PartsSN',VesselType='$vesseltype',
> VesselLength='$length',InstalledOn='$construction',
> VesselTypeOther='$vesseltypeother')
> > ;
> > $result1 = mysql_query($query1);
> > mysql_query($query1);
> > else:
> > $query = "select * from warranty WHERE OwnerName='$result'";
> > $results = mysql_query($query);
> > $row = mysql_fetch_array($results);
> > ?>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
