Re: [PHP-DB] Syntax Error

2007-01-07 Thread Niel Archer
Hi is the syntax error reported for the php or the SQL? Better yet, supply the actual error message, so we can see for ourselves Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Syntax Error

2007-01-07 Thread Chris
JD wrote: Can anyone help me figure out what is wrong with this syntax. Thanks. list($qh,$num) = dbQuery("SELECT password AS passwd1, $DATABASE_PASSWORD_FUNCTION('$password') AS passwd2 ". "FROM $USER_TABLE WHERE username='$username'"); $data = dbResult($qh); No need to repost your quest

[PHP-DB] Syntax Error

2007-01-07 Thread JD
Can anyone help me figure out what is wrong with this syntax. Thanks. list($qh,$num) = dbQuery("SELECT password AS passwd1, $DATABASE_PASSWORD_FUNCTION('$password') AS passwd2 ". "FROM $USER_TABLE WHERE username='$username'"); $data = dbResult($qh); -- PHP Database Mailing List (http://www.p

[PHP-DB] Syntax Error

2007-01-07 Thread JD
I am getting a syntax error in the statement below. Can anyone tell me what it is. Thanks. list($qh,$num) = dbQuery("SELECT password AS passwd1, $DATABASE_PASSWORD_FUNCTION('$password') AS passwd2 ". "FROM $USER_TABLE WHERE username='$username'"); $data = dbResult($qh); -- PHP Database Mai

Re: [PHP-DB] CURL and process not finishing

2007-01-07 Thread Chris
[EMAIL PROTECTED] wrote: - Original Message - From: "chris smith" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: Sent: Friday, January 05, 2007 12:08 PM Subject: Re: [PHP-DB] CURL and process not finishing On 1/5/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: I am using CURL to ch

Re: [PHP-DB] Error for registration mail.

2007-01-07 Thread Niel Archer
Hi You have two functions between the if and else, the syntax you've used only allows one. Use braces. if(mysql_query($sql)) { mail ($email, "Thank you for registering!", $body, "From: [EMAIL PROTECTED]"); header("Location: thankYou.php"); } else { die("Error! Could not insert values".m

[PHP-DB] Error for registration mail.

2007-01-07 Thread Chris Carter
Hi, I am trying to send an email to the user after he registers himself on the website. The code is a DB code that 1) Inserts the data to DB table 2) Sends an email to the user with his details. 3) Passes on a Thank you page. The code works fine without the email code. But I get this error when