Jump to content

Archived

This topic is now archived and is closed to further replies.

reecieboy

$q = "UPDATE users SET sessionid=".session_id()." WHERE userid=".$_POST['username'];

Recommended Posts

Whats wrong with the above?

Problem with query: UPDATE users SET sessionid=27768e4a7b8a093671bf7c4f1e883ed9 WHERE userid=user
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'a7b8a093671bf7c4f1e883ed9 WHERE userid=user' at line 1

Share this post


Link to post
Share on other sites
You need to surround any text with single quotes:
[code]<?php
$q = "UPDATE users SET sessionid='".session_id()."' WHERE userid='".$_POST['username'] . "'";
?>[/code]

Ken

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.