PHP/mySQL - overwriting a row

[WorldChanger]

Yeah... so I'm probably a total nitwit... it's probably right in front of me. But what the PHP command and syntax to overwrite a row? If my primary identifier is "id", what would the code be to overwrite the data in that row?

I tried searching around, but all I got was sore eyes. :eek:

[splict]

UPDATE

[tg]

http://www.sqlcourse.com/

[WorldChanger]

Thanks guys. :)

[WorldChanger]

gah... I replied too soon...

Ok.. basically I've got 100 columns, labeled with numbers, with just one entry. My flash movie passes the variables to the PHP... that's fine. But I can't get it to update the entry.


<?php
mysql_pconnect ("localhost", "database", "password");
mysql_select_db ("database");
mysql_query ("UPDATE tablename SET 1='$1', 2='$2', 3='$3', 4='$4', 5='$5', 6='$6', 7='$7', 8='$8', 9='$9', 10='$10', 11='$11', 12='$12', 13='$13', 14='$14', 15='$15', 16='$16', 17='$17', 18='$18', 19='$19', 20='$20', 21='$21', 22='$22', 23='$23', 24='$24', 25='$25', 26='$26', 27='$27', 28='$28', 29='$29', 30='$30', 31='$31', 32='$32', 33='$33', 34='$34', 35='$35', 36='$36', 37='$37', 38='$38', 39='$39', 40='$40', 41='$41', 42='$42', 43='$43', 44='$44', 45='$45', 46='$46', 47='$47', 48='$48', 49='$49', 50='$50', 51='$51', 52='$52', 53='$53', 54='$54', 55='$55', 56='$56', 57='$57', 58='$58', 59='$59', 60='$60', 61='$61', 62='$62', 63='$63', 64='$64', 65='$65', 66='$66', 67='$67', 68='$68', 69='$69', 70='$70', 71='$71', 72='$72', 73='$73', 74='$74', 75='$75', 76='$76', 77='$77', 78='$78', 79='$79', 80='$80', 81='$81', 82='$82', 83='$83', 84='$84', 85='$85', 86='$86', 87='$87', 88='$88', 89='$89', 90='$90', 91='$91', 92='$92', 93='$93', 94='$94', 95='$95', 96='$96', 97='$97', 98='$98', 99='$99', 100='$100'");
Print "&savestatus=Saved";
?>


Anyone have any ideas?

[freddycodes]

Uh..........

What in the world is that?

Should you have one table with two columns

TABLE
number int(11) NOT NULL,
value varchar(255)