hi....
I have a problem with update query....
update nsefu_stock set symbol = 'WOCKPHARMA-27APR2006' , exchange = 'NSE' ,
series = '' , ind_code = '', grp_code = '', ltp = '514.1', ltq = '6',
change_percent = '0.6', volume = '658800', atp = '515.11', record_date =
'2006-03-31', day_open = '512.9', high = '519.8', low = '506.2', day_close =
'511.05', tsq = '225600', tbq = '123000', update_lock = '0' where
symbol='WOCKPHARMA-27APR2006' and record_date='2006-03-31'
This is the query i am trying update from PHP script.... but when i check the
affected rows after the update it will shows 0 .
If change the query to
update nsefu_stock set symbol = 'WOCKPHARMA-27APR2006xyz' , exchange = 'NSE'
, series = '' , ind_code = '', grp_code = '', ltp = '514.1', ltq = '6',
change_percent = '0.6', volume = '658800', atp = '515.11', record_date =
'2006-03-31', day_open = '512.9', high = '519.8', low = '506.2', day_close =
'511.05', tsq = '225600', tbq = '123000', update_lock = '0' where
symbol='WOCKPHARMA-27APR2006' and record_date='2006-03-31' and run in
PhpMyAdmin it is updating the record
The only difference in both queries is i changed the set symbol =
'WOCKPHARMA-27APR2006xyz'
Plz..... help... What could be the problem....
Thanks in Advance....
---------------------------------
New Yahoo! Messenger with Voice. Call regular phones from your PC and save big.
[Non-text portions of this message have been removed]
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
