I want to create a table of names with two columns where names are taken from the database but I don't know how.. I need help.
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.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…