Need help with queries....

lady

I'm relatively familiar with php/mysql, but I'm pulling my hair out over this one.

I have a few questions.

How to pull data from my database.
How to implement the Rating module (is this a star rating or a G, PG rating?).
Star rating modules for stories.

I have a writing community. On their user pages I would like to show information about them, the comments they made, stories (with topic, comments, views, and rating) they made. As well as links for them to add and read more.

I can get the word links in and the information about them, but for the life of me I can not get the stories to show how I want them.

Wouldn't the SELECT WHERE clause work? I would love any help any one could give me. And I have read the manuel along with a thousand other things, but can not find out how to do this.

Thank you in advance! 🙂

Best,
Lady

_SuperString

Its all down to your database design/structure, if you have your data stored in a relational manner then I see no problem with doing this. Can you maybe post a DB schema (table/fields names and datatypes etc) and details of what you what to retrieve.

lady

Thank you for replying...

This is what I'm trying to retrieve...

function user_sub($uname)
{
$pntable = pnDBGetTables();
list($dbconn) = pnDBGetConn();
$column = &$pntable['stories_column'];
include "stories.php";
/
Fetch active laguage
*/
if (pnConfigGetVar('multilingual') == 1) {
$querylang = "AND (".$column['alanguage']."='".pnVarPrepForStore(pnUserGetLang())."' OR "
.$column['alanguage']."='') ";
} else {
$querylang = '';
}

/*
 *  Build up SQL
 */
$query = "SELECT ".$column['sid'].", "
                  .$column['title'].", "
	.$column['comments'].", "
                  .$column['counter']." "
        ."FROM ".$pntable['stories']." "
        ."WHERE ".$column['informant']."='".pnVarPrepForStore($uname)."' "
                .$querylang
        ."ORDER BY ".$column['sid']." DESC";

/*
 *  Make limited select
 */
$result = $dbconn->SelectLimit($query);

/*
 *  Do output
 */
OpenTable();
echo "<font class=\"pn-title\">"._SUBMISSIONS." ".pnVarPrepForDisplay($uname).": </font><br>";
while "(list('$sid, $title, $comments, $counter') = $result->fields)" {

    $result->MoveNext();
    If (!$title)  {
        $title = '- no Title -' ;
    }
    echo "<li><a class=\"pn-normal\" href=\"modules.php?op=modload&name=News&file=article&sid=$sid\">" . pnVarPrepForDisplay($title) . "</a><br>";
	echo "<li><a class=\"pn-normal\" href=\"modules.php?op=modload&name=News&file=article&sid=$sid\">" . pnVarPrepForDisplay($comments) . "</a><br>";
	echo "<li><a class=\"pn-normal\" href=\"modules.php?op=modload&name=News&file=article&sid=$sid\">" . pnVarPrepForDisplay($counter) . "</a><br>";
}
CloseTable();

}

The db schema is: sid, catid, aid, title, time, hometext, bodytext, comments, counter, topic, informant, notes .....
with sid as primary

This information is all from one table. What am I doing wrong?

(This is also after all the bio information - which does fine, and the comments, which are fine, and the user login information - again fine. I just can't get the story part to show)

Thank you again!
Lady