Query error (access denied through mysql_query)

doctortim

Hi people

Just having a small problem with querying the databse from my insert.php form.

When I submit the form from my create.php to the insert.php file, It connects to the database and then I get the following error:

Warning: mysql_query() [function.mysql-query]:
Access denied for user 'ODBC'@'localhost' (using password: NO)
in C:\wamp\www\sites\*****\admin\professional\blog\pro_blog_insert_new.php
on line 22

Warning: mysql_query() [function.mysql-query]:
A link to the server could not be established in
C:\wamp\www\sites\*****\admin\professional\blog\pro_blog_insert_new.php
on line 22

line 22 is the result/mysql query line as follows

$result = mysql_query($sqlQuery);

I have read that sometimes you need a link identifier in the mysql_querry argument. Tried that with the argument ($sqlQuery, $db), just gave new problem with the function argument.

Is there a problem I'm missing?

PS in case you need to see, here is my connection file again. (that is where $db comes from)

<?php

$user = "root";
$passwd = "******";

// Connecting to and selecting a database
$connect = mysql_connect('localhost', $user, $passwd)
   or die('Could not connect: ' . mysql_error());
echo '<b>Step 1:</b> Connected successfully! <BR>';

$db = '*******_website';
mysql_select_db($db) or die('Could not select database ('.$db.') because of : '.mysql_error());
echo '<b>Step 2:</b> Connected to ('.$db.') successful!<BR>';

// Now we close the connection...
mysql_close($connect);

?>

bradgrafelman

Are you sure the connection file is being included successfully? The error message is saying that you didn't connect to the SQL server before you attempted to execute a query. Try doing a var_dump() on $connection. If that doesn't lead you to the solution, can you show us where you load the connection file in pro_blog_insert_new.php as well as the code around line 22?

Also, $db in the code above is not a link identifier, it's just a string of text. The link identifier is what is returned by the [man]mysql_connect/man function.

doctortim

Displaying in browser after pressing submit and linking to the insert page:

Step 1: Connected successfully!
Step 2: Connected to (*******_website) successful!

Warning: mysql_connect() [function.mysql-connect]:
Access denied for user 'ODBC'@'localhost' (using password: NO)
in C:\wamp\www\sites\*******\admin\professional\blog\pro_blog_insert_new.php
on line 22

Warning: mysql_query():
supplied argument is not a valid MySQL-Link resource in
C:\wamp\www\sites\*******\admin\professional\blog\pro_blog_insert_new.php
on line 22

My connection file has some echoes that come up if the 2 step connection was successful. You can see them above the errors. So this should mean the connection file is not the problem.

Here is some of the code surrounding line22

<?php include_once("include/connect_sql.inc.php"); ?>
<?php
	// Retreiving Form Elements from Form
	$issue_no = addslashes($_REQUEST['issue_no']);
	$issue_date = addslashes($_REQUEST['issue_date']);
	$focus = addslashes($_REQUEST['focus']);
	$toc = addslashes($_REQUEST['toc']);
	$article = addslashes($_REQUEST['article']);
	$resource_link_1 = addslashes($_REQUEST['resource_link_1']);
	$link_descrip_1 = addslashes($_REQUEST['link_descrip_1']);
	$resource_link_2 = addslashes($_REQUEST['resource_link_1']);
	$link_descrip_2 = addslashes($_REQUEST['link_descrip_2']);
	$resource_link_3 = addslashes($_REQUEST['resource_link_1']);
	$link_descrip_3 = addslashes($_REQUEST['link_descrip_3']);
	$resource_link_4 = addslashes($_REQUEST['resource_link_1']);
	$link_descrip_4 = addslashes($_REQUEST['link_descrip_4']);
	$resource_link_5 = addslashes($_REQUEST['resource_link_1']);
	$link_descrip_5 = addslashes($_REQUEST['link_descrip_5']);

$sqlQuery = "INSERT INTO *************** (issue_no, issue_date, focus, toc, article, resource_link_1, link_descrip_1,  resource_link_2, link_descrip_2, resource_link_3, link_descrip_3, resource_link_4, link_descrip_4, resource_link_5, link_descrip_5, created )
	VALUES ('$issue_no' , '$issue_date' , '$focus' , '$toc' , '$article' , '$resource_link_1' , '$link_descrip_1' , '$resource_link_2' , '$link_descrip_2' , '$resource_link_3' , '$link_descrip_3' , '$resource_link_4' , '$link_descrip_4' , '$resource_link_5' , '$link_descrip_5' , NOW());";
$result = mysql_query($sqlQuery, mysql_connect());
?>

doctortim

Also could the mysql_close function be a problem, in essence it seems the connection is being closed before the query executes, and so mysql thinks the query is coming from the unauthorized default windows user??

NogDog

Get rid of the mysql_close() command in your connection script. It doesn't do much good to open up a connection if you then close it before doing any queries.
Get rid of the mysql_connect() argument in your mysql_query() command. The 2nd argument is optional and only needed to select between multiple opened connections, which is very rarely needed; and in any case with no arguments to the mysql_connect() command you're going to get a failed connection.

bradgrafelman

NogDog wrote:
1. Get rid of the mysql_close() command in your connection script. It doesn't do much good to open up a connection if you then close it before doing any queries.

Oops... didn't even notice that...

NogDog

bradgrafelman wrote:
Oops... didn't even notice that...

And I'm still only using my left eye. 😉