Sub query help

ywhere. Maybe I am just not using the right Google "query"? Thanks in advance for any help! -Brian Menke

RE: How do I alter the result of a select

I ended up figuring this out. If anyone ever needs it, this works well select module_id, GROUP_CONCAT(participant_answer SEPARATOR ' ') as answers from participants_answers where email = '[EMAIL PROTECTED]' group by module_id -Brian -Original Message----- From:

How do I alter the result of a select

experienced enough to put it all together. Any help is greatly appreciated, even if it's just a pointer to some mysql docs. Thanks in advance! -Brian Menke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Works in SQL Manager, but not PHP?

ules.module_id = modules.module_id) GROUP BY module_id, email; SELECT module_id, module_name, email, score, DATE_FORMAT(DATE_SUB(date_time, INTERVAL time_zone HOUR),'%e %M %Y') as 'date_time' FROM t WHERE email = '[EMAIL PROTECTED]' ORDER BY date_time DESC; Thanks for any help on this! -Brian Menke

RE: Get the record with the latest date

d and was driving me crazy. Seems simple now but... yikes! Thanks for everyone's help on this! -Brian -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Saturday, May 27, 2006 9:53 PM To: Brian Menke Cc: mysql@lists.mysql.com Subject: Re: Get the record with

Get the record with the latest date

ure out how to piece them together. Any ideas are greatly appreciated! -Brian Menke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Get the record with the latest date

2 [EMAIL PROTECTED] 7 5/27/2006 9:47 PM 3 [EMAIL PROTECTED] 8 5/27/2006 9:50 PM I looked a few places on google, but they seemed to be suggesting using DESC in the where clause and I didn't see how that was going to work? Any ideas are greatly appreciated! -Brian Menke

RE: Fun with Dates and Incentives.

ROTECTED] Sent: Thursday, May 25, 2006 9:13 AM To: Brian Menke Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: Re: Fun with Dates and Incentives. Brian, MySQL's timestamp function is based on the *server*'s timestamp, not the client's. -Sheeri On 5/24/06, Brian Menke <

RE: Fun with Dates and Incentives.

olves huge problems for me and I seriously owe you! I'm gonna do some more research so I understand how this works. THANKS! -Brian _ From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 24, 2006 3:56 PM To: Brian Menke Cc: mysql@lists.mysql.com Subject: Re: Fun

RE: Fun with Dates and Incentives.

ian _ From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 24, 2006 1:31 PM To: Brian Menke Cc: mysql@lists.mysql.com Subject: Re: Fun with Dates and Incentives. Brian Re your schema, --it's redundant to define PRIMARY and UNIQUE keys on the same column, --why not

Fun with Dates and Incentives.

mpleted_modules` ( `module_id` char(2) NOT NULL default '', `email` varchar(64) NOT NULL, `score` int(2) NOT NULL default '0', `time` timestamp NOT NULL default CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=latin1; Brian Menke Visual Matter, Inc 1445 Fo

RE: Student question answer schema

good job with normalization of my other tables for this app, but was having mental problems with the student question answers tables. -Brian Menke -Original Message- From: Mikhail Berman [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 11, 2006 8:49 AM To: JC; Brian Menke Cc: mysql

Student question answer schema

Does anyone happen to know where a basic schema for tracking questions and answers from tests that a student has completed. I don't know why I am having difficulty with this, but I can't seem to figure out how to set up the tables correctly to store this information. The basics N number of studen

Random ID's for existing data

id's to it. This web site will be using PHP as the programming language so it would be nice if I could use the same mechanism to add the random id's automatically when I add new users via a web form. Thanks for any ideas on how to approach this! -Brian Menke

Dates range query

n someone give me an example of how to do this please? I'm sure people do this all the time, but it confuses the heck outta me :-) Thanks! -Brian Menke

Error message on windows xp install

running MS-DOS and Microsoft Windows applications. Choose 'Close' to terminate the application". Any ideas? I was very careful to grab the windows version off a mirror site (linked for mysql.com). Thanks! -Brian Menke

RE: How to use "use" for a specific host

e. -Brian -Original Message- From: V. M. Brasseur [mailto:[EMAIL PROTECTED] Sent: Thursday, September 02, 2004 3:00 PM To: Brian Menke Cc: [EMAIL PROTECTED] Subject: Re: How to use "use" for a specific host Are you using the mysql client to connect? If so, you can use the -h and -

How to use "use" for a specific host

I'm trying to specify a host name and database name to do an update to a table. I can't quite figure out what the correct syntax is? Is it something like: USE [EMAIL PROTECTED] I have tried several permutations of that but can't quite seem to get the syntax just right. Thanks. -Brian