Simple query question ?

[fla5h]

If I wanted to return the thread starters userid what would I use ?


I used

$firstpostinfo=$DB_site->query_first("SELECT userid FROM post WHERE threadid='$threadid' ORDER BY dateline LIMIT 1");

in showthread.php

but it didn't work ?

Is the code wrong, or shouldn't it be in showthread ?

Thanks

Fla5h

[NTLDR]

Where are you trying to put this and where do you want it to appear?

[fla5h]

I'm putting this in showthread.php

just after

while ($post=$DB_site->fetch_array($posts) and $counter++<$perpage) {

I want it to return the userid so I can test it against the userid opening the thread.

Like on here where we have the titles big at the top, I want a different template showing to the normal member than the member that posted the thread.

Got the template location etc sorted, just cannot get the condition statement working

if ($firstpostinfo==$bbuserinfo[userid]) {

eval("\$threadheader = \"".gettemplate("showthread_member_header")."\";");

} else {

eval("\$threadheader = \"".gettemplate("showthread_poster_header")."\";");

}

So am wondering if the first query is correct ?

Is there a way of debugging php etc, say a step through the code line by line ?

Thanks

Fla5h

[NTLDR]

The query for getting the userid of the thread starter is:

$starter = $DB_site->query_first("SELECT postuserid FROM thread WHERE threadid='$threadid'");

And then use $starter[postuserid] to access the userid for the thread starter.

[fla5h]

Stunning m8

thanks a lot, that worked a treat.

[gmarik]

How is this made? http://www.thesistersthree.com/showepisode.ts3?s=&season=6#episode6x16

[Chris M]

How is this made? http://www.thesistersthree.com/showepisode.ts3?s=&season=6#episode6x16
Using PHP & MySQL ;)

Satan

[NTLDR]

How is this made? http://www.thesistersthree.com/showepisode.ts3?s=&season=6#episode6x16

Not that it has anything to do with this thread, but it was written by me for TS3.