Best way to extract php variables

[Jibninjas]

I am trying to figure out the best way to pull define variables from a mysql database, and it just seems like there is a simpler way that I am not thinking of. I have a db of like 5 columns and 15 rows. For each row I need to define a variable for each column, but has to be defined individually so a while statement will not work. This is what I am thinking

$row = db_fetch_array(db_query(SELECT * FROM poker_sites WHERE site_name='pokerstars'));

if (extract($row)) {

 //define variables

} 

Then I would just repeat that process for each row. That just seems like a lot and that there should be an easier way. Any thoughts would be great.

[Mike]

mysql_fetch_row, if you are trying to do it individually

PHP: mysql_fetch_row - Manual

EDIT: Are you using MySql? Or is this drupal?

db_fetch_object | Drupal API

[Jibninjas]

mysql_fetch_row, if you are trying to do it individually

PHP: mysql_fetch_row - Manual

EDIT: Are you using MySql? Or is this drupal?

db_fetch_object | Drupal API

This is drupal.

How is using the db_fetch_object() really different the what I was doing? Wouldn't i still have to repeat this for each individual row in order to define the variables?

[Mike]

but has to be defined individually

Yes, you would have to repeat this for each individual row. I thought that was what you wanted to do. Maybe if you posted exactly what you are trying to do and what your db structure is, I could help more.

[Jibninjas]

Yes, you would have to repeat this for each individual row. I thought that was what you wanted to do. Maybe if you posted exactly what you are trying to do and what your db structure is, I could help more.

Sorry, I'll try to be more clear. there is about 7 columns that I want to pull from with 15 rows. So one column might be rake_percentage and then there would be all of the poker sites that would each have a value.

What about this

$query = db_query(SELECT rake_percentage FROM poker_sites);

$row = db_fetch_array($query);

$ft_percentage .= $row[0];
$doyle_percentage .= $row[1];
//ect... 

Then I would do that for each column, which seems easier then doing it for each row. What do you think?

[JTJagger]

Also be mindful that Drupal has variable_set() and variable_get() available to you.

I'm not clear of the context here but this is probably a good way to accomplish what you're after. Otherwise, utilise the node system (with views), it's wonderful.

[Jibninjas]

Ok, this is what I have come up with that seems to work and I am able to declare all variables in the same while loop

   $query = db_query("SELECT * FROM site_info_s");
   while($row[] = mysql_fetch_array($query)) { 
   
   $ft_name = $row[0][0];
   $stars_name = $row[1][0];
 
   } 

I had to use the mysql_fetch_array() instead of db_fetch_array because for some reason it will not let me use [0][0] to search for the field. I will have to make a post and find out why it does not function the same.

[Mike]

Oh, I see what you are trying to do now. You needed to get multiple rows, then yes, you definitely want to remove the WHERE statement from your query.

Just a tip, if you want to do assign ALL variables by using ONE while loop AND be able to use these variables later, you could just assign one cell as the variable.

For instance:

If your db is setup like this

Room Name | Rake_Percent | Bonus_Amount
fulltilt | 30% | $600
absolute | 27% | $150

  $query = db_query("SELECT * FROM site_info_s"); 
   while($row = mysql_fetch_array($query)) {  
    
   $$name = $row[0]; 
   $name.'_rake' = $row[1]; 
   $name.'_bonus' = $row[2]; 
  
   } 

Then you could just call the variables $fulltilt_rake, $absolute_rake, $fulltilt_bonus, $absolute_bonus whenever you wanted to within the page.

I know you had it figured out, just offering another way to do it that may be a little more user friendly than nested arrays.

[Jibninjas]

Hey Mike,

Thanks for the help. I think your way is easier, but I tried to implement it and got a syntax error stating an unexpected '='

What do you think?

[CasinoMack]

Its the $$name. Should be 1 $. I'm pretty sure.