Jump to content


Photo

Need help with MySQL


  • Please log in to reply
2 replies to this topic

#1 Brain In Vat

Brain In Vat
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 30 April 2006 - 08:13 AM

This is the code I am using:

<?php
$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: 'user@delta.sitelutions.com' (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: 'user@delta.sitelutions.com' (Using password: YES)

I changed some things for security purposes.

#2 Brain In Vat

Brain In Vat
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 30 April 2006 - 08:48 AM

I made a couple of changes and now I get the 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 '='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?

#3 .josh

.josh
  • Staff Alumni
  • .josh
  • 14,871 posts

Posted 30 April 2006 - 09:35 AM

well first off, your sql statement is missing WHERE

$sql = "select lname from experiment where fname='Jouko'";


Did I help you? Feeling generous? Buy me lunch! 
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