Re: Query String
- From: "Richard" <root@localhost>
- Date: Tue, 30 Dec 2008 02:08:49 +0100
<ajtdds@xxxxxxx> wrote in message
news:450e389f-4528-458d-9d27-fdf49e4cc3ab@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hey guys I tried it with the array method, and it seemed to work
thanks. Sorry for what might appear to most of you as a beginners
question.
Anyway I have one last problem.
I need a query to firstly retrieve the latest 10 news articles by
date, where I have used ORDER BY and the date field 'timestamp' with
LIMIT. So far so good..
I have then indicated in the database whether each news article has
an
image included, marked by the field 'image' and options 'Yes' and
'No'.
To prioritise the news articles to view those with images first, I
have used AND image IN ('Yes', 'No') but I get 'Error in query:
$query'. Any other way to achieve the same effect??
<?php
$query = ("SELECT image, newsid, title, headline, timestamp FROM
news
ORDER BY timestamp DESC AND image IN ('Yes', 'No') LIMIT 10");
$result = mysql_query($query) or die ('Error in query: $query .
' .mysql_error());
You have misplaced the apostrophe in die( ..
Regardless of what Jerry says, this is a simple PHP syntax thingie.
Richard.
if (mysql_num_rows($result) > 0)
{
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
$newsid = $row['newsid']; echo $newsid;
$title = $row['title']; echo $title;
$headline = $row['headline']; echo $headline;
}
}
?>
THANKS!! Alec
.
- Follow-Ups:
- Re: Query String
- From: Jerry Stuckle
- Re: Query String
- References:
- Query String
- From: ajtdds
- Re: Query String
- From: FutureShock
- Re: Query String
- From: ajtrichards@xxxxxxxxxxxxxx
- Re: Query String
- From: Jerry Stuckle
- Re: Query String
- From: ajtdds
- Query String
- Prev by Date: Re: Strings, arrays and efficiency
- Next by Date: Re: ldap_bind issues
- Previous by thread: Re: Query String
- Next by thread: Re: Query String
- Index(es):
Relevant Pages
|
