40
Hi
I am currently setting up a script so that it inserts information into one table and then follows onto the next few lines and checks to see if the user already has a row in a different table if not the script should insert into the database, if the user already has a row it will update the information by adding the numbers to the ones currently stored in the database.
At present I am testing the second SQL insert which does not work? I'm not worried about the update just (I think I know how I will sort this out).
Can anyone see what I am doing wrong please?
[PHP]
// Includes the connection details to the database
virtual('/cbagsv2/connections/dbasecon.php');
mysql_select_db($dbase, $connection);
//SQL Insert for the scorecard database table, inserting all details
$sql="INSERT INTO scorecard (user,course,date,score,coursepar,adjustscore,
stablefordpoints,holein1,eagle,birdie,par,bogey,
other,dblbogey,hole1,hole2,hole3,hole4,hole5,
hole6,hole7,hole8,hole9,hole10,hole11,hole12,
hole13,hole14,hole15,hole16,hole17,hole18) VALUES ('$name','$course','$date','$totalscore','$totalpa r',
'$addjustscore','$stableford','$hole1','$eagle','$ birdie',
'$par','$bogey','$dblbogey', '$other','$hole_1_score',
'$hole_2_score','$hole_3_score','$hole_4_score',
'$hole_5_score','$hole_6_score','$hole_7_score',
'$hole_8_score','$hole_9_score', '$hole_10_score',
'$hole_11_score','$hole_12_score','$hole_13_score' ,
'$hole_14_score' ,'$hole_15_score','$hole_16_score',
'$hole_17_score','$hole_18_score')";
if (!mysql_query($sql,$connection))
{
die('Error: ' . mysql_error());
}
else
{
echo "<p>Statistics successfully added to the scorecard database.</p>";
}
//Checks the totalstats db table to see if the user already exists in the table and also checks if the year is the same
$sqlselect = "SELECT * FROM totalstats WHERE name = '$name' AND year = '$year'";
if($result = mysql_db_query($sqlselect, $connection))
{
if(mysql_num_rows($result))
{
}
else
{
$queryInsert = "INSERT INTO totalstats (name,holein1,eagle,birdie,par,bogey,dblbogey,othe r,sablefordpoints,year) VALUES ('$name','$hole1','$eagle','$birdie','$par','$boge y','$dblbogey','$other','$stableford','$year')";
if (!mysql_db_query($queryInsert, $connection))
{
die('Error: ' . mysql_error());
}
else
{
echo "<p>Statistics successfully added to the Statistics database.</p>";
}
}
}
[/PHP]
Here is the contents of the connection file: its only on a testing server locally to my machine so don't have a go at me for using the username and password as root. lol
[PHP]
//Constants saves repeating data, usernames etc throught the pages.
$dbuser = "root";
$pw = "root";
$dbase = "cbags";
$db = "localhost";
//connection string
$connection = mysql_connect($db, $dbuser, $pw);
[/PHP]
Thank you in advance fr your help.
Tom
