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 Link to comment https://forums.phpfreaks.com/topic/3827-php-and-mysql-inserting-data-into-sentinel/ 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.. Link to comment https://forums.phpfreaks.com/topic/3827-php-and-mysql-inserting-data-into-sentinel/#findComment-13288 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.