Date: 01/30/07 (PHP Community)    Keywords: no keywords

Hi

This post has been heavily edited because I realized my problem and now have another question so sorry for any confusion

My original question was about the data from 3 tables not being displayed properly and I realized that my query was not actually returning results simply because the other two tables did not have data in them yet. (This is going to be added later) This brings me to my next question.

Is there some way that I can have it check for data in the other table (I now only have two data tables instead of 3 - Company and CallDetail) and if there is data there, append the query to the regular query. I have an idea how to do this but I'm not sure if it makes logistical sense. I need to be able to check if there have been any additions to the second table (CallDetail) for each Company and include the data when the page is loaded (if there is data to be loaded). I hope this makes sense. :\ Thanks again for your help.

Source: http://community.livejournal.com/php/535998.html