problems getting records from db

esthera

here's my code:

$sql="select catid,catname from categories";
print "sql:$sql";
$result = @($sql, $db);
print "<table cellpadding=5 border=1>\n";
while ($myrow = @mysql_fetch_row($result)) {
$ucatid = urlencode($myrow[1]);
$ucat = 'xx';//urlencode($myrow[2]);
print "<tr><td>$ucat</td><td><a href='$PHP_SELF?action=DelCat&category=$ucatid'>X</a></td></tr>\n";

}

print "</table><br>\n";

There is one record in the table when I run the query from php admin. Nothing is showing up when I display it here. The connection is opening okay.

Also when I run the following
$sql="insert into categories(catname) values('$category')";
@( $sql, $db ) or die( "Error : " . mysql_error() );
}
I get a blank screen with the word "Error:" on it.

What am I doing wrong?

Any ideas?

FMB

$result = @($sql);

$db should already be open I think.

laserlight

You're right to use mysql_error() at this point of development.

I would advise you to drop the error suppression operator (@) as well, and see if it makes a difference.

Ensure that error reporting is set to E_ALL.

esthera

If I remove the @ then I get the following error:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource

The following simple code is just not returning any results (and it should)

$sql="select catid,catname from categories";
$result = @($sql);
while ($myrow = mysql_fetch_row($result)) {
$ucatid = urlencode($myrow[0]);
$ucat = urlencode($myrow[1]);
print "category:$ucat";
}

laserlight

Double check your database server connection, your database selection and your SQL query (e.g. column names).

esthera

all is fine. The query runs from php admin and the database is open.

laserlight

Test with this as a separate PHP script:

<?php
mysql_connect(/* etc */)
	OR die('Error1: ' . mysql_error());
mysql_select_db(/* etc */)
	OR die('Error2: ' . mysql_error());
$sql = "SELECT `catid`,`catname` FROM `categories`";
$result = mysql_query($sql)
	OR die('Error3: ' . mysql_error());
while ($myrow = mysql_fetch_row($result)) {
	$ucatid = urlencode($myrow[0]);
	$ucat = urlencode($myrow[1]);
	echo "category:$ucat";
}
?>

esthera

as a separate file it worked. Any idea what could cause this?

laserlight

Well, chances are there is something wrong with the database connection/selection in the actual script.

esthera

i copied the connection straight to the test file