Re: Select 2 table..

[Aydın Yakar]

Your code not work and how i can use your code for daily stats?;
-----------
$sql = mysql_query("SELECT uyeler.id AS user_id, COUNT(*) AS count FROM uyeler INNER JOIN sitestats ON uyeler.id=sitestats.sid ORDER BY count DESC");

while($veri = mysql_fetch_array($sql)) {
print_r($veri);
}


Error Output:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/aramaus/public_html/giris2.php on line 8

-----------------------------------------------------

That is working:
$sql = mysql_query("SELECT * FROM uyeler");
while($veri = mysql_fetch_array($sql) {
print_f($sql);
}

__________________________________________________________
http://PhpSetup.com | http://Arama.us