mysql help

renny

Hello,

How can I do this?

I want to go through my mysql table (with 2.9 million rows) and search for the rows with a blank SignupIP field and then since it's blank, I want to fill it with something.

This is what I tried but didn't work:

$query = "SELECT * FROM data WHERE SignupUP = '' ";
$result = mysql_query($query);

while(($line = mysql_fetch_array($result)))
{
$line[SignupIP] = "whatever";
}

How should I go about doing this? Thank you so much in advance.

-Renny

RazorSA

$sql_Update = "Update tblModel SET
IP='Whatever'
WHERE IP='NULL'";

??????????

Well, If this does NOT work, read up about UPDATE sql statements ... you were doing a SELECT ...

JDcrack

Try using the is_null() function in PHP
http://www.php.net/manual/en/function.is-null.php

and the "IS NULL" operator for mysql
http://www.mysql.com/doc/en/Comparison_Operators.html

Using ='NULL' or =' ' are bad habits and can return unexpected results.

change:
$query = "SELECT * FROM data WHERE SignupUP = '' "; 

to:
$query = "SELECT * FROM data WHERE SignupUP IS NULL;