[SOLVED] Get from DB and put into an array

[papaface]

Hello,

Can someone tell me how I can do this.

I want to get the location from the database which i can do:

$getbanners = mysql_query("select location from banners where frequency='{$basis}'");

list($location) = mysql_fetch_array($getbanners);

 

There may be more than one record, therefore how can I put all the locations from the db into one array?

 

Thanks

[MadTechie]

your need to use a loop to add to an array

[papaface]

How do I do that?

[MadTechie]

just a basic loop

<?php
$MyArray = array();
for($n = 0; $n < $rows; $n++)
{
$mysql_fetch_assoc($n);
$MyArray[] = rows['TheData'];
}

?>

 

*untested

[papaface]

Yeah, well considering I asked for help could you explain how to implement that into my setup. Otherwise that doesnt really help me.

edit: You changed it.

 

 

<?php

$MyArray = array();

for($n = 0; $n < $rows; $n++)

{

$mysql_fetch_assoc($n);

$MyArray[] = rows['TheData'];

}

 

?>

But what you posted wont work.

[papaface]

I have put:

$getbanners = mysql_query("select location from banners where frequency='d'");

$rows =  mysql_fetch_assoc($getbanners);

echo $rows['location'];

 

But that only returns one location, when it should return 4. Why?

[MadTechie]

I am here to help not to write the whole thing for you, their are many sections

if you don't know how to use MySql with PHP you could of just asked

 

what i posted was an example (which i updated to as it included some OOP)

 

anyways good luck and good day

[papaface]

I have helped so much in this community I think I am aware of that as I have said the same to others.

However I am not asking for you to write a script I am asking for a very small piece of code!

What you have provided does not help me.

[papaface]

I have worked it out.