SyncViews Posted April 14, 2008 Share Posted April 14, 2008 How should I be doing this as I get warnings and it doesn't work Warning: Wrong parameter count for mysql_fetch_array() in /home/flance/public_html/profile.php on line 23 $query = mysql_query('SELECT COUNT(*) FROM posts WHERE user_id='.$_GET["id"]) or exit(mysql_error()); $data = mysql_fetch_array(); $smarty->assign('PROFILE_POSTS', $data["COUNT(*)"]); Quote Link to comment Share on other sites More sharing options...
psychowolvesbane Posted April 14, 2008 Share Posted April 14, 2008 you need to have: $recordset = mysql_query($query,$conn); ($conn is your connection details and assumes you have connected to the database) $data = mysql_fetch_array($recordset); Quote Link to comment Share on other sites More sharing options...
RCS Posted April 14, 2008 Share Posted April 14, 2008 Your code should be something like this <?php $con = mysql_connect($db_host, $db_user, $db_passwd) or die ("Could not connect to database."); mysql_select_db($db_name) or die ("Unable to connect to select database"); $query = mysql_query('SELECT COUNT(*) FROM posts WHERE user_id='.$_GET["id"]) or exit(mysql_error()); $result=mysql_query($query) or die ("Could not complete query."); $smarty->assign('PROFILE_POSTS', $data["COUNT(*)"]); ?> Quote Link to comment 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.