The conn is right, as I can login and my other functions work

<?php
$host = '***************************************';
//$host = 'localhost:************************;
$username = '************';
$password = '***********';
$dbh = ibase_connect($host, $username, $password) or die
('<b>Error:</b> '.ibase_errmsg());



// error handler function
//function myErrorHandler ($errno, $errstr, $errfile, $errline)
//{
// $f = fopen('log.txt', 'a+');
// fputs($f, "$errno :: $errstr : $errfile : $errline\n\r");
// fclose($f);
//}

//set_error_handler("myErrorHandler");
// run query and log if raise exception
/*
function query($dbh, $query){
$result = ibase_query($dbh, $query);
if(ibase_errmsg() != ''){
echo('<hr>'.$query.'<br><b>Error: '.ibase_errmsg
().'</b><hr>');
}
return $result;
}
*/
// function return combobox from table with selected item
// TEST: echo get_combo('SELECT * FROM V_CATERING', 'CATERING', 'Self-
catering');
function get_combo($sql, $f_name, $selected, $f_key = '', $name='')
{
global $dbh;
if($f_key == ''){
$f_key = $f_name;
}

if ($name != '') {
$out = '<SELECT class="body" name="' . $name . '" type=>';
}else{
$out = '<SELECT class="body" name="' . $f_name . '"
type=>';
}

$result = ibase_query($sql);
if ($row = ibase_fetch_assoc($result)) {
do {
if ($row[$f_key] == $selected) {
$out .= '<OPTION value="'.$row[$f_key].'"
selected>' . $row[$f_name] . '</OPTION>';
} else {
$out .= '<OPTION value="'.$row[$f_key].'">' . $row
[$f_name] . '</OPTION>';
}
} while ($row = ibase_fetch_assoc($result));
}
$out .= '</SELECT>';
return $out;
}

function get_y_n($val){
if($val == strtoupper('Y')){
return '<OPTION value="Y" selected>Yes<OPTION
value="N">No';
}else {
return '<OPTION value="Y">Yes<OPTION value="N"
selected>No';
}
}

?>

--- In firebird-php@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> can we see dbcon.php
> Alan
> -----Original Message-----
> From: jason_panzera [mailto:jason@i...]
> Sent: Saturday, November 20, 2004 10:26 PM
> To: firebird-php@yahoogroups.com
> Subject: [firebird-php] PLZ HELP - I am lost
>
>
>
>
> Hay there,
>
> I have a problem, this form works perfectly well on two local
> machines, but on the server it only allows 1 person to signup and
> then I have to restart IIS so another user can register. I can't

see

