MySQL

[pastet89]

How can I get in an array all the values of the row 'code' in Mysql table?
I ttried this:

$query = "SELECT * FROM users";
$res = mysql_query($query);
$str1 = mysql_fetch_assoc($res);
mysql_free_result($res);
print_r($str1[code]);

but it doen't work...? 😕

[djjjozsi]

example:

<?php

include_once("connect.php");
$sql="SELECT * FROM users ORDER BY Username";
$result=mysql_query($sql) or die(mysql_error());
if(mysql_num_rows($result)>0)
{
	while($rows=mysql_fetch_assoc($result))
	{
	 print "<a href=\"?site=listusers&id={$rows["id"]}\"> ".$rows["Username"]."</a><br>\r";
	}
}
else
{
 print "Database is empty";
}
?>