se;ecting all rows...

[mo0ness]

Hey, I was just wondering if any1 knew of an "easier" way 2 select table columns from a database?

Instead of doing each columne at a time like:

$query = "SELECT * FROM $table";

$result = mysql_db_query($dbname, $query);

while ($row = mysql_db_query($result))
{

$col1 = "$row[Col1]";
$col2 = "$row[Col2]";

}

etc, i cud have ALOT of column names 2 fetch. Is there a way it selects ALL columne names, and makes each columne name apart of the $row[]; array automatically?

Thanks for any help!

[cool-palace-ceo]

you could go like this:

$get = mysql_query("SELECT * FROM $table");


$info = mysql_fetch_assoc($get);

$row1 = $info["row1"];
$row2 = $info["row2"];

and if you want to display all the records you do that in a for loop

$get = mysql_query("SELECT * FROM $table");

for($i = 0; $i < mysql_num_rows($get); $i++) {

$info = mysql_fetch_assoc($get);

$row1 = $info["row1"];
$row2 = $info["row2"];

echo "$row1 : $row2";

}

make sure the $info and stuff is INSIDE the for loop!

[mo0ness]

Thanx for ur reply..but doesnt that do just the same? :/
I want 2 do it so I dont have 2 assign each variables 2 each array retreived...which wud be ALL of the column names.

So say, while ($row = mysql_fetch_array($result)) done that, inside the loop i wud just do print "$row[Col35]"; or whatever without having 2 assign a variable 2 it and retreieve all the rows at once. For example, say I had 40 columne names in a table, instead of assignin variables to each array retireved like $row[Col1], $row[Col2], all the way up 2 $row[Col40] - it wud take ages. Its hard 2 explain :\