Hi there!
I´m making a search engine kinda complicated because I have to get data from 2 different tables from my DB.
I made my queries and both work well but when I try to combine them each one deploy different data and don´t make a relation between each other.
This is what I´ve done:
$result = mysql_query("SELECT * FROM db1 WHERE ID LIKE '%$ID%' ");
$result2 = mysql_query("SELECT * FROM db2 WHERE names like '%names%' ");
if (!mysql_num_rows($result2)) {
echo "Not found";
exit;
} else {
while ($Resulting = mysql_fetch_array($result, $result2)) {
How can I combine the 2 queries?
Is it possible to do something like:
"select from db1 AND select from db2"
Thanx a lot for your help
