Re: An interesting SELECT problem

2001-04-28 Thread Bob Hall
>I've been creating a site for someone using MySQL and PHP4. >Basically the table concerned is structured like this; > >id int(5) UNSIGNED Noauto_increment Primary >ship varchar(50) NoIndex >year varchar(15) NoIndex Sir, change the type of this column to Date, whic

An interesting SELECT problem

2001-04-28 Thread Howard Picken
I've been creating a site for someone using MySQL and PHP4. Basically the table concerned is structured like this; id int(5) UNSIGNED Noauto_increment Primary ship varchar(50) NoIndex year varchar(15) NoIndex voyage varchar(50) Yes sex varchar(50)Yes