$20 paypal or bitcoin for help with sql statement - GoFuckYourself.com

mkx · 07-29-2014, 11:29 PM

I need to update orders_status from the orders table based on the following info and table structure. As you can see I have very little clue what I am doing or how to explain this but hopefully someone can make sense of what I am asking for. Will paypal $20 or send the equivalent in bitcoin for the first complete working sql query.

UPDATE orders
SET orders.orders_status='16'
where purchase_items.purchase_orders_id='NULL'

table = purchase_items

purchase_items_id=4839
orders_products_items_id=4761

table = orders_products_items

orders_products_items_id=4761
orders_products_id=3579

table = orders_products

orders_products_id=3579
orders_id=30920

table = orders

orders_id=30920
orders_status=2

Captain Peacock · 07-30-2014, 12:32 AM

Quote:

UPDATE orders
SET orders.orders_status='16'
where purchase_items.purchase_orders_id='NULL'

Bud, I'm sure there's purchase ID and other variables if you try to link two tables. For those of us who went to college its called "unique identifier".

woj · 07-30-2014, 04:56 AM

icq me: 33375924 or woj#at#wojfun#.#com

freecartoonporn · 07-30-2014, 05:34 AM

what ^^ said.

Panty Snatcher · 07-30-2014, 07:22 AM

Hit me on icq , I will give an ans , but i need more info

Looks perty straight forward update statement

674227838

07-29-2014, 11:29 PM	#1
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	$20 paypal or bitcoin for help with sql statement I need to update orders_status from the orders table based on the following info and table structure. As you can see I have very little clue what I am doing or how to explain this but hopefully someone can make sense of what I am asking for. Will paypal $20 or send the equivalent in bitcoin for the first complete working sql query. UPDATE orders SET orders.orders_status='16' where purchase_items.purchase_orders_id='NULL' table = purchase_items purchase_items_id=4839 orders_products_items_id=4761 table = orders_products_items orders_products_items_id=4761 orders_products_id=3579 table = orders_products orders_products_id=3579 orders_id=30920 table = orders orders_id=30920 orders_status=2

07-30-2014, 04:56 AM	#3
woj <&(©¿©)&> Industry Role: Join Date: Jul 2002 Location: Chicago Posts: 47,882	icq me: 33375924 or woj#at#wojfun#.#com __________________ Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000 Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip Manager

07-30-2014, 05:34 AM	#4
freecartoonporn Confirmed User Industry Role: Join Date: Jan 2012 Location: NC Posts: 7,683	what ^^ said. __________________ SSD Cloud Server, VPS Server, Simple Cloud Hosting \| DigitalOcean

07-30-2014, 07:22 AM	#5
Panty Snatcher eat a peach for Hours Industry Role: Join Date: Aug 2013 Posts: 540	Hit me on icq , I will give an ans , but i need more info Looks perty straight forward update statement 674227838