This is pretty noobish i am sure, but bit late and everyone i know which would know is offline lol so thought might get a faster answer here

And yes i know this is SQL, but i think its more likely the PHP in which might be the problem.

I have two SQL query strings one works the other dont but i cant see why =/

PHP Code:

$result = "INSERT INTO `stats` stream_status='".$streamstatus."', listen='".$currentlisteners."', 
time='".date('Y-m-d H:i:s')."', listen_peak='".$peaklisteners."', unique_listen='".$reportedlisteners."'";
$result2 = 'INSERT INTO `stats` (`id`,`stream_status`,`listen`,`unique_listen`,`listen_peak`,`time`) VALUES (NULL,"'.$streamstatus.'","'.$currentlisteners.'","'.$reportedlisteners.'","'.$peaklisteners.'","'.date('Y-m-d H:i:s').'");'; 


$result2 works, but $result doesnt

I much prefer the $result style and want the query to be in that format but can seem to do that and make it work

can someone please advise.

TP for good answers as always!

Dan

INSERT only has TWO forms

INSERT INTO table VALUES(v1,v2 ...);
or
INSERT INTO table (fld1,fld2 ...) VALUES(v1,v2 ...);

The first can be used when you are inserting a value into every column, the second when all or only some of the columns are being supplied.

Originally Posted by dansgalaxy

This is pretty noobish i am sure, but bit late and everyone i know which would know is offline lol so thought might get a faster answer here

And yes i know this is SQL, but i think its more likely the PHP in which might be the problem.

I have two SQL query strings one works the other dont but i cant see why =/

PHP Code:

$result = "INSERT INTO `stats` stream_status='".$streamstatus."', listen='".$currentlisteners."', 
time='".date('Y-m-d H:i:s')."', listen_peak='".$peaklisteners."', unique_listen='".$reportedlisteners."'";
$result2 = 'INSERT INTO `stats` (`id`,`stream_status`,`listen`,`unique_listen`,`listen_peak`,`time`) VALUES (NULL,"'.$streamstatus.'","'.$currentlisteners.'","'.$reportedlisteners.'","'.$peaklisteners.'","'.date('Y-m-d H:i:s').'");'; 


$result2 works, but $result doesnt

I much prefer the $result style and want the query to be in that format but can seem to do that and make it work

can someone please advise.

TP for good answers as always!

Dan

Your first query is way off base! You don't specify fields that way. You don't treat database field names the same as you would your script variables. It should be like the second one but really, get rid of all those extra quotes and cocantations! Like this:

PHP Code:

$result2 = "INSERT INTO `stats` (`id`,`stream_status`,`listen`,`unique_listen`,`listen_peak`,`time`) VALUES (NULL,'$streamstatus','$currentlisteners','$reportedlisteners','$peaklisteners','date(Y-m-d H:i:s)'"; 


That should work just fine for you.

hmm.... ookay

well i have always used the format of

PHP Code:

$result = "INSERT INTO stats stream_status='$streamstatus', listen='$currentlisteners', 
time='date('Y-m-d H:i:s')', listen_peak='$peaklisteners', unique_listen='$reportedlisteners'"; 


for all my queries as i find its the cleanest way which helps to prevent me messing it up

and this style is working for all my other scripts and queries which is why i am a little puzzled. =/

DO'H Do'h do'h

just found what was wrong!!!

SET

the query should read

PHP Code:

"INSERT INTO stats SET stream_status='$streamstatus', listen='$currentlisteners', 
time='".date('Y-m-d H:i:s')."', listen_peak='$peaklisteners', unique_listen='$reportedlisteners'" 


silly me

Dan

yes, silly you dan :|

Lol...

Josh... do i need to go into the back catelogue of joshy d's stupidity o.O

Dan