Jump to content

mysql_result error


Canman2005

Recommended Posts

Hi all

 

I have the following code

 

<?php
$db_name ="***";
$server = "localhost";
$dbusername = "***";
$dbpassword = "***";

$connection = mysql_connect($server, $dbusername, $dbpassword) or die(mysql_error());
$db = mysql_select_db($db_name,$connection)or die(mysql_error());

$sql = "SELECT * FROM countries ORDER BY description ASC";
$query = @mysql_query($sql,$connection) or die(mysql_error());

while ($row = mysql_fetch_array($query))
{
$total = "SELECT COUNT(*) as Num FROM users WHERE `email` NOT LIKE '%@googlemail.com%' AND country_code = ".$row['code']."";
$results = mysql_result(mysql_query($total),0); 
?>
<?php print $row['description']; ?><br>
<?php print $results; ?><br><br>
<?php
}
?>

 

But when I run the page, I get the error

 

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/public_html/test.php

 

Does anyone know why?

 

I've checked and checked again, but cannot seem to find a answer

 

Any help would be great

 

Thanks

 

Dave

Link to comment
https://forums.phpfreaks.com/topic/51819-mysql_result-error/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.