Method to echo mysql result

[Walle]

What is the most optimized/best/fastest method to echo out mysql result? Let’s say if you want display an huge list with 200 , 300 or more rows from single column.

I know table but perhaps not best method to use? Is perhaps echo 200 , 300 using DIVs or UL li more common way to do this?

[dagon]

while i dont know what the data is, or what it is used for, i would probably put it in a tabl with some nice js to make it sortable and add pagination. you generally don't want one page of 300 rows.

To get a better answer you probably want to describe what the data is and what it is to be used for.

[Walle]

Data could be list of title, links, forum topics etc. I agree that 300 rows/page is probably not good but only example on huge list. On my localhost and test database i only have 10 rows and cant proper test optimization with different method.

Echo out 200, 300 table td is no problem than? Or is UL perhaps faster and better to use?

[dagon]

no 300 rows is nothing the db will spit them out in a small fraction of a second, to test, just add some test data to the db

[Walle]

I think i maybe was entirely on wrong way, using table seems only solution anyway I think. Maybe both table and UL like below but that seems to complicated. (And probably not more optimized than using only table rows)

<table>
	<tr>
		<td>Column1</td>
		<td>Column2</td>
		<td>Column3</td>
	</tr>
	<tr>
		<td>UL list </td>
		<td>UL list</td>
		<td>UL list</td>
	</tr>
</table>

I don't know... Anyway thanks, i guess i continues using table.

[RiceBurner]

I have a little function built up that I use for reviewing arrays :

function disp($a,$t=null) {
  static $x = 0;
  $i = '_'.$x;
  $x++;
  $o = null;
  $t = "[".$t."]"." => ";
  if(is_array($a)) { 
    $c = ' hidden';
    $t .= "ARRAY ";
    $o .= "(\n";
    foreach($a as $k=>$v) { $o .= disp($v,$k);  }
    $o .= tag('br').")";
  }
  else { $o .= $a;$c = ' shown'; }
  return tag('span',array('class'=>'k','onclick'=>"showItem('".$i."');"),$t).tag('span',array('id'=>$i,'class'=>'v'.$c),$o)."\n";
}

function ts($a,$t=null) { 
  global $ts;
  $x = tag('pre',null,disp($a,$t));
  $ts .= $x;
  return $x;
}

calling the ts(ARRAY,COMMENT) function at any time (with appropriate entries) adds the output to the generic $ts string. I can also echo each instance of ts() if necessary.

(the tag() function simply creates HTML tags: tag(TAGNAME,ATTRIBUTES,CONTENT).

Then I can echo the $ts variable at the end of my HTML output (prior to </body>).
The css & HTML necessary are:

a.trouble,
a.trouble:link, 
a.trouble:visited { clear:both; float:left; color:#f00; }
pre { clear:both; float:left;font-size:1.2em; font-family:Comic Sans MS,sans-serif; color:#fff;background:#000;}
div#troubleshooting.shown { display:block; }
div#troubleshooting.hidden { display:none; }
div#troubleshooting span.k { clear:both; float:left; padding-left:10px;}
div#troubleshooting span.v { clear:none; float:left; padding-left:0px;}
div#troubleshooting span.shown { display:block; }
div#troubleshooting span.hidden { display:none; }

    

  $trouble .= tag('a',array('href'=>'javascript:void(null);,'onclick'=>"showItem('troubleshooting');",'class'=>'trouble'),'DEV');

$trouble .=  tag('div',array('id'=>'troubleshooting','class'=>'hidden'),$ts); 
echo $trouble

[BrightIdeas]

I actually use this quite a bit on the site I built for the company I work for. I use a table where I have the tr repeat for each of the database records that matches my query.

I assign my query to a variable, do a while loop running a mysql_fetch_array of that query variable. Within the while loop is where the tr's get repeated.

<?php
$var1 = mysql_query("SELECT * FROM table");

echo "<table>";

while ($var2 = mysql_fethc_array($var1)){
echo"
<tr>
  <td width=\"50%\">
     whatever you want listed in this.
  </td>
  <td width=\"50%\">
     don't forget to escape your quotes withing the echo statement
  </td>
</tr>
";
}
echo "</table>";

The section within the {} of the while statement will repeat for all records found in the query.

Downfall is that this will give you a long list in one table. But that's a totally different subject.