One Page Fix

İptal Edildi İlan edilme: Dec 2, 2008 Teslim sırasında ödenir
İptal Edildi Teslim sırasında ödenir

I have a site that wa created using PHP,MYSQL and Smarty Templates. My Host upgraded to MYSQL to 5.0.51a on the server and one of my pages that have been working for over 2 yrs suddenly started getting a syntax error while trying to access the page. This should be a quick fix for an experienced programmer. I need someone that will be able to resolve all of the issues with this page in a timely manner. I am no longer in contact with the programmer that helped me create the site so I would like to start a new relationship with a new programmer for some other addons

***** First I was getting this error ****

[2008-12-01 15:00:44] ERROR (0x10000001) 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 '

[login to view URL],

datecycle,

date_forma' at line 1:db_get_allloan_by_accountid:SELECT ,

[login to view URL],

datecycle,

date_format(lastmodifydatetime,'%Y-%m-%d') as lastmodifydate,

CONCAT_WS(' ', firstname, lastname) as username,

CONCAT('$',FORMAT(loanamount,2)) as loanamount,

paytimes,

times,

CONCAT('$',FORMAT(loanamount/times,2)) as average,

reason

FROM loan, user

LEFT JOIN

(SELECT COUNT(*) as paytimes,

loanpayid

FROM saving

WHERE savingtype='loan payment'

and accountid='2'

and status='normal'

GROUP BY loanpayid) paytotal

ON paytotal.loanpayid=[login to view URL]

WHERE datecycle>='2008-01-01'

and datecycle<='2008-12-01'

and loan.accountid='2'

and user.accountid='2'

and loan.status='normal'

and loan.userid=[login to view URL]

ORDER by lastmodifydatetime DESC;

********************Now I get this error ************************

[2008-12-01 17:52:48] ERROR (0x10000001) Unknown column '[login to view URL]' in 'on clause':db_get_allloan_by_accountid:SELECT loanid,

[login to view URL],

datecycle,

date_format(lastmodifydatetime,'%Y-%m-%d') as lastmodifydate,

CONCAT_WS(' ', firstname, lastname) as username,

CONCAT('$',FORMAT(loanamount,2)) as loanamount,

paytimes,

times,

CONCAT('$',FORMAT(loanamount/times,2)) as average,

reason

FROM loan, user

LEFT JOIN

(SELECT COUNT(*) as paytimes,

loanpayid

FROM saving

WHERE savingtype='loan payment'

and accountid='1'

and status='normal'

GROUP BY loanpayid) paytotal

ON paytotal.loanpayid=[login to view URL]

WHERE datecycle>='2008-01-01'

and datecycle<='2008-12-01'

and loan.accountid='1'

and user.accountid='1'

and loan.status='normal'

and loan.userid=[login to view URL]

ORDER by lastmodifydatetime DESC;

PHP

Proje NO: #351671

Proje hakkında

17 teklif Uzak proje Aktif Dec 4, 2008