I am working with a User mysql database. I need to display the contents of a column and then put a username into a url with profile.php. The profile works when its just sent a dummy url but with this code, the row variable has just blank entries.
mysql_select_db("Users") or die;
$query = "SELECT Username FROM Profile";
$result = mysql_query($query) or die('error making query');
$row = mysql_fetch_array ($result);
$numrow = mysql_num_rows($result);
echo " User List <br>";
for ($x = 0; $x < $numrow; $x++)
{
$temp = $row[x];
$temp = urlencode($temp);
$y=$x+1;
echo "$y.";
echo "<A HREF=\"http://www.isitcontagious.com/David/profile.php?$temp\">$row[x]</A> /n";
}
