On Wed, May 25, 2011 at 08:57:18AM +0430, Negin Nickparsa wrote:
> $id=(int)$_POST['txt'];
> $query1="select * from patient where id=".$id."";
You're not *thinking* about what you're doing. The above is silly. Think
about it: you're sending a string to MySQL. If $_POST['txt'] returns a
string which looks like the number 1, then
$query1 = "select * from patient where id = $_POST[txt]";
should suffice. If you like, test $_POST['txt'] first by echoing it.
> echo $query1;
> $result1=mysql_query($query1);
Ideally, you should be calling this function with an added "connection"
parameter. Like this:
$link = mysql_connect($connection_stuff);
$result1 = mysql_query($query1, $link);
It's not *necessary*, but advisable.
mysql_query() returns a "resource" object, unless there is a problem. If
there is a problem, then it returns FALSE. You can check what it returns
this way:
if (is_resource($result1))
print "It's a resource!";
elseif ($result1 === FALSE)
print "It's false!";
else
print "I don't know what the heck it is!";
>
> echo $result1;
I don't know what you'll get from this "echo" if $result1 truly is a
resource. But if it's false, you won't get much. $result1 should be a
"resource" object, which means it's opaque. You can't know what's in it
unless you use a "helper" function like mysql_num_rows(), etc.
> $num2=Mysql_num_rows($result1);
> $num3=Mysql_num_fields($result1);
>
> still it has previous error
>
> Here is my output:select * from patient where id=1
> *Warning*: mysql_num_rows() expects parameter 1 to be resource, boolean
> given in
>
> *Warning*: mysql_num_fields() expects parameter 1 to be resource, boolean
> given in **
Your error messages clearly mean that 1) you're not getting a proper
resource object back from mysql_query(), or 2) you're somehow changing
$result1 into a boolean before passing it to these other functions. But
I suspect it's #1 above.
Please see the documentation for these functions at php.net. It may
even be available in your native language.
Paul
--
Paul M. Foster
http://noferblatz.com
http://quillandmouse.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
