Hi all,
I feed data into a db and a jscript draws that data from the db and dumps it
in a Marquee on the pg but what happens is everytime i feed in data, there
is an sql update query which updates my db overwriting earlier data... but i
need to archive the data which i wrote earlier so am trying to copy the data
in to another table before the update portion...
My query reads something like this:
mysql_query("SELECT * INTO scr_scroll_ar FROM SCR_SCROLL SET
SCR_MSG1=\"".addslashes($msg1)."\",
SCR_MSG2=\"".addslashes($msg2)."\",
SCR_MSG3=\"".addslashes($msg3)."\",
SCR_MSG4=\"".addslashes($msg4)."\"
WHERE SCR_ID=$id");
What am I doing wrong??? wud appreciate any help.. Tried using INSERT but in
vain...
TIA,
sandeep
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
