Re: Why won`t this delete?

On 27-Oct-00 Julie Meloni wrote: > Not really...escaped double-quotes work just fine. > > Check to see that the value of $Email really _is_ something. echo the > SQL statement and try the query by hand. If the script is not > die()-ing, then quite likely the value of $Email isn't anything that > matches. Check, in the form that precedes it, that the name of the > input field is Email and not email ... case makes a difference. > > Dallas Kropka wrote: > >> Um... try this. >> >> $Updstmt="delete from EList1 where Email= '$Email' "; >> >> mysql_query($updstmt); >> >> >> its the single quotes that make a diff. >> <snip> Julie is correct, but Dallas's solution will also work, by a sidestep around the real problem. from my followup : > $db = mysql_select_db("f199102", $SQLConn) or die ("Couldn`t select > database"); // while (! $code_working ) // read_the_manual(); > > $query_delete=mysql_db_query($db, $Updstmt); Website4S@aol.com is attempting to use a true|false as a string. Regards, -- Don Read dread@texas.net There are old sailors, and there are foolish sailors; but damn few old foolish sailors. ---------------------------------------------