question about substitution variables?

[olibar]

Is it possible to use substitution variables (single-ampersand "&" like in Oracle) in MySql queries?
If so, how can you handle it with php?

[kleineme]

Hi,

do you mean this or that? If so, just use it as any other query: mysql_query("SET @t1=0");

[olibar]

In oracle you can do this:

SELECT employee_id, last_name, salary, department_id
from employees
where employee_id = &employee_num;

When you run this query it will ask you for a value for the variable &employee_num.

It is an interactive way to input values. And, I would like to know if it is possible to do the same in MySQL.
And how do you handle that with PHP?

[kleineme]

Hi,

I haven't seen such a possibility in MySQL yet. But if you have the user input in some PHP variable, you can create a dynamic SQL:

$employee_num = 5;
$sql = "SELECT employee_id, last_name, salary, department_id
  FROM employees WHERE employee_id = " . $employee_num;