[SOLVED] help with insert into and select

[syntax101]

im using php but i have a problem with my code

 

$sql = 'INSERT INTO archivedeletedorders (order_num,cust_num,prod_name,order_quantity,order_dates,del_date,discount,del_status,

sizesx,sizesy,mounting,typeofmedia,cropping,pocket,total,pay_status,transaction,order_name,print_type)

      Select * from orders where orders_num= '.$_POST['orders_num']';

    $result = $db->query($sql);

[revraz]

You sure do.  You need to specify VALUES for your INSERT and you need to seperate it from your SELECT

[syntax101]

i tried to put an sql statement in phpmyadmin that doesnt need a VALUE and it works

 

code:

insert into archivedeletedorders select * from orders where orders_num = 1373

[rajivgonsalves]

did you try echoing the insert statement in php is $_POST['orders_num'] coming in properly ?

[syntax101]

yes i did, my editor is dreamweaver and when i type those code the color of the codes turn red so it means it has an error .

 

[rajivgonsalves]

this

 

 $sql = 'INSERT INTO archivedeletedorders (order_num,cust_num,prod_name,order_quantity,order_dates,del_date,discount,del_status,
   sizesx,sizesy,mounting,typeofmedia,cropping,pocket,total,pay_status,transaction,order_name,print_type)
      Select * from orders where orders_num= '.$_POST['orders_num']';

 

should of been

$sql = 'INSERT INTO archivedeletedorders (order_num,cust_num,prod_name,order_quantity,order_dates,del_date,discount,del_status,
   sizesx,sizesy,mounting,typeofmedia,cropping,pocket,total,pay_status,transaction,order_name,print_type)
      Select * from orders where orders_num= '.$_POST['orders_num'];

 

there was a extra single quotes at the end!

[syntax101]

thanx for the help. i will try this if it will work.