ruzz311

[!--quoteo(post=363452:date=Apr 10 2006, 04:22 PM:name=moberemk)--][div class=\'quotetop\']QUOTE(moberemk @ Apr 10 2006, 04:22 PM) [snapback]363452[/snapback][/div][div class=\'quotemain\'][!--quotec--] Go to your Connections panel. It should be under "Stored Procedures". [/quote] HAHAH if only it were that easy. They're not under stored procs. it says there is none, but when I'm in Enterprise manager, I have all of them showing up... help?

I'm trying to loop through, basically like a 2d array, and check some values against each other. Maybe the best thing is to show you what i'm talking about <?php while(!$rs_MenuItems->EOF){ while(!$rs_Items->EOF){ if($rs_MenuItems->Fields('iItemID') == $rs_Items->Fields('iRecID')){ echo $rs_Items->Fields('tMenu_ItemName')." : ".$rs_Items->Fields('tMenu_ItemDesc')."<br>"; } $rs_Items->MoveNext(); } $rs_MenuItems->MoveNext(); } ?> I'm trying to loop through the $rs_Items recordset for each menuItem, however it only shows for the first MenuItem entry. I've tried putting a pointer after the $rs_Items loop that points too "$rs_Items->MoveFirst();" I was hoping this would kickstart the recordset over and would work the way i want it too, but instead it just repeats the Items Recordset about 50 times and then continues on with out an error. Can anyone help me out, I just started using php this semester. ®u§§311

How do you get the stored procs of your MSSQL server to show in the application view? I've got lots of them and would rather not hand code all this. Any Suggestions?