我的代码是否输入正确？ [关闭]

Question

Is my code being inputted correctly. I am trying to SELECT from my database a set of numbers. Here is the code:

mysql_connect(db_server, db_user, db_pass);
$result = mysql_db_query(db_name,"SELECT *, COUNT(track.usr_id) AS usr_views FROM user, track WHERE track.usr_id = $usr_id AND track.timesin = $les_tag GROUP BY $usr_id ORDER BY usr_views LIMIT 1");      
$usercheck = mysql_result($res, 0, 0); 
$Userstats = $usercheck;  

Am I selecting the code wrong?

Answer 1

Try this...

$conn = mysql_connect(db_server, db_user, db_pass);
if ($conn !== false) {
    mysql_select_db(db_name);
    $result = mysql_query("SELECT *, COUNT(track.usr_id) AS usr_views FROM user, track WHERE track.usr_id =     $usr_id AND track.timesin = $les_tag GROUP BY $usr_id ORDER BY usr_views LIMIT 1");      
    if ($result !== false && mysql_num_rows($result) > 0) {
        $usercheck = mysql_fetch_row($result); 
        $Userstats = $usercheck;
    }
} else {
     die("There was an error while connecting to the mysql server");
}