NULL

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
ddragas
Forum Contributor
Posts: 445
Joined: Sun Apr 18, 2004 4:01 pm

NULL

Post by ddragas »

Hi all

How to update table where 'some_field' is NULL

Code: Select all

$sqlquery = "UPDATE mailovi SET some_field = 0 WHERE some_field = 'NULL'";
	
		mysql_query($sqlquery) or die(mysql_error()); 
<?php

?>
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Post by John Cartwright »

Code: Select all

<?php
$sqlquery = "UPDATE mailovi SET some_field = 0 WHERE some_field IS NULL";
?>
Post Reply