[SOLVED] mysql hustle, but i think it is easy!!!

[npsari]

Hi there,

 

I use this to count repeats from database

 

$q = "SELECT SENDER COUNT(SENDER) as CNT FROM profile GROUP BY SENDER ORDER BY CNT DESC LIMIT 20;";

 

then i echo data...

 

while($row = mysql_fetch_array($result)){

echo  "$row[CNT]";

echo  "<a href='/one.php?ID={$row['SENDER_PROFILE']}' target='_blank'>$row[sENDER_PROFILE]</a>";

}

 

But the quesry to show only the rows where ImageName and Email are not empty

 

i.e. WHERE Image !='' AND Email !=''

 

How can i add this part to the query?

 

can you show me guys please, cus when i add it, i add it wrong

[hostfreak]

Should do the trick

$q = "SELECT SENDER COUNT(SENDER) as CNT FROM profile WHERE ImageName != '' AND Email != '' GROUP BY SENDER ORDER BY CNT DESC LIMIT 20";

[npsari]

wow, cool, solved it out

 

thanks hostfreak