Insert or Update throug ODBC!

[saidbakr]

I used this code to display data from MS Access DB:

$conn = odbc_connect('eng1','said','fox');
$sqls ="select * from mati";
$dot = odbc_exec($conn, $sqls);
while($res = odbc_fetch_row($dot))
{	

echo(odbc_result($dot,"matname")."<br>");
}

and it works so well, But
Now I want to insert or Update, so How can I do this?

Note: of course the SQL satatement of insert or update. I only need to know the way of coding PHP to do this. :rolleyes:

[nnichols]

$conn = odbc_connect('eng1','said','fox');
$sqls ="UPDATE blah, blah, blah";
$dot = odbc_exec($conn, $sqls);

Is that what you mean?

[saidbakr]

Yes Thank you very much. Sorry for asking about a clear topic like this. however, some times Mind may be frozin or hanged up like computers😃 . I feel with alot amount of shying. Sorry again and thank you alot for your valuable help.

[zudo]

Instead of making a loop there is a fucnction that is called odbc_result_all(put the variable here)

it displays all the info