chris smith-9 wrote:
>
> ddg2sailor wrote:
>>
>
>
>>It's still wrong regardless.
>
> I dont run the system , However the code I didnt post checks to make sure
> the user name or email isnt already in use or in fact was in use but
> removed. Diddnt have to bother with that part , it works fine.
>
>>User "A" signs up
>>User "B" signs up
>
>>User "A" clicks the confirm link
>
>>User "B" does not, but is confirmed anyway.
>
>>> reads from the array. I can see where a table might be more use here.
>
>>Eh? I asked about what the sqlesc function does - it is not a native php
>>function.
>
> I wish I could tell you more... but this isnt my code. now it no doubt
> looks sloppy but It does work on anther system and sends the pm. My
> thinking is more along the lines of getting the value for $id comming out
> to = ' ' (null) instead of the Username...
>
> I havent been able yet to test the last edit of this code yet... It may
> even work. It runs on windows 2003 server sqlserver if this helps any.
>
>>> You need quotes around your values:
>>>
>>> $sql = "insert into table(f1, f2, f3) values ('" .
>>> mysql_real_escape_string($value_1) . "', '" .
>>> mysql_real_escape_string($value_2) . "')";
>>>
>>> Im guessing that the preceding line got a bit chopped in the sending....
>>> at least it dosent look quite right as it is. If I cut and paste this
>>> back
>>> together I should be able to follow your convention.
>
>>No, I was just too lazy to use your code and instead I gave an example.
>
> I diddnt expect you to do my work for me :) But thanks for the tip.
>
> --
> Postgresql & php tutorials
> http://www.designmagick.com/
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
--
View this message in context: http://www.nabble.com/Multiple-MySQL-INSERT-tp20786333p20805879.html
Sent from the PHP - General mailing list archive at Nabble.com.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
