September 6, 2008 03:27pm pdt

Member Login

Hall of Fame

Yearly

1hielo 1,378,694
2hernst42 758,639
3Ray_Pas... 319,734
4logudotcom 317,797
5angelIII 313,663
6Roonaan 295,083
7Squinky 232,155
8routinet 221,087
9RQuadling 218,769
10nplib 217,100
11glcummins 215,655
12ddrudik 199,344
13bportlock 144,121
14Xyptilon2 142,289
15b0lsc0tt 133,043
16dr_dedo 124,191
17darron_c... 123,116
18yodercm 120,678
19ali_kayahan 119,574
20Tchuki 109,335
21Michael701 109,309
22rowejd 107,480
23fibo 98,895
24gamebits 97,655
25Rok-Kralj 97,044

	[x] Attachment Details

$count variable not listing all search results

Zone: PHP Scripting Language

I'm using this code in my list of doctors and it works great. however, when i try to use it to output search results it doesn't include all the records in the resulting query. it looks like the record will only print if it's the it's got the lowest primary key - for instance in my table that i'm tying the doctors and the specialties together i've got 3 columns:

doc_id spec_id docspec_id
2 3 4
2 4 5
2 5 6

so, the only time doc_id 2 will show up in search results is with spec_id 3 BECAUSE its got the lowest primary key (docspec_id=4)

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:

           
           
             <?
$count = 0;
while($row = mysql_fetch_assoc($rsDoctorsAlpha))
{
 if( (($count++) % 2) == 0)
  imgDesc($row);
 else
  descImg($row);
}
function imgDesc($row_rsDoctorsAlpha) {
    echo "<tr>
          <td class=\"p\"><a href=\"detail_alpha.php?id=".$row_rsDoctorsAlpha['main_id']."\"><img src=\"../images/doctors2/".$row_rsDoctorsAlpha['drPhoto'].".gif\" border=\"0\"></a></td>
          <td colspan=\"2\" class=\"p\"><strong><a href=\"detail_alpha.php?id=".$row_rsDoctorsAlpha['main_id']."\">".$row_rsDoctorsAlpha['firstname']."&nbsp;".(($row_rsDoctorsAlpha['mi']=="")? "":$row_rsDoctorsAlpha['mi'].".&nbsp;").$row_rsDoctorsAlpha['lastname'].",&nbsp;".$row_rsDoctorsAlpha['title']."</a></strong>&nbsp;".$row_rsDoctorsAlpha['bioBlurb']."</td>
        </tr>";
    return;
}
 
function descImg($row_rsDoctorsAlpha) {
    echo "<tr>
          <td width=\"12%\" class=\"p\">&nbsp;</td>
          <td width=\"12%\" class=\"p\"><a href=\"detail_alpha.php?id=".$row_rsDoctorsAlpha['main_id']."\"><img src=\"../images/doctors2/".$row_rsDoctorsAlpha['drPhoto'].".gif\" border=0 /></a></td>
          <td width=\"76%\" class=\"p\"><strong><a href=\"detail_alpha.php?id=".$row_rsDoctorsAlpha['main_id']."\">".$row_rsDoctorsAlpha['firstname']."&nbsp;".(($row_rsDoctorsAlpha['mi']=="")? "":$row_rsDoctorsAlpha['mi'].".&nbsp;").$row_rsDoctorsAlpha['lastname'].",&nbsp;".$row_rsDoctorsAlpha['title']."</a></strong>&nbsp;".$row_rsDoctorsAlpha['bioBlurb']." </td>
        </tr>";
    return;
}
 
?>

           
         

Start your free trial to view this solution

Question Stats

Zone: Web Development

Question Asked By: phillystyle123

Question Asked On: 05.16.2008

Participating Experts: 1

Points: 500

Translate:

Loading Advertisement...

20080723-EE-VQP-34 / EE_QW_2_20070628