[PHP-DB] PHP - DB2 / odbc_connect() failed

2002-03-07 Thread Jerry
Hello All, I have IBM DB2 v7.2 FP5 on a Windows 2000 Server A Linux Web server running with Apache/PHP4 And IBM DB2 V7.2 Client Install on it. When I try to use odbc_connect($dbname, $user,$password); I received the message: Warning: SQL error: , SQL state ¿Ë ?=z@éÿ¿ÛË ?=z@?=z in SQLConnect

[PHP-DB] mssql_fetch_row() failed to get data with float data type ??

2002-03-07 Thread william
I use PHP 4.0.6 on linux (Red Hat 7.0) to access MS SQL Server 7.0. I can connect to database and get the correct data with char or int data type, but it showed '0' if data type is float or real. Did any one know why it happened ? Thanks in advance. William Hung -- PHP Database Mailing

[PHP-DB] Post code / zip code look up ?

2002-03-07 Thread Dave carrera
Has anyone had experience in the implementation of some kind of post code or zip code lookup function. Ie: Client puts his or her post code or zip code in a form and on submit the db gives back a reseller nearest to that post or zip code. I have seen this on a lot of sites and have no

RE: [PHP-DB] Post code / zip code look up ?

2002-03-07 Thread Alastair Battrick
Has anyone had experience in the implementation of some kind of post code or zip code lookup function. yes I have seen this on a lot of sites and have no idea where to start such a task. we started by buying a license for the data from the post office which cost a load of money. then we

Re: [PHP-DB] Bindbyname error in solaris

2002-03-07 Thread Thies C. Arntzen
On Wed, Mar 06, 2002 at 10:59:33PM +0500, Mohammad Saad wrote: Hello I have PHP4.10 on solaris with oci8 support. everything seems to work well. Oracle support is working fine. but I am getting an error when I am trying OCIBindByName to bind a variable to an out variable of a stored

[PHP-DB] Best way to store/retrieve content??

2002-03-07 Thread Monty
I'm writing some content management scripts for an online magazine. Many articles are formatted in a similar way, but some have a unique page layout that includes grids of photos, tables, etc. I'm not sure if the best way to store content is in a database so it can be flowed into an article

RE: [PHP-DB] Best way to store/retrieve content??

2002-03-07 Thread Leotta, Natalie (NCI/IMS)
Could you use PDFs? -Natalie -Original Message- From: Monty [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 2:31 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Best way to store/retrieve content?? I'm writing some content management scripts for an online magazine.

RE: [PHP-DB] Best way to store/retrieve content??

2002-03-07 Thread Shrock, Court
I would try to use CSS, instead of complex tables. That way, you only need to store the structural html in the database and the layout is handled by CSS--floating images and flowing text are really easy with CSS. -Original Message- From: Monty [mailto:[EMAIL PROTECTED]] Sent:

Re: [PHP-DB] Best way to store/retrieve content??

2002-03-07 Thread Monty
I will be using CSS for other thing, such as paragraph formatting, but, not sure how to use it for creating tables and flowing text around graphics. Can CSS really do all that? Still not sure if this will work because I don't want the writers to have to type in any HMTL code at all if possible.

Re: [PHP-DB] Best way to store/retrieve content??

2002-03-07 Thread Monty
Hi Natalie, no, PDFs won't work. I need to display the content as an HTML page. From: [EMAIL PROTECTED] (Natalie Leotta) Newsgroups: php.db Date: Thu, 7 Mar 2002 14:32:57 -0500 To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Best way to store/retrieve content?? Could you use PDFs?

RE: [PHP-DB] Best way to store/retrieve content??

2002-03-07 Thread Leotta, Natalie (NCI/IMS)
In theory, if your writers are using a word processor such as Word you could try just saving as HTML and seeing if that works. I doubt they'd appreciate it if you asked them to write in FrontPage, but that would give you what you need too. If these ideas don't work you may want to browse other

RE: [PHP-DB] Best way to store/retrieve content??

2002-03-07 Thread Peter Lovatt
Hi I have done a similar thing, and found that you can store just the text in the database. I added 'Short_content' which was a leader, and some other fields for management. I designed a few templates in Dreamweaver and embeded a function to display the content in the page eg trtd?php

RE: [PHP-DB] Best way to store/retrieve content??

2002-03-07 Thread Shrock, Court
Actually, CSS is very powerful--way more than simple html. One drawback is that CSS1 did not include any support for tables directly, but the generic controls work nicely, there just is no way to say table align=center in CSS1. A great book that taught me a lot about CSS is

[PHP-DB] Can I attach an image to a newsgroup post?

2002-03-07 Thread Monty
Is it possible to attach an image to a post here in order to better illustrate a point? If so, how?? Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Best way to store/retrieve content??

2002-03-07 Thread Monty
Hi Peter, thanks a lot for your advice. I think where I'm stuck is how to best store certain types of articles in a data table. Interviews would be easy, because it's just paragraphs of text with an inline photo here and there. The more structured articles are trickier and I can't figure out how

Re: [PHP-DB] Best way to store/retrieve content??

2002-03-07 Thread Monty
Hi Court, thanks a lot for your advice. I am fairly new to PHP, so, I'm a little slow in understanding some of the suggestions in your detailed post. From what I gather, you suggested that an Admin script be created to basically build each portion of an article piece by piece, which would then

Re: [PHP-DB] Can I attach an image to a newsgroup post?

2002-03-07 Thread Paul Burney
on 3/7/02 3:34 PM, Monty at [EMAIL PROTECTED] appended the following bits to my mbox: Is it possible to attach an image to a post here in order to better illustrate a point? If so, how?? Thanks! Please don't upload the image (or any other attachments) to the list/newsgroup. It's better to

RE: [PHP-DB] Best way to store/retrieve content??

2002-03-07 Thread Shrock, Court
Valid point--I was thinking that in a news article or such, the content is mostly already created and edited, just needed to be posted by someone not familar with HTML. I like your idea about the [start-stop block]. To maybe merge what Paul said with your idea, you could store the name of the

RE: [PHP-DB] Best way to store/retrieve content??

2002-03-07 Thread Shrock, Court
I like your idea about the [start-stop block]. To maybe merge what Paul said with your idea, you could store the name of the function handler (generates the appropriate content) inside the []. I meant Peter :) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Monitor files

