Pulling just the first value from a while statement

[LetterAfterZ]

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

//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

[damian34]

$id = null;

while (...) {
if (is_null($id)) { $id = 123; }
}

do you need the other rows at all, ie; do you need a while loop?

[LetterAfterZ]

Ahh awesome. Thanks man!

Yeah it pulls out a whole buncha stuff and creates links and images too. But I just needed this first id variable for the default first page value thing