Re: [PHP-DB] Category Listing

2003-09-22 Thread Peter Beckman
On Sun, 21 Sep 2003, Paul B. [pbcomm, aka WPD] wrote: Hi, i'm working on the site that involves a lot ot categories and subs there of ... The way i have things now is that the structure goes one sub deep ... Ex: PHP - Database PHP - Books in the DB it looks like: id 1

[PHP-DB] Databases and PHP?

2003-09-22 Thread IN
Hello all, With PHP, Is it possible to use DB2-UDB as a database (ADO) or any other database, or must I use MySql. I am considering using PHP for building web's and the kind of database to use might be an important factor. TIA I. Nemlich -- PHP Database Mailing List (http://www.php.net/) To

RE: [PHP-DB] Databases and PHP?

2003-09-22 Thread Jacob A. van Zanen
PHP can be used with many different databases (MySql support is just built in, others you have to compile in). I do not know about DB2 but ODBC is always possible Jack -Original Message- From: IN [mailto:[EMAIL PROTECTED] Sent: Monday, September 22, 2003 11:31 AM To: [EMAIL

[PHP-DB] MySQL: How to properly extract fields from retrieved single record ???

2003-09-22 Thread -{ Rene Brehmer }-
Hi gang Still working on this DB for my gameclan not that it's essential what it's for... and be warned: Never worked with any form of DB in PHP before I began this project, so I'm a total n00b at these MySQL commands (and the manual for MySQL is by far nowhere near as good as the PHP

Re: [PHP-DB] MySQL: How to properly extract fields from retrieved single record ???

2003-09-22 Thread Peter Beckman
On Mon, 22 Sep 2003, -{ Rene Brehmer }- wrote: $result = mysql_query($query); replace with: $result = mysql_query($query) or die(MySQL Error: .mysql_error().\nbr/SQL: .$query); If the query fails, you will see why the query failed, and be able to view the query itself. Maybe

RE: [PHP-DB] MySQL: How to properly extract fields from retrieved single record ???

2003-09-22 Thread Jacob A. van Zanen
Hi, I think this is what you are trying to do. You get a record back that has seveal fields and you want to reference those fields indiviually. This is what I do in this example (which shows people information) and present in HTML table

[PHP-DB] Query Filter in GUI

2003-09-22 Thread dpgirago
Good Morning PHP-DB Listers, I have a PHP GUI in which a select box gets populated by a query of a MySQL DB for all CD's by all artists when the page is first opened. I am now trying to implement the same query but with a WHERE clause that filters the returned CD's to be displayed in the same

RE: [PHP-DB] Query Filter in GUI

2003-09-22 Thread Griffiths, Daniel
how are you testing the check boxes?, looks like the the query string is empty because both the tests you are doing in the code below return false. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 22 September 2003 15:01 To: [EMAIL PROTECTED] Subject: [PHP-DB]

Re: [PHP-DB] Query Filter in GUI

2003-09-22 Thread CPT John W. Holmes
From: [EMAIL PROTECTED] I have a PHP GUI in which a select box gets populated by a query of a MySQL DB for all CD's by all artists when the page is first opened. I am now trying to implement the same query but with a WHERE clause that filters the returned CD's to be displayed in the same

[PHP-DB] Count down

2003-09-22 Thread Frank McIsaac
Hi all. I was wanting to make a page that takes a set date and counts down to zero displaying days, minutes, and seconds. Basically, I want it to count down from the current date and time until a future date and time is reached (ie. Sept. 30th is x days, y minutes, and z seconds away

[PHP-DB] Query FIlter in GUI

2003-09-22 Thread dpgirago
Thank you CPT John W. Holmes. I'll give it a try. David

Re: [PHP-DB] MySQL: How to properly extract fields from retrieved single record ???

2003-09-22 Thread Ignatius Reilly
read the PHP manual and examples under the function mysql_fetch_array(). I find the MySQL manual is very well done and helpful. I've been using it as a reference for 2 years. Take a harder look! Ignatius _ - Original Message - From: -{ Rene Brehmer }- [EMAIL

Re: [PHP-DB] Count down

2003-09-22 Thread Peter Beckman
On Mon, 22 Sep 2003, Frank McIsaac wrote: Hi all. I was wanting to make a page that takes a set date and counts down to zero displaying days, minutes, and seconds. Basically, I want it to count down from the current date and time until a future date and time is reached (ie. Sept.

Re: [PHP-DB] Count down

2003-09-22 Thread Peter Beckman
On Mon, 22 Sep 2003, Peter Beckman wrote: On Mon, 22 Sep 2003, Frank McIsaac wrote: Hi all. I was wanting to make a page that takes a set date and counts down to zero displaying days, minutes, and seconds. Basically, I want it to count down from the current date and time until a

Re: [PHP-DB] MySQL: How to properly extract fields from retrieved single record ???

2003-09-22 Thread George Patterson
On Mon, 22 Sep 2003 13:06:37 +0200 Ignatius Reilly [EMAIL PROTECTED] wrote: read the PHP manual and examples under the function mysql_fetch_array(). I find the MySQL manual is very well done and helpful. I've been using it as a reference for 2 years. Take a harder look! I think Ignatius

Re: [PHP-DB] Pop3?

2003-09-22 Thread andu
On Mon, 22 Sep 2003 16:04:06 -0400 Chris Payne [EMAIL PROTECTED] wrote: Hi there, I get an error about a T_Variable here: $messg_list=pop3_list($id); print_r $messg_list; print_r($messg_list); pop3_quit($id); My mistake but you can't really use php without learning it. Having looked

Re: [PHP-DB] Pop3?

2003-09-22 Thread Chris Payne
Hi there, Thanks for your help :-) Oh and I did read the manual, found it about 20 minutes after I sent the emeial but got sidetracked and forgot to post i'd figured it out in the group - sorry :-) Chris On Mon, 22 Sep 2003 16:04:06 -0400 Chris Payne [EMAIL PROTECTED] wrote: Hi there,

[PHP-DB] Auto load data

2003-09-22 Thread ascll
Greetings, I'm designing a table with 21 columns and 3 rows (1-row column header, 2-row data) store in .php file, and each cell of this table storing a value, that I stored it using MySQL database. Now, I want all the values (just the values, but NOT the table) shown on this page automatic update