Steve Edberg wrote:
As far as displaying only the first row, that's because you're only
fetching the first row; count($row) in your for loop will always
evaluate to 0 (if there are no results) or 1. You need to move the
mysql_fetch_row() call into your loop; something like
$result = mysql_query($sql);
while ($row = mysql_fetch_row($result)) {
var_dump($row);
...
}
or you could do
$result = mysql_query($sql);
$count = mysql_num_rows($result);
for ($i=0; $i<$count; $i++) {
var_dump($row);
...
}
Noted, thank you. I'll play with these too, to see what I think of them.
As far as displaying the results twice, I'm not sure; that resembles the
behavior of mysql_fetch_array() -
The script had ~fetch_array() initially, I couldn't get it to work as
expected so I changed it to ~fetch_row(). Now it's back to ~fetch_array()
Both as a learning exercise and as an end-goal, I'm rewriting some
code so that it does what I want it to, not what it imperfectly does
according to the original programmers intent. That original intent
bears only passing resemblance to what was requested of that programmer,
it's become a sore subject.
http://us.php.net/manual/en/function.mysql-fetch-array.php
- where the default is to return data as both an associative and
numerically-indexed array.
That explains some things. And I have some reading and experimenting
to do before I move on to the next step in the script.
I'm guessing that the above code isn't an
exact cut-and-paste, as using single quotes (eg, mysql_pconnect('$host',
'$login', '$passwd') does not interpolate variables, so that line will
not work unless your username is actually '$login', etc. Which it
probably isn't.
Correct. That was my attempt to obfuscate some of my real data, the
username and password especially. See my other post on this.
Ulex
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php