mysql - Why is my PHP Database query returning 6 rows when only 2 entries?

Solution:

You're looping through the results twice. Get rid of the unnecessaryforeach() call (while() will loop through all of the results of the query).

<?php
mysql_select_db($database_database_connection, $database_connection);
$getdevices=("SELECT * FROM Device_tbl");
$getdevicesresult = mysql_query($getdevices, $database_connection) or die(mysql_error());
while($device=mysql_fetch_assoc($getdevicesresult)){
?>
    <div class="hold-cont">
        <div class="holder">
            <div class="image-hold" >
                <img class="image-icon" src="images/android.png"/>
            </div>
        </div>
        <div class="device-name devicename-txt"><?php echo $device['Model'];  ?></div>
    </div>

<?php
}
mysql_close();
?>
Copy code

Note: I've also changedprint_r(...) toecho ... as$device['Model'] is not an array and I've changed your short opening tags (<?) to normal ones (<?php) as not all servers supportshort tags (see Are PHP short tags acceptable to use?).

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.