Help me please, lol

[simjay]

Any ideas how to get this working?



<?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>";

}

?>

[mark87]

Double post... :mad:

http://www.codingforums.com/showthread.php?p=338654

[JamieR]

ever read the rules?

http://www.codingforums.com/rules.htm

http://www.codingforums.com/postguide.htm

No Double posting and "help me please, lol" is a meaningless thread title.

[joeframbach]

weazel, its been taken care of already by mark87. your "ever read the rules" comment was harsh and made me lose a lot of respect for you. simjay doesn't need that crap, okay?

[JamieR]

okay okay,

I'm just pointing out that all members need to be aware of the rules of CodingForums.

[simjay]

i am sorry for posting 2 times, i ment to put it in the PHP section but by mistake i put it in here, but it was 2 late to delete it. Feel free to delete this post.