How to make SQL UPDATE query
How to make SQL UPDATE query
This tutorial will show you how to use MySQL querys to database in your PHP scripts.
mysql_query
mysql_query() sends a query to the currently active database on the server that's associated with the specified link identifier. If link_identifier isn't specified, the last opened link is assumed. If no link is open, the function tries to establish a link as if mysql_connect() was called with no arguments, and use it.
In next examples we will teach you how to make more querys.
<?php$query="update table set field1='value1', field2='value2', fieldN='valueN'";$result=mysql_query($query);?>
In next example we will extend the query to more complex and specific query.
This query will update date to current data, field1 will be equal to filed2 an