MySQL - Deleting more than one row...

[MtPHP2]

Ok, now I am told this code will only delete the FIRST row with activation=0 (a row in my MySQL db) if I run it, is that true, if so, how do I make it delete all of them?
<?php
mysql_connect("localhost", "bettaverse", "HAHA DON'T TRY CATCH ME OUT WITH THIS!");
mysql_select_db("bettaverse");
$sql = "SELECT * FROM users WHERE activated = 0";
$res = mysql_query($sql);
$row = mysql_fetch_array($res);
$time = date("His");
$allowedtime = date("His") + 100;
if($allowedtime >= $time)
{
$sql = "DELETE FROM users WHERE activated = 0";
}
?>
Thanks for any help in advance.

[volleytotal_ch]

i'll give a try: (comments are for the FOLLOWING row!)

<?php 
mysql_connect("localhost", "bettaverse", "passw"); 
mysql_select_db("bettaverse"); 
// This selects ALL entries with activated='0'
$sql = "SELECT * FROM users WHERE activated = 0"; 
$res = mysql_query($sql); 
// This fetches just the FIRST row of the results and save it in $row:
$row = mysql_fetch_array($res); 
// $time is just the time stored in the first entry found!
$time = date("His"); 
$allowedtime = date("His") + 100; 
if($allowedtime >= $time) 
{ 
// This deletes ALL entries were activated = 0 ONLY if the value of the field 'His' OF THE FIRST ENTRY FOUND is ok for the condition (difficult to explain).
$sql = "DELETE FROM users WHERE activated = 0"; 
} 
?> 
What do you want to do exactly? I guess it can be done very short ;)

[MtPHP2]

Ok, right... So the script I had was almost there, except it only did time for the first user, I need it to do it for each one. How would I go about that?

[MtPHP2]

Oh, BTW...
It would be a big plus if it would email all the users (email address is stored in the db as email) and tell them their account was deleted because they didn't activate it, but that's only if it's easy don't worry about it if it is hard...

[volleytotal_ch]

Ok, here is the script:
You jsut need to add the second where-condition. (where i placed the ????)
This condition will look like

time<='".date(His)-100."'

BUT MAKE A DB-BACKUP BEFORE RUNNING THE SCRIPT!!!!

<?php 
mysql_connect("localhost", "bettaverse", "passw"); 
mysql_select_db("bettaverse"); 
// This selects ALL users with activated='0'
$sql = "SELECT * FROM users WHERE activated = 0 AND ????";
$res = mysql_query($sql) or die("Couldn't connect to db");
if(mysql_num_rows($res)==0)
{
  // No users found in db!
  echo "no users found";
}
else
{
  // Send email to all users:
  while($row = mysql_fetch_array($res))
  {
    // Email to user with address $row["field_user_email"]
    // See function email() for more infos!
  }
  // Delete all users:
  $sql = "DELETE FROM users WHERE activated = 0 AND ????"; 
} 
?>

[MtPHP2]

Where it says AND ???? can I put PHP? For example can I put
AND $allowedtime == >= $time
Will that work? If not how would I do it?

[volleytotal_ch]

i think i posted you somewhere else 😉