eval() error problem, with MYSQL

n_wattam

I have some code in a MYSQL database, as follows. when i execute this php code in its own file, it creates 1 record, as ment to.

<?
$query1 = "INSERT INTO newsevents VALUES (
					'',
					'maker',
					'', 
					'',
					'',
					''
					)";

mysql_query($query1);
?>

However when this code is called from a MYSQL record, and using the following eval() command to process it, i end up with 2 records being created.

<?
$code=$pageconfig['contentmiddle'];
$code=str_replace('<'.'?php','<'.'?',$code);
$code='?'.'>'.trim($code).'<'.'?';
eval($code);
?>

any ideas?

Plasma

echo out $code... see what it contains?

Also, lose the horrible habbit of not giving column names when inserting values into a database!

Use: INSERT INTO table (col1, col2, col5) VALUES (val1, val1, val5)

Can choose the order of the fields this way.

n_wattam

Thanks for the reply...

Tried echo-ing the output and theres nothing aditional to the code, my thoughts where maybe its duplicating the code, but doesnt look that way.

any other ideas?

n_wattam

LMAO, personaly i am going to blame microsoft for this one. After ripping my code down total i have actually found the problem.

<table width="100%" border="0" cellspacing="0" cellpadding="0" background="#000066" style="background-color:#000066;">

In the above code i have let slip an invalid part

background="#000066"

When you take this little bit out, it stops a new record being created twice. What i am guessing is, because of this error IE is loading the page more than once.. GRRRRRRRRR

somot like that i would of never normally spotted.

madwormer2

Oh wow. Now THERE's an error I haven't seen before. Well spotted! 🙂

n_wattam

lol....

500lines of html and php... and that was the last thing i was looking for. :p...

take me back to the days of QBASIC in dos, where the slighest error and the program would not run and highlight the problem. 😃

madwormer2

Whats actually happening is the background="#000066" calls page.php#000066 for the background image. Notices its not actually an image, so doesn't display it. But it does open the page twice. Once for the page, and once for the image.

n_wattam

ah, thanks for that. i did wonder how or why it was managing to do that. I also noticed since this error has been corrected the spead of the site has increased. Before i was getting some big delays but it was random.

At first i thought it was our internet connect or the web services.

Thanks again.