No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
3 Posted Topics
 | 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 … |
| | 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 |
| | 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 … |
The End.