[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
Robin Cornelius wrote: > I am displaying a list of seminars using the following :- > > $sql ="SELECT Seminar_id, > Seminar_name,Seminar_Venue,Seminar_Description,UNIX_TIMESTAMP(Seminar_Date) > as date,UNIX_TIMESTAMP(Seminar_Date2) as > date2,Seminar_PDF,Seminar_type, Seminar_paperscall FROM Seminar WHERE > TO_DAYS(NOW()) <TO_DAYS(Seminar_Date) AND ( Seminar_type=\"0\" OR > Seminar_type=\"1\") ORDER BY Seminar_Date "; > > Which produces a nice list of forthcomming seminars with the next > seminar at the top of the list. > > What i want to do now is start to use the Seminar_paperscall field. > This is a deadline to get submissions to the seminar in and i want to > produce a list that has the seminars in order as before but > interspersed with any submission deadlines eg :- Add a field to the select which is the the earlier of Seminar_paperscall and Seminar_Date (or Seminar_Date if Seminar_paperscall is null) and order by that? Should be possible to generate the description to associate with the date in a similar way. James -- The Mailing List for the Devon & Cornwall LUG http://mailman.dclug.org.uk/listinfo/list FAQ: http://www.dcglug.org.uk/linux_adm/list-faq.html