this is my first try to share my knowledge please just send me the code of the
page topik.php. and please send me the script you just added to your forum.
can i know what is the type of your forum? i think it is phpBB?
Basel juma
----- Original Message ----
From: Sarana Gathaya <[EMAIL PROTECTED]>
To: php-list@yahoogroups.com
Sent: Wednesday, September 19, 2007 7:05:41 AM
Subject: Re: [php-list] Re: Problem in my Forum
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] com> 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] s.com, 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] s.com <mailto:php- list%40yahoogrou ps.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]
<!--
#ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean,
sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;}
#ygrp-vitnav{
padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
#ygrp-vitnav a{
padding:0 1px;}
#ygrp-actbar{
clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
#ygrp-actbar .left{
float:left;white-space:nowrap;}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;font-size:77%;padding:15px 0;}
#ygrp-ft{
font-family:verdana;font-size:77%;border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;}
#ygrp-vital{
background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
#ygrp-vital #vithd{
font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
#ygrp-vital ul{
padding:0;margin:2px 0;}
#ygrp-vital ul li{
list-style-type:none;clear:both;border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
#ygrp-vital ul li .cat{
font-weight:bold;}
#ygrp-vital a {
text-decoration:none;}
#ygrp-vital a:hover{
text-decoration:underline;}
#ygrp-sponsor #hd{
color:#999;font-size:77%;}
#ygrp-sponsor #ov{
padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;margin:0;}
#ygrp-sponsor #ov li{
list-style-type:square;padding:6px 0;font-size:77%;}
#ygrp-sponsor #ov li a{
text-decoration:none;font-size:130%;}
#ygrp-sponsor #nc {
background-color:#eee;margin-bottom:20px;padding:0 8px;}
#ygrp-sponsor .ad{
padding:8px 0;}
#ygrp-sponsor .ad #hd1{
font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
#ygrp-sponsor .ad a{
text-decoration:none;}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;}
#ygrp-sponsor .ad p{
margin:0;}
o {font-size:0;}
.MsoNormal {
margin:0 0 0 0;}
#ygrp-text tt{
font-size:120%;}
blockquote{margin:0 0 0 4px;}
.replbq {margin:4;}
-->
____________________________________________________________________________________
Moody friends. Drama queens. Your life? Nope! - their life, your story. Play
Sims Stories at Yahoo! Games.
http://sims.yahoo.com/
[Non-text portions of this message have been removed]
