Duplicate output

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
zed420
Forum Commoner
Posts: 32
Joined: Wed Jun 04, 2008 11:24 am

Duplicate output

Post by zed420 »

Hi All
Can someone please point out what am I doing wrong here, the query should display one set of results but its showing me THREE same results even thou there is only ONE set of results in the databse so the insert query is fine it hasn't inserted the duplicate data. Some help will appreciated. Thanks

Code: Select all

        function normalJob(){
$id = $_GET['id'];
$query = "SELECT DISTINCT 
job_tb.job_id,job_tb.dateTime,job_tb.cust_name,job_tb.cust_address,job_tb.des,job_tb.typeOfbooking, user.id 
FROM job_tb,user 
WHERE job_tb.user_id = '$id'";
$result = mysql_query($query)or die(mysql_error());    
 
?><div class="smallerText">
<b>These are the jobs you have booked so far.  Please click on Job ID to view further details about the job</b>
<TABLE BORDER=0 WIDTH=100% CELLSPACING=3 CELLPADDING=3 ALIGN=CENTER bgcolor="#CCCCCC">
<TR bgcolor="#FFFFCC" align="center">
<td width="10%"><font color=red><b>Job No.</b></font></TD>
<td width="15%"><font color=red><b>Date/Time</b></font></TD>
<td width="15%"><font color=red><b>Name</b></font></TD>
<td width="25%"><font color=red><b>Pick up Address</b></font></TD>
<td width="20%"><font color=red><b>Destination</b></font></TD>
<td width="20%"><font color=red><b>Booking Type</b></font></TD>
</tr>
<?
    while ($row = mysql_fetch_array($result))  {
    extract($row);
        echo "<tr >
<td>
<a href=\"javascript&#058;open_window('detailNormal.php?job_id=$job_id');\">" . $row['job_id'] . "</a></td>
        <td>" . $row['dateTime'] . "</td>
        <td>" . $row['cust_name'] . "</td>
        <td>" . $row['cust_address'] . "</td>
        <td>" . $row['des'] . "</td>
        <td>" . $row['typeOfbooking'] . "</td>
        </tr>";
    }
?></TABLE></div><?
} 
normalJob();
 
Thanks
Zed
User avatar
aceconcepts
DevNet Resident
Posts: 1424
Joined: Mon Feb 06, 2006 11:26 am
Location: London

Re: Duplicate output

Post by aceconcepts »

I would imagine it's because you're querying two tables without using a JOIN.

Look up "sql join" in Google.
zed420
Forum Commoner
Posts: 32
Joined: Wed Jun 04, 2008 11:24 am

Re: Duplicate output

Post by zed420 »

Thanks
Zed

aceconcepts wrote:I would imagine it's because you're querying two tables without using a JOIN.

Look up "sql join" in Google.
Post Reply