Current location: Hot Scripts Forums » Other Discussions » Database » mysql multiple table update problem


mysql multiple table update problem

Reply
Page 2 of 2 1 2
 
LinkBack Thread Tools Display Modes
  #11 (permalink)  
Old 07-10-08, 01:59 AM
ordique ordique is offline
Newbie Coder
  
Join Date: Jun 2008
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Quote:
p.NCR_No='$ncrno', pd.NCR_No='$ncrno', d.NCR_No='$ncrno' AND pl.NCR_No='$ncrno'
is it correct to write like this??
Reply With Quote
  #12 (permalink)  
Old 07-10-08, 02:27 AM
<?Wille?> <?Wille?> is offline
Junior Code Guru
  
Join Date: Jan 2004
Location: Helsinki, Finland
Posts: 666
Thanks: 0
Thanked 0 Times in 0 Posts
I think your just supposed to use AND/OR in the where clause
Reply With Quote
  #13 (permalink)  
Old 07-10-08, 03:06 AM
dustin56 dustin56 is offline
Newbie Coder
  
Join Date: Jun 2008
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Quote:
Originally Posted by <?Wille?> View Post
I think your just supposed to use AND/OR in the where clause
Correct. I should be like this
Code:
p.NCR_No='$ncrno' AND pd.NCR_No='$ncrno' AND d.NCR_No='$ncrno' AND pl.NCR_No='$ncrno'
.
Reply With Quote
Reply
Page 2 of 2 1 2

Bookmarks

« Omits the text after quotes while importing..Why? | Column name in LIKE query »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
PHP does NOT update the mysql when rapidly sent through browser - $20 REWARD PAYPAL billyspcs PHP 2 04-22-06 01:56 PM
MySQL insert record if update fails? perleo PHP 3 01-06-06 02:21 PM
How to get PHP to input data into a MYSQL table? scl789 PHP 5 04-21-05 09:06 PM
UPDATE: MySQL Auto Backup & Export v1.1 Beyonder General Advertisements 2 03-21-05 02:05 PM
php mysql updating problem kevinb PHP 2 11-06-04 03:15 PM


All times are GMT -5. The time now is 05:03 PM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.