creating a new variable

asa_carter

This is in one file:

$section = "property";
$property = mysql_fetch_array(mysql_query("SELECT * FROM property WHERE id='$property_id'"));

This is in another file:

$section = "vacancies";
$vacancies = mysql_fetch_array(mysql_query("SELECT * FROM vacancies WHERE id='$vacancies_id'"));

Is it possible to create a new variable called $item in a common include file that contains the DB query depending on the value of $section without using conditions?

So.. something like $item (DB array) = the value of $section (DB array)

Hope this makes sense..?

NogDog

asa_carter wrote:
...Hope this makes sense..?

Hmm...not sure. :p

Sounds like what you possibly are after is a function definition in your include file. you could then include ([man]require_once/man would probably be best) that file once, then call the function as needed elsewhere in your application. The function's argument(s) would be the variable value(s) you want to supply, and then it would return the result.

<?php
require_once 'include_file.php';
$section = 'property';
$result = function_name($section);
$section = 'vacancies';
$result = function_name($section);

asa_carter

It doesnt matter too much now as I'm restructuring it so that all queries have the same variable.

$section = "vacancies";
$global_item = mysql_fetch_array(mysql_query("SELECT * FROM vacancies WHERE id='$vacancies_id'"));

What I meant was that if you had a variable eg.

$foo = "bar";
$bar = "12345";

Convert the string value of $foo ("bar") to an actual variable name ($bar) and store the contents of $bar in a new common variable.

So if I had this in one file:

$foo = "bar1";
$bar = "12345";
include ("common.php");

and this is another
$foo = "bar2";
$bar2 = "67890";
include ("common.php");

common.php:
convert the string value in foo to a variable name
get the contents of this variable name and output it

so if $foo contents was "bar2" before the include was called, the include would output "67890"