How to list rows except first one ?

CΛSTΞX · 05-17-2010, 08:19 PM

Hello, how can I list rows except first one ? Thank you.

adamdecaf · 05-17-2010, 09:49 PM

If the array is numeric:

PHP Code:


			
$list = array(0 => 'adam', 1 => 'dave');
$length = count($list);

for ($n = 1; $n < $length; n++) {
   echo $list[$n];
}

CΛSTΞX · 05-17-2010, 09:53 PM

Thanks. But I mean the mysql results. My query is this >

$query="select * from dle_post where $q ORDER BY id DESC limit 10";

I mean how to list items except first one...

adamdecaf · 05-17-2010, 10:04 PM

Then just pull the data normally and put in a numeric array. That way you can print off the array from the 2nd element.

PHP Code:


			
$result = mysql_query('SELECT * ... ');
$list = array();

while ($row = mysql_fetch_array($result)) {
   $list[] = $row;
}

CΛSTΞX · 05-17-2010, 11:01 PM

Sorry but can't understand. What you exactly mean ?

etoolbox · 05-17-2010, 11:08 PM

Is this what you want?

$query="select * from dle_post where $q ORDER BY id DESC limit 1, 10";

CΛSTΞX · 05-17-2010, 11:11 PM

If its showing last 10 results except the first one, yes its is.

nefus · 05-18-2010, 02:46 PM

The limit on the end of the sql query keeps it from showing the first record because it's 1 instead of 0.

core1024 · 05-22-2010, 02:26 PM

you can even

PHP Code:


			
$r = mysql_query('SELECT no, matter FROM whatever WHERE something');
mysql_fetch_assoc($r)
while ($row = mysql_fetch_assoc($r)) {
   echo '<pre>'.print_r($row,true).'</pre>';
}