PHP - Mysql-link As Instance Variable

I've been looking everywhere for a solution of this but I can't find one...   Basically what I did was created a class named USER.

public class USER{

private static $USER = array();

 public function __construct($U='')
 {
   // if $U is not entered (=='') then set $U to MY USER ID ($_COOKIE['user'])
   // do a mysql query by the ID (ala $U) and store the results to self::$USER
 }

 public function ID()
 {
   return self::$USER['id'];
 }

}

This is the code I am running...   I do a user profile page that shows different properties of the USER from the database: USERNAME(),ID(),PHONE(),EMAIL(), etc. etc.

// creates an instance of a different user (other than myself) 

$PROFILE = new USER($ID);  // $ID: 26 will retrieve USERNAME: Test

// create an instance of user class for myself using the cookie holding my id

$ME = new USER($_COOKIE['user']) // $_COOKIE['user']: 01 will retrieve USERNAME: Monster


echo($PROFILE->USERNAME()); // displays Monster
echo($PROFILE->ID()); // displays 01

Any idea what I am doing wrong?  I would assume that $PROFILE->USERNAME() would display Test and $ME->USERNAME() would show monster.  

I am trying to allow the user to update a variable he chooses by radio buttons, which they will then input text into a box, and submit, to change some attributes. I really need some help here.  It works just fine until I add the second layer of variables on top of it, and I can't find the answer to this question anywhere.

<?PHP require('connect.php'); ?>

<form action ='' method='post'> <select name="id">

<?php
$extract = mysql_query("SELECT * FROM cars");
   
   while($row=mysql_fetch_assoc($extract)){
   $id = $row['id'];
   $make= $row['make'];
   $model= $row['model'];
   $year= $row['year'];
   $color= $row['color'];

echo "<option value=$id>$color $year $make $model</option>
";}?>

</select>

Which attribute would you like to change?<br />
<input type="radio" name="getchanged" value="make"/>Make<br />
<input type="radio" name="getchanged" value="model"/>Model<br />
<input type="radio" name="getchanged" value="year" />Year<br />
<input type="radio" name="getchanged" value="color"   />Color<br /><br />

   <br /><input type='text' value='' name='tochange'>
   <input type='submit' value='Change' name='submit'>

</form>

//This is where I need help...

<?PHP
if(isset($_POST['submit'])&&($_POST['tochange'])){
mysql_query("
   UPDATE cars
   SET '$_POST[getchanged]'='$_POST[tochange]'
   where id = '$_POST[id]'
         ");}?>

Hello. I have a bit of a problem. When I fetch the link field from the database.i don't see an actual link on the page.  One more thing, what type of field should I use to store the link in the database? Probably there is where I went wrong. All help is 

Hy,

How can I put a link to a variable without doing like:
Code: [Select]
<a href='#'>$var</a>
I heard that can be other ways.

Thanks

ive done a page that works fine but id like to add links to the results so i can view the models.
working page here http://sts.hostei.com/dsgi/list_records.php
in the make column i want a link that will only show the make clicked.

if this was a fixed page i no how to do it but i cannot figure out to make it from the way ive discribed.

i know i have to alter this line
<td><div align="center"><?php echo $rows['make']; php?></div></td>
but no idea how to do this.
do i create a new page for the query? if so how do i pass the $var?
is it possable to do this from the same page? ie appear undr the main table.

Thanks

<?php
include("config.php"); 

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

$sql = "SELECT make, COUNT(*) AS total, SUM(IF(comments = \'pass\', 1, 0)) AS withComments FROM dsgi_serval GROUP BY make ORDER BY COUNT(*) DESC"; 
$result=mysql_query($sql);
php?>

<table width="319" border="1"><tr>
      <td colspan="4"><font size="4" face="Verdana">
         <strong><div align="center">Validation Total's </div></strong></font> </td>
   </tr>
    <tr>
       <td width="137" align="center"><strong>Make</strong></td>
       <td width="85" align="center"><strong>Total</strong></td>
       <td width="75" align="center"><strong>Validated</strong></td>
    </tr>
<?php
while($rows=mysql_fetch_array($result)){
php?>
    <tr>
        <td><div align="center"><?php echo $rows['make']; php?></div></td>
        <td><div align="center"><?php echo $rows['total']; php?></div></td>
        <td><div align="center"><?php echo $rows['withComments']; php?></div></td>
     </tr>
<?php
}
php?>
     <tr>

         <td><div align="center">Totals</div></td>
         <td> <div align="center">
         
           <?php
// counts all rows
           $query = "SELECT make, COUNT(make) FROM dsgi_serval "; 
           $result1 = mysql_query($query) or die(mysql_error());

           // Print out result
           while($row1 = mysql_fetch_array($result1)){
           echo $row1['COUNT(make)'];
}
?>
        </div></td>
        <td><div align="center">
       
<?php
 
 // counts passes
           $query = "SELECT make, COUNT(make) FROM dsgi_serval where comments like 'pass'"; 
           $result2 = mysql_query($query) or die(mysql_error());
           while($row2 = mysql_fetch_array($result2)){
           echo $row2['COUNT(make)'];

}
?>
       </div></td>
      </tr>
</table>



<?php
mysql_close();
php?>