jawinn

[quote author=fenway link=topic=110407.msg446343#msg446343 date=1159910890] Then go with a UNIQUE index. [/quote] How do I add that to my script?

This is an empty DB.  I will be empting it weekly and eventually daily.  I want to prevent ANY duplicates for a specific column.

I have a web form that dumps form data into a DB. One of the fields is for email address. I would really like the form to kick back an error message if an email address is used that is already in the DB. My DB only has one table. What would the code be for that? Thanks in advance, J

That did it!  Thanks a bunch. J

I want to be able to change the header of a page in order to redirect users to a thankyou.php page.  Here's my setup.  I have index.php that has a form on it.  The form uses a processor called answer.php.  The processor sends the form's data to a database.  I used to just have the form data emailed to me and the users were successfully redirected to the thankyou.php page.  I want to be able to have the form data sent to the DB AND redirect the visitors to the thank you page.  Is there anything different I need to do with my original headers to make this happen.  If I need to post the code just let me know. thanks in advance,

Thanks printf.  Sorry but I am just beginning with PHP and MySQL.  Should I just insert the code above into my script?  Are there any elements I should keep from my original script? thanks in advance

Ok, here's my next problem.  I want to be able to add records to a MySQL table via a web form. Here is my form code: <form method="post" action="answer.php" /> First Name&nbsp;&nbsp;&nbsp;Last Name<br> <input type="text" name="fname" /><input type="text" name="lname" /><br/><br> City&nbsp;&nbsp;&nbsp;State<br> <input type="text" name="city" /><select name="state" /> <option>Alabama</option> <option>Wyoming</option> </select><br/><br> E-mail Address<br> <input type="text" name="email" /><br/><br> Answer: <input type="radio" name="answer" value="A" /> A<input type="radio" name="answer" value="B" /> B<input type="radio" name="answer" value="C" /> C<input type="radio" name="answer" value="D" /> D<br/> <input type="checkbox" name="remember" value="1" />Remember Me<br/><br/> <input type="submit" name="submit" value="Submit" /> </form> Here is my processor code: <?php   include('conn.php');     $error = false; if(isset($_POST['submit'])) { $form = array(); $form['fname'] = $_POST['fname']; $form['lname'] = $_POST['lname']; $form['email'] = $_POST['email']; $form['city'] = $_POST['city']; $form['state'] = $_POST['state']; $answer = $_POST['answer']; if(!ini_get('magic_quotes_gpc')) { // Build safe query values string foreach($form as $key => $value) { $form[$key] = mysql_escape_string($value); } } $query = "INSERT INTO centries (fname,lname,email,city,state,answer) VALUES ('{$form['fname']}', '{$form['lname']}', '{$form['email']}', '{$form['city']}','{$form['state']}', '{$form['answer']}',)"; $result = $database->query($query); ?> Every time I submit the form I get this error: Parse error: parse error, unexpected $ in /xxx/xxx/xxx/xxx/answer.php on line 29 Any help is much appreciated. Thanks in advance, Jawinn

Thanks for the quick responses guys.  It turns out that I was confusing my DB name for the table name.  I was using the DB name for both.

I'm trying to connect to a Godaddy MySQL DB using PHP. This is not a remote connection. This is on a shared account. Here is the code I'm trying to use. I have to be missing something. <?php // set your infomation. $hostname='server.servername.net'; $username='name'; $password='password'; $dbname='dbname'; // connect to the mysql database server. $link_id = mysql_connect ($hostname, $username, $password); echo "success in database connection."; // select the specific database name we want to access. $dbname=$username."_".$dbname; if (!mysql_select_db($dbname)) die(mysql_error()); echo "success in database selection."; // add a table to the selected database $result="CREATE TABLE address_book (first_name VARCHAR(25), last_name VARCHAR(25), phone_number VARCHAR(15))"; if (mysql_query($result)){ echo "success in table creation."; } else { echo "no table created."; } ?> I keep getting in the browser: success in database connection.Access denied for user: 'name@%' to database 'dbname_dbname' Any help is much appreciated.