Multiple echo with mysql_num_row?

[Mr_Mako]

Hi...

I need some help on how exactly to go about doing something.

Let's say I have the following variable:

$variable = "<font face=Arial size=2>Test</font>";

Now, I want to be able to display that variable as many times as I get a result from a mysql_num_row query.

So... lets say

// Create Query //
$sql = "SELECT * FROM table WHERE user_id = '1'";
$result = @mysql_query($sql, $connection) or die(mysql_error());

$num = mysql_num_rows($result);

and $num = "8".

So I'd want to somehow apply that "8" result to the "$variable" so that it displays on the page 8 times.

Is this possible?

[cgraz]

Yeah, use a for loop

// Create Query // 
$sql = "SELECT * FROM table WHERE user_id = '1'"; 
$result = @mysql_query($sql, $connection) or die(mysql_error()); 

$variable = "whatever<br>\n";

for($i=0; $i<mysql_num_rows($result); $i++) {
   echo $variable;
}

Cgraz

[laserlight]

Actually, you just need to extend your code.
cgraz's code should work, but is inefficient.

// Create Query //
// Create Query //
// Create Query //
$sql = "SELECT * FROM table WHERE user_id = '1'";
$result = @mysql_query($sql, $connection)
	or die(mysql_error());

$num = mysql_num_rows($result);

$variable = "<font face=Arial size=2>Test</font>";

for ($i = 0; $i < $num; $i++) {
	echo $variable;
}

P.S.: the use of the <font> tag is deprecated.
You might want to consider CSS instead.