MrBillybob Posted August 10, 2007 Share Posted August 10, 2007 <?php $sql = 'SELECT * FROM `eve_jobs` WHERE `userid` = ' . $_SESSION['sqlid'] . ' AND `jobstatus` > 0 ORDER BY `priority` ASC'; ?> and it equels this SELECT * FROM `eve_jobs` WHERE `userid` = 1 AND `jobstatus` > 0 ORDER BY `priority` ASC but i get this error on the query Warning: Wrong parameter count for mysql_result() in /home/content/t/u/b/tubguys/html/eve/index.php on line 896 Quote Link to comment https://forums.phpfreaks.com/topic/64317-solved-gah-more-mysql-help/ Share on other sites More sharing options...
d22552000 Posted August 10, 2007 Share Posted August 10, 2007 the result from the mysql database was not handled by the php sript properly. how do you ahve the result handling php set up? Quote Link to comment https://forums.phpfreaks.com/topic/64317-solved-gah-more-mysql-help/#findComment-320641 Share on other sites More sharing options...
MrBillybob Posted August 10, 2007 Author Share Posted August 10, 2007 while($row = mysql_fetch_array($result)){ ...not sure what you mean Quote Link to comment https://forums.phpfreaks.com/topic/64317-solved-gah-more-mysql-help/#findComment-320642 Share on other sites More sharing options...
MrBillybob Posted August 10, 2007 Author Share Posted August 10, 2007 up Quote Link to comment https://forums.phpfreaks.com/topic/64317-solved-gah-more-mysql-help/#findComment-320666 Share on other sites More sharing options...
MrBillybob Posted August 10, 2007 Author Share Posted August 10, 2007 PLEASE HELP! Quote Link to comment https://forums.phpfreaks.com/topic/64317-solved-gah-more-mysql-help/#findComment-320726 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.