Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Number of row wrong
- Thread starter TTA23
- Start date
- Thread starter
- #3
For ex. I have a table with 120 name. I have a query that retrieve all the names(120).
I have a While ... statement that shows the name in the browser.
Each time if I use the statement mysql_num_rows($result), it will show that I have 120 names, but I only print 119 in the browser.
Cannot figure why I always miss one name.
I have a While ... statement that shows the name in the browser.
Each time if I use the statement mysql_num_rows($result), it will show that I have 120 names, but I only print 119 in the browser.
Cannot figure why I always miss one name.
ok. try this
Code:
$tablename = ''; //fill in the table name
$sql = "SELECT *, SQL_CALC_FOUND_ROWS from $tablename";
$result = mysql_query($sql) or die(mysql_error());
$php_num_rows = mysql_num_rows($result);
//iterate the rows
$counter = 0;
echo "<table border=\"1\">"
while ($row=mysql_fetch_assoc($result)){
$counter++;
echo "<tr>";
foreach($row as $col){
echo "<td>$col</td>";
}
echo "</tr>";
}
echo "</table>";
//retrieve SQL calculation
$result = mysql_query("select found_rows");
$sqlNumRows = myqsl_result($result ,0,0);
echo <<<HTML
PHP coded solution reports $php_num_rows rows<br/>
Number of outputted rows were $counter <br/>
Mysql reports that it found $sqlNumRows rows
HTML;- Thread starter
- #5
- Status
Similar threads
- Locked
- Question
- Locked
- Question