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]