kingthor Posted February 19, 2009 Share Posted February 19, 2009 Ok lets get this going by telling you my DB contents UserNum = 6 ID=kingthor and the paypal results for $item_name = kingthor this query $unum = $db->Execute('select UserNum from account.dbo.main where ID =?',array($item_name)); echo $item_name; echo '='; echo $unum; echo '<br>'; gives this result kingthor=UserNum 6,6 my question is where on earth does it get the UserNum 6, part from? all i want it to do is spit back 6 Link to comment https://forums.phpfreaks.com/topic/146029-solved-mssql-query-with-funky-results-please-help/ Share on other sites More sharing options...
Mchl Posted February 19, 2009 Share Posted February 19, 2009 What library do you use to connect to mssql? Link to comment https://forums.phpfreaks.com/topic/146029-solved-mssql-query-with-funky-results-please-help/#findComment-766628 Share on other sites More sharing options...
kingthor Posted February 20, 2009 Author Share Posted February 20, 2009 I use FreeTDS here is a link to my php info if it helps http://72.18.194.22/test.php Link to comment https://forums.phpfreaks.com/topic/146029-solved-mssql-query-with-funky-results-please-help/#findComment-767008 Share on other sites More sharing options...
kingthor Posted February 20, 2009 Author Share Posted February 20, 2009 Bumping this so it doesn't get lost. I still need some help. Link to comment https://forums.phpfreaks.com/topic/146029-solved-mssql-query-with-funky-results-please-help/#findComment-767272 Share on other sites More sharing options...
kingthor Posted February 21, 2009 Author Share Posted February 21, 2009 Bumping again since im on may way to page three already. Link to comment https://forums.phpfreaks.com/topic/146029-solved-mssql-query-with-funky-results-please-help/#findComment-767610 Share on other sites More sharing options...
corbin Posted February 21, 2009 Share Posted February 21, 2009 What kind of object is $db? Link to comment https://forums.phpfreaks.com/topic/146029-solved-mssql-query-with-funky-results-please-help/#findComment-767615 Share on other sites More sharing options...
kingthor Posted February 21, 2009 Author Share Posted February 21, 2009 $db = ADONewConnection('mssql'); Link to comment https://forums.phpfreaks.com/topic/146029-solved-mssql-query-with-funky-results-please-help/#findComment-767946 Share on other sites More sharing options...
kingthor Posted February 23, 2009 Author Share Posted February 23, 2009 bumping again Link to comment https://forums.phpfreaks.com/topic/146029-solved-mssql-query-with-funky-results-please-help/#findComment-769120 Share on other sites More sharing options...
kingthor Posted February 24, 2009 Author Share Posted February 24, 2009 solved it myself thanks for no help guys.. Link to comment https://forums.phpfreaks.com/topic/146029-solved-mssql-query-with-funky-results-please-help/#findComment-770255 Share on other sites More sharing options...
Mchl Posted February 25, 2009 Share Posted February 25, 2009 You're welcome. You can't expect people here to know details of third party libraries. Few people use PHP with MSSQL, and among those most use mssql extension shipped with PHP. So now you use exotic library for unpopular database, and when you don't get any help, you're insulting us. Buzz off! Link to comment https://forums.phpfreaks.com/topic/146029-solved-mssql-query-with-funky-results-please-help/#findComment-770874 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.