09182007 0938 GMT-6 DST Post the code exactly like you have it in your code so we can see if there is something else there.
wade Edwin wrote: > Hi Mike, after i've changed the script, the error comes bigger... > It is said: > Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, > expecting T_STRING or T_VARIABLE or T_NUM_STRING in > /home/tifuph/public_html/topik.php on line 113 > > I think it's not a problem the array element with quote or not... > > Thankz for the help... > > --- In [email protected], Mike Franks <[EMAIL PROTECTED]> wrote: >> Edwin - try quoting your array element name: >> >> $row['topik_id'] >> >> By the way, usually when you see a MySQL error message complaining > about >> ORDER BY or some other clause in an SQL query, the problem is that the >> MySQL parser doesn't like whatever occurred just before the clause >> mentioned in the error message. That is, in this case MySQL doesn't > like >> the ORDER BY clause because there's a problem in where topik_id = >> $row[topik_id] >> >> Hope that helps, >> Mike >> >> Edwin wrote: >>> thanks Wade...I don't know that my webhost has different PHP version >>> with mine...So, what should I do if the SQL command doesn't work? >>> >>> this is my SQL command which has error... >>> >>> select * from tbldiskusi where topik_id = $row[topik_id] ORDER BY >>> 'dtglpost' DESC >>> >>> thanks for the help... >>> i owe you.. >>> >>> --- In [email protected] <mailto:php-list%40yahoogroups.com>, >>> Wade Smart <wade@> wrote: >>>> 09162007 1231 GMT-6 DST >>>> >>>> One of the obvious things I find is that a person is using the > newest >>>> version of php or mysql or some other language or software and the >>>> webhost is using a version two or three back. Its not usually an > issue >>>> but, its always good to start out knowing what you are dealing with. >>>> >>>> So, if you are creating code on your own computer make sure you have >>> the >>>> same version or close to the same version as what is on your web > host. >>>> However, after seeing the error, post your code where you are doing >>> your >>>> 'order by' so we can see if there is a problem with it. >>>> >>>> Wade >>> >> >> [Non-text portions of this message have been removed] >> > > > > > Community email addresses: > Post message: [email protected] > Subscribe: [EMAIL PROTECTED] > Unsubscribe: [EMAIL PROTECTED] > List owner: [EMAIL PROTECTED] > > Shortcut URL to this page: > http://groups.yahoo.com/group/php-list > Yahoo! Groups Links > > > >
