ok i worked out the problem possible bug ?? SELECT f.filmID, f.programID, prg.name FROM films f LEFT JOIN EPG.TblProgram prg ON f.programID=prg.programID WHERE f.alive=1 AND ((NOW()>=f.start_date) AND (NOW() <= f.end_date))
the mysql_field_table wont show up properly on a join or even when selected fields this worked though select * from films how can i make it work with a join ? >===== Original Message From daniel <[EMAIL PROTECTED]> ===== >hi guys this seems to return on the first letter of the table name ?? return >@mysql_field_table($this->result,0); what could bne the problem ? > > > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
