Still being new to php, I was trying to make a SQL Query that would put information into a table.

Using PHP, here is how you complete a simple call to the SQL database and get in return a query, which you put into a table.

Heres what I came up with.

1. <table border=1>
2. <?php
3.  
4. mysql_connect("localhost", "username", "password") or die(mysql_error());
5. mysql_select_db("controlcsi") or die(mysql_error());
6.  
7.  
8. $summat = mysql_query("SELECT cllaccid, cllcustomid, cllstatus, cllname
9.                      FROM tblcall_accid
10.                       WHERE cllstatus= 'active'
11.                       GROUP BY cllaccid, cllcustomid, cllstatus, cllname
12.                     ");
13.                                        
14.                                                                                
15. while ($row = mysql_fetch_assoc($summat)) {
16.         $myid = $row['cllaccid'];
17.                 echo '<tr><td>'.$myid.'</td>';
18.         echo '<td>'.$row['cllcustomid'].'</td>';
19.         echo '<td>'.$row['cllstatus'].'</td>';
20.         echo '<td>'.$row['cllname'].'</td>';
21.                 echo '<td><a href="group.php?myid='.$myid.'">Select</a></td></tr>';
22.         }
23. ?>
24. </table>