Re: [PHP-WIN] Help with mysql rowpointer

2001-08-22 Thread Angie Tollerson
Lars, I'm not quite sure I understand why mysql_num_rows($result) would not work for you. You said that function would only tell you how many records that came from your query, but aren't the records that came from your query the only ones you want to count? So if you get 4 records from your q

Re: [PHP-WIN] Help with mysql rowpointer

2001-08-22 Thread Mike Flynn
To return the total amount of records in a table, just do: $query = 'SELECT COUNT(*) FROM tblName'; $result = mysql_query($query); $total_records = mysql_result($result, 0); Or, for short, $total_records = mysql_result(mysql_query($query), 0); To step through the records, just do a normal SELECT