Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


how to create php 2 column table with values from the database


how to create php 2 column table with values from the database  using -'php,mysql,table'

I want to create a table of names with 2 columns where names are taken from the database but I don't know how..I need help guys:-(

names: James, John, Paul, Peter

Here's my code:

<?php
$con = mysql_connect("localhost","root","");
if(!$con){
echo "Unable to connect DB";
}else{
    $db = mysql_select_db("persons",$con);
    echo "Connected";
}
echo "<table border='1'>";
$count = 0;
$sql = "SELECT * FROM tbl_names";
$q = mysql_query($sql);
while($res = mysql_fetch_array($q)){
$count++;
    echo "<tr>";
        for($i=1;$i<=2;$i++){
                echo "<td>{$res['id']}{$res['title']}</td>";
        }
    echo "</tr>";   
}
echo "</table>";
?>


I want the output to be like this:

+-------+-------+
| James | John  |
+-------+-------+
| Paul  | Peter |
+-------+-------+


But my code return:

+-------+-------+
| James | Jame  |
+-------+-------+
| John  | John  |
+-------+-------+
| Paul  | Paul  |
+-------+-------+
| Peter | Peter |
+-------+-------+


I need your help guys.Thanks.
    

asked Oct 19, 2015 by virendra.bajaj
0 votes
6 views



Related Hot Questions



Government Jobs Opening


...