php error

[wijayabahu]

Code: Select all

<?php
  session_start();
 
 
  mysql_connect('localhost','root','') or die(mysql_error());
  mysql_select_db('sh_chart') or die(mysql_error());
 
 

function product(){
   $get =mysql_query('SELECT price FROM sh_chart WHERE price<10.00 ORDER BY DESC');
   echo mysql_num_rows($get);
       
}

i have this error
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\shopingchart\chart.php on line 12

plz give me a right answer

[seandisanti]

That particular error typically means that your query failed. It could be because of a connection issue (bad hostname or credentials) a syntax error, etc. Typically the best way to identify the issue is to either view source on the page where you're seeing it, to see if the SQL error is embedded in your source code, or to output your assembled sql string prior to executing it, and paste it into phpmyadmin or mysql to see what error it spits out.