Re: SQL Syntax Question

2004-08-04 Thread Rhino
- Original Message - From: "Karl-Heinz Schulz" <[EMAIL PROTECTED]> To: "'Philippe Poelvoorde'" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, August 04, 2004 6:41 AM Subject: RE: SQL Syntax Question > Philippe, > &g

RE: SQL Syntax Question

2004-08-04 Thread Karl-Heinz Schulz
Event 2 Details 1 for event 2 Details 2 for event 2 Details 3 for event 2 Is this even possible? TIA -Original Message- From: Philippe Poelvoorde [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 04, 2004 5:52 AM To: Karl-Heinz Schulz Cc: [EMAIL PROTECTED] Subject: Re: SQL Syntax

Re: SQL Syntax Question

2004-08-04 Thread Philippe Poelvoorde
Karl-Heinz Schulz wrote: Thank you for trying to help me. The output is wrong I get either Event 1 Event 2 Details 1 for event 1 Details 2 for event 1 Details 3 for event 1 that query is wrong : $eventdetail_query = mysql_query("select informations, titles, file_name from eventdetail, event where

RE: SQL Syntax Question

2004-08-04 Thread Karl-Heinz Schulz
-Heinz Schulz; [EMAIL PROTECTED] Subject: Re: SQL Syntax Question - Original Message - From: "Karl-Heinz Schulz" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 03, 2004 9:18 PM Subject: SQL Syntax Question > I tried to get an answer on the P

Re: SQL Syntax Question

2004-08-03 Thread Rhino
- Original Message - From: "Karl-Heinz Schulz" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 03, 2004 9:18 PM Subject: SQL Syntax Question > I tried to get an answer on the PHP mailing list and I was told that this > list would be quicker to get me a solution. > > >

Re: SQL syntax question

2002-05-14 Thread Victoria Reznichenko
Graham, Monday, May 13, 2002, 8:45:09 PM, you wrote: GN> I have a directory of professional magicians, consisting of a MySQL table GN> like GN> this: GN> +-++-+ GN> | artist | area| magic | GN> +-++--

Re: SQL syntax question

2001-12-18 Thread Paul DuBois
At 10:02 AM -0800 12/18/01, Steve Osborne wrote: >I would like to use an input form to add users to my database, however, if >the name is already in use, I do not want to add a duplicate record. I also >need this to be case insensitive (ie Santa Claus = santa Claus). Make the (LastName, FirstNa

RE: SQL Syntax question

2001-04-25 Thread Don Read
On 26-Apr-01 [EMAIL PROTECTED] wrote: > I have two table I need to join in a query. The second table needs to be > join twice (I think) to the first. Details as follows (tables pared > down)... > > Table games > gameid > hometeamid > guestteamid > > Table team > teamid > sponsor > > I wan

Re: SQL Syntax question

2001-04-21 Thread Bob Hall
>Hi there, > >I'm using mysql 3.22.27 and get error when trying to run this select >statement: > >SELECT custmls.mlsnumber,custmls.streetnumber,custmls.streetdirect, >FORMAT(custmls.currentprice,0),custmls.streetnam,custmls.streetaddtl, >custmls.municname,custmls.state,custmls.zipcd,custmls.sales