Re: Result Sets

In article <gjfku1$j8v$2@xxxxxxxxxxxxxxxxx>, Ron Fox <fox@xxxxxxxxxxxx>
wrote:

Tim Streater wrote:
In article
<629dba1a-92dd-436d-b635-a022d1a82dd8@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
ajtdds@xxxxxxx wrote:

Please bear with me on this one everyone, as it is not often I use
php.

Am trying to put together a news page. First of all I get the last 10
news articles ordered by date.

$query = ("SELECT title, headline, timestamp FROM news ORDER BY
timestamp DESC LIMIT 10");
$result = mysql_query($query) or die ('Error in query: $query .
' .mysql_error());

What I want to do is create a headline page, where for example the
first result is the main headline with title, image and text, results
2 and 3 are subheadlines (with a different table format), and the
remaining headlines just show the title (again with a different table
format). So how can I separate the results.

I have tried the following where $count determines what happenes when
firstly result 1, and then results 2 and 3, and finally the remaining
are current.

$count=0
if (mysql_num_rows($result) > 0)
{
while($row = mysql_fetch_array($result, MYSQL_ASSOC) AND
$count=1)
{
$page=1; echo $page;
$title = $row['title'];
$headline = $row['headline'];
$count=count+1;
}

while($row = mysql_fetch_array($result, MYSQL_ASSOC) AND
$count<4)
{
$page=2; echo $page;
$title = $row['title'];
$headline = $row['headline'];
$count=count+1;
}

while($row = mysql_fetch_array($result, MYSQL_ASSOC) AND
$count>3)
{
echo $count;
$page=3; echo $page;
$title = $row['title'];
$headline = $row['headline'];
$count=count+1;
}
}

But for some reason I do not get past the first 'while' loop.

Again apologies for what might seem a very simple question.

Alec

1) I'm not sure why you think you need the first while loop, you only
want to go round it once anyway.

2) It should in any case be $count==1 rather than $count=1

And then it will be skipped because $count is initialized to 0. so the
while condition will then never be true.

So it won't. Well spotted that man.

--
Tim

"That excessive Baile ought not to be required nor excessive Fines imposed
nor cruell and unusuall Punishments inflicted" -- Bill of Rights 1689
.

Relevant Pages

  • Re: Result Sets
    ... Am trying to put together a news page. ... What I want to do is create a headline page, ... $page=1; echo $page; ... But for some reason I do not get past the first 'while' loop. ...
    (comp.lang.php)
  • Re: Result Sets
    ... Am trying to put together a news page. ... What I want to do is create a headline page, ... $page=1; echo $page; ... I'm not sure why you think you need the first while loop, you only want to go round it once anyway. ...
    (comp.lang.php)
  • Result Sets
    ... Am trying to put together a news page. ... What I want to do is create a headline page, ... and 3 are subheadlines (with a different table format), ... $page=1; echo $page; ...
    (comp.lang.php)
  • Two Things ... (was Re: The Hazards of Instant Communication)
    ... One report, 1010 newsradio said ... > In reading this morning's newspaper closely, I note the headline "12 ... > I mention this because of today's passion for "instant" news. ... > We all know the famous Truman victory where everyone just "knew" Dewey ...
    (comp.dcom.telecom)
  • Re: Into the Woods - Royal Opera House
    ... No reason to mention terrorism *at all*. ... It's not even particularly news here in Manchester, ... Are they reporting the conviction of the 21/7 bombers yet? ... (My cynical side wonders if their headline was as prominent a while back when gay teenagers were stoned to death in Iran) ...
    (rec.arts.theatre.musicals)