Weird...

[Anon]

Hello.
This is my processing code from submitting data via a form...but the strange thing is, is that this doesn\\'t come up with ANY error nor is it successful. I really don\\'t know why, priviledges etc are all set, any help appreciated.

<?php

if (!$name || !$rank || !$icq)
{
echo \\"You have not filled in all of the details.<BR>\\"
.\\"Please go back and try again.\\";
exit;
}

$name = addslashes($name);
$rank = addslashes($rank);
$icq = addslashes($icq);

@ $db = mysql_pconnect(\\"localhost\\", \\"user\\", \\"pass\\");

if(!$db)
{
echo \\"Unable to connect to database!\\";
exit;
}

mysql_select_db(\\"df2\\");
$query = \\"INSERT INTO members values (\\'\\".$name.\\"\\', \\'\\".$rank.\\"\\', \\'\\".$icq.\\"\\')\\";
$result = mysql_query($query);

if ($result)
echo mysql_affected_rows().\\" member inserted into list.\\";

?>

[jbnew]

When you submit html from a form into a php script, it separates all of the quotes with slashes to preserve the string.

The explode and implode functions must be used to correct this.

$noslash = explode("\", $input);
$newinput = implode("", $noslash );

[Anon]

Actually, I think the problem lies in querying the DB. It does not return a result and that would explain why nothing appears on the page. When I change:
if($result) to if(!$result) then this appears on the page:

-1 member inserted into list.

I have no clue why...cries lol