is this Valid PHP statement

@felgallMay 26.2008 — #It would depend on the value of $ow['endtime']. If that is in the wrong format for the comparison then you will get unexpected results.

@Design-is-BSMay 26.2008 — #Is it supposed to be

[code=php]
 $expiry = $now['endtime']; 
 $now = time(); 
 
 mysql_query("DELETE FROM buildup WHERE $expiry<$now"); 
 [/code]

(probably stupid question...)

@mitchellauthorMay 26.2008 — #this is my full code any help will be good

[code=php]
 <?php
 
 require("connectdb.php");
 
 echo "Updating........";
 
 $query = mysql_query("SELECT * FROM buildings") 
 or die(mysql_error()); 

 $result = mysql_fetch_array($query);
 echo "<br>Connected to database";
 
 $expiry = $result['endtime'];
 $now = time();
 
 while($row = mysql_fetch_array($query))
 {
 if($expiry<$now){
 $buildingtype = $row['building'];
 
 if($buildingtype == 1) {
 $upgrade='bank';
 } elseif($buildingtype == 2) {
 $upgrade='townhall';
 } elseif($buildingtype == 3) {
 $upgrade='lab';
 } elseif($buildingtype == 4) {
 $upgrade='magic';
 } elseif($buildingtype == 5) {
 $upgrade='time';
 } elseif($buildingtype == 6) {
 $upgrade='image';
 } elseif($buildingtype == 7) {
 $upgrade='wall';
 } elseif($buildingtype == 8) {
 $upgrade='tower';
 } else { 
 echo 'Error';
 }
 mysql_query("UPDATE users SET $upgrade=$upgrade+'1'"); 
 echo "<br><br>Updated buildings Successfully";
 echo "<br>Deleting Out of date logs.......";
 mysql_query("DELETE FROM buildup WHERE $expiry<$now");
 echo "<br>Deleted Expired Logs Successfully";
 }
 
 } 
 ?>
 [/code]

any reason why its deleting all results even though ive put WHERE $expiry<$now ?

the above should go through the table and get everything that has expired (IF $expiry<$now) and update and delete

is this Valid PHP statement

3 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

is this Valid PHP statement

3 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

3 Comments(s) _↴

Also in #PHP _↴