SQL Query Read

[TheInsaneManiac]

Hello. I am trying to make this script work, but for some reason it is not. I am trying to read from the DB to find a users customprofilepic filename. So far it's not working to well. Ideas?

$db->query_read("SELECT filename FROM " . TABLE_PREFIX . "customprofilepic WHERE userid='".$row[0]."'");

[Eikinskjaldi]

Well firstly you dont need to quote numeric variables.

Secondly you dont tell us about the nature of the not working.

Thirdly, and I will take a completely blind stab, are you using fetch_rows after the read_query?

[TheInsaneManiac]

Originally Posted by Eikinskjaldi

Well firstly you dont need to quote numeric variables.

Secondly you dont tell us about the nature of the not working.

Thirdly, and I will take a completely blind stab, are you using fetch_rows after the read_query?

Basically it is going to fetch the filename of a profile picture for a specific user. This filename is going to be displayed inside of an img source tag.

[sockwater]

1. What is the exact error it gives you?
2. Are you certain $row[0] contains a valid userid? Use die($row[0]); to check.
3. Don't quote the integer value.
4. Are you sure $db is in scope?
5. What hook are you doing this on?

$userid = (int) $row[0];
die($userid); // use this for a sanity check...
$db->query_read("
        SELECT filename 
        FROM " . TABLE_PREFIX . "customprofilepic 
        WHERE userid = $userid
");