Hey is there a better way?

Vbabiy

$results = mysql_query("SELECT * FROM rsc") or die(mysql_error());
$rows = mysql_fetch_row($results);
$total_rows = mysql_num_rows($results);
$total_cols = count($rows);


$i = 0;
while ($i <$total_cols) {
echo $rows[$i];	

$i++;
}
while($rows = mysql_fetch_row($results)) {
		$i = 0;
		while($i < $total_cols) {
		echo $rows[$i];
		echo "<br>";
		$i++;
		}
}

Is there any way to do it all in one while statment

drew010

if you know the names of all the rows you can do it like this:

$results = mysql_query("SELECT * FROM rsc") or die(mysql_error());

while($data = mysql_fetch_array($results)) {
  echo $data['rowname'] . ' - ' . $data['anotherrowname'] . ' - ' . $data['another'] . '<br />';
}

Vbabiy

so i could build a array with all the rows and echo it that way right?

but with if the rows will get added what would be the best apporch i just trying to print all the data from a db to a table.

Vbabiy

Well here is my goal:

I want to take a MYSQL db and print it to an html table. But I also need to place check box input in each row.

So if any one has any idea please let me know.

Well now to think about if any one has an idea on how I would set up the naming of the check box to be dynamic and detect which on is on. But most important is the first part

Thank,
Guys and Gals