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...

http://www.codingforum.net/showthread.php?p=338654

[JamieR]

ever read the rules?

http://www.codingforum.net/rules.htm

http://www.codingforum.net/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 CodingForum.

[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.