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 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? 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 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 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! 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
Archived
This topic is now archived and is closed to further replies.