[RESOLVED] organzing a table

[blckspder]

hello,

I am trying to pull data from my database and organize it in a table with 2 columns with 4 rows:

Ive got the rows and columns to work correctly but only the first 2 records from the table are populating from the database and not all eight how can I remedy this?? here is my php code thanks!

					<?php
					for($row=1;$row<5;$row++) {
						print '<tr>';
					for($i=1;$i<3;$i++) {
						$recsites = "SELECT * FROM rectable WHERE rec_num='$i'";

					$pullrecvar = mysql_query($recsites);
						while($recrow  = mysql_fetch_array($pullrecvar)) {
						$column = $recrow['reclink'] % 2;
						if($column != 0) {								
							print '<td><a href=' . $recrow['reclink'] . '>' . $recrow['recname'] .'</a></td>';
								}

							if($column == 0) {								
							print '<td><a href=' . $recrow['reclink'] . '>' . $recrow['recname'] .'</a></td>';
								}
						}
					}
					print '</tr>';
					}

				?>

[jheitz]

There seems to be a problem with the logic in your code:

First: Database tables will have a number of rows that normally increase over time. You don't want to hardcode in your PHP code that you want to extract 8 rows.

Second: Your second FOR statement will allways extract records number 1 and 2 from the database. Since it is nested within another for loop, this will happen 4 times, but always the same records will be extracted.

Third: You are running multiple SELECT statements to the database: not ideal.

The best thing would be to have a SELECT statement that brought over all the records that you need. And then use a WHILE loop to go over the records and represent them as you want.

Hope this helps

[blckspder]

Hello,
Thanks for the quick reply..
I should have been more clear sorry for that.. i do only want 8 rows this will be a table where the person can update and change links to other websites basically vendors for guitar products

you can see what Im talking about here :http://sousaink.com/brendel2/
the middle table is the one Im trying to populate... so I need to do something with that inner for loop... I tried to use a while statemet straight up and it would populate the same record in both columns before moving on to the next row.

Hope this explains things better thanks for the help