Missing row

[tranquillo]

hey... I must be doing something wrong... I just don't know what... to me it don't seem logical at all... the code that is pressented below is to list gigs for a couple of musicians... it's ordered by date and for some reason it refuses to show one of the rows... why?

---------------------------------------

$result2 = mysql_query("SELECT * FROM spelningar where spelningar.datum >= current_date AND
spelningar.artist='wieskahubert' order by datum",$db);

---------------------------------------


if ($myrow = mysql_fetch_array($result2)) {

do {
echo &quot;<table width='270' border='0' cellpadding='0' cellspacing='0' class='textsmall' bgcolor=\n&quot;;
echo ($var%2) ? &quot;'#CCCCCC'><tr><td align='left'>&quot; : &quot;'#FFFFFF'><tr><td align='left'>&quot;;
$var++;

printf(&quot;%s</td><td align='left' width='120'>%s</td><td align='left' width='60'>%s&quot;,
$myrow[&quot;datum&quot;], $myrow[&quot;plats&quot;], $myrow[&quot;land&quot;]);

echo &quot;</td><td></td></tr></table>\n&quot;;

} while ($myrow = mysql_fetch_array($result2));
} else {
echo &quot;Sorry, no records were found!&quot;;
}

----------------------------------------------

if I write the SQL queary directly to the MySQL there's no problem. so there's nothing wrong with the dates...

thanks...

-s

 

[spookie]

use a while loop instead of do..while

ie..

while ($myrow = mysql_fetch_array($result2)){

..

//do stuff
}

spookie

--------------------------------------------------------------------------
I never set a goal because u never know whats going to happen tommorow.

 

[sleipnir214]

Yeah.

You're producing a line of output before you actually make the call to retrieve the first row of your data. Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!