Current location: Hot Scripts Forums » Programming Languages » PHP » update one from with info from another?

update one from with info from another?

Reply

#1 (permalink)

Old

03-22-04, 01:41 PM

lordmerlin lordmerlin is offline

lordmerlin is offline

Newbie Coder

Join Date: Jul 2003

Location: South Africa

Posts: 94

Thanks: 0

Thanked 0 Times in 0 Posts

update one from with info from another?

How is this done?

Cause update comments set subscriber='Y' where comments.supplier =
company.company_name doesn't work

Yet, select comments.subscriber, comments.supplier, company.company_name
where comments.supplier = company.company_name does work....

Reply With Quote

Reply

Bookmarks

« heathcosoft search | category error »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded 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 Rules

Forum Jump

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
loop through & update a mysql database	ednit	Perl	4	10-03-09 10:07 PM
reading info from a file (csv / xls) and displaying info	lordmerlin	PHP	7	03-20-04 03:39 PM
PHP to MySQL script question...(using a field to update info in MySQL)	DisneyFan25863	PHP	4	11-02-03 03:31 AM
type mismatch and update loop - HELP!	seala	ASP	1	09-22-03 05:27 PM
not displaying the correct info	sparky	PHP	8	06-26-03 08:28 AM