$query = "SELECT * FROM FWnews";
$result = mysql_query($query);
$count = 0;

while($row1 = mysql_fetch_array($result,MYSQL_ASSOC))
{
$counter = $count++;
$newstitle.$counter = $row1[newstitle];
}

echo $newstitle1;

The idea i want is to be able to select the first, second and third records from the table 'FWnews' and enter the values in separate variables???

There is a field 'newsID' which increments by one every time a new record is created

The code is the way i was thinking, but it dont work, is there another way??

cheers
Ash;)

My new web design domain
www.askmultimedia.co.uk

__________________
My new web design domain
www.askmultimedia.co.uk

Use Arrays like $newtitle[]= ..

http://www.mediasworks.com/tutorial/