mysql_Fetch_array(); Question

dr_pea

hi all

im trying to pull an array of data from mysql

this is the code im using.

//the sql syntax below pulls the last 7 records from the database

$sql 	=	"SELECT * FROM db_news ORDER BY 'id' DESC LIMIT 7";

$query	=	mysql_query($sql) or die('MYSQL QUERY ERROR' . mysql_error());

while($row = mysql_fetch_array($query))
{
echo $row['id'];
}

the code above outputs 'id's' 7 to 1 as 7654321

what i want to do is explode the 7654321 into an array so i can call them any where on the page. and not just while the while loop is running,

complicated ?

what im trying to do is grab the latest 7 news reports from mysql and then display them in certain places on a webpage

thanks for reading

thorpe

while($row = mysql_fetch_array($query))
{
  $arr[] = $row['id'];
}

Now you can use $arr[0], $arr[3] etc etc.... wherever you like.

dr_pea

thorpe wrote:
while($row = mysql_fetch_array($query))
{
  $arr[] = $row['id'];
}
Now you can use $arr[0], $arr[3] etc etc.... wherever you like.

Thanks very much thope, works like a treat, how does that bit of code work array into array ? saved in a while loop?

I was trying

$id = $row['id'];

but $id was only outputting inside the while loop and once the while had finished $id was outputting nada..

thanks again

hope to see you around.

thorpe

Everytime $arr[] = $row['id']; is called, it increments the array index and then stores the value of $row['id'] in the newly created index.

A simple way to see whats happening (just for example) would be...

while($row = mysql_fetch_array($query))
{
  $arr[] = $row['id'];
  print_r($arr);
}