Jump to content

Archived

This topic is now archived and is closed to further replies.

Brain In Vat

Need help with MySQL

Recommended Posts

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.

Share this post


Link to post
Share on other sites
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?

Share this post


Link to post
Share on other sites
well first off, your sql statement is missing WHERE

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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.