[SOLVED] PHP / MySQL issue with INSERT INTO

[SamDOD]

using this code i am connecting to my data base and inserting login information from one table to another.

 

function Log3(){
$Susername = $this->dbuser;
$Spassword = $this->dbpass;
$Shostname = $this->dbhost; 
$Sdatabase = $this->dbase;

$dbhandle = mysql_connect($Shostname, $Susername, $Spassword)
or die("Unable to connect to MySQL");

$selected = mysql_select_db($Sdatabase,$dbhandle)
  or die("Could not select Database");

$SQL2="INSERT INTO userlog4(userName, lastLog, ip, logtimeout)";
$SQL2.="SELECT (userName, lastLog, ip, logtimeout) ";
$SQL2.="FROM myuser WHERE ".$this->tblID."='".$_SESSION['userID']."'";

$Send=mysql_query($SQL2);

mysql_close($dbhandle);
}

 

It works fine, but.... i cant seem to do more than one col. If instead of (userName, lastLog, ip, logtimeout) i only put userName, or ip, by itself in both places it transfers fine but when i add another one it does not work. What am i doing wrong?

 

Thank you for your time.

 

 

[rhodesa]

try putting parenthesis around the nested select:

 

$SQL2="INSERT INTO userlog4(userName, lastLog, ip, logtimeout) ";
$SQL2.="(SELECT (userName, lastLog, ip, logtimeout) ";
$SQL2.="FROM myuser WHERE ".$this->tblID."='".$_SESSION['userID']."')";

[SamDOD]

Same thing happed. Nothing happens if i have two or more col but if i have one col it works.

[rhodesa]

try this and see if mysql is throwing any errors:

 

$SQL2="INSERT INTO userlog4(userName, lastLog, ip, logtimeout) ";
$SQL2.="(SELECT userName, lastLog, ip, logtimeout ";
$SQL2.="FROM myuser WHERE ".$this->tblID."='".$_SESSION['userID']."')";

$Send=mysql_query($SQL2) or die("INSERT ERROR: ".mysql_error());

[SamDOD]

INSERT ERROR: 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 ' lastLog, ip, logtimeout) FROM myuser WHERE ID='1')' at line 1

[rhodesa]

can you do an echo $SQL2 and post the "generated" value of that string...

[SamDOD]

sorry had not uploaded the changed doc so i was getting nothing till i ran it again then got that error.

[rhodesa]

see this post: http://www.phpfreaks.com/forums/index.php/topic,222080.msg1020283.html#msg1020283

 

i removed parenthesis from around the list of field names. from the error you post, it looks like you haven't removed them yet...

[SamDOD]

It works, thank you i knew it was something stupid on my part that i was totally overlooking.

Thank you very much!