>Hi All MySQL users > >I am having a slight problem and getting inot a bit of a tizz. > >I have two tables and I am trying to produce a dropdown select menu whilst >creating a join. The two tables are as follows... > >CREATE TABLE itinerary ( > i_id int(3) unsigned NOT NULL auto_increment, > i_title varchar(100) default NULL, > i_description mediumtext, > i_category int(3) unsigned default NULL, > i_ordernumber int(3) unsigned default NULL, > i_text mediumtext, > i_image1 varchar(255) default NULL, > i_image2 varchar(255) default NULL, > i_image3 varchar(255) default NULL, > PRIMARY KEY (i_id), > UNIQUE KEY i_id (i_id), > KEY i_id_2 (i_id) >) TYPE=MyISAM; > >and > >CREATE TABLE dates2 ( > d_id int(3) unsigned NOT NULL auto_increment, > d_objid int(3) unsigned default NULL, > d_startdate date default NULL, > d_enddate date default NULL, > PRIMARY KEY (d_id), > UNIQUE KEY d_id (d_id), > KEY d_id_2 (d_id) >) TYPE=MyISAM; > >The two fields that are associated are dates2.d_objid and itinerary.i_id what I >want to do is pull out the dates for a selected itinerary.i_id and present them >in a select menu. I am using php but it's been a while and have only >got so far >inot a tizz :) > >Can anyone shed a little light on the quesry or a bit of guidance on how to >approach this? > >Thank you >Andrew >
This is what I have used for the query and the php <? echo "<select name=\"StartDate\" size=\"1\" class='menuForm'>"; $result=mysql_query("select dates2.d_objid ,dates2.d_startdate,dates2.d_enddate from dates2 left join itinerary.i_id on dates2.d_objid = itinerary.i_id where dates2.d_startdate and dates2.d_enddate=" . $Date . " group by dates2.d_startdate"); while ($row = mysql_fetch_array($result)) { $d_startdate=$row['StartDate']; $d_enddate=$row['EndDate']; echo "<option value=\"$Date\">$d_startdate - $d_enddate </option>"; } echo "</select>"; ?> which is clearly wrong somewhere :( Any help would be nice Andrew > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]