Ambiguous?

From: Date: Fri, 09 Aug 2013 12:00:26 +0000
Subject: Ambiguous?
Groups: php.general 
Request: Send a blank email to php-general+get-321825@lists.php.net to get a copy of this message
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

« previous php.general (#321825) next »