Code: Select all
mysql_query("SELECT * FROM antiques,art WHERE email ='$Email'"); Code: Select all
mysql_query("SELECT * FROM antiques WHERE email ='$Email'"); Please can some one tell me how to select 2 tables?
Youssef
Moderator: General Moderators
Code: Select all
mysql_query("SELECT * FROM antiques,art WHERE email ='$Email'"); Code: Select all
mysql_query("SELECT * FROM antiques WHERE email ='$Email'"); Code: Select all
SELECT *
FROM antiques
WHERE antiques.email = '$Email'
UNION ALL
SELECT *
FROM art
WHERE art.email = '$Email'
Code: Select all
$sql_added_Swaps = mysql_query( "SELECT *
FROM antiques
WHERE antiques.email = '$Email'
UNION ALL
SELECT *
FROM art
WHERE art.email = '$Email'");
$productCount = mysql_num_rows($sql_added_Swaps);
if ($productCount > 0)
{
while($row = mysql_fetch_array($sql_added_Swaps))
{
$id = $row["id"];
$producttittle = $row["producttittle"];
$productdescription = $row["productdescription"];
$firstname = $row["firstname"];
$city = $row["city"];
$country = $row["country"];
$postalcode = $row["postalcode"];
$email = $row["email"];
$Category = $row["Category"];// what table is it in
$dateadded = $row["dateadded"];
}
}Code: Select all
if (!$result) {
die('Invalid query: ' . mysql_error());
}Code: Select all
if (!$sql_added_Swaps ) {
die('Invalid query: ' . mysql_error());
}Code: Select all
$sql_added_Swaps = mysql_query( "SELECT *
FROM antiques
WHERE antiques.email = '$Email'
UNION ALL
SELECT *
FROM art
WHERE art.email = '$Email'");
if (!$sql_added_Swaps) {die('Invalid query: ' . mysql_error());}
$productCount = mysql_num_rows($sql_added_Swaps);
if ($productCount > 0)
{
while($row = mysql_fetch_array($sql_added_Swaps))
{
$id = $row["id"];
$producttittle = $row["producttittle"];
$productdescription = $row["productdescription"];
$firstname = $row["firstname"];
$city = $row["city"];
$country = $row["country"];
$postalcode = $row["postalcode"];
$email = $row["email"];
$Category = $row["Category"];// what table is it in
$dateadded = $row["dateadded"];
}
}Code: Select all
SELECT firstname
FROM antiques
WHERE antiques.email = '$Email'
UNION ALL
SELECT firstname
FROM art
WHERE art.email = '$Email'
Code: Select all
mysql_query( "SELECT *
FROM antiques
WHERE antiques.email = '$Email'
UNION ALL
SELECT *
FROM art
WHERE art.email = '$Email'");