RE: [PHP-DB] dynamic URL result in search?

2002-06-04 Thread Ruprecht Helms
Hi Rita, >[...] I need to get users to the page their > book is on [books.php?page=3] -- else they'll have to try to find the book > they searched for by going through a bunch of pages. verbal if found books.php?page=$booksite else URL searchsite endif You mast have a databas

Re: [PHP-DB] how to create a graph from a db?

2002-06-04 Thread Andy
Hi Chris, this is very easy done with a library called jpgraph. Check out: http://www.aditus.nu/jpgraph/ A nice example can be found on my website at: http://www.globosapiens.net/community/03010001.html Hope this helps, Andy -- http://www.

[PHP-DB] Re: how to create a graph from a db?

2002-06-04 Thread Paul Willard
Take a look phplot.php http://www.phplot.com Chris Payne wrote: > Hi there everyone, > > I have a db and the last column is id2 ? this adds a 1 everytime a > banner is clicked so that I can track which banners are being clicked > the most ? that works great, no problems ? but how can I get the

Re: [PHP-DB] Oracle9i+php4.2.0

2002-06-04 Thread Ing.Peter Misovic
Hallo, Directly I have problem with php_oci8.dll. And i have instaled Oracle9i and problem is, that my PHP application doesn´t work correctly. I can´t connect to Oracle for expample and etc. Therefor I would like to know If I need another php´s dll for Oracle9i working. Thanks a lot ... Thailon

[PHP-DB] Converting non latin characters

2002-06-04 Thread Andy
Hi there, I have a table containing cities of the world. Now I am running into problems because people are starting to complain that some mayor cities are not in the db like Tokyo. After checking my table I discovered that there lots of cities are written with some non latin characters. Tokyo is

[PHP-DB] permissions "system"

2002-06-04 Thread Jason Markantes
Howdy All- I've poked around the net for some snippets, and have done my own in the past, but wanted to get some more ideas on how you do a permissions "system". This means, in your application, how do you control and enforce different permissions for different users? Simple example: An image re

RE: [PHP-DB] how to create a graph from a db?

2002-06-04 Thread Shrock, Court
You can also use something like jpgraph (http://www.aditus.nu/jpgraph/)... -Original Message- From: Chris Payne To: [EMAIL PROTECTED] Sent: 6/4/02 10:00 PM Subject: [PHP-DB] how to create a graph from a db? Hi there everyone, I have a db and the last column is id2 – this adds a 1 every

[PHP-DB] informix stored procedures exception handling

2002-06-04 Thread Andrey V. Glukhov
I am moving to php-4.2.1 now and still looking for explanation how to use exeption handling in informix stored procedures. As I've wrote a year ago here, when I trying to execute the following php code: and stored procedure is: CREATE PROCEDURE TEST() RAISE EXCEPTION -746, 0, "testing..."; E

RE: [PHP-DB] how to create a graph from a db?

2002-06-04 Thread Cal Evans
never done it myself but look into the png/jpg routines built into PHP. You can use them to dynamically create an image. What you DO with the image is up to you. :) Seriously, there are some tutorials out there about this very topic. hit phpbuilder.com or google.com to find them. =C= * * Cal

[PHP-DB] how to create a graph from a db?

2002-06-04 Thread Chris Payne
Hi there everyone, I have a db and the last column is id2 – this adds a 1 everytime a banner is clicked so that I can track which banners are being clicked the most – that works great, no problems – but how can I get the result out as a chart on the screen? I’d like to list the 5 most popular b

Re: [PHP-DB] Trouble displaying info in a multiline form

2002-06-04 Thread Jason Wong
On Wednesday 05 June 2002 02:51, Paulo Nunes wrote: > Hi all > > I'm having trouble displaying some content into a multiline form. Some part > of the field's data seems to be missing. I'm using the following code: > echo "Contents: name=\"content\" value=".\ > $content." > "; > The variable $c

Re: [PHP-DB] random

2002-06-04 Thread Jason Wong
On Wednesday 05 June 2002 03:56, Natividad Castro wrote: > hi to all, > > I have a drop down menu where users will select a word. After they submit > it, I will generate a code number where I want to display the first three > characters of the word they selected follow by Month and Date and three

RE: [PHP-DB] random

