lists.mysql.com
> Subject: Re: error in your SQL syntax
>
>
> Thanks, works fines.
>
> I use access because i don´t know a GUI tool that make SQL
> querys more easy.
>
> Thanks all again,
>
> Daniel Sousa
> - Original Message -
> From:
: error in your SQL syntax
Here is your original query, reformatted merely so that we humans can read it
better:
SELECT DISTINCT specials.specials_id
, products_to_categories.products_id
, categories.parent_id
, products_description.products_name
Here is your original query, reformatted merely so that we humans can read
it better:
SELECT DISTINCT specials.specials_id
, products_to_categories.products_id
, categories.parent_id
, products_description.products_name
, products.products_price
, products.
You have an awful lot of brackets in the query, many of which don't appear
to be needed. For example, I don't see why you have brackets in this phrase:
AND ((languages.languages_id)=1))
Perhaps removing the unnecessary ones will help the query work better and
more consistently on each machine.
A
Hi.
On Mon, Oct 01, 2001 at 08:32:42PM -0400, [EMAIL PROTECTED] wrote:
> I don't know anything about MySQL, Ive just been trying(with no luck)to
> install a forum(Snitz forum from www.snitz.com) on my website. My website is
> Linux/MySQL/Chilisoft! Im running out of support my host hasn't gotte
I don't know anything about MySQL, Ive just been trying(with no luck)to
install a forum(Snitz forum from www.snitz.com) on my website. My website is
Linux/MySQL/Chilisoft! Im running out of support my host hasn't gotten back
with me, and Snitz support doesn't know. So I got to messing around w
From: <[EMAIL PROTECTED]>
> MySQL said: You have an error in your SQL syntax near 'order by
> 'Variable_name' ASC' at line 1
>
> Any ideas as to what this means, and how to fix it?
Hi Dave,
How 'bout sending us the entire SQL statement, please.
---
Rodney Broom
Programmer: Desert.Net
-
