Databases
StackOverflow2013
Postsdbo
PODynamically create variables in while loop based on sql query
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODynamically create variables in while loop based on sql query
    primarykey
    data
    text
    <pre><code>SELECT a.uid, a.name_f, a.name_l, b.position FROM users a, room_members b WHERE a.uid = b.userid AND b.room_id=$room_id </code></pre> <p>I have the above query that selects the name, uid, profile pic and position of a certain user based on the room_id, and I want to return a while loop that assigns the following variables to any positions that returns in my query, dynamically. </p> <pre><code>$position1_name_f $position1_name_l $position1_uid $position1_pic $position2_name_f $position2_name_l $position2_uid $position2_pic </code></pre> <p>So for example, if positions 4 and positions 8 are the only ones among the data returned, it would return the following variables and I would be able to use theses variables freely in my script.</p> <pre><code>$position4_name_f $position4_name_l $position4_uid $position4_pic $position8_name_f $position8_name_l $position8_uid $position8_pic </code></pre> <p>There would be a maximum of 10 positions at the most. I desperately need those variables because I use them heavily with the layout of the site and there's no way for me to do a simple while loop echo; otherwise, everything would be a lot easier. </p> <p>I tried using variable variables and I also tried deploy a counter but couldn't get either to work. </p> <p>I started the following query and would really appreciate some help. Thanks</p> <pre><code>$room_members=mysql_query("SELECT a.uid, a.name_f, a.name_l, b.position FROM users a, room_members b WHERE a.uid = b.userid AND b.room_id=$room_id"); while($members_sql=mysql_fetch_array($room_members)) { //Need some dynamic variables here... } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USuser1011713
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PODynamically create variables in while loop based on sql query
      1. This table or related slice is empty.
      1. VTDownMod
    1. COOut of my last 11 questions, I have accepted 10 answers. So, thanks for the wonderful and incredibly useful suggestions but please don't offer advice without fully knowing the facts.
      singulars
      1. PODynamically create variables in while loop based on sql query
      1. USuser1011713
    2. COIf anyone uses the answer from this questio, the following function works great while searching through the array: function search($array, $key, $value) { $results = array(); if (is_array($array)) { if (isset($array[$key]) && $array[$key] == $value) $results[] = $array; foreach ($array as $subarray) $results = array_merge($results, search($subarray, $key, $value)); } return $results; } courtesy of http://stackoverflow.com/questions/1019076/how-to-search-by-key-value-in-a-multidimensional-array-in-php
      singulars
      1. PODynamically create variables in while loop based on sql query
      1. USuser1011713
    3. CO'this user has accepted an answer for 9 of 14 eligible questions' that is not 10 out of 11 ;-)
      singulars
      1. PODynamically create variables in while loop based on sql query
      1. USDaan Timmer
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload