[RESOLVED] Mysql multiple rows and separate using php

[cjay175]

I am trying to find a way to pull multiple rows from a database and than be able to separate the rows and use them in php.

      $result = mysql_query("SELECT url, image, placement FROM advert
      WHERE user='1'") OR die(mysql_error());
      //This grabs 3 rows with placement name equal to 'sideadtop','sideadmiddle','sideadbottom'

      ($row = mysql_fetch_array($result, MYSQL_NUM));

      $keytop = array_search('sideadtop', $row);
      $sideadtop['url'] == $row[$keytop]['url'];
      $sideadtop['image'] == $row[$keytop]['image'];

      $keymiddle = array_search('sideadmiddle', $row);
      $sideadmiddle['url'] == $row[$keymiddle]['url'];
      $sideadmiddle['image'] == $row[$keymiddle]['image']; 

I am trying to get the url and image values for each ad placement value. Should I be using mysql to pull individual rows or use php to separate them if possible. Or is there a better way to do this?

Any help is appreciated

Thanks

[NogDog]

Not sure if this is what you are asking, but typically you create your SQL to retrieve all the desired rows, then use a while() loop to process each result row:

$sql = "SELECT blah blah blah...";
$result = mysql_query($sql);
while($row = mysql_fetch_assoc($result)) {
   // do stuff with $row to process/output this result row
} 

[cjay175]

hey thanks for the reply...

So if I did it with a while loop, would it be possible to get a specific variable.

For example say i want to get

$row['0']['url']
$row['1']['url']
$row['2']['url']

and use them within another function... I need to get speficic "url" field based on the placement field.

So if placement == "sideadtop" I would like to get the url that is in the row of that placement.

I would like to know if I have to do this with individual calls to MYSQL getting one row ata time or if there is a way to get all 3 rows and seperate them as needed?

Thanks again

[NogDog]

You can easily dump the results into an array (or object) for later use, e.g.:

$data = array();
while($row = mysql_fetch_assoc($result)) {
   $data[] = $row;
}
print_r($data); 

Or you could use one of the query column keys as the first array dimension key:

$data = array();
while($row = mysql_fetch_assoc($result)) {
   $data[$row['id']] = $row;
}
print_r($data); 

[cjay175]

Hey there,

thanks so much I never knew or thought you could use the column id.

$data[$row['id']] = $row; 

That worked awsome, i really appreciate it - cheers