Re: [Phplib-users] PHPLIB duplicate (one is blank) db inserts with Templates...

[Andrew C. <ph...@ev...>]

Last time I tried to post to the list, it was held for approval (and is 
still being held).  So, I don't know if this will make it to the whole 
list but, we'll try ...

an...@my... wrote:
>  Below is an example of code of one page : 

> $aDb = new DB_oi_ct;
> $aDb->query("$squery");
> $squery = "	INSERT INTO auto_messages
> 			(	message_name,
> 				auto_messages
> 			)
> 			VALUES
> 			(	'$Message_Name',
> 				'$Message'
> 			)";

I'm not familiar with FastTemplates and I'm not sure this has any 
bearing on your problem but, shouldn't you be defining the query string 
($squery) BEFORE you call the query method of your database object with 
the variable?  As written, won't this section of your script send an 
empty query to the database since $squery is undefined at the point you 
call the query method with it?  Or am I missing something?

Andrew Crawford