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] >
