If you can send me the code. I like to share my knowloege with you.
try to use ` mark for $row[`topik_id`];
select * from tbldiskusi where topik_id = $row['topik_id'] ORDER BY
'dtglpost' DESC
saranagathaya
Edwin <[EMAIL PROTECTED]> 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]
>
---------------------------------
Need a vacation? Get great deals to amazing places on Yahoo! Travel.
[Non-text portions of this message have been removed]
