more than certain number

[wazo]

Hi guys

if i wanted to show all listings with more than 5 applications how would i do it

I have this if i want to show all records with 0 applications

$sql = ("select * from jobs WHERE applications='0'"); 

I guess it would be something similar?

[spikeZ]

simple operators
> greater than
< less than
= equal to
!= not equal to

(select * from jobs where applications >= 5);

[wazo]

thank you

how about rows that have been added in the last 24 hours?

what would be the logic?

[spikeZ]

heres a snippet for the last 7 days. should be easy to alter

<?php
$now = time(); // this is the current UNIX timestamp for the server
$days = 7; // change to number of days
$days_ago = date("Y-m-d H:i:s", ($now - (86400 * $days));
 $query = "SELECT username FROM users WHERE lastvisited > '$days_ago'";
 $result = @mysql_query($query);
 if(@mysql_num_rows($result)) {
        while($row = mysql_fetch_row($result)) {
             print "$row[0] <br />";
       }
 }
?>

[r937]

!= not equal to

<> not equal to, sql standard