Page 1 of 1

Duplicate output

Posted: Mon Nov 24, 2008 7:51 am
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

Re: Duplicate output

Posted: Mon Nov 24, 2008 8:25 am
by aceconcepts
I would imagine it's because you're querying two tables without using a JOIN.

Look up "sql join" in Google.

Re: Duplicate output

Posted: Mon Nov 24, 2008 9:04 am
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.