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
Multiple submit forms inside a mysql array page
Hi all,
Im having trouble to get the beneath script to work the thing i can't seem to get wor
multiple recipients + dbuser mail recall
Hello,
I am building a php login script.
When the user registers the script will send
Somebody hacked into my site and changed coding >>> URGENT HELP NEEDED <<<
I am not that much into programming , but somebody is hacking to my site and injecting some kind of
exclude characters from counting?
Hello, I wanted to ask if you have a string like:
Code: $my_s='ASRGREGTGTR----REGREGRE+++RRRRRR..
Post, not working, please help
The error is:
Method Not Allowed
The requested method POST is not allowed for the URL /student
How do I send data using an html link
Hi
If I have
<a href="main_file.php">
How do I send data t
Hyperlink in PHP to MySQL record
Hello,
I am having trouble as i am new to php. I have connected to the database and I have di
Why does this file not return file names that start with numbers?
This file returns a list of filenames to help populate a drop down in my form. For some reason it ig
using variables in another page
I have a test database set up on localhost. I have a form that I can type a name into, hit the butto
Select Rows as Columns..
is there a way to select COLUMN_NAME from user_tab_columns where table_name='TABLENAME';
and ha
