Variable Problem

[PhreakShow]

Alright I'm making a private message thing for my site and everything works but now I need to make a way for users to delete the messages. I need the message ID to go to the next page where the delete code is but my message ID is in an array because I used mysql_fetch_array. How do I make one piece of the array become a variable like $id = $stuff['2']; That right there isnt working...

[cgraz]

I'm guessing you display a delete link for each message?

// sample query
$query = mysql_query("SELECT * from messages WHERE user='$user'");

while ($a_row=mysql_fetch_array($query)) {

   echo "Subject: " . $a_row["subject"];
   echo " " . "Time Received: " . $a_row["time"];
   echo " " . "<a href=delete.php?id=" . $a_row["id"]  . ">Delete</a><br>";
}

When they click delete, the message id is passed over to the page delete.php, where you use a query such as

$id = $_GET['id'];
DELETE from messages WHERE id='$id'

Cgraz

[dustbuster]

Originally posted by PhreakShow
How do I make one piece of the array become a variable like $id = $stuff['2']; That right there isnt working...

I just thought I'd mention that putting '2' in $id = $stuff['2'] probably won't give you anything unless you have a column in your table named 2. If you want to get the data out into your variable:

$id=$stuff[2];//will return the 3rd item in your array.
$id=$stuff['id'];//will return the data for 'id'

D.