Re: dropdown with two Sql query
| From: | Tamara Temple | Date: | Sun, 26 Jun 2011 15:29:30 +0000 |
| Subject: | Re: dropdown with two Sql query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-313723@lists.php.net to get a copy of this message | ||
On Jun 25, 2011, at 3:57 PM, asp kiddy wrote:
SELECT td.id_resultat,td.fld_email_id,email.fld_name_email FROM $table_db td JOIN $table_db_email email ON td.fld_email_id = email.id_email WHERE td.id_resultat = $idI see two small problems right away:
FROM $table_db tdshould read: FROM $table_db AS td and:
JOIN $table_db_email emailshould read JOIN $table_db_email AS email Maybe that's it?