I need some help writing a PHP script that will decide to create a new row in
mysql or just update an exsisting account and pass the information back to my
swf file... any suggestions? I am sure alot of people would need this when
creating a form that updates or creates account information...

Thanks

Adam

Well... I am currently trying to find this answer... This is the code I am
developing for the answer to this question... it is currently not working.
Maybe someone out here in the world knows why this doesn't work... seem like it
should to me...

The php collects the customer number with variable field1 using post, opens
the mysql connection, does a selection looking for matching customer number,
looks to see if the results found any rows that match, then decides whether to
update to the specified customer or insert a new customer...but is doesn't work
(hair being yanked out) HELP!!!


<?php
$field1 = $_POST['field1'];

$link= mysql_connect("localhost", "adamsim_asimms1", "somepassword") or die
('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("adamsim_lendingsourceone");

$result = mysql_query("SELECT * FROM leads WHERE data1 = '$field1'");

if (mysql_num_rows($result) > 0) {
mysql_query("UPDATE leads SET data2='field2', data3='field3', data4='field4',
data5='field5', data6='field6', data7='field7', data8='field8', data9='field9',
data10='field10', data11='field11', data12='field12', data13='field13',
data14='field14', data15='field15', data16='field16', data17='field17',
data18='field18', data19='field19', data20='field20', data21='field21',
data22='field22', data23='field23', data24='field24', data25='field25',
data26='field26', data27='field27', data28='field28', data29='field29',
data30='field30', data31='field31', data32='field32', data33='field33',
data34='field34', data35='field35', data36='field36', data37='field37',
data38='field38', data39='field39', data40='field40', data41='field41',
data42='field42', data43='field43', data44='field44', data45='field45',
data46='field46', data47='field47', data48='field48', data49='field49',
data50='field50', data51='field51', data52='field52', data53='field53',
data54='field54', data55='field55', data56='field56', data57='field57',
data58='field58', data59='field59', data60='field60', data61='field61',
data62='field62', data63='field63', data64='field64', data65='field65',
data66='field66', data67='field67', data68='field68', data69='field69',
data70='field70', data71='field71', data72='field72', data73='field73',
data74='field74', data75='field75', data76='field76', data77='field77',
data78='field78', data79='field79', data80='field80', data81='field81',
data82='field82', data83='field83', data84='field84', data85='field85',
data86='field86', data87='field87', data88='field88', data89='field89',
data90='field90', data91='field91', data92='field92', data93='field93',
data94='field94', data95='field95', data96='field96', data97='field97',
data98='field98', data99='field99', data100='field100', data101='field101',
data102='field102', data103='field103', data104='field104', data105='field105',
data106='field106', data107='field107', data108='field108', data109='field109',
data110='field110', data111='field111', data112='field112', data113='field113',
data114='field114', data115='field115', data116='field116', data117='field117',
data118='field118', data119='field119', data120='field120', data121='field121',
data122='field122', data123='field123', data124='field124', data125='field125',
data126='field126', data127='field127', data128='field128', data129='field129',
data130='field130', data131='field131', data132='field132', data133='field133',
data134='field134', data135='field135', data136='field136', data137='field137',
data138='field138', data139='field139', data140='field140', data141='field141',
data142='field142', data143='field143', data144='field144', data145='field145',
data146='field146', data147='field147', data148='field148', data149='field149',
data150='field150', data151='field151', data152='field152', data153='field153',
data154='field154', data155='field155', data156='field156', data157='field157',
data158='field158', data159='field159' WHERE data1='field1'");
}ELSE {
mysql_query("INSERT INTO leads VALUES(", '$field2', '$field3',
'$field4', '$field5', '$field6', '$field7', '$field8', '$field9', '$field10',
'$field11', '$field12', '$field13', '$field14', '$field15', '$field16',
'$field17', '$field18', '$field19', '$field20', '$field21', '$field22',
'$field23', '$field24', '$field25', '$field26', '$field27', '$field28',
'$field29', '$field30', '$field31', '$field32', '$field33', '$field34',
'$field35', '$field36', '$field37', '$field38', '$field39', '$field40',
'$field41', '$field42', '$field43', '$field44', '$field45', '$field46',
'$field47', '$field48', '$field49', '$field50', '$field51', '$field52',
'$field53', '$field54', '$field55', '$field56', '$field57', '$field58',
'$field59', '$field60', '$field61', '$field62', '$field63', '$field64',
'$field65', '$field66', '$field67', '$field68', '$field69', '$field70',
'$field71', '$field72', '$field73', '$field74', '$field75', '$field76',
'$field77', '$field78', '$field79', '$field80', '$field81', '$field82',
'$field83', '$field84', '$field85', '$field86', '$field87', '$field88',
'$field89', '$field90', '$field91', '$field92', '$field93', '$field94',
'$field95', '$field96', '$field97', '$field98', '$field99', '$field100',
'$field101', '$field102', '$field103', '$field104', '$field105', '$field106',
'$field107', '$field108', '$field109', '$field110', '$field111', '$field112',
'$field113', '$field114', '$field115', '$field116', '$field117', '$field118',
'$field119', '$field120', '$field121', '$field122', '$field123', '$field124',
'$field125', '$field126', '$field127', '$field128', '$field129', '$field130',
'$field131', '$field132', '$field133', '$field134', '$field135', '$field136',
'$field137', '$field138', '$field139', '$field140', '$field141', '$field142',
'$field143', '$field144', '$field145', '$field146', '$field147', '$field148',
'$field149', '$field150', '$field151', '$field152', '$field153', '$field154',
'$field155', '$field156', '$field157', '$field158', '$field159'")}


mysql_close($link);
?>