MySQL Query Error

xem · November 29, 2011, 6:48pm

Hello, can anyone help with the mysql error I’m having!
Error message :

SELECT * FROM tbl_info_admin WHERE u_name=‘’
Warning: Wrong parameter count for mysql_query() in /home/foodecrp/public_html/beta2/register.php on line 12
Error: with query

Here is the code:

&lt;?php
session_start();
include "config.php";
$fullname=$_POST['f_name'].$_POST['l_name'];
$email=$_POST['email'];
$u_name=$_POST['u_name'];
$u_pass=$_POST['pass'];
$user_type=$_POST['u_type'];

$sql="SELECT * FROM `tbl_info_admin` WHERE u_name='$u_name'";
echo $sql;
mysql_query(); &lt;-----Line 12 -------&gt;
echo mysql_error();  
$num=mysql_num_rows(mysql_query($sql)) or die("Error: ". mysql_error(). " with query ". $query);

if($_POST['submit'])
	{
		if($u_pass==$_POST['re_pass'])
			{
				if($num&gt;0)
					{
						$msg="UserName Already Exist.";
					}
					else
					{
						$query="INSERT INTO `tbl_info_admin` VALUES
														(
														 	'$fullname',
															'$email',
															'$u_name',
															'$u_pass',
															'$user_type'
													)";
						if(mysql_query($query))
							{
								$con_msg="Congragulations, $fullname. You are successfully registered.";
							}
					}
			}
			else
			{
				$msg_match="Password does not match.";
			}
	}
?&gt;

Gman · November 29, 2011, 9:07pm

Change line 12 to $query = mysql_query($sql);

Remove mysql_query() from num_rows and add $query

xem · November 30, 2011, 7:14am

Did that! New error shows up now!

Parse error: syntax error, unexpected T_VARIABLE in /home/foodecrp/public_html/beta2/register.php on line 14

&lt;?php
session_start();
include "config.php";
$fullname=$_POST['f_name'].$_POST['l_name'];
$email=$_POST['email'];
$u_name=$_POST['u_name'];
$u_pass=$_POST['pass'];
$user_type=$_POST['u_type'];

$sql="SELECT * FROM `tbl_info_admin` WHERE u_name".$u_name;
$query=mysql_query($sql)

 
$num=mysql_num_rows($query) or die("Error: ". mysql_error(). " with query ". $query);[B]&lt;----Line 14[/B]

if($_POST['submit'])
	{
		if($u_pass==$_POST['re_pass'])
			{
				if($num&gt;0)
					{
						$msg="UserName Already Exist.";
					}
					else
					{
						$query="INSERT INTO `tbl_info_admin` VALUES
														(
														 	'$fullname',
															'$email',
															'$u_name',
															'$u_pass',
															'$user_type'
													)";
						if(mysql_query($query))
							{
								$con_msg="Congragulations, $fullname. You are successfully registered.";
							}
					}
			}
			else
			{
				$msg_match="Password does not match.";
			}
	}
?&gt;

Gman · November 30, 2011, 12:08pm

$query = mysql_query($sql) is missing the ;

StarLion · November 30, 2011, 1:43pm

Incidentally,


$num=mysql_num_rows($query) or die("Error: ". mysql_error(). " with query ". $query);[B]<----Line 14[/B]

$query isnt going to tell you anything.


$num=mysql_num_rows($query) or die("Error: ". mysql_error(). " with query ". [B]$sql[/B]);

xem · November 30, 2011, 6:13pm

@StarLion & @Gman: did both , new error shows up now!

here it goes:
Error: with query SELECT * FROM tbl_info_admin WHERE u_name

&lt;?php
session_start();
include "config.php";
$fullname=$_POST['f_name'].$_POST['l_name'];
$email=$_POST['email'];
$u_name=$_POST['u_name'];
$u_pass=$_POST['pass'];
$user_type=$_POST['u_type'];

$sql="SELECT * FROM `tbl_info_admin` WHERE u_name".$u_name;
$query=mysql_query($sql);

 
$num=mysql_num_rows($query) or die("Error: ". mysql_error(). " with query ". $sql);

if($_POST['submit'])
	{
		if($u_pass==$_POST['re_pass'])
			{
				if($num&gt;0)
					{
						$msg="UserName Already Exist.";
					}
					else
					{
						$query="INSERT INTO `tbl_info_admin` VALUES
														(
														 	'$fullname',
															'$email',
															'$u_name',
															'$u_pass',
															'$user_type'
													)";
						if(mysql_query($query))
							{
								$con_msg="Congragulations, $fullname. You are successfully registered.";
							}
					}
			}
			else
			{
				$msg_match="Password does not match.";
			}
	}
?&gt;

xem · November 30, 2011, 6:16pm

StarLion:

Incidentally,


$num=mysql_num_rows($query) or die("Error: ". mysql_error(). " with query ". $query);[B]<----Line 14[/B]

