Re: [PHP] simple question abt convert to integer

2011-05-24 Thread Bálint Horváth
Problem solved succesfully after changed the query integer apostrofyless.. and printed the mysql_errno() and mysql_error()... Remember: -In the script languages as php the apostrofy ' or " or sg. like these means the string marker... -While ure developing show all error codes and messages... -If u

Re: [PHP] simple question abt convert to integer

2011-05-24 Thread Paul M Foster
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 whi

Re: [PHP] simple question abt convert to integer

2011-05-24 Thread Negin Nickparsa
i recieve nothing not a resource id and nore false

Re: [PHP] simple question abt convert to integer

2011-05-24 Thread Bálint Horváth
If the query is incorrect u get boolean: false, if its correct u get a resource id... Bálint Horváth On 25 May 2011 06:28, "Negin Nickparsa" wrote:

Re: [PHP] simple question abt convert to integer

2011-05-24 Thread Negin Nickparsa
$result1=mysql_query($query1); echo $result1; it can't echo $result1 i don't know why?

Re: [PHP] simple question abt convert to integer

2011-05-24 Thread Negin Nickparsa
Bálint Horváth, the second post of me is using your idea your idea is working but why i have error still?

Re: [PHP] simple question abt convert to integer

2011-05-24 Thread Negin Nickparsa
$id=(int)$_POST['txt']; $query1="select * from patient where id=".$id.""; echo $query1; $result1=mysql_query($query1); echo $result1; $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_

Re: [PHP] simple question abt convert to integer

2011-05-24 Thread Bálint Horváth
Hi, I've a simply idea... If you have integer in your mysql, don't use " at that field in the query... Try this: $query="select * from patient where id=".$id.""; There isn't apostrofy in the mysql query... Bálint Horváth On 25 May 2011 06:06, "Negin Nickparsa" wrote: > my code is this: > $query1=

[PHP] simple question abt convert to integer

2011-05-24 Thread Negin Nickparsa
my code is this: $query1="select * from patient where id=".$_POST['txt']; it works but i think because i have error in next line: *Warning*: mysql_num_rows() expects parameter 1 to be resource, boolean given $num2=Mysql_num_rows($result1); i echoed $ query1 and the result was this=>select * from

[PHP] about php comet

2011-05-24 Thread 李白|字一日
hello, I am every interested in comet applications recently, and sadly found php is very weak in this area. i am just wondering if it is possible to write an extension to extend the ability of the php to easy the way to comet applications? if it possible for php to hold the connect from the clie

Re: [PHP] GnuPG from PHP - Where is the include ??

2011-05-24 Thread Stuart Dallas
On Tue, May 24, 2011 at 8:41 PM, Eli Orr (Office) wrote: > Please advise - I'guess it is not a build in and looking for the GnuPG PHP > include as > all the GnuPG functions are now considered undefined. http://php.net/gnupg.installation -Stuart -- Stuart Dallas 3ft9 Ltd http://3ft9.com/ -- P

[PHP] GnuPG from PHP - Where is the include ??

2011-05-24 Thread Eli Orr (Office)
Please advise - I'guess it is not a build in and looking for the GnuPG PHP include as all the GnuPG functions are now considered undefined. See below. Thanks Eli // GnuPG from PHP - Where is the include ?? // http://www.gnupg.org/gph/en/manual.html // http://www.gnupg.org/documentation/how

Re: [PHP] strcmp()?

2011-05-24 Thread tedd
At 11:10 AM -0700 5/24/11, David Harkness wrote: On Tue, May 24, 2011 at 12:48 AM, Vitalii Demianets wrote: So. to write compatible scripts one should check "< 0", not "== -1". Which matches the documentation: Returns < 0 if str1 is less than str2; > 0 if str1 is greater than str2,

Re: [PHP] strcmp()?

2011-05-24 Thread David Harkness
On Tue, May 24, 2011 at 12:48 AM, Vitalii Demianets wrote: > So. to write compatible scripts one should check "< 0", not "== -1". > Which matches the documentation: Returns < 0 if str1 is less than str2; > 0 if str1 is greater than str2, and 0 if they are equal. David

Re: [PHP] WHERE field = a range of values (value

2011-05-24 Thread Paul S
On Tue, 24 May 2011 21:09:34 +0700, "Richard S. Crawford" wrote: On Tue, May 24, 2011 at 6:51 AM, Paul S wrote: I'd like to check a table to retrieve rows for which one field equals one of a set of values #get products(fields) in category list while ($row = $db_connect->fetch_ar

Re: [PHP] WHERE field = a range of values (value

2011-05-24 Thread Richard S. Crawford
On Tue, May 24, 2011 at 6:51 AM, Paul S wrote: > I'd like to check a table to retrieve rows for which one field equals one > of a set of values > > > #get products(fields) in category list >while ($row = $db_connect->fetch_array($productsincategory_list)) { > $product = $row ['sele

[PHP] WHERE field = a range of values (value

2011-05-24 Thread Paul S
I'd like to check a table to retrieve rows for which one field equals one of a set of values #get products(fields) in category list while ($row = $db_connect->fetch_array($productsincategory_list)) { $product = $row ['selection']; $fields = "$fields" . " $product,"; }

Re: [PHP] strcmp()?

2011-05-24 Thread Vitalii Demianets
On Monday 23 May 2011 15:00:27 tedd wrote: > >Are you absolutely certain about that? > > > >    echo strcmp('These are nearly equal', 'These are almost equal'), "\n"; > >    echo strcmp('different', 'unequal'), "\n"; > >    echo strcmp('b', 'a'), "\n"; My result is: 13 -17 1 I'm runninng PHP 5.2.