You need this:
while($row=mysql_fetch_array($res)) {
echo first column;
if($row=mysql_fetch_array($res)) {
echo second column;
}
}
Darren McPhee wrote:
Does anybody know of a SELECT QUERY that will select every other record of a
table ? I want to do this so that I can display m
> Does anybody know of a SELECT QUERY that will select every
> other record of a
> table ? I want to do this so that I can display my products
> in 2 columns (I
> will also be using arrays of course).
Don't know of a select that'll do it, but then I don't really understand
why you'd want
..
> -Original Message-
> From: Darren McPhee [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, November 17, 2002 9:17 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP] Query to select every other record
>
> Does anybody know of a SELECT QUERY that will select every other
record of
&
Does anybody know of a SELECT QUERY that will select every other record of a
table ? I want to do this so that I can display my products in 2 columns (I
will also be using arrays of course).
The first column would show the result of the first query starting at record
1. The second column would s
4 matches
Mail list logo
