put into an array from database

[brem13]

i'm trying to figure out how to put data(users) into an array from a database, i'd also like to make it so that array doesnt have duplicates. any help?

$result = mysql_db_query($database, "select * from $table ORDER BY rand()") or die (mysql_error());
while($qry = mysql_fetch_array($result))
{ 
$user = $qry['username'];
$pic = $qry['mainPic'];
$lastOnline = $qry['lastLogin'];
$lookingFor = $qry['lookingFor'];
}//end while
$users = array($user);
$distinct = array_unique($users);

[priti]

one more option can be:

 

$users=array();

while($qry = mysql_fetch_array($result))

{

    if(!in_array($qry['username'],$users)

    {

              array_push($users,$qry['username']);

    }

}//end while

 

[brem13]

ok, i tried that, its still giving me duplicates and all the usernames are 'array' now

[Adam]

I don't know why you'd have duplicate users in that table, but you just need to modify your SQL. Try adding a group by clause:

 

select * from $table GROUP BY username ORDER BY rand()

[brem13]

nope, still duplicates, what i'm doing is displaying random users from a database(user is only in database once) but they show up multiple times on page

[Adam]

You're saying the query is selecting the exact same record twice?

 

Does this happen if you run the same SQL separately in a MySQL administrator (e.g. PHPMyAdmin)?

 

Edit: by the way mysql_db_query is deprecated.

[brem13]

yes, here is the full code

while($i < 10)
{
if($i == 4 || $i == 7)
	echo "</tr><tr>";

echo "<td width=225px height=125px align=left valign=top>";
include("config.php");
mysql_connect($server, $db_user, $db_pass) or die (mysql_error()); 
$result = mysql_db_query($database, "select * from $table GROUP BY username ORDER BY rand()") or die (mysql_error());
$users=array();
while($qry = mysql_fetch_array($result))
{ 
	$user = $qry['username'];
	$pic = $qry['mainPic'];
	$lastOnline = $qry['lastLogin'];
	$lookingFor = $qry['lookingFor'];
	if(!in_array($qry['username'],$users))
	{
	     array_push($users,$qry['username']);
	}
}//end while
list($width, $height, $type, $attr) = getimagesize("userImages/thumbs/".$pic);

if($height>=101)
{
	echo "<a href=viewProfile.php?user=$users style='text-decoration:none;'><font face=tahoma size=2 color=#FFFFFF>$users</font><br><img src=userImages/thumbs/$pic height=75px></a><br>";
}//end if $height
else
{
	echo "<a href=viewProfile.php?user=$users style='text-decoration:none;'><font face=tahoma size=2 color=#FFFFFF>$users</font><br><img src=userImages/thumbs/$pic width=75px></a><br>";
}
echo "<font face=tahoma size=1>$lastOnline - $lookingFor</font>";
echo "</td>";

$i++;
}//end while

[Adam]

What are you saying yes to?

[brem13]

yes it is selecting the same record twice, here is a screenie of what it looks like

 

[attachment deleted by admin]

[Adam]

And you if run the SQL in a MySQL administrator?

[brem13]

it does not give me duplicates

[Adam]

Probably because you have the query contained in a loop..

 

while($i < 10)
{

 

Why is it within a loop?

[brem13]

if u notice in the picture, i want it to select 9 users randomly and put them in the table, without having to put the same code 9 times

 

[Adam]

select * from $table ORDER BY rand() LIMIT 9

[brem13]

ok, tried that, and changed the code around a bit, took it out of the while loop and now i'm getting the same user for all of them

 

modified code:

$result = mysql_db_query($database, "select * from $table ORDER BY rand() LIMIT 9") or die (mysql_error());

while($qry = mysql_fetch_array($result))
{ 
$user = $qry['username'];
$pic = $qry['mainPic'];
$lastOnline = $qry['lastLogin'];
$lookingFor = $qry['lookingFor'];
list($width, $height, $type, $attr) = getimagesize("userImages/thumbs/".$pic);
if($height>=101)
{
	$display = "<a href=viewProfile.php?user=$user style='text-decoration:none;'><font face=tahoma size=2 color=#FFFFFF>$user</font><br><img src=userImages/thumbs/$pic height=75px></a><br>";
}//end if $height
else
{
	$display = "<a href=viewProfile.php?user=$user style='text-decoration:none;'><font face=tahoma size=2 color=#FFFFFF>$user</font><br><img src=userImages/thumbs/$pic width=75px></a><br>";
}

}//end while
$i = 1;
while($i < 10)
{
	if($i == 4 || $i == 7)
	echo "</tr><tr>";

	echo "<td width=225px height=125px align=left valign=top>";
	echo $display;
	echo "<font face=tahoma size=1>$lastOnline - $lookingFor</font>";
	echo "</td>";
	$i++;
}//end while

[brem13]

ok, finally got it to work, got rid of the while loop, inserted limit 9, changed around code a bit, result below

mysql_connect($server, $db_user, $db_pass) or die (mysql_error()); 
$result = mysql_db_query($database, "select * from $table ORDER BY rand() LIMIT 9") or die (mysql_error());
$i=1;							
while($qry = mysql_fetch_array($result))
{ 
$user = $qry['username'];
$pic = $qry['mainPic'];
$lastOnline = $qry['lastLogin'];
$lookingFor = $qry['lookingFor'];
list($width, $height, $type, $attr) = getimagesize("userImages/thumbs/".$pic);
echo "<td width=225px height=125px align=left valign=top>";
if($height>=101)
{
echo "<a href=viewProfile.php?user=$user style='text-decoration:none;'><font face=tahoma size=2 color=#FFFFFF>$user</font><br><img src=userImages/thumbs/$pic height=75px></a><br>";
}//end if $height
else
{
echo "<a href=viewProfile.php?user=$user style='text-decoration:none;'><font face=tahoma size=2 color=#FFFFFF>$user</font><br><img src=userImages/thumbs/$pic width=75px></a><br>";
}
echo "<font face=tahoma size=1>$lastOnline - $lookingFor</font>";
echo "</td>";
$rows = mysql_num_rows($result);  
if($i==3 || $i==6)
	echo "</tr><tr>";
$i++;
}//end while