Hi what is wrong with my PHP Code?

P

Paolo M

New member
// Hi i have a problem displaying some info in my code and a statement keeps on appearing "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY b.journaldetail_debitamount DESC, b.journaldetail_creditamount DESC' at line 4" what is wrong with my code? please help me :-(

<?php
include('functions.php');
connect();
session_start();
include('checkUser.php');
$user = $_SESSION['userId'];
$id = $_GET['journalid'];
$adj = $_GET['adj'];
?>
<?php
include('header.php');
$query_journalid = mysql_query("SELECT a.*, b.* FROM tbl_journal as a
LEFT JOIN tbl_journaldetail as b ON a.journal_id = b.journal_id
WHERE a.user_id = ".$user." AND a.journal_id = ".$id."
ORDER BY b.journaldetail_debitamount DESC, b.journaldetail_creditamount DESC") or die(mysql_error());
while($info = mysql_fetch_array($query_journalid))
{
list($year,$month_number,$day) = split("-",$info['journal_date']);
$month_name = date( 'F', mktime(0, 0, 0, $month_number) );
}
?>

<div id='content'>
<form name="frmJournal" method="post" action="processData.php?action=add&field=journal" onsubmit="return validateForm();">
<p align="center"><b>GENERAL JOURNAL</b></p>
<p>Journal No.:<?php echo $id; ?></p>
<table border=1 align="center" width="90%" class="journal" cellpadding="0" cellspacing="0">
<tr align="center">
<td colspan="2"><b>DATE</b></td>
<td><b>Accounts & Explanation</b></td>
<td><b>F</b></td>
<td><b>Debit</b></td>
<td><b>Credit</b></td>
</tr>
<tr>
<td><?php echo $year; ?></td>
<td>*</td>
<td>*</td>
<td>*</td>
<td>*</td>
<td>*</td>
</tr>

<?php

$query_journalid = mysql_query("SELECT a.*, b.*, c.account_name FROM tbl_journal as a
LEFT JOIN tbl_journaldetail as b ON a.journal_id = b.journal_id
LEFT JOIN tbl_accounts as c ON b.account_id = c.account_id
WHERE a.user_id = ".$user." AND a.journal_id = ".$id."
ORDER BY b.journaldetail_debitamount DESC, b.journaldetail_creditamount DESC") or die(mysql_error());
$ctr=1;
$num_rows = mysql_num_rows($query_journalid);
while($info = mysql_fetch_array($query_journalid))
{
if($ctr==1 && ($info['journaldetail_creditamount']==0.00 || $info['journaldetail_creditamount']==0))
{
echo "<tr>";
echo "<td>".$month_name."</td>";
echo "<td>".$day."</td>";
echo "<td>".$info['account_name']."</td>";
echo "<td>*</td>";
echo "<td class='numalign'>".number_format($info['journaldetail_debitamount'],2)."</td>";
echo "<td>*</td></tr>";
}
if($ctr>1 && ($info['journaldetail_creditamount']==0.00 || $info['journaldetail_creditamount']==0))
{
echo "<tr>";
echo "<td>*</td>";
echo "<td>*</td>";
echo "<td>".$info['account_name']."</td>";
echo "<td>*</td>";
echo "<td class='numalign'>".number_format($info['journaldetail_debitamount'],2)."</td>";
echo "<td>*</td></tr>";
echo "</tr>";
}
if($ctr>1 && ($info['journaldetail_creditamount']!=0.00 || $info['journaldetail_creditamount']!=0))
{
echo "<tr>";
echo "<td>*</td>";
echo "<td>*</td>";
echo "<td>* * * * *".$info['account_name']."</td>";
echo "<td>*</td>";
echo "<td>*</td>";
echo "<td class='numalign'>".number_format($info['journaldetail_creditamount'],2)."</td>";
echo "</tr>";
}
if($ctr==$num_rows)
{
echo "<tr&
 
Back
Top