displaying data

[Anon]

Hi All

This will probably seem pretty basic to many here...I am simply trying to display selected data from rows in MySql. Everything works fine until I try to display the data stored in mysql_fetch_array ($sql_result)

Error:

parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING'

Here's the code:

while ($row = mysql_fetch_array ($sql_result)) {

	$player_id = $row["player_id"];
	$player_pos = $row["player_pos"];
	$player_desc = $row["player_desc"];
	$player_price = $row["player_price"];

	echo "<TR><TD>$player_id</TD><TD>$player_pos</TD><TD>$player_desc</TD><TD align=right>$player_price</TD></TR>";

	}

[mdmann]

Here is how I code such things. This has
worked for me. I think the problem is that
you have to index into row[] with an integer:

$numfields = mysql_num_fields($sql_result);
while ($row = mysql_fetch_array ($sql_result))
{
for ($i=0; $i<$numfields; $i++)
{
$field = mysql_field_name($sql_result, $i);

      $temp = $row[$i];

      if ($field == "player_id") $player_id = $temp; 
                                                    else if ($field == "player_pos") $player_pos = $temp ; 
                                                    else if ($field == "player_desc") $player_desc = $temp; 
                                                    else if ($field == "player_price") $player_price = $temp; 

  }

}

echo "<TR><TD>$player_id</TD><TD>$player_pos</TD><TD>$player_desc</TD><TD align=right>$player_price</TD></TR>";

Michael

[reagent]

mysql_fetch_array fetches the results into an internal array that is indexed on both the row NUMBER and the row NAME, so his usage is correct.

I'm not sure what is causing the parse error, could you identify what line it is occurring on (if you have that information available)?

p.

[Anon]

Try this:

echo ("tags and $variables");

I have always used paren's around whatever I'm echo'ing.

Regards,
DLB

[mdmann]

Sorry, Darkhelmet. I didn't notice that you
had use the fetch_array call instead of the
fetch_row call. Guess I should read a bit
more carefully.

Michael