with it no good

[nhatrang]

Hi guys,

I have 4 sql queries command, but for some reason, with the last one, it doesn't work, but when i take it out, it worksl ike charm... can somebody help me?


<? $lilet_db = mysql_query("SELECT title,threadid,firstpostid,forumid FROM localhost_vbnews.thread WHERE forumid IN $channels AND attach <>0 AND title !='$et[title]' ORDER BY dateline DESC limit 30") or die(mysql_error());
while($lilet = mysql_fetch_array($lilet_db)) {

$lilpost_db = mysql_query("select pagetext from localhost_vbnews.post WHERE postid=$lilet[firstpostid]") or die(mysql_error());
while($lilpost = mysql_fetch_array($lilpost_db)) {
$liletatt_db = mysql_query("SELECT attachmentid,userid FROM localhost_vbnews.attachment WHERE postid=$lilet[firstpostid] ORDER BY dateline DESC limit 1") or die(mysql_error());
while($liletatt = mysql_fetch_array($liletatt_db)) {
$position_db = mysql_query("SELECT pagetext FROM localhost_vbnews.post WHERE threadid=$lilet[threadid] AND title='position' ORDER BY dateline DESC limit 1") or die(mysql_error());
while($position = mysql_fetch_array($position_db)) {

$post = substr($lilpost[pagetext], 0, 98);
$title = substr($lilet[title], 0, 25);
echo " <div class=\"box\"><a href=\"page.php?et=$lilet[firstpostid]&ch=$lilet[forumid]&desc=$liletatt[attachmentid]\" style=\"text-decoration:none;\">
<img src=\"/show_image.php?filename=./images/attach/$liletatt[userid]/$liletatt[attachmentid].attach&pos=$pos&width=243&height=98\" width=\"243\" height=\"98\" alt=\"$lilpost[pagetext]\" /></a>
<h5>$title</h5>
<p>$post</p>
<a href=\"page.php?et=\" style=\"text-decoration:none;\"><img src=\"layout/more.png\" alt=\"$lilet[title]\" width=\"39\" height=\"9\" /></a>
</div>";
} } }


This is the query that throws it off... i'm not sure why :(

The thing for sure is that, not all threads has replies with title "position"... could this be the problem?

Here is the one that I'm having a hard time on

$position_db = mysql_query("SELECT pagetext FROM localhost_vbnews.post WHERE threadid=$lilet[threadid] AND title='position' ORDER BY dateline DESC limit 1") or die(mysql_error());
while($position = mysql_fetch_array($position_db)) {

Thank you in advance.

[Opserty]

Well the query will only return threads that have the exact title 'position', vB adds "RE:" to replies by default so you may only return a small number of entries.

I don't really know what you are trying to achieve but you could just remove the AND title='postion'

[nhatrang]

well, I wanted one query to pull out a thread with the title exactly like position...

[Marco van Herwaarden]

It might be due to language, but 'exactly' and 'like' are 2 words that contradict.

If you want the title to be exactly 'position':
..WHERE title = 'postition'...
If you want the title to contain the word 'position':
...WHERE title LIKE '%position%'