Any ideas how to get this working?
PHP Code:
<?php
$sql = "SELECT * FROM adddb ORDER BY dateinput DESC LIMIT 0,20";
$result = mysql_query($sql, $conn) or die(mysql_error());
while ($newArray = mysql_fetch_array($result)) {
$id = $newArray['id'];
$nameof = $newArray['nameof'];
$why = $newArray['why'];
$link = "view.php?id";
$totalcomments = 0;
$query = "SELECT * FROM comments WHERE adddbid = $id";
$result = mysql_query($query);
while ($user = mysql_fetch_assoc ($result)) {
$totalcomments++;
}
echo "<a href='$link=$id'>$nameof</a> $totalcomments<br>";
}
?>
Comment