Re: Ambiguous?

On 09/08/2013 14:00, Karl-Arne Gjersøyen wrote:

1) query foreach($varenr_inn_pa_lager as $vnr){

             include('../../tilkobling.php');
             $sql = "SELECT * FROM exan,dynamit WHERE varenr = '$vnr' LIMIT

1";

             $resultat = mysql_query($sql, $tilkobling) or

die(mysql_error()); 2) Result: Column 'varenr' in where clause is ambiguous 3) Tables in MySQL database mysql> SELECT * FROM exan; +------------+-------------+-------+----------+----------+-------------+ | leverandor | valgt_lager | un_nr | varenavn | varenr | kg_pa_lager | +------------+-------------+-------+----------+----------+-------------+ mysql> SELECT * FROM dynamit; +------------+-------------+---------------+--------+-------+---------------------+------------+-------------+

| leverandor | valgt_lager | type          | dim_mm | un_nr |
varenavn            | varenr     | kg_pa_lager |

+------------+-------------+---------------+--------+-------+---------------------+------------+-------------+ 4) My question: What means with "ambiguous" here? Thanks. Karl a field named 'varenr' exists in both tables - your sql query needs to specify from which table you are selecting the data.

foreach($varenr_inn_pa_lager as $vnr){

           include('../../tilkobling.php');
           $sql = "SELECT * FROM exan,dynamit WHERE varenr = '$vnr' LIMIT

do you really need to include the file 'tilkobling.php' repeatedly for each iteration over $varenr_inn_pa_lager?? Rich