How do I get all data from a MySQL database?

Data can be fetched from MySQL tables by executing SQL SELECT statement through PHP function mysql_query . You have several options to fetch data from MySQL. The most frequently used option is to use function mysql_fetch_array().