[PHP-DB] Re: sybase time outs

2003-08-08 Thread Michael Peppler
On Thu, 07 Aug 2003 12:07:47 -0400, Mills Staylor wrote: > Hi Guys. Is it possible to specify a sybase timeout with the current > stable version of php? I am using --with-sybase (dblib) compiled against > sybase OCS. I'm currently researching the same thing (although I use the CTlib version). I

Re: [PHP-DB] Sorting issue

2003-08-08 Thread Jeff
One last question. I changed all the DB values where numbers are used - (varchar - int) But for the well locations, there are dashes in them, I.E. 10-15-065-22 With setting the field to int, it only displays the first part. 10-15-065-22 shows as 10 There are also several other fields that use da

RE: [PHP-DB] determining if a query returns no value

2003-08-08 Thread Adam Alkins
Quoting [EMAIL PROTECTED]: > Youy could use: > if(!$result) { > // Don't display > } else { > echo "Title"; > } > > You fill in the blanks That only checks to see the query failed. A query returning no rows doesn't fail... -- Adam Alkins http://www.rasadam.com -- PHP Database Mailing L

Re: [PHP-DB] Sorting issue

2003-08-08 Thread David T-G
Jeff -- ...and then Jeff said... % % Yes duh... *grin* % % I didn't realize numbers weren't considered characters. % What's the sql entry for numeric characters? Integer looks like it will do the trick for you. % % I'm new at this, and figure I'm not doing to bad so far. . I know what yo

Re: [PHP-DB] Sorting issue

2003-08-08 Thread John W. Holmes
Jeff wrote: One last question. I changed all the DB values where numbers are used - (varchar - int) But for the well locations, there are dashes in them, I.E. 10-15-065-22 With setting the field to int, it only displays the first part. 10-15-065-22 shows as 10 There are also several other fields

Re: [PHP-DB] Sorting issue

2003-08-08 Thread John W. Holmes
Jeff wrote: $query = "SELECT kwo, lsd, date, event FROM $gradient_tablename $order_by_str $sort_order_str $limit_str"; So what column is not sorting correctly? Is the column a INTEGER-type column or a CHARACTER-type column... Again: "55" > "14000" 55 < 14000

RE: [PHP-DB] determining if a query returns no value

2003-08-08 Thread Wendall Williams
Thank you Matt. That did the trick! I knew it had to be something simple. Wendall At 10:39 AM 8/7/2003 -0700, Matt Schroebel wrote: Wendall Williams wrote: > If the client has no entries for that category, it > needs to move on to the next category. Yes, see mysql_num_row($result). That function

Re: [PHP-DB] Sorting issue

2003-08-08 Thread Jeff
=P Sure! Heres the List Records section... function list_records() { global $default_dbname, $gradient_tablename; global $default_sort_order, $default_order_by, $records_per_page; global $sort_order, $order_by, $cur_page; global $PHP_SELF; $link_id = db_connect($default_dbname);

Re: [PHP-DB] Sorting issue

2003-08-08 Thread Jeff
Thank you EVERYONE.. AGIAN! *grin* "John W. Holmes" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Jeff wrote: > > > Yes duh... > > > > I didn't realize numbers weren't considered characters. > > What's the sql entry for numeric characters? > > > > I'm new at this, and figure I'm