On Apr 3, 2005, at 12:50 PM, Robb Kerr wrote:
Please excuse the length and complexity of this post. I am facing a
complicated problem and need to find a solution. Also, I have posted
this on
both PHP and MySQL boards so please overlook the possibly slightly
off-topic
subject.
I have got one tabl
- Original Message -
From: "Robb Kerr" <[EMAIL PROTECTED]>
To:
Sent: Sunday, April 03, 2005 12:50 PM
Subject: Multiple Select storing
> Please excuse the length and complexity of this post. I am facing a
> complicated problem and need to find a solution. Also, I have posted this
on
> b
Nissim Lugasy writes:
> Are there plans for mysql to have the capabilities to execute single sql
> statement with nested SELECT . or Is there a way around this for the time
> being?
>
> Thanks
>
Hi!
For the moment, you can only do (with MySQL 4.0) UNION's in all
variants with as many SELECT'
l Message-
From: Chris [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 18 september 2001 13:05
To: MySql
Subject: Re: multiple select
If this is your query, you might have a problem at the first 'AND' :
SELECT * from tipps AND name LIKE '%$name%' AND stadt = '$stadt' A
#x27;%$name%' AND stadt = '$stadt' AND
kueche= '$kueche' ORDER by $order ASC LIMIT $start, $limit
Sorry if this does not answer your question
- Original Message -
From: "Michael Paffrath" <[EMAIL PROTECTED]>
To: "MySql" <[EMAIL PROTECTED]>
am 18.09.2001 12:30 Uhr schrieb Chris unter [EMAIL PROTECTED]:
> Post your query
SELECT * from tipps AND name LIKE '%$name%' AND stadt = '$stadt' AND kueche
= '$kueche' ORDER by $order ASC LIMIT $start, $limit
Michael Paffrath
fatmedia - agentur für interaktive medien
Schillerstraße 6
50968 Köl
Post your query
- Original Message -
From: "Michael Paffrath" <[EMAIL PROTECTED]>
To: "MySql" <[EMAIL PROTECTED]>
Sent: Tuesday, September 18, 2001 12:10
Subject: multiple select
hi!
i am rather new to mysql and i have problems with a multiple select
statement.
i have a search form wh
This is best done with a LEFT JOIN. Please read up the manual about it.
- Original Message -
From: "Maxim Maletsky" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "'PHP General List. (E-mail)'"
<[EMAIL PROTECTED]>
Sent: Tuesday, April 03, 2001 9:41
Subject: SQL : multiple SELECT and missin