Hi I am trying to make a simple PHP page that queries a MySQL database. There are two tables created by a program (I don't have any control over the creation of these tables) but they both created by the same data source.
I was trying to form a FULL JOIN to display data from both tables in one web page - However I can't seem to get this to work. The only common column in both is ResultSetID which in one is totally unique - the other is repeated (although the identifier does relate to the same user and data entered by that user) The two tables are: resultsets: (which contains the following columns) ResultSetID, Candidate, QuizName, PercentageScore, PercentagePass, PassFail and questiondata (which contains the following colloums) ResultSetID, SectionReference, Responce The code I have strung together so far is as follows:..... <?php // Make The MySQL Server + Datebase Connection mysql_connect("localhost", "root", "") or die(mysql_error()); mysql_select_db("questions") or die(mysql_error()); // Construct our join query $query = "SELECT * FROM questions.resultsets FULL JOIN questions.questiondata ON ResultSetID"; $result = mysql_query($query) or die(mysql_error()); // Print out the contents of each row into a table while($row = mysql_fetch_array($result)){ echo $row['resultsets.ResultSetID']. " - ". $row['questiondata.QuestionID']. " - ". $row['questiondata.Responce']; echo "<br />"; } ?> But the output I am getting from the webpage is: Column 'ResultSetID' in on clause is ambiguous Is this because the ResultSetID in the questiondata is not unique per row? And if so is there any way to merge the two tables together? Sorry to be a real novice but I only started to look at PHP and MySQL last night! -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php