mysql functions

[SyncViews]

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(*)"]);

[psychowolvesbane]

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);

[RCS]

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(*)"]);
?>