executing php in a wordpress blog post?

[Useless]

Originally Posted by walrus

I run exec.php and am able to add php to pages without any problem. have never tried posts but can't imagine it would be different.

That's what I've used and works fine within posts. I believe it's another situation in which you want to turn off the Visual Rich Editor.
http://bluesome.net/post/2005/08/18/50/

[walrus]

Originally Posted by Useless Warrior

That's what I've used and works fine within posts. I believe it's another situation in which you want to turn off the Visual Rich Editor.
http://bluesome.net/post/2005/08/18/50/

Or, in other words, read the fucking manual

[spacedog]

Originally Posted by walrus

Or, in other words, read the fucking manual

yep. did everything it said.. even installed the role manager, etc..

tried several times & nothing works.. not in a post nor as a page.

I have tgp on root & blog in dir.

Script is in root & trying to include tgp script in post thats on blog in dir as

<?
 include("../script.php");
 $query   = "SELECT COUNT(url) AS numrows FROM links";
 $result  = mysql_query($query) or die('Error, query failed');
 $row     = mysql_fetch_array($result, MYSQL_ASSOC);
 $numrows = $row['numrows'];
 
 $maxPage = ceil($numrows/65);

 $sql = "SELECT url, title, date FROM `links` ORDER BY date DESC LIMIT ".$offset.", 65;";
 $rs = mysql_query($sql);
 echo mysql_error();
 
 
 $self = $_SERVER['PHP_SELF'];
 $nav = '';
 for($page = 1; $page <= $maxPage; $page++)
 {
    if ($page == $pageNum)
    {
        $nav .= " $page ";
    }
    else
    {
        $nav .= " <a href=\"$self?page=$page\">$page</a> ";
    }
 }

while($row = mysql_fetch_row($rs)){
     echo "<a href=\"".$row[0]."\">".$row[1]."</a>".$row[2]."\n<br>\n";}

 echo "<p>Page: ";
 $self = $_SERVER['PHP_SELF'];
 $nav = '';
 for($page = 1; $page <= $maxPage; $page++)
 {
    if ($page == $pageNum)
    {
        $nav .= " $page ";
    }
    else
    {
        $nav .= " <a href=\"$self?page=$page\">$page</a> ";
    }
 }

echo $first . $prev . $nav . $next . $last;
 mysql_close();
?>

and I end up with on the post

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ 65′ at line 1
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /dirname/0/blahblah/htdocs/file/name/wp-content/plugins/exec-php/runtime.php(41) : eval()’d code on line 29

[Useless]

In the docs, the author states:

If you experience a PHP error message like 'Some error in /home/minime/htdocs/blog/wp-content/plugins/exec-php/runtime.php(41) : eval()’d code on line 4' then it's time to repair your PHP code. If you are unsure where your code breaks, first run it in a separate file to punch out all bugs and afterwards copy the code into your article or widget.

So I guess he's saying, "it's you, not me."

I'm not a PHP guru, so I really couldn't tell you what's wrong with the included script's code.

[spacedog]

Originally Posted by Useless Warrior

In the docs, the author states:So I guess he's saying, "it's you, not me."

I'm not a PHP guru, so I really couldn't tell you what's wrong with the included script's code.

The code works fine on a normal php page. Must be some conflict with wordpress & the plugin and I don't know how to fix this as I didn't write this code

[walrus]

It's more than likely a pathing problem in the code. Wordpress is a bit unique in that a post resides within the theme and the path through there would be through your theme.

Try using absolute instead of relative paths and you may be ok.