problems with mysql & php4 pages after mysql upgrade

"Brent Bailey" <[email protected]>
Newsgroups gmane.comp.db.mysql.bugs
Message-ID <017901c39732$fa2d0800$3303a8c0@brentb>
Dear sirs
 
I recently upgraded the version of mysql im using to 3.23.58
Before the upgrade we were using some web pages written with php4 to
track abuse complaints and such from our customers.
However now after the upgrade the pages will view the data from the
mysql database  but from the website I cant edit or delete any of the
data.
But I can do it from the command line as well as phpMyAdmin. The error
im getting is 
"Cant Query"
when I go to use the edit or delete functions of the website
 
 
the code im using (which has work all along until after the upgrade) is
this is the submit page code that connects and submits and queries mysql
 
<?php
 
    $sql= "INSERT INTO abuse(offendingip, cmmac, cpemac, location,
username, typeofabuse, actiontaken, openclose) VALUES ('$offe
ndingip','$cmmac','$cpemac','$location','$username','$typeofabuse','$act
iontaken','$openclose')";
        $connect = mysql_connect("localhost","blah","blah" ) or die
("Can't connect to server");
        $db = mysql_select_db("abuse", $connect) or die ("Can't connect
to the Data Base");
        $sql_result = mysql_query($sql, $connect) or die ("Can't execute
query");
 
 
For whatever reason it seems that I can view the data but that's it
 
Any and all help is VERY appreciated
 
Brent Bailey CCNA 
High Speed Data Services 
MetroCast Cablevision 
603-332-8629 ext:242 
[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.