Re: SQL Syntax Question

- 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

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

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

-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

- 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

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. I have two tables "Event" and "Eventdetails" (structures dump can be found at the end of the message). I want to display all events and the related information from the eventdetai

SQL Syntax question

These are tables that I did not design (and would not have in this fashion), but I have to make do with them Table 1 structure: id_num number, descr1 varchar(30), descr2 varchar(30), descr3 varchr(30) Table 2 structure id_name varchar(15), ext_descr varchar(30) Table 2 is a child of table 1

Re: SQL syntax question

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

SQL syntax question

Hi, I have a directory of professional magicians, consisting of a MySQL table like this: +-++-+ | artist | area| magic | +-++-+ | Joe Bloggs | AZ*IN*TX | childrens | +-

sql syntax question

I have the following query: select *, max(event_date) as high, min(event_date) as low from schedule where event_date between '2002-03-01' and '2003-04-30' group by week_ending,meeting_id order by name, event_date, start_time If I order by event_date, start_time, name, I get the proper results.

Re: SQL syntax question

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

SQL syntax question

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). I've tried the following code, but it doesn't seem to be working $chknamero

RE: SQL Syntax question

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

SQL Syntax question

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 want a query to return game.gamid, team.sponsor (hometeam), team.spons

Re: SQL Syntax question

>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

SQL Syntax question

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.salesassoc, ip