amount of results

[raffael3d]

I want to make that it sais "7 entries were found in the database".

I tried it this way, but it doesn't work.

		$result = mysql_query("select * from jobs");
		 /* Printing results in HTML */
    print "<table>\n";
    while ($line = mysql_num_rows($result, MYSQL_ASSOC)) {
        print "\t<tr>\n";
        foreach ($line as $col_value) {
            print "\t\t<td>$col_value</td>\n";
        }
        print "\t</tr>\n";
    }
    print "</table>\n";

[jeremuck]

look at the manual.

mysql_num_rows returns the number of rows.
You are trying to loop through an array.

Just
echo mysql_num_rows($result)
will do it.