mrwebbie
-
Posts
3 -
Joined
-
Last visited
Never
Posts posted by mrwebbie
-
-
Hmm, and to totally cop to my ignorance, how would I do that?
-
Okay, a little background. I didn't write these databases or create the php pages. So, you'll need to be gentle with me. :) I know enough to be dangerous, but I'm mainly just a maintainer here...not a designer.
Anyway, I was recently moved to an upgraded server by my host, and in the process, we went ahead and upgraded to PHP 5.0. I have two databases with 5 applications running off of one and one off of the other. Everything is working just fine on the database with the multiple applications, but on the other database, I have a problem with two functions.
The first searchs for a record so it can be updated. You can get to a point where you can choose the record you want, but when you do, this is the error you get:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Here is the code in line 1 --
<?php require_once('Connections/julian.php'); ?>
Okay, the second error is from a page that functions similar to the one above but it will actually delete a record. Again, you can get to a point where you can select the record you want to delete, but then you get this error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and clients.advocate_id = advocates.advocate_id and clients.race_id = race.race_' at line 1
Here is the code in line 1 --
<?php require_once('Connections/julian.php'); ?>
Obviously, even a noob like me can see that the line 1 thing may not be the issue. So, I'm really at a loss. It is just weird that these are the only two things that are giving me any problems.
So please help! :)
Nick
Moved to new server and upgraded to PHP5 .... now I have two errors!
in PHP Coding Help
Posted
Here is the copy of the connection file: (I've X'd out the username and password)
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_julian = "localhost";
$database_julian = "juliancenter_org_-_vawa";
$username_julian = "XXXXXXXX";
$password_julian = "XXXXXXXX";
$julian = mysql_pconnect($hostname_julian, $username_julian, $password_julian) or die(mysql_error());
?>
I'm so confused :)