8 thoughts on “First PHP/MySQL Project Day 6: Joining Tables Together”

1. Cool!

   You should take a look at PHP Object Oriented Programming. It is better then doing it the other way because you don’t have to write as much code, well for big projects anyway.

   I’ve been messing about with css, here take a look. Not anything that I would use for a website, except maybe the dark layout, 4.

   http://yaseen.iifree.net/1/index.html
   http://yaseen.iifree.net/2/index.html
   http://yaseen.iifree.net/3/index.html
   http://yaseen.iifree.net/4/index.html

   Still making some more.

   Reply ↓

2. Hei Liz.

   BRILLIANT!
   Have been trying to crack the codes on these things myself for a good while, so the links are very useful to me indeed.
   Continued Grand Day to you and yours.

   Reply ↓

3. Thanks, guys!

   Yas – Nice job on those layouts! I should follow your example and practice my CSS too, lol. And of course the Object Oriented Programming… One more thing on my list!

   Reply ↓

4. Excellent tutorial.

   I found this while searching for an example of a php/mysql database as I want to write a simple (very very simple!) help desk application ( I help out at some schools and want the teachers to have a simple way of recording requests/faults).

   Would it be possible, please, to have a copy of the code used in the final tutorial to use as a starting point (to save some typing )
   regards
   Simon

   Reply ↓

5. Hi, Simon, and thanks! I lost my copy of the the code I used in this series but I typed up what was shown in this last video. It’s just part of what’s required to make everything work, though… this doesn’t include connecting to MySQL, or the rest of the form(s) shown. But hopefully this excerpt is better than nothing.

   (By the way, check out a forum like PHP Freaks for help.)

   
// Selecting the data

   $resultselect = mysqlquery('SELECT id, item, todo.tag, deadline, color FROM todo LEFT JOIN tags ON todo.tag = tags.tag');

   // Fetching and displaying the data
   while($row = mysql_fetch_array($resultselect)) { ?>

   <?php if($row['color']) { ?>
   <span stlye="color:<?php echo $row['color'] ?>">
   <?php } ?>

   <input type="checkbox" name="done[]"
     id="<?php echo $row['id'] ?>"
     value="<?php echo $row['id'] ?>" />

   <label for="<?php echo $row['id'] ?>">

   <?php echo $row['item'];

   if($row['tag']) {
     echo ' - tagged ' . $row['tag']; }

   if($row['deadline'] != 0000-00-00) {
     echo ' - due on ' . $row['deadline']; }

   ?>

   </label>

   <?php if($row['color']) { ?>
     </span>

   <?php }

   } ?>


   Reply ↓

6. It explained what exactly I wanted to know!
   Thanks to LearningNerd team.

   Reply ↓

7. Hi Team,

   I am using the same syntax for my database but its showing me the ids(int) of another table instead of strings(varchar).
   I am using MyISAM engine.
   Does the engine affect joining two tables?

   Here is my code:

   $sql = “SELECT * FROM (org LEFT JOIN category ON org.org_category = category.category_id) ORDER BY org.org_id DESC”;

   What was going wrong?
   Thanks in advance!

   Reply ↓

8. Amol,

   If you do a join on two tables that have a column name that is the same, the result set will show only that last one.

   A solution for this is to alias your columns in your SELECT like:

   SELECT o.id as oid, c.id as catid FROM org o LEFT JOIN category on…

   The ‘o.id as oid’ is an example of an alias. Once you alias a column you can get to it in your results by referencing the alias.

   Hope that helps.

   Reply ↓