Are there any best practices to follow when using mysql_fetch_row in PHP to avoid errors?

When using mysql_fetch_row in PHP, it is important to check if the result set is empty before attempting to fetch rows to avoid errors. This can be done by checking if the result set is not false before fetching rows. 

$result = mysql_query("SELECT * FROM table");
if($result !== false){
    while($row = mysql_fetch_row($result)){
        // process the row data
    }
} else {
    echo "Error fetching data from database";
}

Keywords

mysql_fetch_row PHP errors data retrieval best practices

Related Questions