il" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Subject: Re: [PHP] numrows
Hello,
Chris, with all due respect, DESC is a reserved word for
SQL. is english ORDER BY ID DESC meand sort by id in
descending order.
Martin,
your SQL seems to
Hello,
Chris, with all due respect, DESC is a reserved word for
SQL. is english ORDER BY ID DESC meand sort by id in
descending order.
Martin,
your SQL seems to be fine. Are you sure that you are
connected to your database.
I have run the following SQL against my database
SELECT *
FROM users
better late than never :)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Sorry - it's late! "I knew that" he said.
Raphael Pirker wrote:
> Hi Chris,
> FYI:
>
> "Chris Fry" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > Should be ORDER BY ID, DESC
>
> actually it shouldn't be this way, since DESC is an option of the ORDER BY
>
Hi Chris,
FYI:
"Chris Fry" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Should be ORDER BY ID, DESC
actually it shouldn't be this way, since DESC is an option of the ORDER BY
command meaning DESC...
ORDER BY [column] [ASC | DESC] (ASC is default)
so the o
i'd have a look at the table structure.
also if you're using <> to denote inequality then use !=
both of the previous posts are incorrect
Steve
"Chris Fry" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Should be ORDER BY ID, DESC
>
> Chris
>
> Martin Kamph
Should be ORDER BY ID, DESC
Chris
Martin Kampherbeek wrote:
> What's wrong with this? I get the error: Warning: Supplied argument is not a valid
>MySQL result resource in /home/sites/site49/web/vragen/vragen.php on line 42
>
> $query = "SELECT * FROM question WHERE answer<>'1' AND id>250 ORDER
What's wrong with this? I get the error: Warning: Supplied argument is not a valid
MySQL result resource in /home/sites/site49/web/vragen/vragen.php on line 42
$query = "SELECT * FROM question WHERE answer<>'1' AND id>250 ORDER BY id DESC";
$result = MYSQL_QUERY($query);
$number = MYSQL_NUM_
8 matches
Mail list logo
