Need help with MySQL
Posted 30 April 2006 - 08:13 AM
$dbh=mysql_connect ("localhost", 'user', "password") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("user_data", $dbh);
$sql = "select lname from experiment fname='Jouko'";
$result = mysql_query ($sql) or die (mysql_error().$sql);
$b_row = mysql_fetch_array($result);
This is the result:
Warning: mysql_connect(): Access denied for user: 'firstname.lastname@example.org' (Using password: YES) in /home/bill5040/public_html/Test/sql.php on line 2
I cannot connect to the database because: Access denied for user: 'email@example.com' (Using password: YES)
I changed some things for security purposes.
Posted 30 April 2006 - 08:48 AM
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 '='Jouko'' at line 1select lname from experiment fname='Jouko'
How do I find the manual that correspond to my MySQL server? How do I find out my MySQL server version?
Posted 30 April 2006 - 09:35 AM
$sql = "select lname from experiment where fname='Jouko'";
Please, take the time and do some research and find out how much it would have cost you to get your help from a decent paid-for source. A "roll-of-the-dice" freelancer will charge you $5-$15/hr. A decent entry level freelancer will charge you around $15-30/hr. A professional will charge you anywhere from $50-$100/hr. An agency will charge anywhere from $100-$250/hr. Think about all this when soliciting for help here. Think about how much money you are making from the work you are asking for help on. No, we do not expect you to pay for the help given here, but donating a few bucks is a fraction of the cost of what you would have paid, shows your appreciation, helps motivate people to keep offering help without the pricetag, and helps make this a higher quality free-help community
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users