Posted by nick.bonadies on 04/12/07 18:17

> $queryAddRecord = "INSERT INTO tbl_employees(firstName, lastName)
> VALUES(";
> if (!empty($_POST['firstName']))
> {
> $queryAddRecord .= "'".$_POST['firstName']."',";
> }
> else {$queryAddRecord .="Null,";}
>
> if (!empty($_POST['lastName']))
> {
> $queryAddRecord .= '"'.str_replace("'", "''",
> $_POST['lastName']).'",';
> }

I figured it out. Its the '"' part, it should be "'".str_replace....

Thanks for the help! I appreciate it.

• Next in forum: Re: DIssapearing/reappearing Session variables
• Prev in forum: Re: Implement a super search engine using php
• Thread view: Re: Single quotes in MSSQL

[Reply to this message]