Getting Multiple Data

[Krux20]

Hi,

 

For some reason I keep getting multiple data when I run the following code:

$result = mysqli_query($con,'SELECT Bike.BikeCode,Bike.Manufacturer,Bike.Model,Bike.FrameMaterial,Bike.Description,Bike.Price, BikeImages.SourcePath, BikeImages.BikeCode FROM Bike,BikeImages WHERE Bike.BikeCode = BikeImages.BikeCode');

 

http://tinypic.com/r/vdiee1/6

[mrMarcus]

You have more code. Please post it.

[Krux20]

   function products () {

   $con = mysqli_connect("localhost","root","");
   mysqli_select_db($con,"bicycle");

   if (!$con) {
     die('Could not connect: ' . mysql_error());
    }

 $result = mysqli_query($con,'SELECT Bike.BikeCode,Bike.Manufacturer,Bike.Model,Bike.FrameMaterial,Bike.Description,Bike.Price, BikeImages.SourcePath, BikeImages.BikeCode FROM Bike,BikeImages WHERE Bike.BikeCode = BikeImages.BikeCode');
 //$images = mysqli_query($con,'SELECT BikeImages.SourcePath,Bike.BikeCode FROM BikeImages,Bike WHERE BikeImages.BikeCode = Bike.BikeCode');

 echo "







 ";

 while ($row = mysqli_fetch_array($result)) {


    echo "" . "" . ""  .""  .""  . "" .  "" . "";

 }

BikeCode Manufacturer Model FrameMaterial Description Price " . $row['BikeCode'] . " " . $row['Manufacturer'] . " " . $row['Model'] ." " .$row['FrameMaterial'] ." " . $row['Description'] . " " . number_format($row ['Price'], 2) . " " . ' ' . "

[MDCode]

It's not going to help if you take information out of your page

[Krux20]

function products () {

   $con = mysqli_connect("localhost","root","");
   mysqli_select_db($con,"bicycle");

   if (!$con) {
     die('Could not connect: ' . mysql_error());
    }

 $result = mysqli_query($con,'SELECT Bike.BikeCode,Bike.Manufacturer,Bike.Model,Bike.FrameMaterial,Bike.Description,Bike.Price, BikeImages.SourcePath, BikeImages.BikeCode FROM Bike,BikeImages WHERE Bike.BikeCode = BikeImages.BikeCode');
 //$images = mysqli_query($con,'SELECT BikeImages.SourcePath,Bike.BikeCode FROM BikeImages,Bike WHERE BikeImages.BikeCode = Bike.BikeCode');

 echo "<table border='1'>
 <tr>
 <th> BikeCode </th>
 <th> Manufacturer </th>
 <th> Model </th>
 <th> FrameMaterial </th>
 <th> Description </th>
 <th> Price </th>
 </tr>";

 while ($row = mysqli_fetch_array($result)) {


    echo "<tr>" . "<td>" . $row['BikeCode'] . "</td>" . "<td>" . $row['Manufacturer'] . "</td>"  ."<td>" . $row['Model'] ."</td>"  ."<td>"  .$row['FrameMaterial']   ."</td>"  . "<td>" . $row['Description'] . "</td>" .  "<td>" . number_format($row ['Price'], 2) . "<td>" . '<form action="cart.php?add='.$row['BikeCode'] .'" method="POST"><input type="submit" value="Add" name="add">    </form>' . "</td>" . "</tr>";

 }

[AyKay47]

What results are you expecting?

Also, use mysqli_error() instead of mysql_error()

[Pikachu2000]

What results are you expecting?

Also, use mysqli_error() instead of mysql_error()

 

mysqli_connect_error() would be the correct function to use where mysql_error() currently is in the code.

[AyKay47]

ya

[mrMarcus]

Do you have multiple, identical records in your table? From the image you provided, it seems the last 2 records are not identical.

 

Please check and be 100% certain your table does not contain duplicates.

Edited November 28, 2012 by mrMarcus

[Krux20]

Hi,

 

Yes, I do have duplicates data since there are two images for one product. So, the ID for the item is linked to the Images of the product.

 

http://tinypic.com/r/33yqefl/6

[Barand]

Do you have more than one image for each bike (like 2 images where you are getting the bike data listed twice)?

[Krux20]

Example: SourcePath BikeCode

"Images/IMAGE1.jpg" MAB2012-5

"Images/IMAGE2.jpg" MAB2012-5

[Barand]

That isn't "duplicate" data, that's the way joins work - matching data from one table is joined the matching data from the other, so bike data is joined to each image.

 

Try SELECT DISTINCT ...

 

and only select fields for the bike records - that's all you are listing

Edited November 29, 2012 by Barand

[Krux20]

Yes, but I have the BikeCode in the Bike table and I have the SourcePath in another table called BikeImages. How can I access get the sourcepath and the BikeCode from the two tables without repeating data.

Edited November 29, 2012 by Krux20

[Barand]

You have to accept that is how it works and adjust your processing code. How you adjust depends on how you want to display.