No problem bro, mark this thread as solved now. Don't forget the rep! ;)

Replace the $result in this one:


to $sql because your $sql variable is what holds your query.
$result holds the mysql_num_rows value.

much easier:


$query="SELECT SUM(points) AS `total` from members2";
$result=mysql_query($query);
$total=mysql_result($result,0,"total");

sure,you can,get the id of that you want to delete then perform the delete query in the same page.for example:
(this is your page,e.g. sample.php)

<?php
//db connections..

$result =...

tizag works best!

http://www.tizag.com/phpT/

just delete out the

"$row = mysql_fetch_array($result);"

and it would be fine.

<?php
require_once('core/db.php');
require_once('core/secure.php');

$query = mysql_query("SELECT username FROM admin WHERE id = 1");
$result=mysql_query($query);...

I think the class itself has the error.Try to check them more intensively to find out why it is not working.

please replace this part of your code:


<?php
$category = "Posts";

# setup SQL statement
$SQL = " SELECT * FROM posts WHERE category = '$category' ";

# execute SQL...