Posted by Ben on 12/19/05 13:44

Hi,

I have a problem with this query:


$link = mysql_connect("localhost", "root", "pw");
$dbsel = mysql_select_db('mydb', $link);
$lol='bibi';

$sql = "select count(*) as totuur from studres where where dag>= curdate()
AND logon='" . $lol . "'";
$result = mysql_query($sql);
$row = mysql_fetch_field($result,0);
// J'ai essay� avec: $row = mysql_fetch_row($result);
$totu=$row[0];


The error is on line: $row = mysql_fetch_field($result,0):
Warning: mysql_fetch_field(): supplied argument is not a valid MySQL result
resource in c:\Inetpub\wwwroot\myfile.php on line 74


Thanks
Ben

• Next in forum: Re: which connection is best?
• Prev in forum: Re: which connection is best?
• Thread view: problem with select count(*)

[Reply to this message]