[SOLVED] function not working right

[darkfreaks]

ok so this function is giving me this.

Warning: mysql_query() [function.mysql-query]: Access denied for user 'kabooc'@'localhost' (using password: NO) in /home/kabooc/public_html/func.lib.php on line 5

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/kabooc/public_html/func.lib.php on line 5

 

the code is:

 

<?php

function fetch($query) {
return mysql_query(mysql_fetch_array($query));

}?>

any help debugging this would be appreciated

 

[premiso]

Read the error. You need to make sure you have permissions setup for the user kabooc not using a password on your mysql database.

 

It is not the function at all.

[darkfreaks]

that user has all permissions for that database

 

some of the other functions require config.inc.php to connect i tried that and it still threw the error which i believe it has to be the function. ???

[Maq]

that user has all permissions for that database

 

Are you sure?  Cause that error usually means 1 thing...

 

Could you log in to mysql with root and do "show users;" (or w/e the command is) and see if kabooc is set up with all privileges for your local server?

[premiso]

Does the query work outside of the "fetch" function you created?

 

Before you use the "fetch" are you getting a good connection to the database. Honestly if the query works outside than you should try passing the dblink or making it global to the function and using that.

 

But if the mysql_query does not work outside of the function the issue lies within your database username/password privileges.

[trochia]

1) Are you using a "canned script" (modules) for some of this?

 

2) Are you on a "shared" enviorment?

 

3) If you're uploading to #2, and you don't have the ability to "CHMOD", you'd run into this.

 

4) If you can't "change" r-w perm's w.it..this would possibly be it, again?

 

 

[premiso]

1) Are you using a "canned script" (modules) for some of this?

 

2) Are you on a "shared" enviorment?

 

3) If you're uploading to #2, and you don't have the ability to "CHMOD", you'd run into this.

 

4) If you can't "change" r-w perm's w.it..this would possibly be it, again?

 

 

 

Hes not doing a file upload. He is just trying to query from his database....

[darkfreaks]

this function worked fine until i used  include_once to call another file. so something is messing it up. the script is global anyhow.ill have to find a way to rewrite it ugh. :-\

[Maq]

It should work.  I use a class that I include in all my files.  I create an object of that class that handles queries, connections etc...

 

Yours should still work.

[premiso]

Look at the file you are including and see if you are resetting the mysql_connection in it, or if it is being reset. That is what seems to be happening imo.

[darkfreaks]

i see the problem in both scripts the connection variable is $con 

[premiso]

could mysql_close($connection) kill it even if $connection is defined to another database. ???

 

Possibly, if you are using multiple connections, I would highly suggest using $connection in the mysql_query as the second parameter.

 

<?php

function fetch($query) {
global $connection;
return mysql_fetch_array(mysql_query($query, $connection));

}?>

 

Also I just noticed that you had the fetch_array in the wrong spot, and also note that without the while loop this will only ever return the first array value.

 

function fetch($query) {
    global $connection;
    $result = mysql_query($query, $connection);
    while ($row = mysql_fetch_array($result)) {
          $return[] = $row;
    }
    return $return;
}

 

That will return the multi-dimm array with the results.

[darkfreaks]

ok now i get  "failed to open file no such file or directory on line 478"

 

 

code:

 

<?php
$lines = file($inj_path . $file);?//line 478>

[premiso]

You need to post more code, but obviously the $inj_path. $file does not link to a file. Print it out and see what it contains and why it does not work.

 

Without more code this would be impossible to debug.

[Maq]

If you want to switch databases, instead of closing the connection each time, just select a different one:

 

mysql_select_db('new_db');
mysql_close(); //closes everything...  don't specify a DB

[darkfreaks]

<?php
$inj_path = '';
$file="exploits.txt";
$lines = file($inj_path . $file);//dont work
?>