var_dump() results

From: Date: Sun, 13 Jan 2008 17:32:37 +0000
Subject: var_dump() results
Groups: php.general 
Request: Send a blank email to php-general+get-267180@lists.php.net to get a copy of this message
It's pretty much the same. With var_dump(), values from the first row of the table are iterated twice, the script is not looping through and reporting all 2100 rows. Grossly similar behavior was observed with print_r() and echo: while different data was reported by each, the loop wouldn't loop. The first row was reported once (or twice) and that was the end of that. I've tried foreach() also, same-same. It doesn't loop, it just reports the first row. Here's my code: <?php //connect to db $link = mysql_pconnect('$host', '$login', '$passwd'); if (!$link) {
    die('Unable to connect : ' . mysql_error());
} // make $table the current db $db_selected = mysql_select_db('$table', $link); if (!$db_selected) {
    die ('Unable to select $table : ' . mysql_error());
} //get column data
	$sql    = "SELECT column2, column3 FROM $table";
$result = mysql_query($sql); $row = mysql_fetch_row($result); //loop through to display results for($i=0; $i < count($row); $i++){ var_dump($row); echo "<br /><br />"; ?> Ulex

« previous php.general (#267180) next »