php linking problem from sql

aznjay

<?
session_start();

$link = mysql_connect('localhost','chaotici_error', 'password')
    or die("Could not connect");
mysql_select_db('chaotici_error')
    or die("Could not select database");

$result = MYSQL_QUERY("SELECT username FROM users WHERE username='$username'") or die ("Username not matched");
$worked = mysql_fetch_array($result); 
$user = $worked[username];
$html = $_POST['edithtml'];
$my_quadrant = $_SESSION['edithtml'];


$update ="UPDATE users SET html='$html' WHERE username='$my_quadrant' LIMIT 1";
mysql_query($update) or die ("Could not add data to the table");



$query = "SELECT html from users WHERE username='$my_quadrant'";  

$show = mysql_query($query);  

while ($row=mysql_fetch_array($show)) 
{ 
  echo "$row[code=html]";  

}

?>
<a href="http://www.chaoticillusions.com/community/spoono/edithp.php?user=<?php echo $my_quadrant ?>&html"> link </a>

?>

Hey, can anyone help me link how to link the data. This is what i mean, <a href="http://www.chaoticillusions.com/community/spoono/edithp.php?user=<?php echo $my_quadrant ?>&html"> link </a> this link is suppose to show the html codes from another user, but it won't show the data. Can any please help me ??

davieboy

try

<? 
session_start(); 

$link = mysql_connect('localhost','chaotici_error', 'password') 
    or die("Could not connect"); 
mysql_select_db('chaotici_error') 
    or die("Could not select database"); 

$result = MYSQL_QUERY("SELECT username FROM users WHERE username='$username'") or die ("Username not matched"); 
$worked = mysql_fetch_array($result);  

$user = $worked[username]; 
$html = $_POST['edithtml']; 
$my_quadrant = $_SESSION['edithtml']; 


$update ="UPDATE users SET html='$html' WHERE username='$my_quadrant' LIMIT 1"; 
mysql_query($update) or die ("Could not add data to the table"); 



$query = "SELECT html from users WHERE username='$my_quadrant'";   

$show = mysql_query($query);   

while ($row=mysql_fetch_array($show))  

{  

  echo "$row[code=html]";   

} 
echo "<a href=\"http://www.chaoticillusions.com/community/spoono/edithp.php?user=$my_quadrant &html\">link</a> 

?>

aznjay

hey that didn't work. I will try some other scripts okay.😃