Jump to content

Passing Variables Help Request.


Strixy

Recommended Posts

Let me start by explaining the project a little.

Via a web form, the user selects 2 numbers (drop down) and 2 items (drop down). The numbers selected are to be placed in a table. The two items are selected from a drop down list of 6 choices. The location of those numbers (in the table) is determined by the users selection of item1 and item2. The correlation of item1 and item2 is stored in a mysql database and as described, determined by the users input.

If I put a results table together, such that each cell in the table is a unique $variable, then I can store those variable names as searchable/selectable results in a mysql database. The end result is such that the users choice of items will determine the placement of the two numbers in a table of results.

Example;
[code]
<?php
// other stuff eg, web form, mysql_connect, select_db, etc...  leading to
      $number1 = $_POST['number1'];
      $querya = mysql_select("SELECT varname FROM table WHERE $item1 = '$item2');// will reaturn a location variable ...
      $resulta = return($querya, 0);  // ... "location1a" or "location2b" or whatever.
      "$".$resulta = $number1  // This is the part I'm having problems with.
?>[/code]

Lets say that the result of the query, for the sake of arguement, is "location2b".

I would like to create a variable name that is determined by the mysql result and then set that variable to whatever $number1 was set to back at the $number1 = $_POST['number1'] so that I can echo the value of $number1 in the appropriate place. For example, a table 6x6 with 36 variables all connectted to the result of the mysql query. The result table looks like... (html removed)

$location1a    $location1b    $location1c    $location1d .... etc ....
$location2a    $location2b    $location2c    $location2d .... etc ....
$location3a    $location3b    $location3c    $location3d  ....etc ....
etc..
etc..

So, for example, if the mysql query returns "location2b" as the result of the query, I would like to be able  to echo the value of $number1 in the proper location.

Any thoughts would be appreciated. Even if its to say it can't be done so I can stop trying to figure this out. Thank you!
Link to comment
Share on other sites

You are trying to use variable variables (http://www.php.net/manual/en/language.variables.variable.php)
[code]<?php
// other stuff eg, web form, mysql_connect, select_db, etc...  leading to
      $number1 = $_POST['number1'];
      $querya = "SELECT varname FROM table WHERE $item1 = '$item2'";// will reaturn a location variable ...
      $rw = mysql_query($querya) or die("Problem with the query: $querya<br>" . mysql_error());
      $resulta = $rw['varname'];  // ... "location1a" or "location2b" or whatever.
      $$resulta = $number1  // This is the part I'm having problems with.
?>[/code]

Ken
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.