2002-06-04 Thread Beau Lebens
substr($foo, 0, 3); check the other string functions in the manual - they are *very* useful Beau // -Original Message- // From: Natividad Castro [mailto:[EMAIL PROTECTED]] // Sent: Wednesday, 5 June 2002 3:57 AM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] random // // // hi to all, /

[PHP-DB] Trouble displaying info in a multiline form

2002-06-04 Thread Paulo Nunes
Hi all I'm having trouble displaying some content into a multiline form. Some part of the field's data seems to be missing. I'm using the following code: Section: ".$r[0].""; echo ""; echo "Description "; echo "Button text: "; echo "Contents: "; echo ""; echo ""; The variable $content should

[PHP-DB] dynamic URL result in search?

2002-06-04 Thread Rita
I've been plugging away at learning a bunch about PHP, but now I'm stuck. I've found a search utility at http://www.digitalgenesis.com/software/dgssearch.html , and I was able to go through and customize it. But then I came upon the problem of correct URL's for the search results. I just learned

[PHP-DB] random

2002-06-04 Thread Natividad Castro
hi to all, I have a drop down menu where users will select a word. After they submit it, I will generate a code number where I want to display the first three characters of the word they selected follow by Month and Date and three number that will be generating randomly. I don't have any problem

Re: [PHP-DB] foreach

2002-06-04 Thread James Kupernik
found my problem .. thank you for your help! You guy put me in the right direction to solve this problem. Thanks!! "Jason Wong" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > On Tuesday 04 June 2002 00:52, James Kupernik wrote: > > yes because I'm using it i

RE: [PHP-DB] query

2002-06-04 Thread Gary . Every
Instead of <> use != Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 "Pay It Forward" mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Natividad Castro [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 11:06 AM To: [EMAIL PROTECTED]

[PHP-DB] query

2002-06-04 Thread Natividad Castro
Hi to all, can anyone please tell me what I'm doing wrong in this query? This one doesn't work when I use <> operator INSERT INTO record_status(rec_id) select 150bk.ID from 150bk WHERE PHY_ST<>'IN' Or PHY_ST<>'OR' Or PHY_ST<>'PA' Or PHY_ST<>'IA' Or PHY_ST<>'MN' Or PHY_ST<>'CO' Or PHY_ST<>'ME' Or

[PHP-DB] RE: [PHP] Ho to write output of sql query to txt file?

2002-06-04 Thread Jay Blanchard
[snip] I did read on mysql.com and your article. Than I tryed to transfer the datasets. Export worked ok. The textfile contains the records. Import message: Query OK, 35 rows affected (0.04 sec) Records: 35 Deleted: 0 Skipped: 0 Warnings: 630 The warning already tells it. the datasets are tota

[PHP-DB] Re: [PHP] Ho to write output of sql query to txt file?

2002-06-04 Thread andy
Original question: > [snip] > I am trying to get only records out of a table mathing a query. This should > be piped into a textfile. My problem is that I have to transmit this records > to a new machine. So the output should be a kind of sql commands which I > could run with phpadmin or similar

[PHP-DB] RE: [PHP] Ho to write output of sql query to txt file?

2002-06-04 Thread Jay Blanchard
[snip] I am trying to get only records out of a table mathing a query. This should be piped into a textfile. My problem is that I have to transmit this records to a new machine. So the output should be a kind of sql commands which I could run with phpadmin or similar to import them to the other db

[PHP-DB] php apache freetds install difficulty

2002-06-04 Thread Wes Forster
Hello, I'm hoping someone can please help me. Solaris8 - Patched to 8_recommended Apache 1.3.24 PHP 4.1.2 freetds .53 gcc 2.95 libgcc libgcj Im needing the mssql interface to work. After I compile Apache during the make process I get. /export/php/ext/mysql/php_mysql.c:1888: undefined refere

[PHP-DB] Ho to write output of sql query to txt file?

2002-06-04 Thread andy
Hi there, I am trying to get only records out of a table mathing a query. This should be piped into a textfile. My problem is that I have to transmit this records to a new machine. So the output should be a kind of sql commands which I could run with phpadmin or similar to import them to the othe

[PHP-DB] Re: SQL Troubles with JOIN, GROUP BY and MAX???

2002-06-04 Thread Adam Royle
I think this is something like you would want... Adam SELECT users.id, username, MAX(stamp) as stamp, filename FROM users, files WHERE users.id = userid GROUP BY username -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php