Show records using mysql_fetch_assoc( ) function

mysql_fetch_assoc() return the rows from the number of records available in the database as an associative array. at a time it returns only the first row as an associative array. if we want to retrieve all the records of the table then we must put this function inside the while loop.

Syntax:

mysql_fetch_assoc(query)

PHP MySQL Select Query Using mysql_fetch_assoc() With Output Example

<?php  
	$host = "localhost";  
	$user = "";  
	$pass = "";  
	$dbname = "users";
	$conn = mysql_connect($host,$user,$pass) or die(mysql_error());  
	if(!$conn){  
	  die("Could not connect:".mysql_connect_error());  
	}
	// select database 
	mysql_select_db($dbname,$conn);  
	$sql = "SELECT * FROM users";  
	$result=mysql_query($sql);
	print_r(mysql_fetch_assoc($result));
	mysql_close();  
?> 

Output:

Array(
	[id] =>1
	[name] => rakesh
	[salary] =>20000
) 

Show all records from users table using mysql_fetch_assoc( ) function:

<?php  
	$host = "localhost";  
	$user = "";  
	$pass = "";  
	$dbname = "users";  
	  
	$conn = mysql_connect($host,$user,$pass) or die(mysql_error());  
	if(!$conn){  
	  die("Could not connect:".mysql_connect_error());  
	}
	// select database 
	mysql_select_db($dbname,$conn);  
	$sql = "SELECT * FROM users";  
	$retval=mysql_query($sql);  
	  
	if(mysql_num_rows($retval) > 0){  
		echo "<table border='1'>";
		echo "<tr><th>ID</th><th>Name</th><th>Salary</th></tr>";
		while($row= mysql_fetch_assoc($retval))
		{
			echo "<tr>";	
			echo "<td>".$row['id']."</td>";
			echo "<td>".$row['name']."</td>";
			echo "<td>".$row['salary']."</td>";
			echo "</tr>";
		}		
		echo "</table>";
	}else{  
		echo "0 results";  
	}  
	mysql_close();  
?> 

Output:

Result In Table: Users