Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001072

[PHP-DB] Can I UPDATE 2 tables with 1 SQL statement? From: Mark Gordon (eyesyte <email protected>)
Date: 07/30/01

Heres what I'm trying to do:

$data=addslashes(fread(fopen($form_data, "rb"), filesize($form_data)));

//some lines of code edited out

$result = mysql_query ("
UPDATE bands, binary_data
SET genreid='$genre', bandname='$name', bandesc='$description',
bandurl='$url', bandemail='$email', bin_data='$data',
filename='$form_data_name', filesize= '$form_data_size',
filetype='$form_data_type'
WHERE bandname='$name' AND bands.bin_id=binary_data.bin_id
");

Thanks all you smart people.

=====
Mark
eyesyte <email protected>

__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/ 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>