Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Please HELP me.... :(

Author  Topic  slavic Starting Member 2 Posts Posted - 2004-10-23 : 17:23:21 Please help me I have a such code: <?$tmp=mysql_query("SELECT id, fname, gender, birthday, pic1, pic2, pic3 FROM ".C_MYSQL_MEMBERS." WHERE status >= '7' and (pic1 != '' or pic2 != '' or pic3 != '') order by regdate DESC limit ".C_LASTREG); $color=''; while($i=mysql_fetch_array($tmp)) { $color = ($color == COLOR4) ? COLOR3 : COLOR4; $name = (trim($i['fname']) == '') ? $i['id'] : $i['fname']; $pic1=$i["pic1"]; $pic2=$i["pic2"]; $pic3=$i["pic3"]; if ($pic1 != "") {$fotourl=$pic1;} else {if ($pic2 != "") {$fotourl=$pic2;} else {if ($pic3 != "") {$fotourl=$pic3;} }} $age=abs(mysql2data($i['birthday'],1)); echo "<TABLE class='tr' height='50' width='50' border='0'><TR><TD style='BACKGROUND:#eeeeee' align='middle'><a href=\"view.php?l=".$l."&id=".$i['id']."\" class=desc>".$name."</a></TD></TR><TR><TD align='middle'><a href=\"view.php?l=".$l."&id=".$i['id']."\" class=desc><img src=$photodir$fotourl border=0 width=80></a></TD></TR><TR><TD class=desc align='middle'>Age: ".$age."</TD></TR></TABLE>";} $tmp=mysql_query("SELECT count(id) as total FROM ".C_MYSQL_MEMBERS." WHERE status >= '7'"); $rows=mysql_fetch_array($tmp);$usc=$rows['total'];?> The Problem is that appears 1 table in a row but not 4: BUT I NEED TO APPEAR 4 TABLES IN A ROW AND IN TOTAL TO BE 5 ROWS PLEASE HELP ME.