Sedang Disiapkan

Problem with one page

This post is for NickolaS

I have a site that was created using PHP,MYSQL and Smarty Templates. My Host upgraded to MYSQL to [url removed, login to view] 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 '

[url removed, login to view],

datecycle,

date_forma' at line 1:db_get_allloan_by_accountid:SELECT ,

[url removed, login to view],

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=[url removed, login to view]

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=[url removed, login to view]

ORDER by lastmodifydatetime DESC;

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

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

[url removed, login to view],

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=[url removed, login to view]

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=[url removed, login to view]

ORDER by lastmodifydatetime DESC;

Kemahiran: PHP

Lihat lebih lanjut: where to start as php programmer, version one, the one group, problem with error, page problem, n. y. post, line in problem, error on page fix, c line templates, 1. problem, 1 problem, your one, syntax, one line php, join with you, desc, create one page, check username, status page, average php mysql, php sql syntax error, select page, resolve server, php mysql error unknown column, smarty page

Tentang Majikan:
( 10 ulasan ) Stockbridge, United States

ID Projek: #357389