a strange little search result bug...

vaska

where's WeedPacket? hope he's off enjoying the sun in the carribean or something nice like that...such a helpful person...

i have a question too...

i have this query...i'm using to search things...but EVERY time...it returns an empty set of values first...and then the data...the data is correct, but i don't understand why i get the empty set too...

the query looks like this...

$query_s = mysql_query ("SELECT DISTINCT title,text,date,id FROM main WHERE (title LIKE '%$text%' or text LIKE '%$text%') ORDER BY date DESC " ) or die ("Wrongo!");

if the above isn't clear...this is what i get...say it return 3 results...

result (empty)
result 1
result 2
result 3

any ideas? thanks...jv

milind24

can u paste the code , how u fetching and printing the record

vaska

yeah...here it is...pretty simple...jv

<?php do {?>
            <tr> 
              <td height="21" class="unnamed3a"><? print $row_s['udate']; ?></td>
              <td class="unnamed3a"><a href="prev_entry.php?id=<? print $row_s['id']; ?>"><? print $row_s['title']; ?></a></td>
              <td class="unnamed3a"><? print $row_s['section']; ?></td>
              <td class="unnamed3a"><? print $row_s['status']; ?></td>
            </tr>
            <tr> 
              <td colspan="4" bgcolor="#CCCCCC"><img src="imgs/spcr.gif" width="10" height="1"></td>
            </tr>
            <?php } while($row_s = mysql_fetch_array($query_s));?>
            <tr align="right">

diego25

Use a while loop instead of a do-while loop.

Diego

gtibok

Please don't call me an idiot but why do you search all fileds DISTINCT?
shouldn't be only one DISTINCT?

vaska

distinct? huh? it works...

how would you structure the "while" loop?

thanks...jv

diego25

Same way.

<?
while($row_s = mysql_fetch_array($query_s)) {
  ?><tr> 
              <td height="21" class="unnamed3a"><? print $row_s['udate']; ?></td>

          <td class="unnamed3a"><a href="prev_entry.php?id=<? print $row_s['id']; ?>"><? print $row_s['title']; ?></a></td>

          <td class="unnamed3a"><? print $row_s['section']; ?></td>

          <td class="unnamed3a"><? print $row_s['status']; ?></td>

        </tr>

        <tr> 
          <td colspan="4" bgcolor="#CCCCCC"><img src="imgs/spcr.gif" width="10" height="1"></td>

        </tr>
 <? } ?>

Diego

vaska

that works great...but...i don't understand why that made the difference? is there a some easy explanation as to why that works better than before?

thanks...jv

diego25

In a do-while loop, the body of the loop is executed first, no matter what, and THEN it checks the while() statement. Therefore, in your do-while loop, it would try to output $row_s['whatever'] first, BEFORE the while statement is executed (which defines $row_s). Therefore you get an empty row at the beginning. In my while loop, $row_s is defined first, and then it's outputted.

Diego