PHP Table. Displaying multiple rows into one

Question

Here is my code:

    <table border="2px solid #FFF" width="100%">
            <tr>
                <td width="50%"><Center>Username:</Center><br /></td>
                <td width="50%"><center>Numebr Of Warnings:</center><br /></td>
            </tr>
            </table>
            <?
            $query = mysql_query("SELECT * FROM warnings");
            $numrows = mysql_num_rows($query);
                if($numrows != "0"){
                   while($row = mysql_fetch_assoc($query)){
                        $warned = $row['username'];
                        $by = $row['by'];
                        $sql = mysql_query("SELECT * FROM warnings WHERE username='$warned'");
                        $warns = mysql_num_rows($sql);
                        ?>
                            <table border="2px solid #FFF" width="100%">
                                <tr>
                                    <td width="50%"><center><b><?php echo $warned; ?></b></center></td>
                                    <td width="50%"><center><b><?php echo $warns; ?></center></b></td>
                                </tr>
                            </table>
                        <?php
                   }
                }
                else
                    echo "No Currently Warned Users";
                ?>

            <hr />

And here is the result: enter image description here

How can I make it so that instead of showing the 2 results for the user Mrg..... I just want it to show one result with the number or rows there are.

Help would be appreciated.

There is no such thing as a "php table". What you should is a html table. — arkascha
– arkascha, Commented Apr 8, 2014 at 15:53
by = varch (255). id = int. username = varchar (255). date = datetime — user3474238
– user3474238, Commented Apr 8, 2014 at 16:02

John Conde · Accepted Answer · 2014-04-08 15:53:19Z

1

You can use DISTINCT in your query to avoid duplicate rows in your results:

SELECT DISTINCT username, `by` FROM warnings

answered Apr 8, 2014 at 15:53

John Conde

220k100 gold badges464 silver badges504 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3474238 Over a year ago

This added the 2 and the 1 to make three for all users.

user2585076 · Accepted Answer · 2014-04-08 16:05:57Z

0

Change the mysql_fetch_assoc with mysql_feth_array

You're getting the user with double record. Then for each user you are getting 2 lines

The best way to check it is to add pseudo-points to your code.

$query = mysql_query("SELECT * FROM warnings");
$arr=array();
while($row = mysql_fetch_assoc($query))
{
    $arr[]=$row;
}
echo "<pre>";
print_r($arr);    
echo "</pre>";
exit;

Here check if the $arr has double entries. Then change the mysql_fetch_assoc with mysql_fetch_array and try again

answered Apr 8, 2014 at 16:05

user2585076

6 Comments

user3474238 Over a year ago

Sorry don't follow fully. What about echoing the table?

user2585076 Over a year ago

You can see if your array has double entries from records. I think the mysql_fetch_assoc when you're selecting records from db getting double records. If you have still problem I can help you with teamviewer or anything you need.

user3474238 Over a year ago

Sorry to be a pain... could you write the full code out for me including the table so I can understand and learn from it? Sorry. Thanks

user2585076 Over a year ago

No problem. I'm trying to help people. Please write the table struct here. I'll write the code for you.

user3474238 Over a year ago

by = varch (255). id = int. username = varchar (255). date = datetime. Only by and username are needed :). THANKS!

|

user2585076 · Accepted Answer · 2014-04-08 17:03:50Z

0

Here is the table

(by,id,username,date)

a1,1,u1,date

a2,2,u2,date

a3,3,u2,date

a4,4,u2,date

And here is the php code

<?php
$conn = mysqli_connect("localhost","username","password");
mysqli_select_db($conn,"dbname");

$warns = mysqli_query($conn,"select username, count(username) as warncount  from dtest.warnings W group by username");

while($line = mysqli_fetch_array($warns))
{
    echo $line['username']." has ".$line['warncount']. " warns <br/> ";
}
?>

answered Apr 8, 2014 at 17:03

user2585076

8 Comments

user3474238 Over a year ago

Thanks but got this error: Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /home/cocpages/public_html/mods.php on line 40. I did change the db connect files

user2585076 Over a year ago

try directly my code. Create a table with the above structre and check. If you need I can show you on my computer. Don't worry I'm not hacker, cracker :)

user3474238 Over a year ago

Didn't mean files I just connected to my DB. Table structure is correct. Might do a Teamviewer in a bit if no solution. Can we do a private chat here? Could you make one? :)

user2585076 Over a year ago

I'm here. I've gone out. Are you there ?

user3474238 Over a year ago

I'm here. Any idea on what we can do? I am thinking of changing the table so that instead of inserting a new row it updates the current one to add 1 to the current value if the username exists in the table

|

Collectives™ on Stack Overflow

PHP Table. Displaying multiple rows into one

3 Answers 3

1 Comment

6 Comments

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

6 Comments

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related