vb.org Archive - Need help populating a table

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Need help populating a table (https://vborg.vbsupport.ru/showthread.php?t=50589)

leviw

03-21-2003 06:25 PM

Need help populating a table

I'd like to make a table populated from a database query.

I'd like the table to be about 5 collums wide, and as many rows as it takes. The problem is, I dont know how to do it.

Right now I run the query and have a foreach() statement set up, which of course produces one result per run. I assume I need to do an if($i=0; $i >=4; $i++) statement to limit the width of the table, but I'm having trouble getting the syntax right.

Any suggestions would be fantastic, I'm obviously new to php but know there must be an easy way to do this. Its difficult to ask for what you want when you dont know what its called. :cross-eyed:

Thanks in advance.

Overgrow

03-23-2003 12:46 PM

You need to know how many columns in your table before you attempt to make it. Then print the first opening lines of your table out before you start to loop through the results.

PHP Code:


		
			
echo "<table><tr><td> col 1 </td><td> col 2 </td><td> col 3 </td><td> col 4 </td></tr>";



while ($row = mysql_fetch_array ($dbresults) ) {



 echo "<tr><td> data </td><td> data  </td><td> data  </td><td> data  </td></tr>";



} // close while



echo "</table>";

leviw

03-23-2003 04:05 PM

Thanks for the help, I ended up going with this:

Code:

<table openers above>

$i = 0;

while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {

        if ($i >= 5) {

                print "</tr><tr>";

                $i = 0;

        }

        printf ("<td><img src=%s><br>%s</td>", $line['filename'],$line['filename']);

        $i = $i + 1;

}

<table closers below>

All times are GMT. The time now is 07:20 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01364 seconds Memory Usage 1,715KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: