Cant insert data

Lovebev1

my registration page at www.hoopstart.com/registration.php is not letting me insert data. The error message on the bottom of the page. Looking at my page is it possible anybody can tell me why?

BobLennon

Can you post a small sample of the code that demonstrates this error?

Maybe enabling the error outputs with some code like this may help:

ini_set('display_errors',1);
error_reporting(E_ALL & ~E_NOTICE);

Also, if you are using a MySQL database to check the registration you should use the mysql_error() function to get more details.

Lovebev1

$sql_result = mysql_query($sql,$connection) or die ('Could not insert data');

BobLennon

Lovebev1 wrote:
$sql_result = mysql_query($sql,$connection) or die ('Could not insert data');

Your call to mysql_query has two arguments. It should only have one. That will cause the die phrase to print out the error you see on the page.

rincewind456

BobLennon wrote:
Your call to mysql_query has two arguments. It should only have one. That will cause the die phrase to print out the error you see on the page.

Sorry but your wrong two parameters can be passed through mysql_query
they are:

Parameters

query
A SQL query

The query string should not end with a semicolon.

link_identifier
The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect() is assumed. If no such link is found, it will try to create one as if mysql_connect() was called with no arguments. If by chance no connection is found or established, an E_WARNING level warning is generated.

bodzan

Show us the querry you're trying... And show us the error you're getting...

BTW: rincewind456 is right...

Lovebev1

Staill having trouble inserting data. Message reads: Could not insert data due to

Here is my code.
<?php
//Connect
$link = mysql_connect('localhost', 'hoopstar_test', 'test') or die(mysql_error());

$db_selected = mysql_select_db('hoopstar_HoopStartRegistration', $link);
if (!$db_selected) {
die ('Can\'t use hoopstar_HoopStartRegistration: ' . mysql_error());
}

$query= "INSERT INTO hoopstar_HoopStartRegsitration.001(RegNo,FirstName1,LastName1,Age1,Sex1,DOB,ShirtSize1,FirstName2,LastName2,Age2,
DOB2,Sex2,ShirtSize2,FirstName,LastName,Address,City,State,Zip,DayPhone,EvePhone,CellPhone,Other,Email,
NameCard,CardNo,ExpDate,CardType,School,Cost) VALUES('$RegNo','$FirstName1','$LastName1','$Age1','$Sex1','$DOB',
'$ShirtSize1','$FirstName2','$LastName2','$Age2','$DOB2','$Sex2','$ShirtSize2','$FirstName','$LastName','$Address',
'$City','$State','$Zip','$DayPhone','$EvePhone','$CellPhone','$Other','$Email','$NameCard', '$CardNo','$ExpDate',
'$CardType','$School','$Cost')" ;

mysql_query($query,$link) or die ('Could not insert data due to ' . mysql_error());

echo('Thank you for registering with HoopStart.com.');
?>

bodzan

Follow BobLennon's first advice, but turn error reporting to the maximum level:

 ini_set('display_errors',1);
error_reporting(E_ALL);

Just to ensure showing off all errors and notices...

On the other issue do I read your code right? You table name is hoopstar_HoopStartRegsitration.001? I figure maybe there is a typo in there - shoudn't it be hoopstar_HoopStartRegistration.001? Notice 's' in Registration part...

I figure that the table name is 001 and the rest is database name and I really would avoid naming database in the query when the connection is established by calling the database. There would be no error in just calling the 001 as a table name...