clause is ambiguous
Posted: Wed Aug 23, 2006 2:17 pm
For the following query
I get the error: "Column: 'a_id' in where clause is ambiguous"
What is this saying?
Code: Select all
...connect to db
$a_id = $_GET['a_id'];
$query = "SELECT * FROM article INNER JOIN image ON (image.a_id=article.a_id) WHERE a_id='$a_id'";
...rest of codeWhat is this saying?