You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1'>

[a65]

why i am getting the above error..

<?php
session_start();
/*this is for making payment by user*/
if(isset($_SESSION['sname']) && isset($_SESSION['spassword']) && isset($_SESSION['saccount_type']))
{
mysql_connect("localhost","root","");
mysql_select_db("bank_acount");
$query="select * from account";
$result=mysql_query($query) or die(mysql_error());
$row=mysql_fetch_assoc($result);
$num=mysql_num_rows($row);
echo($query);
?>

[Dharmender]

Try This

<?php
session_start();
/*this is for making payment by user*/
if(isset($_SESSION['sname']) && isset($_SESSION['spassword']) && isset($_SESSION['saccount_type']))
{
$conn=mysql_connect("localhost","root","");
if(!$conn)
{
die("Cannot connect:".mysql_error());
}
mysql_select_db("bank_acount");
$query="select * from account";
$result=mysql_query($query);
if(!$result)
{ die(mysql_error();}
$num=mysql_num_rows($result);
echo($num);
?>

 

Echo whatever you want.

[a65]

that worked..thanx