RE: [PHP] mysql_field_table problem
| From: | daniel | Date: | Sun, 30 Mar 2003 05:57:19 +0000 |
| Subject: | RE: [PHP] mysql_field_table problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-141624@lists.php.net to get a copy of this message | ||
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 <daniel@electroteque.org> =====
>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