Simple PHP issue

[Technosailor]

This should not be an issue... but it is. I have spent the better part of 2 hours trying to figure out why I am getting an eval code parse error. This snippet is being called from a file (all HTML except this) and eval()ed. The error is on line 9 which is the mysql_query line.

<?php
$sql = @mysql_query("SELECT *
FROM articles
WHERE featured = '1'
LIMIT 0 , 1");
//echo mysql_num_rows($getSnippet);
if(!$sql)
    {
    echo 'No articles available';
    }
else
    {
    while($snippet = mysql_fetch_array($sql))
        {
?>

<h3><?php echo $snippet['title']; ?></h3>
  
<?php echo substr($snippet['article'],150); 
        }
    }
?>

Called from:

        $pagecontent = stripslashes(makehtml(nl2br($rowContent['content'])));
        echo '<p>';
        eval('?>'.$pagecontent);
        echo'</p>'; 

Make any sense of it?

[Andy Tomaka]

What happens if you don't eval the code? Just run the code as normal PHP. I imagine it works, right? I am failing to see exactly why anything would be causing a problem. If you're still having a problem tomorrow, I'll take some time and sit down and look at it. Unfortunately, my two tests tomorrow have my attention right now

[Technosailor]

So what was the point of the response?

I can't simply run the code. It's coming in from mysql. It's a string. It needs to be eval()ed.

Next.

[Andy Tomaka]

I was implying you try the code without pulling it from the mySQL database. Simply checking if it worked to begin with, which I've had happen to me personally before.

However, feel free to ignore my suggestion. I don't appreciate your response (from an advisor?!?!) and will no longer be helping you.

I do wish you luck with fixing your problem.

[Technosailor]

Forgive me. I'm dealing with another issue at the moment as well. Yes it runs fine by itself, but not as an eval()

[anode]

Try using single-quotes only and escaping them within the string. eval has.."issues" with quotes much of the time.

[Technosailor]

yeah, I tried that too. I've broken everything down to try to narrow down the error, and it still seems to be happening at the eval:

$getContent = mysql_query("SELECT * FROM pages WHERE id = ".$selectedpage);
if(!@$getContent)
    {
    echo '<p>Page Data Not Available.</p>';
    }
else
    {
    while($rowContent = mysql_fetch_array($getContent))
        {
        echo '<h3 class="feature">'.stripslashes($rowContent['title']).'</h3>';
        $pagecontent = nl2br($rowContent['content']);
        $pagecontent = makehtml($pagecontent);
        $pagecontent = stripslashes($pagecontent);
        echo '<p>';
        eval('?>'.addslashes($pagecontent).'<?php ');
        echo'</p>';
        }
    }

[Technosailor]

anyone...

[Cam]

What does makehtml() do? Not in the manual

Why don't you just do this?

while($rowContent = mysql_fetch_array($getContent))
    {
        echo '<h3 class="feature">'.stripslashes($rowContent['title']).'</h3>';
        $pagecontent = nl2br($rowContent['content']);
        $pagecontent = makehtml($pagecontent);
        $pagecontent = stripslashes($pagecontent);
        echo '<p>';
        echo addslashes($pagecontent);
        echo'</p>';
        }
    } 

[Technosailor]

$pagecontent has PHP in it. It won't execute right?

[Technosailor]

What does makehtml() do? Not in the manual

Why don't you just do this?

while($rowContent = mysql_fetch_array($getContent))
    {
        echo '<h3 class="feature">'.stripslashes($rowContent['title']).'</h3>';
        $pagecontent = nl2br($rowContent['content']);
        $pagecontent = makehtml($pagecontent);
        $pagecontent = stripslashes($pagecontent);
        echo '<p>';
        echo addslashes($pagecontent);
        echo'</p>';
        }
    } 

makehtml() is a bbcode parser I wrote.

[Cam]

$pagecontent has PHP in it. It won't execute right?

Yeah, that's right

[Technosailor]

got it. Thanks to naramation. it was the nl2br() screwing everything up.

Thanks guys