parse error

deolsabh

I am getting parse error on line no. 43
Fatal error: Call to undefined function: pg_exec() in /usr/local/apache/www/1.php on line 43

mysql_select_db("db");
#@$ok = mysql_select_db("$database");
$query = "insert into customers (name, last, email, street, city, zip, state, phone, month, day, year, customerid) values
('$name', '$last', '$email', '$street', '$city', '$zip', '$state', '$phone', '$month', '$day', '$year', '' )";
#$result = mysql_query($query);
$result = pg_exec("select name from customers (LINE NO. 43)
name = '$name'
and street = '$street'
and zip = '$zip'
and month = '$month'
and day = '$day'");
if (pg_NumRows($result) == 0 )
{
$result = mysql_query($query);
} else {
print "data alreay in database\n";
}

die('MySQL error: ' . mysql_error() . '<br>Query: ' . $query);

if (!$name || !$last || !$street || !$city || !$zip || !$month || !$day )
{
echo " You have not entered all the required details.<br>"
."Please go back (Use your Browser back button) and try again.";
exit;
}

if ($result)
echo mysql_affected_rows(). " member added to Club.";
?>

</body>
(LINE NO. 43)

tsinka

Hi,

there is no pg_exec function in php. Seems like you are trying to use PostgreSQL functions. mysql_query should do it. Do you want to port code written for PostgreSQL to MySQL ?

deolsabh

oh i think i have combined 2 different
please help me to correct this syntax
i want to see if inormation is already in database
thanks

tsinka

Ok,

I've some questions:

Is the customer data coming from a form ?
Are $last, $street, $email ... POST variables or GET variables ?
Is customerid an auto_increment field ?
Are month, day and year the birthday of a customer ?

From what I see in your code you use name, street, zip, month and day to determine if the given customer already exists in the database. Wouldn't it be better to use last instead of name ?

I see
echo mysql_affected_rows(). " member added to Club.";

Is it theoretically possible to add more than one member to the club ?

Please post the complete code of both scripts (as .txt files, phpbuilder doesn't permit .php files to be posted), that would help very much 🙂

Thomas