store value of sql in variable

[tazgalsinh]

I have this sql script

		$ownername = @mysql_query("SELECT name FROM members WHERE username = '$user'");

	while($row=mysql_fetch_array($ownername)) {
				echo "<table>";
	            echo "<tr>";
		        echo "<td>" . (htmlspecialchars($row['name'])) ."</td>\n";
				echo "</tr>";
				echo "</table>";
				}

It will only ever turn up one name.How can i store this name in a variable for use in another part of the page?

thanks.

[laserlight]

As your thread topic title hints, store the name in a variable:

$result = mysql_query("SELECT name FROM members WHERE username = '$user' LIMIT 1");
$ownername = mysql_result($result, 0);

echo "<table>";
echo "<tr>";
echo "<td>" . htmlspecialchars($ownername) ."</td>\n";
echo "</tr>";
echo "</table>";