can't find problem
Posted: Mon Apr 30, 2007 2:14 pm
I can't get my code to attach to the database, can't someone help me?
Code: Select all
<?
include "connect.phtml";
$db=delranfire_org;
if(isset($_POST['select'])){
$query1="insert into members(flname,pass,email)values('$select','$flname','$pass','$email')";
mysql_db_query($db,$query1,$connection) or die("Error in query:$query. " .mysql_error());
}//end if
?>
<html>
<head>
<title>
<?
include "admin_panel_title.php";?>
</title>
</head>
<body bgcolor="#000000" text="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" link="#FF3333" vlink="#CC0000" alink="#CC0000">
<form action="addmember.phtml" method="post">
<center>
<img src="/newadmin/Administration_Panel_Banner.png"><br>
<h3>Add a Member</h3>
<table border="1" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="47%" align="center" valign="middle">
<div align="right"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="2">First & Last Name: </font></b></div>
</td>
<td width="51%" valign="middle">
 <INPUT TYPE="text" NAME="flname" SIZE="30"></INPUT>
</td>
</tr>
<tr>
<td width="47%" align="center" valign="middle">
<div align="right"><font face="Verdana, Arial, Helvetica, sans-serif"><b><font size="2">Password: </font></b></font></div>
</td>
<td width="51%" valign="middle">
 <INPUT TYPE="text" NAME="pass" SIZE="30"></INPUT>
</td>
</tr>
<tr>
<td width="47%" align="center" valign="middle">
<div align="right"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><b>EMail Address: </b></font></div>
</td>
<td width="51%" valign="middle">
 <INPUT TYPE="text" NAME="email" SIZE="30"></INPUT>
</td>
</tr>
<tr>
<td colspan="3">
<div align="center">
<input type="submit" name="Submit" value="Add Member">
<input type="reset" name="reset" value="Clear Information">
</div>
</td>
</tr>
</table>
</form>
<a href="/newadmin/">Back to Administration Panel</a>
</body></html>
<?
mysql_close();
?>