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
Please help understand this code
I noticed the index page on my site was modified this morning and found this code inserted at the bo
PHP & Images [Resize, Crop, Save]
Hey! Well I have a little dilema, hoping I could find some guidance.
I have a CMS and on the
constructor ?
i have written this program and made 3 constructors in the class and i want to call them in the main
Send current URL in URL with a $_GET variable problem.
Hello community,
I have created a function that gets the current variable of a page, example:
that old Malformed Headers problem again!!!!! HELP!!!!!!
I've read the http://www.phpfreaks.com/forums/index.php/topic,37442.0.html
I don't think my c
Simple MySQL script is not working
Hey guys,
Just familiarizing myself with PHP and MySQL. I am following along in the O'Reilly
Greek characters in php
Hi,
I'm making a script and I m using for first time greek characters.
I started to write
PHP Thumbnail Creation
Ok so i use this function to create thumbnails:
Code: [Select]function createthumb($name,$fil
Get relative path from absolute path
How would one go about getting the relative path to a file from its absolute path?
Using the $_GET variable to view certain records
Hello,
First let me explain my problem, I have 2 pages the first page pull a list of Guide ti