Check If Row is Empty Or Not

[kumschick]

hi, i'm writing on a code with php and mysql.

the idear is:

$add=mysql_query("SELECT * FROM $shop WHERE ct='$REMOTE_ADDR' AND title='$row[title]'",$connection);
while($row=mysql_fetch_array($add))
{

if(!empty($row[quantity])) {
$add2 = "INSERT INTO $DB VALUES ('$id','$title','$lang','$qe','$px','$REMOTE_ADDR')";
$result2b = mysql_query($add2, $connection);
} else {
$qe2=$row[qe]+1;
$add2 = "UPDATE $DB SET quantity='$qe2' WHERE ct='$REMOTE_ADDR' AND title='$row[title]')";
$result2a = mysql_query($add2, $connection);
}

}

But since the Row is empty it does nothing! How can I say if the row is empty then "INSERT * INTO ..." else "UPDATE $DB ..."

Thx for helping

[LordShryku]

Try counting instead

$add = mysql_query("SELECT count(*)
                      FROM ".$shop."
                     WHERE ct='".$REMOTE_ADDR."' 
                       AND title='".$row['title']."'");
$cnt = mysql_fetch_row($add);
if($cnt[0] == 0) {
   // add the row
}

[kumschick]

Yes, it works, but if I want to read also from the DB

if($cnt[0] == 0) {
// ADD The ROW
} else {
// READ The ROW
}

How do I do it?

[LordShryku]

In that case, use mysql_num_rows to count instead

$add = mysql_query("SELECT *
                      FROM ".$shop."
                     WHERE ct='".$REMOTE_ADDR."'
                       AND title='".$row['title']."'");
$cnt = mysql_num_rows($add);
if($cnt == 0) {
   // add the row
}
else {
   while($row=mysqlfetch_array($add)) {
       // echo $row['whatever'];
    }
}

[kumschick]

yes, I know that, I did it before, but if
i put a test echo inside i don't get the output.

Example:

$add = mysql_query("SELECT *
FROM ".$shop."
WHERE ct='".$REMOTE_ADDR."'
AND title='".$row['title']."'");
$cnt = mysql_num_rows($add);
if($cnt == 0) {
// add the row
}
else {
echo"Wello World 1"; //THIS IS SHOWN!!!
while($row=mysql_fetch_array($add)) {
echo"test1"; //NOT SHOWN????
echo"$row['whatever']"; //NOT SHOWN????
echo"test2"; //NOT SHOWN????
}
echo"Wello World 2"; //THIS IS SHOWN!!!
}

any idear???