Re: Multiple Select storing

table that contains personal information about users. Another table consists of a list of many interests. This table is composed of simply 2 fields - an ID and the interest. (see below) I can build an HTML form which includes a multiple select list out of which the user can select their interests

Re: Multiple Select storing

- 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,

Multiple Select storing

users. Another table consists of a list of many interests. This table is composed of simply 2 fields - an ID and the interest. (see below) I can build an HTML form which includes a multiple select list out of which the user can select their interests. I have the list configured so that it

Re: multiple select with single command.

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'

multiple select with single command.

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 - Before posting, please check: http://www.mysql.com/manual

RE: multiple 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

Re: multiple select

#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

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

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

multiple select

hi! i am rather new to mysql and i have problems with a multiple select statement. i have a search form where the user can choose 4 conditions, when all 4 conditions are chosen i get a result but when the user just chooses 1,2 or 3 conditions i get a mysql error... does anyone know a

Re: SQL : multiple SELECT and missing rows.

You want to use the "LEFT JOIN" syntax. A general outline would be: SELECT [your fields] FROM accounts LEFT JOIN addresses ON addresses.ID = accounts.ID WHERE ... ORDER ... LIMIT ... This would select all addresses.ID's, including those where accounts.ID is NULL. -Kevin --On Tuesday, April 03

Re: multiple SELECT and missing rows.

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

Re: [PHP] SQL : multiple SELECT and missing rows.

"Maxim Maletsky" <[EMAIL PROTECTED]> wrote: > As you can see, the main data is in 'accounts', the 'addresses.ID' is UNIQUE > and corresponds to 'accounts.ID'. The fact is that not every account has an > address registered with it. > FROM > accounts, > addresses You're doing a straight join. You

SQL : multiple SELECT and missing rows.

Hello Guys, I have a (very simple?) SQL question. I'm more then sure the answer to it is whether "just do this..." or "It's impossible man, how could you even get that into your mind..." I have this database design: (it's more complex of course, but you get an idea) Table 'account