for loop

[sebastienp]

$requete = "SELECT * FROM Content";
$result = mysql_query ($requete,$db);
$seb = mysql_fetch_object($result);

for($i=0; $i < mysql_num_rows($result); $i++)
{
	print($seb->text);

}

how come this will only print the 1st value in my feild text?
how could i make it so it prints it all

[laserlight]

$requete = "SELECT * FROM Content";
$result = mysql_query ($requete,$db);
$num_rows = mysql_num_rows($result);

for ($i = 0; $i < $num_rows; $i++)
{
	$seb = mysql_fetch_object($result);
	echo $seb->text;
}

Basically, mysql_fetch_object() would take the current row.
Since you only call it once, it only takes the first row.
Think about it, just running a loop that only does output shouldnt magically change the contents of a variable.
Hence you have to assign to $seb to change it.

Conversely,

$requete = "SELECT * FROM Content";
$result = mysql_query ($requete,$db);

while ($seb = mysql_fetch_object($result)
{
	echo $seb->text;
}