[RESOLVED] Mysql multiple rows and separate using php

This site is best viewed in a modern browser with JavaScript enabled.

[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