[RESOLVED] help me please

[andy_cool]

hi, any please give me a solution on this
i m getting an error
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in..
i have checked all but no solution yet
the code is as fallows:

$connection = db_connect();

$query = sprintf("SELECT * FROM modules WHERE name = '%s'",

                mysql_real_escape_string($module_name));			

				$result = mysql_query($query);

	  //Checking Whether the Result is Empty.

		$number_of_news = mysql_num_rows($result);

		if ($number_of_news == 0) 

		{

		  return false;	

		}			

		return true;			

}

[djjjozsi]

$result = mysql_query($query) or die(mysql_error());

Maybe in your query you have a mistake. Is $module_name empty?

[andy_cool]

yes it is empty!
that is the reason for error. isn't it?
:queasy:

[djjjozsi]

andy_cool;10972458 wrote:

yes it is empty!
that is the reason for error. isn't it?
:queasy:

You get a variable from a form or in an url, you can catch its value with $POST or $GET. $_GET["module_name"]

[andy_cool]

🙂
i got the solution
thank u

:o 🙂

[djjjozsi]

i got the solution
thank u

:o 🙂[/QUOTE]

You're welcome. Don't forget to set the thread as resolved if you think you got the answer 🙂

[andy_cool]

hi,
i m new in cake php.
can any one help me.
post ur replies, i m strong need of that
thank u

[djjjozsi]

andy_cool;10972464 wrote:

hi,
i m new in cake php.
can any one help me.
post ur replies, i m strong need of that
thank u

You should ask in a new topic, please.

[andy_cool]

hello sir,
i m trying to get the values for drop down option from different module.
i have created a drop down of category in which the option are from category table where as i wan to save them in users table on save.
The Controller name in Users_Controller.php
The Action Name is admin_adddetail
and
view is in admin_adddetail.ctp
please help 😕

[djjjozsi]

well, you should answer it in a new thread instead. (i can't help you in cakephp, sorry)