deleting an entry? what am i doign wrong?
Posted: Sat Jan 24, 2004 8:48 am
Code: Select all
<?php
$sql1="delete from crews where name ='". $crew ."'";
?>A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
<?php
$sql1="delete from crews where name ='". $crew ."'";
?>Code: Select all
<?php
$sql1 = "DELETE FROM crews WHERE name ='". $crew ."'";
echo $sql1;
?>Code: Select all
<?php
include("checklogin.php");
include("connect.php");
$sql="select crew from game where name ='". $_COOKIE[access] ."'";
$rs=mysql_query($sql,$conn)
or die("could not execute query1");
$row= mysql_fetch_array($rs);
$crew=$row[crew];
echo($crew);
$sql="select leader,r1,r2,r3,r4 from crews where name ='". $crew ."'";
$rs=mysql_query($sql,$conn)
or die("could not execute query2");
$row= mysql_fetch_array($rs);
$r1=$row[r1];
$r2=$row[r2];
$r3=$row[r3];
$r4=$row[r4];
$leader=$row[leader];
if ( $leader == $_COOKIE[access] )
{
if ($_POST[choice] == "yes")
{
$sql1="update game set crew = '' where name ='". $_COOKIE[access] ."'";
$rs1=mysql_query($sql1,$conn)
or die("could not execute query");
$r1 = explode(",", $r1);
$size1 = count($r1);
$ri = 1;
while( $i < $size1 )
{
$sql1="update game set crew = '' where name ='". $r1[$i] ."'";
$rs1=mysql_query($sql1,$conn)
or die("could not execute query");
}
$r2 = explode(",", $r2);
$size2 = count($r2);
$i = 1;
while( $i < $size2 )
{
$sql1="update game set crew = '' where name ='". $r2[$i] ."'";
$rs1=mysql_query($sql1,$conn)
or die("could not execute query");
}
$r3 = explode(",", $r3);
$size3 = count($r3);
$i = 1;
while( $i < $size3 )
{
$sql1="update game set crew = '' where name ='". $r3[$i] ."'";
$rs1=mysql_query($sql1,$conn)
or die("could not execute query");
}
$r4 = explode(",", $r4);
$size4 = count($r4);
$i = 1;
while( $i < $size4 )
{
$sql1="update game set crew = '' where name ='". $r4[$i] ."'";
$rs1=mysql_query($sql1,$conn)
or die("could not execute query");
}
$sql1="delete from crews where name ='". $crew ."'";
echo($sql);
$rs1=mysql_query($sql1,$conn)
or die("could not execute query");
$result="Crew disbanded";
}
}
else
{
$result="Only the leader can disband!";
}
?>