[Wolves] Any PHP/MySQL experts who can help me?

Andy Smith andy at lug.org.uk
Thu May 3 17:25:14 BST 2007


On Thu, May 03, 2007 at 04:42:49PM +0100, Philip Harper wrote:
> /* Change database entry to say that the user is no longer logged in */
> 
> $userID = $_SESSION['user'];
> 
> $result = mysql_query(" UPDATE userAccount SET loggedOn = 'N' WHERE 
> userID = '$userID' ");

I assume you have instrumented the above lines to print out the
$userID and the exact query being executed?

I also assume this is code stripped down to bare minimum for brevity
and your real code escaopes strings in SQL queries properly etc..

Cheers,
Andy

-- 
http://bitfolk.com/ -- No-nonsense VPS hosting
Encrypted mail welcome - keyid 0x604DE5DB
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://mailman.lug.org.uk/pipermail/wolves/attachments/20070503/fdf79701/attachment.bin


More information about the Wolves mailing list