Printing only 1 row of data set

ryclem

Ok...so I am finally getting events to print out in my calendar....the only problem is that if 4 rows of data are returned from mysql then each day is printing 5 times....

for instance

Jan

1 Test Data 1 1 1

I only want the one with data to print...else (if no data, then just the number)...

Here is the code for that block:

while ($row = mysql_fetch_array($result))
{
if ($row['date']==$cal_date)
{
print "<td class='tcell' bgcolor=#CCCCCC valign=\"top\" height=\"100\">$d   $row[description]</td>";
}
else {print "<td class='tcell' bgcolor=#CCCCCC valign=\"top\" height=\"100\">$d  yuck</td>";
}
}

Please help....

ryclem

Correction: I meant to say that if 4 rows of data are returned that it is printed 4 times, not five....

Is this because I am using a while loop and not a for loop? or something like that?

Anon

Out of curiosity, what SELECT query are you sending?

Try using "LIMIT 1" in the appropriate spot in your query, see if that does the trick. That will return only one row of your db.

--
James Kass
http://my8by10.com

ryclem

FYI, here is the query...

$query = "SELECT * FROM $TableName2 where class_id = '$class_id'";
$result = mysql_query($query, $Link);
$numrows = mysql_num_rows($result);

So, I will try something like
$query = "SELECT * FROM $TableName2 limit 1 where class_id = '$class_id'";

$query = "SELECT * FROM $TableName2 where class_id = '$class_id' limit 1";

I'll try both and see if one works....thanks...

Anon

Should be at the end of the query.

Head on over to:

http://www.mysql.com/doc/S/E/SELECT.html

for more info on making sure your query arguments are in the right order. 🙂

-- James Kass
http://my8by10.com