PDA

View Full Version : Sql help! PLease!!



мϊкэ
07-08-2005, 07:51 PM
right on my affiliates script how can i show all the affiliates after a certain id number? the sql query right now is


$result = mysql_query("SELECT * FROM affiliates ORDER BY total DESC"); // makes a query to database to table "affiliates" and orders it by total descending

while ($row = mysql_fetch_object($result)) { // while loop While you are connected to the database do this...

how can i modify it so say, i only want to show all the affiliates after the affiliate id 4? any help anybody?

T0X!C-uk
07-08-2005, 07:58 PM
try putting a 4 where it says total

мϊкэ
08-08-2005, 03:43 PM
that just makes the one with the id 4 go at the end!

Want to hide these adverts? Register an account for free!