[Resolved] php-mysql problem

[mitjakac]

something stupid :-)

What is wrong with next expresion?

$contdel = "DELETE FROM contact WHERE cont_id='$contd'";

$result = mysql_query($contdel);

I think that something about php or mysql version, becose this simple code worked earlier...

I simplified this and still nothing.
Thanks in advance.
MiTja

[devinemke]

what does [man]mysql_error[/man] have to say?

[mitjakac]

OK, I didn't explain all.

I conclude that this part is the problem becose I don't have any other explanation:
When I put this code on page and send cont_id, it give me nothing on page.

$contd = $HTTP_GET_VARS['cont_id'];

$contdel = "DELETE FROM contact WHERE cont_id='$contd'";

$result = mysql_query($contdel);

if (!$result) {
echo "Error";
} else {
echo "Contact deleted sucsesfuly";
}

MiTja

[devinemke]

set error_reporting(E_ALL) then try again

[mitjakac]

I still geting empty page??!!!

When I remove mysql query (delete from....) I have result, so I think that something is wrong with that part.

Is there maybe some changes with delete sentence in new version of mysql, becose this worked on other page earlier.

MiTja

[tsinka]

Hi,

please post more code (including the mysql_connect part).

Additionally, create a phpinfo() page and check if a mysql section exists. Did you upgrade from MySQL 4.0.x to MySQL 4.1.x ?

Thomas

[mitjakac]

Hi Thomas,

I build whole site with 30 pages in php, php version is 4.3.10,

I connect with database with 'include file' (baza.php), and with other files work fine.

I use many sql queries (select, update) and everything is working fine.

I didn't use delete query anywhere.

MiTja

[Weedpacket]

Originally posted by mitjakac
I didn't use delete query anywhere.

You mean, apart from the place where you're having the problem.

[tsinka]

Please post the complete script as attachment.

[mitjakac]

Yes, it's a first time I use this script on a site.

I will post a file, so you can check it.

You must know the following:
1. script for conection with databse is working fine with other

2. this file is called from one page, and page name is stored in mysql table, but there is no problem with that

3. script is working with '$contd = $HTTP_GET_VARS['cont_id'];' and when I delete other script and leave just this part with 'echo $contd' it's work, so there is no problem with variable

......

Thanks in advance,
MiTja

[tsinka]

Ok,

one problem:

You need to escape all double quotes in the echo statements (including the ones enclosing the class values).

Thomas

[mitjakac]

The last thing doesn't solve the problem!!!?

I am sure that something is wrong with SQL statement...

Anybody????

MiTja

[tsinka]

Let's try a different script:

<?PHP
    error_reporting(E_ALL);
    $contd = isset($_GET['cont_id']) ? $_GET['cont_id'] : "";
    echo "GET parameter cont_id is: ".$contd."<br>\n";
    flush();

if (preg_match('§^[0-9]+$§',$contd)) {
    $contcount = 'SELECT COUNT(*) AS cnt FROM contact';
    $result = mysql_query($contcount) or die('Error SELECT: '.mysql_error());
    $row = mysql_fetch_assoc($result);
    echo "Count: ".$row['cnt']."<br>\n";
    flush();

    $contdel = "DELETE FROM contact WHERE cont_id=".$contd;
    $result = mysql_query($contdel) or die('Error DELETE: '.mysql_error());
    echo "record with cont_id=".$contd." deleted<br>\n";
    flush();
} else {
    echo "Invalid cont_id<br>\n";
}
?>

Thomas

[mitjakac]

It is working!!!!

Tsinka, thank you very much.

Can you give me simple explanation about what was wrong?

I don't see it!!

Again, thank you.

MiTja