Re: Query String
- From: "Richard" <root@localhost>
- Date: Tue, 30 Dec 2008 14:20:05 +0100
"Jerry Stuckle" <jstucklex@xxxxxxxxxxxxx> wrote in message
news:gjbtem$j60$2@xxxxxxxxxxxxxxxxxxxxxx
Richard wrote:
<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.
Wrong answer, Richard. A misplaced apostrophe will give a syntax
error. The error he got is a MySQL error from an invalid query.
This is not a PHP problem. It is a MySQL error, and belongs in
either a MySQL newsgroup or a SQL newsgroup.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@xxxxxxxxxxxxx
==================
In fact, the answer is correct, try it yourself:
but I get 'Error in query:$query'.
The error he got was... nothing.
R.
.
- 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
- Re: Query String
- From: Richard
- Re: Query String
- From: Jerry Stuckle
- Query String
- Prev by Date: Re: Throw Exceptions from setters: second opinion
- Next by Date: Re: Throw Exceptions from setters: second opinion
- Previous by thread: Re: Query String
- Next by thread: Re: Query String
- Index(es):
Relevant Pages
|
