Jump to content


Photo

Need to seperate values from query result into variables


  • Please log in to reply
1 reply to this topic

#1 kshet26

kshet26
  • Members
  • Pip
  • Newbie
  • 3 posts

Posted 08 June 2006 - 09:09 PM

I need to seperate the values contained in a query result into seperate variables. How would I go about doing this?

This is my query:

$result = mysql_query("SELECT DISTINCT Bug.ixBug, Bug.sTitle, Person.sFullName, Area.sArea, Bug.dtOpened, Bug.ixPriority, Bug.ixPersonAssignedTo FROM `Bug`, BugEvent, Person, Area WHERE Area.ixArea = Bug.ixArea AND Person.ixPerson=Bug.ixPersonAssignedTo AND Bug.ixBug =BugEvent.ixBug AND Bug.ixStatus=1 AND Bug.fOpen=1 AND Bug.ixPriority =1 AND (Bug.ixProject = 2 OR Bug.ixProject = 4)") or die(mysql_error());

I need to get the 7 values from each row of this query and seperate it into individual variables. I though about using a foreach() statement, but I could figure out how to do the value separation. I need them in seperate varibles so I output them to a file in specific places.

#2 poirot

poirot
  • Members
  • PipPipPip
  • Advanced Member
  • 646 posts
  • LocationAustin, TX

Posted 08 June 2006 - 09:21 PM

What do you need? When you use mysql_fetch_* it will return you an array with the results, and they're organized enough for me.

[a href=\"http://www.php.net/mysql_fetch_assoc\" target=\"_blank\"]http://www.php.net/mysql_fetch_assoc[/a]
[a href=\"http://www.php.net/mysql_fetch_row\" target=\"_blank\"]http://www.php.net/mysql_fetch_row[/a]
[a href=\"http://www.php.net/mysql_fetch_array\" target=\"_blank\"]http://www.php.net/mysql_fetch_array[/a]

like:

while ($row = mysql_fetch_assoc($result)) {
   $ixbug = $row['ixBug'];
   $area = $row['sArea]'
}

~ D Kuang




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users