php
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1") {
$updateSQL = sprintf("UPDATE Aircraft SET Aircraft_Name=%s, Aircraft_Make=%s,
Engine_Count=%s, Engine_Power_HP=%s, Max_Speed_MPH=%s WHERE Aircraft_Name=%s",
GetSQLValueString($_POST['idtop_art'], "int",
GetSQLValueString($_POST['title_art'], "text",
GetSQLValueString($_POST['description_art'], "text",
GetSQLValueString($_POST['text_art'], "text",
GetSQLValueString($_POST['date_art'], "date",
GetSQLValueString($_POST['username_art'], "text",
GetSQLValueString($_FILES['art_img']['name'], "text",
GetSQLValueString($_POST['id_art'], "int");

sorry above is the code i use with my sql database.

i need to know how to update an access database using php.

can anyone help me?

thanks
gavin

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>i need to know how to update an access database using php.<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
I assume you're using DW MX/MX2004? If so, AND you have to covert all code to an access database, AND want to stay within the DW enviroment (no handcoding if possible), then you may want to look into PHP_ADODB, otherwise known as PhAKT (www.interaktonline.com/Products/Free-Products/PHAkt/) & ImpAKT (www.interaktonline.com/Products/Dreamweaver-Extensions/ImpAKT/) or NeXTensio (www.interaktonline.com/Products/Dreamweaver-Extensions/NeXTensio/) from InterAKT.

How many pages do you have to modify? I wish I could point you to a couple Tutorials/Premium Articles on PHP w/Access, but we don't have any <i>yet</i>.

~ ~ ~ ~ ~ ~ ~
Chris Charlton <i>- DMXzone Manager</i>
<font size=1>[ Studio MX/MX2004 | PHP/ASP | SQL | XHTML/CSS | XML | Actionscript | Web Accessibility | MX Extensibility ]</font id=size1>