Query failed issue with php script but works fine in mssql manager!
Posted on
16th Feb 2014 07:03 pm by
admin
hi i have the script below which copies data from one table to another but will only insert new data update current data or delete old data from tempproducts to products then it will delete the tempproducts from the db however i keep getting this error:
Warning: mssql_query() [function.mssql-query]: Query failed in E:UpdateProducts.php on line 33
updateproducts.php
Code: [Select]<?php
include('../../otherscripts/functions.php');
$log = new Logging();
// create DB connection
$host = "localhost";
$user = "user";
$pass = "pass";
$mydb = "db";
$db = mssql_connect($host,$user,$pass);
//Select Database
mssql_select_db($mydb);
// delete all old data
$sql0 = "SELECT * FROM tempproduct";
$sql1 = "INSERT INTO products SELECT * FROM tempproduct WHERE manf_part_no NOT IN (SELECT manf_part_no FROM products) AND supp_id NOT IN (SELECT supp_id FROM products)";
$sql2 = "DELETE FROM products WHERE manf_part_no NOT IN (SELECT manf_part_no FROM tempproduct) AND supp_id NOT IN (SELECT supp_id FROM tempproduct)";
$sql3 = "UPDATE p1 SET p1.avail_qty = t1.avail_qty, p1.cost_price = t1.cost_price, p1.rrp = t1.rrp, p1.date_added = t1.date_added, p1.description = t1.description FROM Products p1 INNER JOIN tempproduct t1 ON (p1.manf_part_no = t1.manf_part_no AND p1.supp_id = t1.supp_id)";
$sql4 = "TRUNCATE TABLE tempproduct";
//If tempproduct is empty done Execute Commands if it is full then execute commands
$query = mssql_query($sql0) or die($log->lwrite('Failed to select for count from db'));
$rowcount = mssql_num_rows($query);
if($rowcount == 0){
$log->lwrite('Teh tempproduct am emptyish');
}
else{
mssql_query($sql1) or die($log->lwrite('Failed to insert to db'.$sql1));
mssql_query($sql2) or die($log->lwrite('Failed to Delete from db'));
mssql_query($sql3) or die($log->lwrite('Failed to Update db'));
mssql_query($sql4) or die ($log->lwrite('Failed to TRUNCATE db'));
}
?>
if i run $sql1 command in the sql manager it runs fine and no errors occur?
Your Answer:
Login to answer
303
20
Other forums
Socket programming
Hello all,
I have a PHP socket script. GPS trackers connect to this socket. IMEI verification
Change log of Cost centre change in Plant maintenance order
Hi,
How to view Change log of Cost centre in Plant maintenance order. Not visible thru 'Docume
Just a white page
Okay so, my website, when I click SignUp on it it takes me to /join.php but its a complete white pag
Unable to display contents in Second Drop Down Box
Hi All,
What I am trying to do is 2 dependent drop down boxes and when user selects su
uploading video files into mysql in php
hi,
I have the video files which i have to upload into mysql db. along with creating thumbnails f
Displaying returned XML in another PHP page
I have an online payment form that will return XML given if a payment is successful or declines. I
Nested (echoed) php running wrong script
Got a problem with a php website I'm creating.
In a nutshell, the first page is entirely html
how make 2 column in table with data tybe long row
hi every one
I want make in my table 2 column with data tybe long raw
how thi
How to kill asynchronous postback / current postback?
Hi,here is my problem:I have a web site with many pages of which some may take time to process resul
dinamic "textboxes"?
Ey all, my first post here, i hope its not a hard one
I display mysql results in a table