> the prob here or on the server. PLZ HELP
>
> Jason
>
> <?php
> session_start();
> require_once 'dbcon.php';
> $registered=0;
> if ($_POST['submit']=='Register'){
> $query = "SELECT * from MEMBERS where EMAIL='".$_POST
> ['EMAIL']."'";
> $result = ibase_query($dbh, $query);
> $row = ibase_fetch_assoc($result);
> $email_exist = 0;
> if ($row[EMAIL] == $_POST['EMAIL']) $email_exist =
> 1;
> if ($email_exist == 0){
>
> if(($_POST['WEBPASSWORD'] != ($_POST['WEBPASSWORD_again']))
> || $_POST['WEBPASSWORD'] == ''){
> $msg = '<span class="sub_heading"><font
> color=red>Incorrect passord</font></span><br><br>';
> } else {
> /*
> //strip tags before enter data in db
> $_POST[VENUE] = addslashes(htmlspecialchars($_POST
> [VENUE]));
> $_POST[SURNAME] = addslashes(htmlspecialchars($_POST
> [SURNAME]));
> $_POST[NAME] = addslashes(htmlspecialchars($_POST
> [NAME]));
> $_POST[TELH] = addslashes(htmlspecialchars($_POST
> [TELH]));
> $_POST[CEL] = addslashes(htmlspecialchars($_POST
> [CEL]));
> $_POST[FAX] = addslashes(htmlspecialchars($_POST
> [FAX]));
> $_POST[EMAIL] = addslashes(htmlspecialchars($_POST
> [EMAIL]));
> $_POST[ADDRESS1] = addslashes(htmlspecialchars($_POST
> [ADDRESS1]));
> $_POST[ADDRESS2] = addslashes(htmlspecialchars($_POST
> [ADDRESS2]));
> $_POST[ADDRESS3] = addslashes(htmlspecialchars($_POST
> [ADDRESS3]));
> $_POST[ADDRESS4] = addslashes(htmlspecialchars($_POST
> [ADDRESS4]));
> $_POST[POSTAL1] = addslashes(htmlspecialchars($_POST
> [POSTAL1]));
> $_POST[POSTAL2] = addslashes(htmlspecialchars($_POST
> [POSTAL2]));
> $_POST[POSTAL3] = addslashes(htmlspecialchars($_POST
> [POSTAL3]));
> $_POST[POSTAL4] = addslashes(htmlspecialchars($_POST
> [POSTAL4]));
>
>
> $_POST[ID] = addslashes(htmlspecialchars($_POST[ID]));
> $_POST[OCCUPATION] = addslashes(htmlspecialchars
> ($_POST[OCCUPATION]));
> $_POST[TELW] = addslashes(htmlspecialchars($_POST
> [TELW]));
> $_POST[BANKNAME] = addslashes(htmlspecialchars($_POST
> [BANKNAME]));
> $_POST[BRANCHNAME] = addslashes(htmlspecialchars
> ($_POST[BRANCHNAME]));
> $_POST[BRANCHCODE] = addslashes(htmlspecialchars
> ($_POST[BRANCHCODE]));
> $_POST[BANKACCOUNT] = addslashes(htmlspecialchars
> ($_POST[BANKACCOUNT]));
> $_POST[ACCOUNTHOLDER] = addslashes(htmlspecialchars
> ($_POST[ACCOUNTHOLDER]));
> $_POST[ACCOUNTTYPE] = addslashes(htmlspecialchars
> ($_POST[ACCOUNTTYPE]));
>
>
> $_POST[DIRECTIONS] = addslashes(htmlspecialchars
> ($_POST[DIRECTIONS]));
> */
> $query = 'SELECT * from MEMBERS order by LINK desc';
> $result = ibase_query($dbh, $query);
> $row = ibase_fetch_assoc($result);
> $link_no = $row[LINK];
> $link_no++;
>
> $query = "INSERT INTO MEMBERS
> (LINK,SURNAME,NAME,TELH,CEL,FAX,EMAIL,ADDRESS1, ADDRESS2,
> ADDRESS3,ADDRESS4,ADDRESS5,";
>
> $query .= "POSTAL1,POSTAL2,POSTAL3,POSTAL4,MEMBERSHIPID,WEBPAS
> SWORD,VENUENAME) VALUES (".$link_no.",'".ucwords(substr($_POST
> ['SURNAME'], 0, 30));
> $query .= "', '".ucwords(substr($_POST['NAME'], 0,
> 30))."', '".substr($_POST['TELH'], 0, 30)."', '".substr($_POST
> ['CEL'], 0, 30);
> $query .= "', '".substr($_POST['FAX'], 0,
> 30)."', '".strtolower(substr($_POST['EMAIL'], 0, 36))."','".substr
> ($_POST['ADDRESS1'], 0, 30);
> $query .= "', '".substr($_POST['ADDRESS2'], 0,
> 30)."', '".substr($_POST['ADDRESS3'], 0, 30)."','".substr($_POST
> ['ADDRESS4'], 0, 30);
> $query .= "', '".substr($_POST['ADDRESS5'], 0,
> 30)."', '".substr($_POST['POSTAL1'], 0, 20)."', '".substr($_POST
> ['POSTAL2'], 0, 20);
> $query .= "', '".substr($_POST['POSTAL3'], 0,
> 20)."', '".substr($_POST['POSTAL4'], 0, 20)."', '".substr($_POST
> ['MEMBERSHIPID'], 0, 30)."', '".strtolower(substr($_POST
> ['WEBPASSWORD'], 0, 20))."','".substr($_POST['VENUE'], 0,

30)."')";

>
> //echo $query;
> $result=ibase_query($dbh, $query) or
> die('Database error. Please contact
> Administrator');
> //if (!mail("nedeljko@f...", "My
> Subject", "this is just test email\n")) echo error;
>
> $message = '
> <html>
> <head>
> <title>Wildfly - Confirm of
> membership</title>
> </head>
> <body>
> <br><strong>Welcome to
> Wildfly</strong>
> <br>
> <br>You are now a registered member
> of the Wildfly community, which depending on
> <br>what membership you have
> selected, will give you access to a wide range of different

benefits.

> <br>
> <br>
> <br><strong>Your Registrations
> Detials:</strong>
> <br> Email Address: '.$_POST
> ['EMAIL'].'
> <br> Password: '.$_POST
> ['WEBPASSWORD'].'
> <br>
> <br>
> <br>We hope you enjoy everything that
> WildFly has to offer and should you have
> <br>any questions or need anything in
> the world of fly fishing, please do not
> <br>hesitate to contact us.
> <br>
> <br>Please Do not reply to this email!
> <br>
> <br>
> <br>Regards,
> <br>Wildfly
> <br>
> <br>www.wildfly.co.za
> <br>Tel (033) 2666981
> <br>Fax (033) 2666981
> <br>Email: reservations@w...
> </body>
> </html>';
>
> $emailfrom
> = 'admin@w...';
> $emailto = $_POST
> ['EMAIL'].',gareth@w...,jason@w...';
> $subject = 'Wildfly -
> Confirmation of membership';
>
> $headers = "MIME-Version: 1.0
> \r\n";
> $headers .= "Content-type:
> text/html; charset=iso-8859-1\r\n";
>
> // additional headers
> $headers .= "To:
> $emailto\r\n";
> $headers .= "From:
> $emailfrom\r\n";
> $headers .= "Cc:\r\n";
> $headers .= "Bcc:\r\n";
> // and now mail it
>
> $query = "select * from
> members where ((EMAIL='" . $_POST['EMAIL'] . "') or (EMAIL='" .
> strtoupper($_POST['EMAIL']) . "')) and WEBPASSWORD='" . $_POST
> ['WEBPASSWORD'] . "'";
> $result = ibase_query
> ($dbh, "select * from members where ((EMAIL='" . $_POST
> ['EMAIL'] . "') or (EMAIL='" . strtoupper($_POST['EMAIL']) . "'))

and

> WEBPASSWORD='" . $_POST['WEBPASSWORD'] . "'");
> if ($row = ibase_fetch_assoc
> ($result)) {
> session_register('login');
> session_register
> ('member_id');
> $_SESSION['login'] = $row
> ['MEMBERSHIPID'];
> $_SESSION['member_id'] = $row
> ['LINK'];
>
> mail($emailto, $subject,
> $message, $headers);
> session_write_close();
> ibase_close($dbh);
> if ($row['MEMBERSHIPID']
> =="Fly Fisher") header("Location: club_rulesb.php");
> else header("Location:
> myadminvenue.php");
> }else {
> // not send email and
> password
> header('Location: join.php');
> }
> }
> }
> $registered = 1;
> }
> include('header.php');
> ?>
> <script src="js/check.js" type="text/javascript"></script>
> <script Language="JavaScript">
> function validateForm(theForm)
> {
> if (!validRequired(theForm.NAME,"Name")){return false;}
> if (!validRequired(theForm.SURNAME,"Surname")){return false;}
> if (!validRequired(theForm.CEL,"Cel")){return false;}
> if (!validRequired(theForm.WEBPASSWORD,"Password")){return false;}
> if (!isequal
> (theForm.WEBPASSWORD_again,theForm.WEBPASSWORD,"Passwords"))

{return

> false;}
> if (!validEmail(theForm.EMAIL,"Email Address",true)) return false;
> return true;
> }
> </script>
> <style type="text/css">
> <!--
> .style1 {font-weight: bold}
> -->
> </style>
> <link href="main.css" rel="stylesheet" type="text/css">
>
> <table width="770" border="0" align="center" cellpadding="6"
> cellspacing="0" class="lastest_catch_boarder">
> <tr>
> <td colspan="2" ><p align="right"><span class="heading">Join
> WildFly</span><br>
> <br>
> <span class="sub_heading"><span style="font-weight: bold"><a
> href="join.php" style="color: #000000">Membership Types</a> - <br>
> <a href="club_rules.php" style="color: #000000">Club
> Rules</a> - <br>
> <a href="mem_terms.php" style="color: #333333">Membership
> Terms & Conditions</a> - <br>
> <a href="reg.php" style="color: #000000">Signup Now</a> -
> </span></span> <strong><br>
> </strong> </p>
> <p>
>
> <?
> if ($email_exist == 1){
> //edit this part
> //you can close php, put html code and open again php
> echo 'Email exist in database';
> }
> if ($registered == 1) include('sponsors_h.php');
> $registered == 0;
> if (($_POST[submit]!='Continue')&&($_POST['submit']!='Register')){
> ?>
> <form name="newuser" action="<? 'PHP_SELF' ?>" method="post">
>
> <span class="sub_heading"> Registration Form </span><br>
> <br>
> <? print $msg ?>
> <table width="98%" border="0" align="center" cellpadding="4"
> cellspacing="0" bgcolor="eeeeee" class="main_boarder">
> <tr>
> <td nowrap>Registration Type </td>
> <td nowrap>
> <select name="MEMBERSHIPID" class="body" id="MEMBERSHIPID">
> <option value='Fly Fisher'>Fly Fisher</option>
> <option value="Venue">Venue</option>
> </select>
> </td>
> <td nowrap> </td>
> <td nowrap> </td>
> </tr>
> <tr>
> <td nowrap> </td>
> <td nowrap> </td>
> <td nowrap> </td>
> <td nowrap>
> <input name="submit" type="submit" class="body"
> value="Continue" id="sumbit">
> </td>
> </tr>
> <?
> include('sponsors_h.php');
> ?>
> </table>
> </form>
> <?
> };
> if ($_POST[submit]=='Continue'){
> ?>
> <form name="newuser" action="<? 'PHP_SELF' ?>" method="post"
> onsubmit="return validateForm(this)">
> <input type="hidden" name="MEMBERSHIPID" value='<?echo $_POST
> [MEMBERSHIPID];?>'>
>
> <span class="sub_heading"> Registration Form </span><br>
> <br>
> <? print $msg ?>
>
>
>
> <table width="98%" border="0" align="center" cellpadding="4"
> cellspacing="0" bgcolor="eeeeee" class="main_boarder">
>
> <tr>
> <td colspan="4" nowrap><strong>New Registraton</strong></td>
> </tr>
> <tr>
> <td nowrap>Email Address*<br>
> </td>
> <td nowrap><input name="EMAIL" type="text" class="body"
> id="EMAIL"></td>
> <td nowrap>First Name*</td>
> <td nowrap><input name="NAME" type="text" class="body"
> id="NAME"></td>
> </tr>
> <tr>
> <td nowrap>Password*</td>
> <td nowrap><input name="WEBPASSWORD" type="password" class="body"
> id="WEBPASSWORD"></td>
> <td nowrap>Last Name* </td>
> <td nowrap><input name="SURNAME" type="text" class="body"
> id="SURNAME"></td>
> </tr>
> <tr>
> <td nowrap>Confirm Password*</td>
> <td nowrap><input name="WEBPASSWORD_again" type="password"
> class="body" id="WEBPASSWORD_again"></td>
> <td nowrap>Tel</td>
> <td nowrap><input name="TELH" type="text" class="body"
> id="TELH"></td>
> </tr>
> <td nowrap>Fax</td>
> <td nowrap><input name="FAX" type="text" class="body"
> id="FAX"></td>
> </tr>
> <tr>
> <td nowrap>Comanpy Name (if aplicable) </td>
> <td nowrap><input name="VENUE" type="text" class="body"
> id="VENUE"></td>
> <td nowrap>Cell*</td>
> <td nowrap><input name="CEL" type="text" class="body"
> id="CEL"></td>
> </tr>
> <tr valign="top">
> <td nowrap>Physical Address<br></td>
> <td nowrap><input name="ADDRESS1" type="text"
> class="body" value="<? echo $row['ADDRESS1']; ?>"></td>
> <td nowrap>Postal Address*</td>
> <td nowrap><input name="POSTAL1" type="text" class="body"
> value="<? echo $row['POSTAL1']; ?>"></td>
> </tr>
> <tr valign="top">
> <td nowrap> </td>
> <td nowrap><?
> print get_combo('SELECT * FROM TOWNS ORDER BY
> TOWN', 'TOWN','', '','ADDRESS2');
> ?></td>
> <td nowrap> </td>
> <td nowrap><?
> print get_combo('SELECT * FROM TOWNS ORDER BY
> TOWN', 'TOWN', '', '','POSTAL2');
> ?></td>
> </tr>
> <tr valign="top">
> <td nowrap> </td>
> <td nowrap><?
> print get_combo('SELECT * FROM V_PROVINCES
> ORDER BY PROVINCES', 'PROVINCES', '', '','ADDRESS3');
> ?></td>
> <td nowrap> </td>
> <td nowrap><?
> print get_combo('SELECT * FROM V_PROVINCES
> ORDER BY PROVINCES', 'PROVINCES', '', '','POSTAL3');
> ?></td>
> </tr>
> <tr valign="top">
> <td nowrap> </td>
> <td nowrap> <input name="ADDRESS4"
> type="text" class="body" size="8" value="<? echo $row

['ADDRESS4']; ?

> >"></td>
> <td nowrap> </td>
> <td nowrap> <input name="POSTAL4"
> type="text" class="body" size="8" value="<? echo $row

['POSTAL4']; ?

> >"></td>
> </tr>
> <tr valign="top">
> <td><div align="left">Country</div></td>
> <td colspan="3" nowrap>
> <?
> print get_combo('SELECT * FROM V_COUNTRY ORDER BY
> COUNTRY', 'COUNTRY', '', '','COUNTRY');
> ?>
> </td>
> </tr>
> <tr>
> <td nowrap>
> <input name="submit" type="submit" class="body"
> value="Register" id="sumbit">
> </td>
> <td nowrap> </td>
> <td nowrap> </td>
> <td nowrap> </td>
> </tr>
> <?
> include('sponsors_h.php');
> ?>
> </table>
> </form>
> <?
> }
> ?>
> </td>
> </tr>
>
> </table>
> <?php
> include('footer.php')
> ?>
>
>
>
>
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
>
> --------------------------------------------------------------------

--------

> --
> Yahoo! Groups Links
>
> a.. To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-php/
>
> b.. To unsubscribe from this group, send an email to:
> firebird-php-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of

Service.

>
>
>
> [Non-text portions of this message have been removed]