$query isnt going to tell you anything.


$num=mysql_num_rows($query) or die("Error: ". mysql_error(). " with query ". [B]$sql[/B]);

Please check above post, forgot to tag ur quotes above! NEW ERROR

DaveMaxwell · November 30, 2011, 7:22pm

You changed your query.

$sql=“SELECT * FROM tbl_info_admin WHERE u_name”.$u_name;
should be
$sql=“SELECT * FROM tbl_info_admin WHERE u_name = '”.$u_name . “'”;

Gman · November 30, 2011, 7:28pm

Change, if($_POST[‘submit’])

To

if(isset($_POST[‘submit’]) )

Also put a or die mysql_error at the end of your mysql_query statement

xem · December 1, 2011, 6:06pm

Same error! See the error yourself: Visit beta2.foodiecorp.com & click Registration link

Gman · December 1, 2011, 8:20pm

Post your code again please

xem · December 2, 2011, 6:02am

&lt;?php
session_start();
include "config.php";
$fullname=$_POST['f_name'].$_POST['l_name'];
$email=$_POST['email'];
$u_name=$_POST['u_name'];
$u_pass=$_POST['pass'];
$user_type=$_POST['u_type'];

$sql="SELECT * FROM `tbl_info_admin` WHERE u_name = '".$u_name . "'"; 
$query=mysql_query($sql) or die("Could nor select from table");

 
$num=mysql_num_rows($query) or die("Error Error: ". mysql_error(). " with query ". $sql);

if(isset($_POST['submit']) )
	{
		if($u_pass==$_POST['re_pass'])
			{
				if($num&gt;0)
					{
						$msg="UserName Already Exist.";
					}
					else
					{
						$query="INSERT INTO `tbl_info_admin` VALUES
														(
														 	'$fullname',
															'$email',
															'$u_name',
															'$u_pass',
															'$user_type'
													)";
						if(mysql_query($query))
							{
								$con_msg="Congragulations, $fullname. You are successfully registered.";
							}
					}
			}
			else
			{
				$msg_match="Password does not match.";
			}
	}
?&gt;

DarthGuido · December 2, 2011, 6:57am

The ‘or die’ on mysql_num_rows() doesn’t make much sense. Change the one on mysql_query() to give more info:


$query=mysql_query($sql) or die("Error: ". mysql_error(). " with query ". $sql);
  
$num=mysql_num_rows($query);

And before using user input in a query, sanitize it with mysql_real_escape_string (if it’s a string, like in this case):

$sql="SELECT * FROM `tbl_info_admin` WHERE u_name = '" . mysql_real_escape_string($u_name) . "'";

And you should put all these lines:

$fullname=$_POST['f_name'].$_POST['l_name'];
$email=$_POST['email'];
$u_name=$_POST['u_name'];
$u_pass=$_POST['pass'];
$user_type=$_POST['u_type'];
 
$sql="SELECT * FROM `tbl_info_admin` WHERE u_name = '" . mysql_real_escape_string($u_name) . "'"; 
$query=mysql_query($sql) or die("Error: ". mysql_error(). " with query ". $sql);
  
$num=mysql_num_rows($query);

inside the if(isset($_POST[‘submit’]) )

xem · December 2, 2011, 3:57pm

guido2004:

The ‘or die’ on mysql_num_rows() doesn’t make much sense. Change the one on mysql_query() to give more info:
$query=mysql_query($sql) or die("Error: ". mysql_error(). " with query ". $sql);
  
$num=mysql_num_rows($query);
And before using user input in a query, sanitize it with mysql_real_escape_string (if it’s a string, like in this case):
$sql="SELECT * FROM `tbl_info_admin` WHERE u_name = '" . mysql_real_escape_string($u_name) . "'"; 
And you should put all these lines:
$fullname=$_POST['f_name'].$_POST['l_name'];
$email=$_POST['email'];
$u_name=$_POST['u_name'];
$u_pass=$_POST['pass'];
$user_type=$_POST['u_type'];
 
$sql="SELECT * FROM `tbl_info_admin` WHERE u_name = '" . mysql_real_escape_string($u_name) . "'"; 
$query=mysql_query($sql) or die("Error: ". mysql_error(). " with query ". $sql);
  
$num=mysql_num_rows($query);
inside the if(isset($_POST[‘submit’]) )

Thankyou so much!!! it worked at last

Topic		Replies	Views
mysql_num_rows(): Error PHP	2	487	August 22, 2011
Database Query Error (Parameter 1...resource, boolean) PHP	23	5515	October 8, 2014
MYSQL Query Problem PHP	6	402	January 23, 2010
How to solve PHP error : Warning: mysql_num_rows() expects parameter 1 to be resource, boolean on line 54 PHP	4	29711	December 19, 2016
Login Trouble PHP	19	1401	July 20, 2010

MySQL Query Error

Related Topics