Hi Edmund, There is a big difference between PHP and CakePHP, PHP is a web/scripting programming language while CakePHP "Which was built using PHP" is actually a web application framework that you use to build web applications. I suggest getting your hands really dirty with PHP first before you come over to CakePHP so you can use the framework effectively and efficiently.
Good Luck On Thu, Aug 18, 2011 at 5:59 AM, Edmund Wilson < [email protected]> wrote: > 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 > [email protected] For more options, visit this group > at http://groups.google.com/group/cake-php > -- 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 [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
