Posted by Geoff Berrow on 06/20/07 08:22

Message-ID: <1182325982.532226.144310@i13g2000prf.googlegroups.com> from
James_sgp contained the following:

>On Jun 20, 2:58 pm, Geoff Berrow <blthe...@ckdog.co.uk> wrote:
>> Message-ID: <1182306258.201378.288000@j4g2000prf.googlegroups.com> from
>> James_sgp contained the following:
>>
>> >The problem is that the variable
>> >$max_depth isn`t updated when it is written into the database, hence
>> >the original value is always there.
>>
>> Then you have to do the debugging all of us do. If you have
>> something like
>> $sql= "INSERT... ";
>>
>> Then add
>> echo $sql;
>> to see whether the variable is making it to the insert statement

>I have...
>The SQL query contains the old value, while is i 'echo' the variable
>before making the SQL staement it contains the new number!

so you've done

if(strcmp($distance,"ft")==0) $max_depth=$max_depth/3.28;
echo $max_depth;
$sql= "INSERT... $max_depth ... ";
echo $sql;

and $max_depth is different in the INSERT statement?


--
Geoff Berrow 0110001001101100010000000110
001101101011011001000110111101100111001011
100110001101101111001011100111010101101011

• Next in forum: Routine for solving linear n-dimensinal equations
• Prev in forum: Re: Checking string contents
• Thread view: Re: Checking string contents

[Reply to this message]