Hello mysql list,
As is very often the case, five minutes after I posted this, I found
the problem or solution, not sure it was the "problem" as I am not
convinced that mysql ought to get confused so easily. I changed
DATE_FORMAT( `Messages`.`Date`, '%D %M %Y' ) AS Date,
DATE_FORMAT( `Messages`.
Hello mysql,
I have a PHP script that is running the following query:
SELECT `Messages`.`ID`,
`Messages`.`Sender`,
`Messages`.`Subject`,
DATE_FORMAT( `Messages`.`Date`, '%D %M %Y' ) AS Date,
LEFT(`Messages`.`Text`, 200 ) AS Preview,
`Messages`.`New`,
`Profiles`.`NickName`,
`Profiles`.`RealName`
26, 2007 10:06 AM
*To:* [EMAIL PROTECTED]
*Cc:* Micah Stevens; mysql@lists.mysql.com
*Subject:* Re: Sorting Problem
Try:
select * from business_names
left join business_entries using (bus_id)
left join business_categories using (bcat_id)
where business_categories.bcat_id=17
order by business_nam
PROTECTED]
Cc: Micah Stevens; mysql@lists.mysql.com
Subject: Re: Sorting Problem
Try:
select * from business_names
left join business_entries using (bus_id)
left join business_categories using (bcat_id)
where business_categories.bcat_id=17
order by business_names.organisation
You must have
Micah Stevens [mailto:[EMAIL PROTECTED]
Sent: Monday, March 26, 2007 1:10 AM
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: Sorting Problem
The query using JOIN syntax (you can read about this in the documentation)
describes the interelationship between the three tables you described, in
th
@lists.mysql.com
Subject: Re: Sorting Problem
The query using JOIN syntax (you can read about this in the documentation)
describes the interelationship between the three tables you described, in
this way you can select information based on a WHERE clause as it relates
to the category table, while
http://www.softtools.com
-Original Message-
From: Micah Stevens [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 25, 2007 9:23 PM
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: Sorting Problem
This doesn't work?
SELECT businesses.name from businesses
left join links using (businessID)
evens [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 25, 2007 9:23 PM
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: Sorting Problem
This doesn't work?
SELECT businesses.name from businesses
left join links using (businessID)
left join categories using (categoryID)
where cat
This doesn't work?
SELECT businesses.name from businesses
left join links using (businessID)
left join categories using (categoryID)
where category.name = 'something'
order by businesses.name ASC
On 03/25/2007 12:40 PM, Sid Price wrote:
Hello,
I have a MySQL database design that provides
Hello
I've got a problem,, I've tried to search the archive for this list with no
luck.
Maybe it's because Unicode problems isn't that rare...
Anyway ..
Here is my problem.
Sorting on a VARCHAR collate utf8_swedish_ci (table with default charset
utf8)..
As many probably know, in Swedish
H Bartel wrote:
I have the following tables which look like this:
table tartist
++--+--+---+---+
| id | name | info | image | genre |
++--+--+---+---+
table programm
++--+---++
| id | date | stage | artist |
++--+---++
Hi,
I have a problem with selecting / ordering by different criteria from
different tables. Maybe this doesn't even work, or there is a much
better way?
I have the following tables which look like this:
table tartist
++--+--+---+---+
| id | name | info | image | genre |
+
I have a bit of a problem. I need to do something kinda odd that I'm
hoping to get help with...except for any suggestions of changing my
table structure. This might seem weird but I need to try and make it
work as it is.
I have a table called pwdata that looks like the following:
id fiel
13 matches
Mail list logo
