Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
~2K People Reached
Favorite Forums
Favorite Tags
Member Avatar for Odubz

Hi Im still quite new when using MS SQL but I have a pretty good understanding of it. -I am using Crystal Reports to retrieve and manipulate data from my database. -I am creating small tables for certain data. -This data is selected from a constantly updating table. So i …

Member Avatar for tesuji
0
234
Member Avatar for Odubz

Hello, I was wondering does anyone have an idea how to make a dropdown menu that dosent repeat values from the SQL Server? Perferably using a while loop. I was thinking of camparing the set values with the new values as it loops through them but im not sure. -Thanks

Member Avatar for Odubz
0
152
Member Avatar for Odubz

Hello, I have looked over many examples of how to populate a dropdown with rows like [code=php] $sql="SELECT id, thing FROM table"; $result=sqlsrv_query($conn,$sql) or die("Couldn't execut query"); while ($data=sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)){ $id=$row["id"]; $thing=$row["thing"]; $options.="<option value=\"$id\">".$thing "</option>"; } [/code] But i need to populate this list with tables and will need to …

Member Avatar for jenyroger
0
2K