a_gajic — Wed, 24 Oct 2001 12:16:53 +0000

THANKS MARK!!!!!!!!!!!!!!!!!!!

its working

Mark Hensler — Tue, 23 Oct 2001 23:36:23 +0000

Add more debug code to that..

<?php
$db = @mysql_connect(\"localhost\",\"a_gajic\",\"mypassword\");
if (!$db || !mysql_select_db(\"articles\")) {
    echo \"\nError connecting to database.\n\";
}

include(\"header.inc\");

function Query_Error($file,$line,$query,$silent=true) {
/**
 * takes the line and file where the query was built, and the query itself
 * prints the debug string.
 * 
 * if $silent, it will print in <!--comment tags-->
 */
    
    echo \"\n\n\";
    if ($silent) echo \"<!--\n\";
    echo \"FILE: $file\n\";
    echo \"LINE: $line\n\";
    echo \"\n\";
    echo \"QUERY ERROR:\n\";
    echo mysql_error() . \"\n\";
    echo \"\n\";
    echo \"QUERY:\n\";
    echo $query . \"\n\";
    if ($silent) echo \"-->\n\";
    echo \"\n\";
    
}

if ($id)  {

    // Display each individual article
    
    $query = \"SELECT * FROM articles WHERE id=$id\";
    $result = mysql_query($query);
    if (!$result) {
        Query_Error(__FILE__, __LINE__, $query, true);
    }

    if  ($result && $h = mysql_fetch_array($result))  {

        printf (\"<p>%s written by <a href=\\"mailto:%s\\">%s</a></p>\n\", $h[title], $h[email], $h[author]);
        printf (\"%s\n\", $h[\"article\"]);

    }

}

else  {

    // Show a list of all contacts with hyperlinks to their full stats page

    echo \"<p>Please select an article that you wish to view.</p>\";

    // Start of the list
    
    $query = \"SELECT * FROM articles ORDER BY article DESC\";
    $result = mysql_query($query);
    if (!$result) {
        Query_Error(__FILE__, __LINE__, $query, true);
    }

    while($result && $h = mysql_fetch_array($result)) {

        printf (\"<a href=\\"%s?id=%s\\">%s</a>\n\", $PHP_SELF, $h[id], $h[article]);
        echo \"<br>\";

    }

}

include(\"footer.inc\");
?>

This will print better errors. The errors will be printed in comment tags, so that your page isn't litered with error messages. If you don't want the error messages in comments, set the TRUE to FALSE in the Query_Error() function.

As far as DB connection, double check that your host/user/pass are correct and your db name. Case sensitve!