delete query returns no echo and doesn't delete

Question

Post reply

delete query returns no echo and doesn't delete

ksenia 76064

Newbie

Points: 3
More actions
June 22, 2012 at 11:20 am

#262767

<?php
if($errors == 0)
{
echo "success1!";
$DBConnect = @mysql_connect("db.start.ca", "nokeekwe", "1rcPass");
if($DBConnect === FALSE)
{
echo "Unable to connect. " .
"Error code " . mysql_errno() . ": " .
mysql_error() . "";
$errors++;
}
else
{
echo "success2!";
$DBName = "nokeekwe";
$result = @mysql_select_db($DBName, $DBConnect);
if($result === FALSE)
{
echo "Unable to select DB. " .
"Error code " . mysql_errno($DBConnect) .
": " . mysql_error($DBConnect) .
"";
$errors++;
}
}
}
if($errors > 0)
{
echo "Please use your browser's BACK button" .
" to return to the form and fix your errors.";
}
echo "success3!";
if($errors == 0)
{
echo "success4!";
if(isset($_COOKIE['jobID']))
{
$TableName = "tbljobs";
$SQLstring = "DELETE * FROM $TableName WHERE $TableName.jobID = {$_COOKIE['jobID']}";
$QueryResult = @mysql_query($SQLstring, $DBConnect);
echo "success5!" . $_COOKIE['jobID'] . "";
if($QueryResult === FALSE)
{
echo "Unable to save your review. " .
" Error code " .
mysql_errno($DBConnect) . ": " .
mysql_error($DBConnect) . "";
$errors++;
}
else
{
echo "success!";
}
}
}
}
}
?>
Server version: 5.1.50-log
Protocol version: 10
MySQL client version: 5.0.27
Used PHP extensions: mysql
returns blank page

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323755 More actions · Answer 1

not sure how many posters here will be familiar enough to debug php and mysql functions;

with luck there might be a few folks out of the huge group of volunteers, but

there might be other forums better suited for this question than for SQL server.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!