Inserting records into Sybase with PHP

[Shell]

I have been searching unsuccessfully for information on how to INSERT or UPDATE a record in Sybase using PHP.

I have found many references to MySQL or to selecting information from Sybase.

I can SELECT records, but cannot locate the proper INSERT syntax. I'm currently trying:

$lendBook = sybase_query ("INSERT INTO borrow VALUES ("[e-mail]", "0-41-876006-2", "12/08/02", ''", $db));

I don't know if "sybase_query" is correct. The above code works when I apply it as direct SQL, just not with my code. The code above gives a 'parse error'.

Thank you for any guidance on where I might find the missing info.
-SMR

[matto]

I suppose, when done from php, the query fails because of single/double quote confusion. inside an sql statement, use single quotes. maybe, "direct sql" is more tolerant regarding this.

[mattr]

That is a PHP error because you have malformed quotes.

Take look at yours and mine:

<?php

$lendBook = sybase_query ("INSERT INTO borrow VALUES ("[e-mail]", "0-41-876006-2", "12/08/02", ''", $db)); 

$lendBook = sybase_query ("INSERT INTO borrow VALUES ('[e-mail]', '0-41-876006-2', '12/08/02', '')", $db); 

?>