Hello peeps,
I am proud of myself. With the help of this forum, Codewalkers and a few good books I have managed to get a web page to add records to a web based database. No mean feat when you consider a few short weeks ago I thought Perl and PHP were the same thing…
I want to select and delete records of the database now but I always get an error akin to this:
Parse error: parse error in /home/.sites/3/site227/web/data/TUK/delete.php on line 3
I don’t have the first clue what is going wrong, here is my code:
<?php
if (isset($_POST[‘submit’])){
$db = mysql_connect(“localhost”, “user”, “password”) OR die mysql_error();
mysql_select_db(“database”,$db) OR die mysql_error();
function escape_data ($data){
global $db;
if (ini_get(‘magic_quotes_gpc’)){
$data = stripslashes ($data);
}
return mysql_real_escape_string($data, $db);
}
$message = NULL;
if (empty($_POST[‘selectedrecord’])){
$u = FALSE;
$message = ‘<P>Enter company</P>’;
} else {
$u = escape_data($_POST[‘selectedrecord’]);
}
if ($u){
$query = “SELECT record_id FROM tuk_members WHERE (company_name=’$u’)”;
$result = @mysql_query ($query);
$num = mysql_num_rows ($result);
if ($num == 1){
$row = mysql_fetch_array($result, MYSQL_NUM);
$query = “DELETE FROM tuk_members WHERE record_id=$row[0]”;
$result = @mysql_query ($query);
}
}
?>
<form action ="<?php echo $_SERVER[‘PHP_SELF’]; ?>" method=“post”>
<P>Enter Company:<input type=“text” name=“selectedrecord” value="<?php if (isset($_POST[‘selectedrecord’])) echo $_POST[‘selectedrecord’]; ?>" /></P>
<input type=“submit” name=“submit” value=“submit”/>
Can anyone help??
AH