A combo query retreiving data from database

août 10, 2017

Question:

I have 2 tables:
sent & profile

I store emails in sent, and when i echo them, i want to if each email already exists in profile

So, i did this:

Code:

$q = "SELECT * FROM sent ORDER BY date_sent DESC, time_sent DESC LIMIT 50;";

$res = @mysql_query($q);

while($r = @mysql_fetch_array($res))
{
$IsHeMember==$r[email_sent];
print "Nickname:";
print "...";
print "$r[nickname_sent]";
print "...............";
print "Profile ID:";
print "...";
echo "<a href='/ads/results/one.php?ID={$r['profile_sent']}' target='_blank'>$r[profile_sent]</a>";
print "...............";
print "Email:";
print "...";
print "$r[email_sent]";
print "...............";
print "Date:";
print "...";
print "$r[date_sent]";

$q2 = "SELECT * FROM profile WHERE Email='$IsHeMember'";
$res = @mysql_query($q2);

if(mysql_num_rows($res)>0){
print "...............";
print "Member";
}else{
print "...............";
print "Not Member";
}

print " ";

}

but somehow, this code only shows the results which meet both conditions
I.e. only the results where the email is in both sent & profile

I want to shows all rows from sent, and to check the email in profile

Hope i am understandable, Very Happy

Answers:

Rename the second variable $res = @mysql_query($q2); to $res1 = @mysql_query($q2);

Your code can be something like this:

Code:

<?
$q = "SELECT * FROM sent ORDER BY date_sent DESC, time_sent DESC LIMIT 50;";

$res = @mysql_query($q);

while($r = @mysql_fetch_array($res))
{
$IsHeMember==$r[email_sent];
print "Nickname:";
print "...";
print "$r[nickname_sent]";
print "...............";
print "Profile ID:";
print "...";
echo "<a href='/ads/results/one.php?ID={$r['profile_sent']}' target='_blank'>$r[profile_sent]</a>";
print "...............";
print "Email:";
print "...";
print "$r[email_sent]";
print "...............";
print "Date:";
print "...";
print "$r[date_sent]";

$q2 = "SELECT * FROM profile WHERE Email='$IsHeMember'";
$res1 = @mysql_query($q2);

if(mysql_num_rows($res1)>0){
print "...............";
print "Member";
}else{
print "...............";
print "Not Member";
}

print " ";

}

?>

Rechercher dans ce blog

Excelhelp

A combo query retreiving data from database

Commentaires

Enregistrer un commentaire

Posts les plus consultés de ce blog

XAJAX with PHP – The future of web development

XAJAX with PHP – The future of web development

Database connection pooling in ADO.Net