Please Help

Hello All,

I am new to PHP and am trying to write a script to UPDATE/INSERT data to a database with a php script. As of right now, it will UPDATE records in the datbase when I load the page, but will not insert any new records

Here is a brief look at the code, hopefully someone can help clean it up for me so that it works...

// Get all the data from the "example" table
$result3 = mysql_query("SELECT * FROM picksheet WHERE Week=$cw ORDER BY user_name")
or die(mysql_error());

echo "<table border='1'<td class='v8'>" ;

echo "<tr><th>PoolMeister</th> <th>$pass[Favorite] $pass[Spread] $pass[Underdog]</th><th>$pass[Favorite2] $pass[Spread2] $pass[Underdog2]</th> <th>$pass[Favorite3] $pass[Spread3] $pass[Underdog3]</th> <th>$pass[Favorite4] $pass[Spread4] $pass[Underdog4]</th> <th>$pass[Favorite5] $pass[Spread5] $pass[Underdog5]</th> <th>$pass[Favorite6] $pass[Spread6] $pass[Underdog6]</th> <th>$pass[Favorite7] $pass[Spread7] $pass[Underdog7]</th> <th>$pass[Favorite8] $pass[Spread8] $pass[Underdog8]</th> <th>$pass[Favorite9] $pass[Spread9] $pass[Underdog9]</th> <th>$pass[Favorite10] $pass[Spread10] $pass[Underdog10]</th> <th>$pass[Favorite11] $pass[Spread11] $pass[Underdog11]</th> <th>$pass[Favorite12] $pass[Spread12] $pass[Underdog12]</th> <th>$pass[Favorite13] $pass[Spread13] $pass[Underdog13]</th> <th>$pass[Favorite14] $pass[Spread14] $pass[Underdog14]</th> <th>$pass[Favorite15] $pass[Spread15] $pass[Underdog15]</th> <th>$pass[Favorite16] $pass[Spread16] $pass[Underdog16]</th><th>TB</th><th> Total Wins</th></tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result3 )) {
// Print out the contents of each row into a table

$Winner=0;
$Ties=0;
$Losses=0;
$Game1Winner=" ";
$Game2Winner=" ";
$Game3Winner=" ";
$Game4Winner=" ";

// if/then/else Example
if (($pass[FavScore]-$pass[Spread]) > ($pass[UndScore])) {
($Game1Winner="$pass[Favorite] -$pass[Spread]");
} elseif (($pass[FavScore] -$pass[Spread]) < ($pass[UndScore])) {
// notice that PHP uses "elseif" instead of Perl's "elsif"
($Game1Winner="$pass[Underdog] +$pass[Spread]");
} else {
($Game1Winner='Tie');
}

if (($pass[FavScore2]-$pass[Spread2]) > ($pass[UndScore2])) {
($Game2Winner="$pass[Favorite2] -$pass[Spread2]");
} elseif (($pass[FavScore2] -$pass[Spread2]) < ($pass[UndScore2])) {
// notice that PHP uses "elseif" instead of Perl's "elsif"
($Game2Winner="$pass[Underdog] +$pass[Spread2]");
} else {
($Game2Winner='Tie');
}

echo "<tr><td class='v8'>";
echo $row['user_name'];

//Game 1
if ($pass[FavScore]==0 and $pass[UndScore]==0)
{
echo '<TH bgcolor="white">';
}
elseif (($pass[FavScore] )==($pass[UndScore] +$pass[Spread]))
{
echo '<TH bgcolor="silver">';($Ties==$Ties++);

}
elseif (($pass[FavScore] +$pass[Spread])==$pass[UndScore])
{
echo '<TH bgcolor="silver">';($Ties==$Ties++);

}
elseif ($row['Game01']=="$Game1Winner")
{
echo '<TH bgcolor="lightgreen">';($Winner==$Winner++);
}
elseif ($row['Game01'] <>"$Game1Winner")
{
echo '<TH bgcolor="red">';($Losses==$Losses++);

}
echo $row['Game01'];

$sel4="select *from Standings";

$result4=mysql_query($sel4);

echo "$Winner";
while($array = mysql_fetch_array($result4)){
//print out the field values and values using print_r
echo '<pre>';
print_r($array);
echo '</pre>';
$num4 = mysql_num_rows($result4);

if ($num4!= 0)
{
$up="UPDATE Standings set W$cw='$Winner', L$cw='$Losses', T$cw='$Ties' where user_name='$row[user_name]'";
if (!mysql_query($up))
{
die('Error: ' . mysql_error());
}

}
else
{

$sql4="INSERT INTO Standings ( user_name, W$cw, L$cw, T$cw)
VALUES
('$row[user_name]','$Winner','$Losses','$Ties')";
if (!mysql_query($sql4))
{
die('Error: ' . mysql_error());
}
}
}
}

echo "</table>";

If there are records already in database, they will get updated, but nothing new will be inserted?

Any help would be great!

Patsman77

$result4 = mysql_query($sel4);
$i = 0;

// In this while -loop you get the data to a new table
// that is easier to handle because it is organised
while( $aTmpRow = mysql_fetch_array($result4) ) {
// Set the array
$aStand[$i]["User Name"] = $aTmpRow["user_name"];
// If you only need the user name data, you don't have
// to add the other columns
$aStand[$i]["Other Data"] = $aTmpRow["other_data"];
$i++;
}

$r=0;
$update = 0;
// This while goes thru all the records in the standings
// table
while($r<count($aStand)) {

if($aStand[$r]["User Name"] == $row["user_name"] ) {
// For a user (from $row) the script finds in the db
// it updates the data for that user
// SQL UPDATE
$update = 1;
}
$r++;
}

if( $update == 0 ){
// If the script doesn't find any users that match the
// Standings -user, it inserts a new record
// INSERT
}

Please Help

new to php

patsman77

deMorte

patsman77

patsman77

patsman77

deMorte

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week