BoarderLine Posted February 23, 2011 Share Posted February 23, 2011 Close the connection with this at bottom of page: </php mysql_close($dbhandle); ?> Quote Link to comment https://forums.phpfreaks.com/topic/228515-mysql-cross-table-lookup/page/2/#findComment-1178494 Share on other sites More sharing options...
shalkith Posted February 23, 2011 Author Share Posted February 23, 2011 no good. Still getting the error with that code. Quote Link to comment https://forums.phpfreaks.com/topic/228515-mysql-cross-table-lookup/page/2/#findComment-1178495 Share on other sites More sharing options...
Pikachu2000 Posted February 23, 2011 Share Posted February 23, 2011 Is your database MySQL? If it is, there are a few instances where you've got mSsql functions rather than mYsql . . . Quote Link to comment https://forums.phpfreaks.com/topic/228515-mysql-cross-table-lookup/page/2/#findComment-1178497 Share on other sites More sharing options...
shalkith Posted February 23, 2011 Author Share Posted February 23, 2011 Yes I'm using mysql Quote Link to comment https://forums.phpfreaks.com/topic/228515-mysql-cross-table-lookup/page/2/#findComment-1178498 Share on other sites More sharing options...
shalkith Posted February 23, 2011 Author Share Posted February 23, 2011 I changed the mssql instances to mysql and the 500 error went away but its still not displaying the rank. There's no output where i put the code now. Quote Link to comment https://forums.phpfreaks.com/topic/228515-mysql-cross-table-lookup/page/2/#findComment-1178499 Share on other sites More sharing options...
fenway Posted February 23, 2011 Share Posted February 23, 2011 Then you have a php syntax issue. Quote Link to comment https://forums.phpfreaks.com/topic/228515-mysql-cross-table-lookup/page/2/#findComment-1178638 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.