Fastest way to retrieve results from db
Posted: Wed Aug 09, 2006 11:43 am
Ok so I often code things in such a manner:
That allows me not to have to reference the columns directly. I could have said
What is the fastest and most effective way to retrieve the results?
Code: Select all
dbconnect string
blah blah
while ($row = mssql_fetch_assoc($result3)){
foreach ($row as $col2=>$val2){
do some stuff
}
}Code: Select all
while ($row = mssql_fetch_assoc($result3)){
$val=$row['fieldname here'];
}What is the fastest and most effective way to retrieve the results?