reference, tutorial, tutorials, help, example, photoshop, html, php, mysql, 3d software, internet, graphics, programming, multimedia
Home >> Development >> WEB Programing >> PHP >>

Using UPDATE MySQL query in PHP [1/1]

Type: Code reference, tutorial, tutorials, help, example, photoshop, html, php, mysql, 3d software, internet, graphics, programming, multimedia
Using UPDATE MySQL query in PHP
Level: Beginner reference, tutorial, tutorials, help, example, photoshop, html, php, mysql, 3d software, internet, graphics, programming, multimedia 
Using UPDATE MySQL query in PHP
Date: 2007-Apr-02
Using UPDATE MySQL query in PHP
Visited: 3890 times
Using UPDATE MySQL query in PHP
Rating: Using UPDATE MySQL query in PHP
Using UPDATE MySQL query in PHP
Author: Ivory Morhuld
This tutorial will show you how to use MySQL querys to database in your PHP scripts.

mysql_query(query, [link_identifier])


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 and field3 will be increased with 21 in all rows where sex equal to male, and age more that 21.

<?php
$query="update table set date=now(), field1=field2, field3=field3+21 where sex='male' and age>='21'";
$result=mysql_query($query);
?> 
Rate this tutorial:                    
reference, tutorial, tutorials, help, example, photoshop, html, php, mysql, 3d software, internet, graphics, programming, multimedia - Using UPDATE MySQL query in PHP [1/1] - reference, tutorial, tutorials, help, example, photoshop, html, php, mysql, 3d software, internet, graphics, programming, multimedia

Need a specific tutorial? Do not hesitate and submit a request!
Related Tags: query update php mysql UPDATE  php MYSQL Query update query  update mysql query how to use in php  update mysql query set  mysql update query example  using and in update query in mysql  update query using mysql  PHP and update query using MySQL  php mysql using AND in update query  update+mysql query  Using the update query in mysql  update mysql query php  update mysql query  update mysql query  update query mysql and php  update "mysql query"  mysql update query in php  mysql update using query  mysql query update NOW()  use update mysql query in with php