Re: SQL query problem with mysql.

2001-03-05 Thread Bob Hall
>hi, > >i'm writing a book (wrox publishers) which uses mysql for the sample >database. >i seem to have encountered a problem with an SQL query. >its a simple voting application, with a candidate table, and a vote table: > >create table candidate ( >candidatenumber integer not null auto_increment,

Re: SQL query problem with mysql.

2001-03-05 Thread Jason Landry
t;; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, March 05, 2001 3:54 AM Subject: SQL query problem with mysql. > hi, > > i'm writing a book (wrox publishers) which uses mysql for the sample > database. > i seem to have encount

RE: SQL query problem with mysql.

2001-03-05 Thread Aaron Weiker
MAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: SQL query problem with mysql. hi, i'm writing a book (wrox publishers) which uses mysql for the sample database. i seem to have encountered a problem with an SQL query. its a simple voting application, with a candidate table, and a v

SQL query problem with mysql.

2001-03-05 Thread Larry Kim
hi, i'm writing a book (wrox publishers) which uses mysql for the sample database. i seem to have encountered a problem with an SQL query. its a simple voting application, with a candidate table, and a vote table: create table candidate ( candidatenumber integer not null auto_increment, firstnam