Re: [chiPHPug-discuss] Double posts to my database

[Neil Y. <ny...@as...>]

The database is being updated as soon as the code hits the mysql_query 
statement, not when you call the result (i.e. $result_ReportNewDiversion 
on a line by itself), which doesn't do anything.  Move the lines with 
$result_<whatever> into the if statement and I think you'll get the 
result you are looking for.

Neil


Roderick Thomas wrote:
> Please examine my attached script.  I don't understand what I'm doing 
> wrong with my "if" statements.  I'm thinking my unique conditions 
> should only report to either the "diversionlog" table or the 
> "othercrimes" table.  Additionally, only one post should be made to 
> the "changelog" table.
>
> Instead, the a post is being made to both the "diversionlog" and the 
> "othercrimes" tables and double posts are being made to the 
> "changelog" table.
>
> This is odd to me because the conditions don't seem to overlap and all 
> of the variables are printing as I expect them to.
> ------------------------------------------------------------------------
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> ------------------------------------------------------------------------
>
> _______________________________________________
> chiPHPug-discuss mailing list
> chi...@li...
> https://lists.sourceforge.net/lists/listinfo/chiphpug-discuss