gingercrock Posted March 1, 2006 Share Posted March 1, 2006 hey, i am currently building a basic website to get the feel for using mySql and so on.. i have a registration form from which i wish the data entered by the user to enter into a database i have.. however, i have tried various different attempts to get this working but i am failing each time.. here is my code:[i]<?php $connection = mysql_connect("sentinel.cs.cf.ac.uk","scm5sjc","my_password_here"); mysql_select_db("sjcdb",$connection)or die("failed!"); $title="title"; $first="first"; $last="last"; $age="age"; $subject="subject"; $year="year"; $email="email" mysql_query("INSERT INTO info values('NULL', '$title','$last','$age',$subject','$year','$email')",$connection); mysql_close(connection);?>[/i]This page is named 'display.php' and is linked up by the registration form 'main.php'.. once the submit button is pressed, however on the website "https://www.cs.cf.ac.uk/phpMyAdmin/index.php" where my database is, no data is entered.. any help would be great!!! thanks Steven Quote Link to comment Share on other sites More sharing options...
shocker-z Posted March 1, 2006 Share Posted March 1, 2006 change:mysql_query("INSERT INTO info values('NULL', '$title','$last','$age',$subject','$year','$email')",$connection);for:mysql_query("INSERT INTO info values('NULL', '$title','$last','$age',$subject','$year','$email')",$connection) OR die(mysql_error());and paste what error it has.. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.