Gegevens uit database in tabel
Ik heb alle gegevens uit de database gehaald, en kan het ook in tabel, kolom, cel zetten. Maar wat ik niet weet is wat ik moet doen als ik producten per 2 naast elkaar wil hebben in die tabel?
Tabel hieronder bestaat uit het volgende:
2 Kolomen, 4 cellen met producten (dit is uiteraard meer maar om een voorbeeld te stellen).
Product | Product
Product | Product
Ik heb dit al maar geen flauw benul hoe dit in 2 kolommen te zetten. Kan iemand mij verder helpen?
Alvast Bedankt,
mcmac
Dit is de script code
Code (php)
1
2
3
4
5
6
7
8
9
10
2
3
4
5
6
7
8
9
10
<?php
$result = mysql_query("SELECT DISTINCT id,title FROM producten ORDER BY id DESC LIMIT 0,5");
while($row = mysql_fetch_array($result)){
$id = $row['id'];
$title = $row['title'];
echo "<table with='400' border='1'>";
echo "<tr><td><a href='producten.php?id=$id'>[ID: $id]</a> | [Title: $title]<br></td></tr>";
echo "</table>";
}
?>
$result = mysql_query("SELECT DISTINCT id,title FROM producten ORDER BY id DESC LIMIT 0,5");
while($row = mysql_fetch_array($result)){
$id = $row['id'];
$title = $row['title'];
echo "<table with='400' border='1'>";
echo "<tr><td><a href='producten.php?id=$id'>[ID: $id]</a> | [Title: $title]<br></td></tr>";
echo "</table>";
}
?>
Edit: En <table> en </table> horen buiten de while-loop.
Gewijzigd op 01/01/1970 01:00:00 door - SanThe -
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
<?php
echo "<table with='400' border='1'>";
$result = mysql_query("SELECT DISTINCT id,title FROM producten ORDER BY id DESC LIMIT 0,5");
while($row = mysql_fetch_array($result))
{
echo '<tr><td><a href="producten.php?id=' . $row['id'] . '">[ID: ' . $row['id'] . ']</a> | [Title: ' . $row['title'] . ']<br></td>';
if($row = mysql_fetch_array($result))
{
echo '<td><a href="producten.php?id=' . $row['id'] . '">[ID: ' . $row['id'] . ']</a> | [Title: ' . $row['title'] . ']<br></td></tr>';
}
else
{
echo '<td> </td></tr>';
}
}
echo "</table>";
?>
echo "<table with='400' border='1'>";
$result = mysql_query("SELECT DISTINCT id,title FROM producten ORDER BY id DESC LIMIT 0,5");
while($row = mysql_fetch_array($result))
{
echo '<tr><td><a href="producten.php?id=' . $row['id'] . '">[ID: ' . $row['id'] . ']</a> | [Title: ' . $row['title'] . ']<br></td>';
if($row = mysql_fetch_array($result))
{
echo '<td><a href="producten.php?id=' . $row['id'] . '">[ID: ' . $row['id'] . ']</a> | [Title: ' . $row['title'] . ']<br></td></tr>';
}
else
{
echo '<td> </td></tr>';
}
}
echo "</table>";
?>