PEAR DB Abstraction

[last_trace]

I'm on my dev server right now but..

I keep getting an error "DB Error: syntax error"
[code]<?php
$sql = "INSERT INTO `links` (`email`, `website`, `website_name`, `button`, `accepted`) VALUES('$email','$website','$website_name','$button','0')";

        $result = $db->query($sql);

            if (DB::isError($result))
            {
                die ($result->getMessage());
            }
            else
            {
            echo 'You have successfully applied and I will review your submission.';
            }
?>[/code]

any ideas?

[btherl]

If you have a syntax error, try printing out [code=php:0]$sql[/code].  My guess is that one of your variables contains the ' character.

You should always use mysql_real_escape_string() on any data you are putting into an SQL query.