Add &amp; Delete Issues

Add & Delete Issues

scrypte

Ok having trouble updating and deleting a record. here is the coding:

    $sql = "SELECT * FROM friends WHERE `userid_1`='$userid'  &&  `status`='1'";
   $result = @mysql_query($sql) or die("couldn't execute query  $sql.".mysql_error());
   while($row = mysql_fetch_array($result)) {
      $friend1=$row{'userid_2'};
      $friendindex=$row{'index'};
   $sql2 = "SELECT * FROM users WHERE `userid`='$friend1'";
   $result2 = @mysql_query($sql2) or die("couldn't execute query .".mysql_error());
   while($row = mysql_fetch_array($result2)) { 
   		$username1=$row{'username'};
   		echo "<tr><td width=150><a href=viewprofile.php?id=$friend1>$username1</a></td><td class=text align=right>[ <a href=profile.php?index=$friendindex&addme=approve>approve</a> ]</td><td class=text align=right>[ <a href=profile.php?index=$friendindex&addme=deny>deny</a> ]</td></tr>\n";
	}
}
if ($friend=="approve") {
if ($index > 0) {
$status = 2;
$sql = "UPDATE friends SET status=\"$status\ WHERE `index`='$friendindex';";
$r = mysql_query($sql);
} Else {
if ($friend=="deny") {
if ($index > 0) {
$status = 2;
$sql = "DELETE FROM friends WHERE `index`='$friendindex';";
$r = mysql_query($sql);
} Else {
Exit;
}
}
}
}

any help would be greatly appreciated

Rodney_H_

Maybe try this for update:

$sql = "UPDATE friends SET status='$status' WHERE index='$friendindex' ";

And this for delete:

$sql = "DELETE * FROM friends WHERE index='$friendindex' ";

scrypte

could the problem be how I am calling this script?

profile.php?index=$friendindex&friend=deny

Rodney_H_

Oh, try this:

<?php

if ($_GET['friend'] == 'approve') {
// do stuff
}

else if ($_GET['friend'] == 'deny') {
// do other stuff
}

else {
// do something else
}

?>

scrypte

ok for some reason its still not functioning

here is the link I am using:

<a href=profile.php?friend=approve>approve</a>

and here is the coding


$sql = "SELECT * FROM friends WHERE userid_1='$userid' AND status='1'";
$r = mysql_query($sql);
while ($arr = mysql_fetch_array($r)) {
	$friend1 = $arr['userid_2'];
	$indexvar = $arr['index'];
$sql = "SELECT * FROM users WHERE userid='$friend1'";
$r = mysql_query($sql);
while ($arr = mysql_fetch_array($r)) {
	$username1 = $arr['username'];
      echo "<tr><td width=150><a href=viewprofile.php?id=$friend1>$username1</a></td>\n";
      echo "<td class=text align=right>[ <a href=profile.php?friend=approve>approve</a> ]</td>\n";
      echo "<td class=text align=right>[ <a href=profile.php?friend=deny>deny</a> ]</td></tr>\n";
	}
}
if ($_GET['friend'] == "approve") { 
	$sql = "UPDATE friends SET status = '2' WHERE index = '$indexvar'";
	$r = mysql_query($sql);
} 
else if ($_GET['friend'] == "deny") { 
	$sql = "DELETE FROM  friends WHERE index = '$indexvar'";
	$r = mysql_query($sql);
} 
else {}

If you know what could possibly be wrong please tell me

Rodney_H_

Ok. But back up for one second. In your query,

$sql = "SELECT * FROM friends WHERE userid_1='$userid' AND status='1'";

Where are you getting the "$userid" variable value from???

scrypte

that is a session variable established by cookie

Rodney_H_

Sorry, scrypte, I was trying to do too many things at once..

Try this:

<?php
$sql = "SELECT * FROM friends WHERE userid_1='$userid' AND status='1'";

$r = mysql_query($sql);
while ($arr = mysql_fetch_array($r)) {
    $friend1 = $arr['userid_2'];

$sql = "SELECT * FROM users WHERE userid='" . $friend1 . "'";
$r = mysql_query($sql);
while ($arr = mysql_fetch_array($r)) {
    $username1 = $arr['username'];
	$index = $arr['index']; 
      echo '<tr>
	  <td width="150"><a href="viewprofile.php?id=' . $friend1 . '">' . $username1 . '</a></td>
      <td class="text" align="right">[ <a href="profile.php?friend=approve&index=' . $index . '">approve</a> ]</td>
      <td class="text" align="right">[ <a href="profile.php?friend=deny&index=' . $index . '">deny</a> ]</td>
	  </tr>' . "\n";
    }
}

// get friend action from q-string:
if(isset($_GET['friend'])){
	$action = $_GET['friend'];
}
if(isset($_GET['index'])){
	$index = $_GET['index'];
}

if ($action == "approve") { 
    $sql = "UPDATE friends SET status = '2' WHERE index = '" . $index . "'";
    $r = mysql_query($sql);
} 
else if ($action == "deny") { 
    $sql = "DELETE FROM  friends WHERE index = '" . $index . "'";
    $r = mysql_query($sql);
} 
else {}  

?>

scrypte

nah unfortuneately its still not working for some god aweful reason that i dont understand what so ever

Rodney_H_

Please post all of the code. Not just the snippet you are concerned with.

scrypte

ok you got it lol

it wont let me post the full page of code so i'll give you a link to a zip file with it in it Click here for Profile.php

Here is the full code lol

scrypte

ignore the inane comments like

 and such i did that when i copied and pasted everything

scrypte

here is the error:

couldn't execute query UPDATE friends SET status='2' WHERE index = '21'.You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'index = '21'' at line 1

here is the coding:

   $sql = "SELECT * FROM friends WHERE `userid_1`='$userid'  &&  `status`='1'";
   $result = @mysql_query($sql) or die("couldn't execute query  $sql.".mysql_error());
   while($row = mysql_fetch_array($result)) {
      $friend1=$row{'userid_2'};
      $index1=$row{'index'};
   $sql2 = "SELECT * FROM users WHERE `userid`='$friend1'";
   $result2 = @mysql_query($sql2) or die("couldn't execute query .".mysql_error());
   while($row = mysql_fetch_array($result2)) { 
   		$username1=$row{'username'};      

 echo "<tr>\n";  

 echo "<td width=150><a href=viewprofile.php?id=$friend1>$username1</a></td> \n";
 echo "<td class=text align=right>[ <a href=profile.php?index=$index1&approved=true>approve</a> ]\n"; echo "</td>\n";
 echo "<td class=text align=right>[ <a href=profile.php?index=$index1&deny=true>deny</a> ]</td> \n";
 echo "</tr>\n"; 
	}
}
if ($index > 0) {
if ($approved=="true") {
$sql = "UPDATE friends SET status='2' WHERE index = '$index'";
$result = mysql_query($sql) or die("couldn't execute query  $sql.".mysql_error());
} Else {
Exit;
}
}
if ($index > 0) {
if ($deny=="true") {
$sql = "DELETE FROM friends WHERE index = '$index'";
$result = mysql_query($sql) or die("couldn't execute query  $sql.".mysql_error());
} Else {
Exit;
}
}

does anyone know why im getting this error?

qadeer_ahmad

Hi,
Is index is numeric field then use this query like this

$sql = "UPDATE friends SET status='2' WHERE index = $index";

also same for status if it is also a numeric field. thne ur query is

$sql = "UPDATE friends SET status=2 WHERE index = $index";

scrypte

i figured out the problem

since index is a reserved variable by MySQL i had to change the field to id in the database and then parse that information.

it works now thanks