Looping through records(PHP, MYSQL)...

[enrmpaga]

In ASP i'd do something like:

do while rsResults.EOF
looped content...
rsResults.NextResult
Loop

 

What is the equivalent in php?

 

I could do a forloop and pre-define the number of results to bring out but i want something more dynamic.

 

 

 

[trq]

while ($row = mysql_fetch_assoc($result)) {
  // display data
}

[trq]

ps: your vbscript is invalid also.

 

while not rsResults.EOF
  looped content...
  rsResults.Next
Loop

 

[enrmpaga]

humm its not going to the next result...

[enrmpaga]

ah got it just used a do while loop with a counter to pull the next results out...

[wildteen88]

Thorpe's code should work fine? Sounds like you're using the mysql_result function.

[enrmpaga]

correct...

[wildteen88]

Using mysql_result is a very long winded way of getting results (IMO). By using Thorpe's code you can do away with mysql_result and just use the $row array to access your results.

 

$query = 'SELECT * FROM table';
$result = mysql_query($query);

while ($row = mysql_fetch_assoc($result))
{
    // display contents of the $row array
    echo '<pre>' . print_r($row, true) . '</pre>';
}

To access a field from the row you'd use $row['field_name_here'] allows for much cleaner code.