DML functions
Posted: 2013-01-22 06:48
Like sqlvalue function, which function shall i use for search, insert and update in the table (please share samples if you can) ?
To delete/edit/insert:
Code: Select all
sql("update table `customers` set phone='123456789' where customerID=22", $eo);Code: Select all
$records = sql("select * from `customers` where state='NY' order by customerID", $eo);
while($customer = mysql_fetch_assoc($records)){
echo "{$customer['firstName']} {$customer['lastName']} <br/>";
}