[RESOLVED] Help with SELECT

[theyapps]

I've been fighting with this all day reading forums and the what not but with no luck.
I am trying to formulate a MySQL Query to read some info from my phpbb3's data base to put it on my home page. I want to select all rows where forum_id=10 from the 'phpbb_topics' table.

What I have now:

$link = mysql_connect('localhost', 'user', 'pass');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo '<!--Connected successfully-->';

// Formulate Query
$query = sprintf("SELECT * FROM phpbb_topics WHERE forumid=10",
    mysql_real_escape_string($firstname),
    mysql_real_escape_string($lastname));

// Perform Query
$result = mysql_query($query);

// Check result
// This shows the actual query sent to MySQL, and the error. Useful for debugging.
if (!$result) {
    $message  = 'Invalid query: ' . mysql_error() . "\n";
    $message .= 'Whole query: ' . $query;
    die($message);
}

// Use result
while ($row = mysql_fetch_assoc($result)) {
    echo $row['topic_id'];
}

// Free the resources associated with the result set
// This is done automatically at the end of the script
mysql_free_result($result);
mysql_close($link);

Error returned

Invalid query: Unknown column 'forumid' in 'where clause' Whole query: SELECT * FROM phpbb_topics WHERE forumid=10

[djjjozsi]

go to phpmyadmin, and see the id field's name in you topics table.

forumid is not in your forum_topics table.

and change this:

$query = sprintf("SELECT * FROM phpbb_topics WHERE forumid=10",
mysql_real_escape_string($firstname),
mysql_real_escape_string($lastname));

into

$query = "SELECT * FROM phpbb_topics WHERE forumid=10",

i know that would be safer, but if you use it bad, that won't work..