HELP newbie

[Anon]

APP: simple shopping cart
ERROR: Warning: Supplied argument is not a valid MySQL result resource in index.php on line 46

$result=mysql("$DBName","SELECT * FROM Category ORDER BY Category");
fontFace("Arial","Select a category:<br><br>");
echo "<ul>";
/// line 46/// while ($row = mysql_fetch_row($result)) {
$Cat=$row[0];
$CatID=$row[1];
fontFace("Arial","<li><a href='$Relative/items.php?CA=$CatID&UID=$UID'>$Cat</a></li>");
}
echo "</ul>";

[Anon]

First, before this line:

$result=mysql("$DBName","SELECT * FROM Category ORDER BY Category");

Make sure you do a mysql_connect(hostname, username, password); .

Second, the function you should be using on that line is mysql_db_query(database_name, query). Also, after the query, try using echo mysql_error() .. this will help you debug your database applications. Hope that helps!

Chris King