MySQL+PHP
| From: | Diana Wu | Date: | Wed, 21 Jul 2010 07:30:01 +0000 |
| Subject: | MySQL+PHP | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-307058@lists.php.net to get a copy of this message | ||
Dear all,
I'm a newbie, need your help.
Now I am building a databasea using MySQL and PHP, I want to put two tables
in one searching, the two are in one database.
$query = "SELECT SQL_CALC_FOUND_ROWS * FROM table1 WHERE ".implode(" AND
", $data);
$number = "SELECT FOUND_ROWS()";
How can I change this if I want to put table2 in it.
Thank you.
Best wishes,
diana
2010-7-21