Re: [PHP-DB] SQL Select statement

2001-02-19 Thread Lennin Arriola
2 2 21 3 then your sql statement will work. (* you might still add another field in case for instance there are several votaciones...) Lennin Arriola [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PRO

Re: [PHP-DB] composite keys

2001-02-19 Thread Lennin Arriola
composite keys, Indeed not recommended. Lennin Arriola [EMAIL PROTECTED] ps. check out, http://www.ambysoft.com/mappingObjects.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list

Re: [PHP-DB] runing a query and a another task at the same time

2001-02-19 Thread Lennin Arriola
IMHO, I don't think you can doit on PHP, you may have to do it outside PHP, for instance in java, java has multithreading, and then you might access it through PHP, Lennin Arriola [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROT

Re: [PHP-DB] Suppressing NULL values in search results

2001-02-19 Thread Lennin Arriola
I used to do this: function nice( $value ) { if ($value=="") { return "- "; } else return $value; } print nice($row["company"]) Lennin Arriola [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [E

Re: [PHP-DB] number_format bug?

2001-02-20 Thread Lennin Arriola
I was curious about it, so I tried it on my machine and I got "13,80" win2k+php4. I think is about settings in your php configuration, although I don't still find a reference for it. Lennin Arriola [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsu

Re: [PHP-DB] php.mysql

2001-02-21 Thread Lennin Arriola
perhaps the version of mysql you have installed? it's got to be >3.22 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] number formatting bug?

2001-02-21 Thread Lennin Arriola
I was thinking again , if you are for instance using winxxx check in start settings/control panel/regional settings decimal after point... this might be affecting, there must be something similar on unix. Check out in the help "set_locale" that should do the trick. Lennin Arri

Re: [PHP-DB] Most Occurring

2001-02-22 Thread Lennin Arriola
you mean the "mode". I'm afraid you'll have to do it by hand. Other databases do have functions for a couple of statistics measures( though not sure the mode is included), but MYSQL doesn't. Lennin Arriola [EMAIL PROTECTED] -- PHP Database Mailing List (http://www

Re: [PHP-DB] next & previous record

2001-02-22 Thread Lennin Arriola
Keep a counter of the rows you have fetched. so when you want to go back call mysql_data_seek ($Result, Counter-1); then mysql_fetch and you've got the previous row. Lennin Arriola [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e

Re: [PHP-DB] parsing parameter over page

2001-03-06 Thread Lennin Arriola
I don't think so, you'll have to persist your object in some way, for example in a database and then you only pass the id of your object. Another option is to persist your object as a string and then pass it either in the query or as post in a form. Lennin Arriola [EMAIL PROTECTED]

[PHP-DB] classes and & operator

2001-03-13 Thread Lennin Arriola
from one of my classes functions, and then the script doesn't crash, it does not work however due to that the logic of the script requires the &. When I put back the &, it works 2 or 3 times and then back to the crash thanks, Lennin Arriola -- PHP Database Mailing List (h