include("include.php");
$pageName= "listfavorites.php";
if ( !$userLoggedIn )
{
header( "location: login.php");
exit;
}
else
{
$usUserName = $userLoggedIn;
}
if ( count($HTTP_POST_VARS) )
{
switch( $submit )
{
case "Add New Favorite":
$sql = "
INSERT INTO
favorites ( favName, favUrl, favUserName, favShowMain,
favPassword, favComments, usUserName, favCategory )
VALUES
( '$newFavName', '$newFavUrl', '$newFavUserName', '$newFavShowMain',
'$newFavPassword', '$newFavComments', '$usUserName', '$newFavCategory' )
";
if ( !($result = mysql_query($sql,$conn)) ) DBErr($sql, $conn);
break;
case "Save Changes":
if ( is_array($delete) )
{
while ( list ($favId, $dataList ) = each ( $delete ) )
{
$sql = "
DELETE FROM favorites WHERE favId = '$favId'
";
// echo("sql - $sql
");
if ( !($result = mysql_query($sql,$conn)) ) DBErr($sql, $conn);
unset( $favOldShowMain[$favId]);
unset( $favShowMain[$favId]);
}
}
if ( is_array($favOldShowMain) )
{
while ( list ($favId, $data ) = each ( $favOldShowMain ) )
{
// echo("old - $favOldShowMain[$favId], new - $favShowMain[$favId]
");
if ( ($favOldShowMain[$favId] !="Y" && $favShowMain[$favId] == "Y" ) ||
($favOldShowMain[$favId] =="Y" && $favShowMain[$favId] != "Y" ) )
{
if ( $favShowMain[$favId] == "Y" )
$showmain = "Y";
else
$showmain = "N";
$sql = "UPDATE favorites SET favShowMain = '$showmain'
WHERE favId = '$favId'
";
if ( !($result = mysql_query($sql,$conn)) ) DBErr($sql, $conn);
}
}
}
break;
case "Show Category":
break;
}
if ( $category == "None" || $category == "None" )
$showCat = "";
else
$showCat = $category;
}
?>
Inner Athlete - Create a training program