SQl num_rows problem

Posted on 16th Feb 2014 07:03 pm by admin

when i try to count rows from an SQL select i get an warning

Code: [Select]$countviews = mysql_query("SELECT * FROM viewed WHERE sfw = '0' AND cookieid = $id");
$num_rows_viewed = mysql_num_rows($countviews);
Code: [Select]Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in ******.php on line 58
anybody an idea why this is?

Your Answer:

Login to answer

Other forums

retrieving images from mysql database using php
So I've been trying to figure out how to store images in a mysql database, and as far as i can tell

New to Arrays
Hi I am new to PHP (a week and a half now) and I am just beginning to read about arrays. I understan

big pagination problem in php
<?php

$connect = mysql_connect("localhost", "root", "")

button help
i originally had this but realised it is much easier to have a button.

Code: <?php

show random images
hey guys

can someone please suggest a way in which the following code can be edited so it onl

Linked Keywords
I am trying to get a script that makes my predefined keyword converted to links and / or converted t

Had a simple form script that suddenly stopped working
It was made about a year ago and had been working fine. Last time it was known to work for sure was

PHP MySQL and DATE
Hi everyone

I have a databse and in one of the columns I have date values such as 2009-March-

Force download script not handling files with spaces properly
I have a regular old php force download script, uses this code:

Code: header("Cache-Cont

Something like an INI editor or a DelimitedText-Editor
Hi all,

Am very, very, very new to PHP and not sure if I should be posting this to a Javascri