[SOLVED] Uninclude an id

[dachshund]

<?php
$today = date('Y-m-d');
$sql="SELECT * FROM interviews ORDER BY id DESC";
$result=mysql_query($sql);
?>

 

hello everyone, just wondering if anyone knows how to uninclude an id?

 

from this code i want id no1 to be unincluded because i already have more code to place it at the top of the page, and dont want it represented twice.

 

any help would be much appreciated.

 

thanks

[jackpf]

WHERE `ID`!=1

Something liek that.

[dachshund]

could you show me where to put that in the code?

 

sorry i couldn't do it. reasonably new to this.

[lonewolf217]

$sql="SELECT * FROM interviews WHERE ID != 1 ORDER BY id DESC";

[dachshund]

ok that works, but i stupidly asked the wrong question. i need the most recent id to be removed, whatever number that might be at the time.

[dachshund]

anyone?

 

 

[Ken2k7]

SELECT e.* FROM interviews e, interviews k WHERE e.id < k.id

Something like that?

[jackpf]

$last = mysql_insert_id();
$query = "SELECT * FROM table WHERE ID != $last";

Something like that I think.

[fenway]

Always the most recent? Then you can skip the "first" one with LIMIT and an offset.

[dachshund]

hmm still havent got it. how would i skip the first one with a limit and an offset?

[Ken2k7]

Hmm.. thought it would work.

 

SELECT * FROM interviews e INNER JOIN interviews k ON e.id < k.id

 

Per fenway, it would be like LIMIT 1,999999999999 or some really big number at the end.

[dachshund]

hmm when i try that it just comes up with 2 of the one i dont want (the latest id) at the bottom  :-\

[Ken2k7]

Oh, try using DISTINCT.

 

SELECT DISTINCT e.* FROM interviews e, interviews k WHERE e.id < k.id

[dachshund]

ok great that worked, thanks for everyones help. no doubt ill be back on here with more Q's soon.