Wht does this error mean ?

[rathour]

i keep getting these type of messages how do i fix them ?
mysql_num_rows() is not a my sql function
mysql_num_array() is not a my sql function


Please help .

[bartonc]

i keep getting these type of messages how do i fix them ?
mysql_num_rows() is not a my sql function
mysql_num_array() is not a my sql function


Please help .

Since that doesn't look like an error that MySql would output, you'll need to tell us what programming language that you are using and what means you have of connecting to the database.

If the IS an error cause by a SQL query, then perhaps you will have better luck by posting in the MySQL Forum.

[pbmods]

Heya, Rathour. Welcome to TSDN!

Is PHP complaining about a 'Call to undefined function mysql_num_rows()'?

[rathour]

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\Alam_project\login.php on line 6


This is the error i get with this file :::::::

<?php
session_start();
$con=mysql_connect("localhost","root","");
$db=mysql_select_db("alam1",$con);
$rs=mysql_query("select userid,password from newuser where userid='".$_POST["txtuid"]."' and password='".$_POST["txtpass"]."'");
if(mysql_num_rows($rs)<=0)
 
{
$_SESSION["msg"]="<b><font color=red>Invallid Userid or Password</font></b>";
}
else
{
unset($_SESSION["msg"]);
$rows=mysql_fetch_array($rs);
$id=$rows["userid"];
//header("Location:user_profile_signin.php?id=".$id);
}
?>
<!--/*$query="SELECT detail, inrepret from menu";
$result=mysql_query($query); 
$num_results=mysql_num_rows($result); 
for ($c=0;$c<$num_results;$c++)
{
$relevancy=0;
$row=mysql_fetch_object($result);
$mypage=$row->number;
$mycontent=strtolower(strip_tags($row->article)); 
for ($d=0; $d<$q_num; $d++)
{*/-->
 

tell me wht needs to be fixed here ?

[pbmods]

Heya, Rathour.

First thing I fixed for you:
Please use CODE tags when posting source code:

[CODE=php]
PHP code goes here.
[/CODE]

Now then, you're likely getting this error because your MySQL query is generating an error. Try adding this line after your mysql_query():

echo mysql_error();
 

[epots9]

you error is in this line
[php]
$rs=mysql_query("select userid,password from newuser where userid='".$_POST["txtuid"]."' and password='".$_POST["txtpass"]."'");
[/php]

since userid would be a number you don't enclose it with single quotes as if it were a string (varchar). so it would be like:

[php]
$rs=mysql_query("select userid,password from newuser where userid=".$_POST["txtuid"]." and password='".$_POST["txtpass"]."';");
[/php]

now it should run fine.