Array_Unique Question Regarding Mysql Command?

[scm22ri]

Hi Everyone,

 

I want to display the vehicles every user is selling but for some reason I'm getting duplicate information. I think the answer to my question is the array_unique function but I'm having a hard time trying to figure out where the function should go? Any help would be appreciated. Thanks

 

 

<?php
include_once "init.php";

echo "<table border='1'>";
echo "<tr> <th>User ID</th> <th>First Name</th> <th>Last Name</th> <th>Car Desc ID</th> <th>Price</th> <th>Mileage</th> <th>Transmission</th> <th>Color</th> <th>Year</th> <th>Make</th> <th>Model</th> </tr>";

$query = "SELECT users.user_id, users.firstname, users.lastname, prices.car_desc_id, prices.price, \n"
. "\n"
. "prices.mileage, prices.transmission, prices.color, car_desc.year, car_desc.make, car_desc.model\n"
. "\n"
. "FROM users, prices, car_desc\n"
. "\n"
. "WHERE prices.car_desc_id LIMIT 0, 30 ";

// $result = array_unique($query);

// $query = "SELECT * FROM car_desc ORDER BY id ASC";
$thedude = mysql_query($query) or die(mysql_error());
// $result = array_unique($thedude);
while ($row = mysql_fetch_array($thedude)) {

$user_id = ($row['user_id']);
$firstname = ($row['firstname']);
$lastname = ($row['lastname']);
$car_desc_id = ($row['car_desc_id']);
$price = ($row['price']);
$mileage = ($row['mileage']);
$transmission = ($row['transmission']);

$color = ($row['color']);
$year = ($row['year']);
$make = ($row['make']);
$model = ($row['model']);


// keeps getting the next row until there are no more to get
/*while ($row = mysql_fetch_array($result))*/ {
// Print out the contents of each row into a table
?>
<tr>
<td><?php echo "$user_id"; ?></td>
<td><?php echo "$firstname"; ?></td>
<td><?php echo "$lastname"; ?></td>
<td><?php echo "$car_desc_id"; ?></td>
<td><?php echo "$price"; ?></td>

<td><?php echo "$mileage"; ?></td>
<td><?php echo "$transmission"; ?></td>

<td><?php echo "$color"; ?></td>
<td><?php echo "$year"; ?></td>
<td><?php echo "$make"; ?></td>
<td><?php echo "$model"; ?></td>
</tr>
<?php
}
/*echo "</table>";*/
}
/*else*/ {
/*trigger_error(mysql_error()); // for development only; remove when in production*/
}
?>

Edited October 1, 2012 by scm22ri

[Jessica]

You need to specify on what columns to join those tables.

[PFMaBiSmAd]

Locking this thread because you already have an active thread for this.