Howtofetchdatafrommysqltableusingmysql_fetch_associ_MySQL

php mysql_connect('localhost','root','') or die(mysql_error());

mysql_select_db('new') or die(mysql_error());

$query=mysql_query('select * from table1') or die(mysql_error());

while($res=mysql_fetch_assoc($query))

{

echo'

}

echo'

?>

Now you'll get output like this:

Where,

the result of array should be like this:

Array(

[game_ID] => 1

[category_Name] => Adventures

[game_Title] => Achilles

)

Suppose you'll use

echo'

That means you use numeric index instead associative, then you will get undefined offset error like as follows as: