I have some code that pulls out some details from a database, then loads it into an array as follows:

PHP Code:
//Load artwork information into the gallery array
                
$artworkset = @mysql_query(
                
"SELECT *, DATE_FORMAT(date, '%d/%m/%Y') AS ddmmyyyy FROM artwork limit $offset$limit");
                if (!
$artworkset) {
                    exit(
'Unable to load artwork from the database' mysql_error());
                }

while (
$artwork mysql_fetch_array($artworkset)) {
                
                
$id $artwork['id']; 
and so forth.

That's all fine, but I need to get JUST the first $id value into another variable for use with another component. Any idea how? Been stumpted on this for a while now, nothing I've tried has worked...

Thanks