Re: [PHP-DB] mssql_query returns a boolean false instead an empty recordset whenthe query doesn't match any record

2005-11-07 Thread Ziv Gabel
you can try this while ($row = @mssql_fetch_array($result, MSSQL_ASSOC)) { if(!$row) { continue; } else { //process each registry from the query } } Best Regards Ziv Gabel Pineapp Support - Original Message

Re: [PHP-DB] Re: newbie question on PHP & Mysql...

2005-09-21 Thread Ziv Gabel
Try This $result = mysql_query("SELECT SUM(AcctInputOctets),SUM(AcctOutputOctets) FROM radacct WHERE username = '$argv[1]' "); this will make sure that even if $arg[1] is empty it still get '' (empty) as part of the query - Original Message - From: "Sylvain Gourvil" <[EMAIL PROTECT

RE: [PHP-DB] Possible MySQLi extension BUG!

2005-09-13 Thread Ziv Gabel
having to debug encoding problems best regards ziv gabel מאת: Bastien Koert [mailto:[EMAIL PROTECTED] נשלח: ו 09/09/2005 20:05 אל: [EMAIL PROTECTED]; php-db@lists.php.net נושא: RE: [PHP-DB] Possible MySQLi extension BUG! Questions: 1. what is the current databas

RE: [PHP-DB] retrieving field names in ascending order

2005-09-10 Thread ziv gabel
You can use usort which use yor function to compare the values The syntax is usort($aaray,function) And use this function function cmp($a, $b) { if (strtolower($a) == strtolower($b)) { return 0; } return (strtolower($a) < strtolower($b)) ? -1 : 1; } -Original Message-

RE: [PHP-DB] RE: Really dumb Question - Select Many & Display Records

2005-09-03 Thread ziv gabel
If you just need to know how to make the page refresh when you select an item then on the select tab you add (if I remember right) onchange:document.submit; (you can check www.w3schools.com if that's not working) And if you just want to make the select from the db then its Select distinct column

[PHP-DB] begginer question

2005-09-03 Thread ziv gabel
Hi everyone I just need something that I believe is very simple only I can't find an answer for it anywhere I have a database that each row has a machine, its serial, the customer and other details. The problem is that I have customers with more than one machine and I need to query for all the row

RE: [PHP-DB] Brain not working, help needed :-)

2005-08-29 Thread ziv gabel
The format should be $id[$count] -Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED] Sent: Monday, August 29, 2005 8:46 AM To: php-db@lists.php.net Subject: [PHP-DB] Brain not working, help needed :-) Hi there everyone, I have the following code: while ($row = mysql_f