> new to php so be nice :)
Always! ;)
> win2k.... iis5.....ms access..
Check...
> // connect to system dsn odbc name login and password or die
> $connect = odbc_connect("DB","name","pword") or die (" not connected");
>
> $sql="INSERT INTO basket (Item,Amount,Price) Values
> ('$id','$amount','$price')";
> // prepare SQL statement
> //$sql_prepare = odbc_prepare($connect,$sql) or die("Couldn't prepare
> query.");
> // prepare SQL statement
> $sql_result = odbc_prepare($connect,$sql) or die("Couldn't
> prepare query.");
>
> // execute SQL statement and get results
> odbc_execute($sql_result) or die("Couldn't execute statement1.");
>
> odbc_free_result($sql_result);
> odbc_close($connect);
Off the top of my head, you might want to uncomment your sql_prepare
statement.
As it is:
// prepare SQL statement
//$sql_prepare = odbc_prepare($connect,$sql) or die("Couldn't prepare
query.");
// prepare SQL statement
$sql_result = odbc_prepare($connect,$sql) or die("Couldn't prepare
query.");
As it should be:
// prepare SQL statement
$sql_prepare = odbc_prepare($connect,$sql) or die("Couldn't prepare
query.");
// prepare SQL statement
$sql_result = odbc_prepare($connect,$sql) or die("Couldn't prepare
query.");
Also, if that's not it...what errors are you getting, if any?
Speaking for myself, I end up using odbc_exec() rather than the combination
of odbc_prepare()/odbc_execute(). Just a personal preference.
You might want to toss in some data validation prior to the $sql definition.
It'll help insure you're not trying to insert bad/null values into your
database.
Hope this helps ya,
- Erik
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
