PHP not displaying records from database, no error given

[ramonred]

Hi,

 

I am having trouble with a php script that I've used successfully before. I know it is getting as far as connecting to the database, but it won't display any records.

 

Here is the code:

 

^{<?php connectDB();}

 

^{if (isset($reg))}

^{

^{displayItems($reg);}

^}

^else

^{

  ^{//do nothing}

    ^}

^{function connectDB() {}

^{$dbcnx = @mysql_connect("localhost", "redfrogp_misa", "********");}

  ^{if (!$dbcnx) {}

      ^{echo( "<P>Unable to connect to the " .}

            ^{"database server at this time.</P>" );}

      ^exit();

  ^}

 

    ^{// Select the contacts database}

  ^{if (! @mysql_select_db("redfrogp_misa") ) {}

      ^{echo( "<P>Unable to locate the" .}

            ^{"database at this time.</P>" );}

      ^exit();

  ^}

^{return true;}

^}

^{function displayItems($r) {}

 

    ^{$result = mysql_query("select * from items");}

 

    ^{if (!$result) {}

      ^{echo("<P>Error performing query: " .}

          ^{mysql_error() . "</P>");}

      ^exit();

    ^}

 

 

    ^{while ( $row = mysql_fetch_array($result) ) {}

 

^{$row["desc"];}

 

    ^}

^}

^?>

 

I've checked my bracketing very carefully. I don't see what the issue is, any help would be appreciated. Thanks.

[Gamic]

You are using the symbol '@' in front of mysql function calls which suppresses warnings. I'd suggest running the code again without that.

[bobinindia]

This may seem stupid but is 'desc' a column name in your table?

Just in case!!

$row["desc"];

[Barand]

echo $row['desc'];

 

 

DESC is a mySQL reserved word, so don't use as a column name. Change to something else.