Member Avatar for cmax

Hi!
I'AM A PROBLEM ON HOW TO UPDATE DATA IN THE DATABASE MYSQL CAN YOU GIVE A CODE PLSE?

  • 2 Contributors
  • 1 Reply
  • 47 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by mrcniceguy
Member Avatar for mrcniceguy

to update the datas in Database
Just you use this
(After connecting to database and selecting a Database to use,then this follows,I`M using a contact as a table in my database:

$query="UPDATE contact SET first='$first' last='$last' email='$email'
  WHERE user='$user and $password='$password' ";
$result=mysql_query($query);
if(!$result){
 echo " Unable to update your contacts";
}else{
echo "Your contacts updated successfuly";
}

I hope this can help.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.