2002-03-07 Thread jas
I am wondering if there is a way to monitor the contents of a directory for changes and if a change is made, to record the name of the file changed the date etc and send it to a database and also an email... has anyone every seen anything like this and if so are there any intrustion detection

[PHP-DB] looking for a particular script, or how-to...

2002-03-07 Thread chip . wiegand
I'm looking for a script that will give me this - a web page that shows who is currently accessing my mysql database. If it could provide other details that would be great too. I'm not sure how to go about setting this up. I couldn't find any mysql command that shows the users accessing the

[PHP-DB] counting of values in one field possible with one sql statement?

2002-03-07 Thread Andy
Hi there, I am wondering if it would be possible to get the amount of different values in one sql command. E.g.: field age: 0,3,5,5,2,3 Sql querry should return how often 3 occurs. Which would be 2. And as well the other values... 1 for agestructure 2 becuase it occures only once. I wrote

RE: [PHP-DB] Best way to store/retrieve content??

2002-03-07 Thread Peter Lovatt
Hi I am not an expert but could XML be an answer? The author(s) gets a screen designed by you, looking like the screen you will publish, with type in text boxes (name=short_text1, name=short_text2 etc )where the text will be. When you store the input from the form you end up with article

[PHP-DB] Re: counting of values in one field possible with one sqlstatement?

2002-03-07 Thread Frank Flynn
Yes, in fact there is a faster way, GROUP BY SELECT COUNT(*) AS c, age FROM $T5 GROUP BY age This will give you two columns 'c' and 'age' which will be the count (the number of) and each age. So from your example (0,3,5,5,2,3) we'd get: c age 1 0 2 3 2 5 1 2 That's

[PHP-DB] Soft-Linking and includes

2002-03-07 Thread Jonathan Hilgeman
I'm on a red hat system, and I've soft-linked two directories: /www/dir1/subdir /www/dir2/subdir -- /www/dir1/subdir Now, inside subdir is a file that tries to include(../info.php); which prints out some information about the file paths and my database stuff. So there's: /www/dir1/info.php

Re: [PHP-DB] Email Validation

2002-03-07 Thread CrossWalkCentral
How would I go about doing the DNS look up part? Markus Lervik [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... On Tuesday 12 February 2002 06:19, CrossWalkCentral wrote: I am working on a form that I have in php and am looking for some advise on form

[PHP-DB] MySQL Result

2002-03-07 Thread Chris Payne
Hi there everyone, I have delete working perfectly by doing the following: include(connectionstart.php); mysql_query (DELETE FROM emaillist WHERE EMail = '$email' ); However, how do I return a true or false flag whether the row was deleted or not? I basically need to know how to do a 0 or 1

Re: [PHP-DB] Re: Split a long db record into multiple pages

2002-03-07 Thread Jason Wong
On Friday 08 March 2002 10:12, CrossWalkCentral wrote: I am interested in receiving some help on this one as well. Will [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Does anyone know how to limit a long record, like a news article that has 5 pages?

[PHP-DB] ora-12705

2002-03-07 Thread Yusuf Akyol
Hi to Everybody, I try to set env parameter (NLS_LANG) of Oracle but I got 'ORA-12705' message. Does anybody know ,why? I use PHP and Apache's last releases and Oracle 8.0.5. Best reagrds. _ Yusuf AKYOL ICQ#:361342 Current ICQ status: SMS: (Send an SMS