[PHP-WIN] Re: MySQL question

2003-09-22 Thread Sek-Mun Wong
of course this is a php newsgroup :) try DAYOFMONTH DAY is only available in mysql 4.1.1 "Disko_kex" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Hi SELECT RegDate FROM table WHERE month(RegDate) = '10' // this is working SELECT RegDate FROM table WHERE day(RegDate) = '2' // w

[PHP-WIN] Re: mysql question

2003-07-09 Thread Cristian MARIN
Try to make a many-to-many design : Create a table 'images_img' with id_img, name_img, accession_img ... for the images Create a table 'categories_ctg' for the categories with id_ctg, name_ctg, description_ctg ... Create a table for unifing this two imgtoctg_itc with id_itc, idimg_itc, idctg_itc I