[RESOLVED] num rows or count

chrispos

Hi girls and boys.

I am using php5 and MySQL5 and I have set up a table called stats with an id code month and year.

I am using php 5 and MySQL 5. The idea is to set up stats for customers to see how many times the individuals article has been visited each month. When the page is visited It puts into a table called stats with the id code month and year. I have a chart script but I am having problems with the following script. When I put the following script it works fine.

$link = mysql_connect("mysqlblah", "blah", "blah") or die (mysql_error());
mysql_select_db("blah", $link);

$result = mysql_query("SELECT * FROM `customers`WHERE `sid` = '$sid'", $link);
$num_rows1 = mysql_num_rows($result);
echo "$num_rows1";

But when I add the following code nothing happens.

$result = mysql_query("SELECT * FROM `customers`WHERE `sid` = '$sid'And `month` = '$m' And `year` = '$y'", $link);
$num_rows1 = mysql_num_rows($result);

I am trying to count the number of times an individual advert has been visited for each month of the year only for each individual customer.

I hope someone can help but if not have a great day any way.

paulnaj

Try putting a space between "'$sid'" and "And"

chrispos

Sorry just tried that and it did not work. Is there any other way may be count or something.

Thanks for trying though

paulnaj

Ok Chris, just saying it didn't work doesn't really help us to help you.

What didn't work? What happened?

Also, have you got error reporting on? If not (or you don't know) place the line ...

error_reporting(E_ALL); // Comment this line out after debugging

... at the top of your script.

Then try echo-ing out the SQL statement before doing the query. Is it as you expect?

<?php
$sql = '
SELECT * 
FROM `customers` 
WHERE `sid` = "'.$sid.'"
AND `month` = "'.$m.'" 
AND `year` = "'.$y.'"
';
echo '<pre>'.$sql.'</pre>';

$result = mysql_query($sql, $link);
$num_rows1 = mysql_num_rows($result); 
?>

chrispos

Thanks Paulnaj

What is returning is the sql query. It is printing the query so what I have done is put

echo $num_rows1 and this is blank. So i get the query printed but not the number rows.

paulnaj

Did you turn error reporting on?

chrispos

I put it on after I got the sql query print out and I still get the print out so it seems the query is working just not showing the number results. Strange. I think I will try a count query and see if that works. As I said the strange thing is it works fine to the point I put in the And row = It works fine with sid = $sid it is after that that it falls down.

chrispos

Thanks Paulnaj

For all your help. It is now printing as it should.