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 <[EMAIL PROTECTED]> 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]
