Re: Multiple Select storing

2005-04-03 Thread Michael Stassen
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

Re: Multiple Select storing

2005-04-03 Thread Rhino
- 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

Re: multiple select with single command.

2001-12-13 Thread Sinisa Milivojevic
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'

RE: multiple select

2001-09-18 Thread Remco Brood
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

Re: multiple select

2001-09-18 Thread Chris
#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]>

Re: multiple select

2001-09-18 Thread Michael Paffrath
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

Re: multiple select

2001-09-18 Thread Chris
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

Re: multiple SELECT and missing rows.

2001-04-02 Thread Rolf Hopkins
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