hii iam in work of making a accounts holding database website based on php
can u please debug the lines beloow
it fails to do the queryy
is their anything wrong wit syntax
$gmobileq="INSERT INTO table2 (date, modelnumber, price, paid, sold ) select (date, modelnumber, price, paid, sold ) from table1 where shop ='3gmobile'";
mysql_query($gmobileq) or die('Error, failed to enter record) ;
at the same time
when i enter
mysql> INSERT INTO table1 (date, modelnumber, price, paid, sold) select date, modelnumber, price , paid , sold from table2
where shop ='3gmobile';
in mysql monitor it works fine..
so please help
can u please debug the lines beloow
it fails to do the queryy
is their anything wrong wit syntax
$gmobileq="INSERT INTO table2 (date, modelnumber, price, paid, sold ) select (date, modelnumber, price, paid, sold ) from table1 where shop ='3gmobile'";
mysql_query($gmobileq) or die('Error, failed to enter record) ;
at the same time
when i enter
mysql> INSERT INTO table1 (date, modelnumber, price, paid, sold) select date, modelnumber, price , paid , sold from table2
where shop ='3gmobile';
in mysql monitor it works fine..
so please help