NYCPHP Meetup

NYPHP.org

[nycphp-talk] PHP Error - Need Help Debugging

subscriptions subscriptions at burakueda.com
Thu Apr 13 00:29:17 EDT 2006


You are trying to concatenate a numer with strings.
Try this one:

$checkreplies = "SELECT
                    posts.postid,
                    posts.subject,
                    posts.body,
                    posts.created,
                    users.userid,
                    users.username,
                    users.aim,
                    users.created,
                    users.admin
                FROM posts, users
                WHERE posts.postid = '".$_GET["id"]."'
                AND    posts.userid = users.userid
                AND posts.replyto = '".$_GET["postid"]."'
                LIMIT ".strval(($pagecount-1)*10-1).", 10";

Using strval() does the trick :D

hope this helps...

Burak



IAlsoAgree at stny.rr.com wrote:
> I'm sure it's going to be something really obvious, but for now I just
> can't seem to figure out what it is.
>
> I'm getting the following error:
> Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING
>
> The line of code is:
> $checkreplies = "SELECT posts.postid, posts.subject, posts.body,
> posts.created, users.userid, users.username, users.aim, users.created,
> users.admin FROM posts, users WHERE posts.postid = \"$_GET[id]\" AND
> posts.userid = users.userid AND posts.replyto = $_GET[postid] LIMIT
> ".($pagecount-1)*10-1.", 10";
>
> >From what I can gather, it sounds like I misused a double quote or
> misplaced a peroid. But looking at the code, I can't see where I did
> either wrong.
>
> Anyhelp would be appreciated.
>
> Thanks,
> -Joe
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
> New York PHP Conference and Expo 2006
> http://www.nyphpcon.com
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php
>
>   




More information about the talk mailing list