Total members 11895 |It is currently Sun Dec 22, 2024 9:24 am Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka





Example of update query .
Code:

 
function update_ban_of_user($username,$banned)
     {
       
$query="update user set banned='$banned'  where username='$username'";
        
$result=mysql_query($query) ;
        echo 
mysql_error();
        return 
mysql_affected_rows();
     }
 




_________________
M. S. Rakha, Ph.D.
Queen's University
Canada


Author:
Mastermind
User avatar Posts: 2715
Have thanks: 74 time
Post new topic Reply to topic  [ 1 post ] 

  Related Posts  to : update query example
 vBulletin update     -  
 Get affected rows for an update in php     -  
 update an xml file with jaxb     -  
 Asp.net insert update delete Examples     -  
 Update table with search box using ajax     -  
 Update phpbb to latest version with mods     -  
 update an xml file with jaxb and accessing to its elements     -  
 Load file and update content using AJAX and JQuery     -  
 EJB-QL IN where query     -  
 more than one parameter with name query     -  



Topic Tags

PHP Database






Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com