Passing MySQL Query via PHP

Zoltarc

I am a total newbie to MySQL and PHP 🙁
I've been playing around with it and I can make sense of most things but I need a little help to get started.

I would like to pass the following via a PHP file and return the result.

SELECT count(*) FROM wts_result WHERE result = '1' GROUP BY result

It works in phpMyAdmin so I assume it’s correct. It returns the total number of wins in the results column for the table wts_result in the database m2sclan1_csc (wins = 1, losses = -1). I’ve read many guides and the official MySQL manual but I’m really struggling. Can some one show me the way please?

sid

$dbhost => your host (f.ex. localhost)
$dbname => database name
$dbuser => the user
$dbpw => the password


$dblink = mysql_connect ("$dbhost", "$dbuser", "$dbpw") or die ("Could not connect");
$dbselect = mysql_select_db("$dbname");

$result = mysql_query("SELECT count(*) FROM wts_result WHERE result = '1' GROUP BY result");

if ($row = mysql_fetch_array($result)) {
    print "$row[0]";
}
else {
   print "error";
}

mysql_close($dblink);

Zoltarc

Thank you 😃