row counter

[mdell]

I am new to PHP and programing. I am trying to add an auto row counter for when something is added to the table. The table is set up for an auto_increment function. I keep getting back '1 is not a MYSQL row index'. I do know that there is more than one item there!
This is what I have and multiple variations of it...

if (!($listnumrows = mysql_num_rows($link))) {
printf("<BR>error in mysql_num_rows, error %s <BR>", mysql_error($link));
}
while ($listnumrows <0 ($link)) {
printf("There are %s listings in the database", mysql_num_rows ($tableName, $databaseName, $link));
}
What ot do...?
Thanks for any help.

[Anon]

Well I am not the best at PHP but why dont you just set it to view the info on the last record, if your tables have it so they have id\\'s then the last id will be the number of rows you have too? am I right if not sorry just trying to help

Matt

[brandonschnell]

your code makes no sense.

if ( mysql_num_rows() equals 0 )
{
then error in mysql_num_rows
}

while ( mysql_row_rows() less than 0 ) #how can you have -1 rows?
{
there are x listings in the database
}

make things simple (and fast). to speed up the following, have it count the column that is set as auto_increment and not all columns (*).

<?
$query = "SELECT COUNT(*) FROM $tableName";
$query_results = mysql_db_query("$databaseName",$query);
$row = mysql_fetch_array($query_results);
$total_rows = $row[0];

echo "There are $total_rows listings in the database";
?>

[mdell]

I certainly like your idea, it seems easier. BUT I am getting back the same error "0 is not a MYSQL result index"
What do you think is going on?

[brandonschnell]

call the function mysql_error() after every line and tell us what line the first error occurs on.

http://www.php.net/manual/en/function.mysql-error.php

[kparker]

Your problem is before the code you show us. Your sql query itself is failing. Display the results of mysql_error() immediately after your call to mysql_query().