[PHP-DB] Install SAPDB with Apache and PHP

2002-04-27 Thread Benjamin Heckmann
I got SAPDB (7.3) to compile with the apache (1.3.24) and php (4.1.2) under AIX (4.3.3) without failures and it seems to run. It is quite easy after all, but I had to do a lot of research to get the knowledge: ---START--- cd apache /configure cd ../php /configure --with-apache=../apache --with-

[PHP-DB] Maximum field length with PHP 4.1.2/MSSQL v7 ?

2002-04-27 Thread Chris MacKenzie
Hi All, I've come across an interesting problem. I'm trying to retrieve some text data (in this case a question up to 400 chars), but each time I perform a select statement I only receive the first 255 chars. What's the go here, is this just another microsoft thing ? -- Rgds, Chris MacKenzie W

Re: [PHP-DB] Maximum field length with PHP 4.1.2/MSSQL v7 ?

2002-04-27 Thread pan
From: "Chris MacKenzie" <[EMAIL PROTECTED]> > I've come across an interesting problem. I'm trying to retrieve some > text data (in this case a question up to 400 chars), but each time I > perform a select statement I only receive the first 255 chars. > > What's the go here, is this just another

[PHP-DB] Not Inserting Data

2002-04-27 Thread Neil
Thank you all for your suggestions on why my code is not working. WILL TRY EVERYTHING AND LET YOU GUYS KNOW. Keep up the great work Neil

Re: [PHP-DB] Maximum field length with PHP 4.1.2/MSSQL v7 ?

2002-04-27 Thread bob parker
Pan, It looks as if you may be using FORM with method=get. If so try method=post to get the full data Bob Parker On Saturday 27 April 2002 20:35, you wrote: > From: "Chris MacKenzie" <[EMAIL PROTECTED]> > > > I've come across an interesting problem. I'm trying to retrieve some > > text data (in

Re: [PHP-DB] Maximum field length with PHP 4.1.2/MSSQL v7 ?

2002-04-27 Thread Chris MacKenzie
pan wrote: > > From: "Chris MacKenzie" <[EMAIL PROTECTED]> > > I've come across an interesting problem. I'm trying to retrieve some > > text data (in this case a question up to 400 chars), but each time I > > perform a select statement I only receive the first 255 chars. > > > > What's the go her

Re: [PHP-DB] Maximum field length with PHP 4.1.2/MSSQL v7 ?

2002-04-27 Thread Chris MacKenzie
pan wrote: > i.e., do you know the db.table.field in question is a column type meant > to hold the data you expect? You seem to be indicating a consistent > return of 255 when you ask for 400 - seems to be a clue about the > field specification. Ah, sorry I didn't make it terribly clear. I meant

[PHP-DB] conroling url variable when reading csv file

2002-04-27 Thread chidambaram
Hi All i am reading a file named index.csv through a php script i want make a php script such that for example http://www.chida.com/in.php?topic=flu&col=1,2 the php script should read the index.csv and variables fromthe url and display according to it.In the above example it should read csv fil

Re: [PHP-DB] conroling url variable when reading csv file

2002-04-27 Thread Jason Wong
On Saturday 27 April 2002 22:51, chidambaram wrote: > Hi All > > i am reading a file named index.csv through a php script > i want make a php script such that > > for example http://www.chida.com/in.php?topic=flu&col=1,2 > > the php script should read the index.csv and variables fromthe url > and

[PHP-DB] mysql results to a session variable?

2002-04-27 Thread Jas
I am just wondering if there is a way to pull the results from an mysql query into an session variable that can be passed from page to page. If there is a way to do this could someone please point out a good tutorial on this "specific" function or maybe an example of how to accomplish this. Any

Re: [PHP-DB] Maximum field length with PHP 4.1.2/MSSQL v7 ?

2002-04-27 Thread pan
cc:'d to poster >Ah, sorry I didn't make it terribly clear. I meant that I only ever get >a maximum of 255 chars returned. O.K. - then that makes it seem a truncation problem and not a data definition problem. minor thing: in edit_exam_question.php there is " print 'Select Correct Answer:';

[PHP-DB] Re: Newbie and having to convert from idc/htx format

2002-04-27 Thread Frank Flynn
On 4/27/02 1:52 AM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: I'm not too familiar with idc/htx but I have used PHP, IIS, MS SQL and Linux and had great results. Here are some ideas that might help you: -Try installing PHP on your current server (IIS) now you can convert sections of your w

[PHP-DB] select and sort question

2002-04-27 Thread Kirk Babb
I have a db table which holds news in the following manner: ID (auto-increment), newsdate (DATE), newstitle, and newstext I have been displaying them by ID, and would like instead to sort them by date (descending). Since I'm using Flash I have been doing mysql_fetch_array for each ID query and t

Re: [PHP-DB] select and sort question

2002-04-27 Thread mike
There are many ways to sort by date. I use something like this SELECT * FROM newsitems WHERE newsdate=(whatever date you want); For selecting records for the current date I use php's date function to get the current date in the right format. $current_date = date("Ymd"); SELECT * FROM newsitems

Fw: [PHP-DB] select and sort question

2002-04-27 Thread Richard Emery
Why don't you sort in your SELECT statement? SELECT * FROM newsitems where ID='1' ORDER BY newsdate DESC - Original Message - From: Kirk Babb <[EMAIL PROTECTED]> To: <> Sent: Saturday, April 27, 2002 3:56 PM Subject: [PHP-DB] select and sort question I have a db table which holds news

Re: [PHP-DB] Maximum field length with PHP 4.1.2/MSSQL v7 ?

2002-04-27 Thread Chris MacKenzie
pan wrote: > >Ah, sorry I didn't make it terribly clear. I meant that I only ever get > >a maximum of 255 chars returned. > > O.K. - then that makes it seem a truncation problem and not a > data definition problem. > > minor thing: in edit_exam_question.php there is > " print 'Select Correct

Re: [PHP-DB] Maximum field length with PHP 4.1.2/MSSQL v7 ?

2002-04-27 Thread pan
cc:'d to poster From: "Chris MacKenzie" <[EMAIL PROTECTED]> > > Either one of the unknown queries in edit_exam_question.inc > > is truncating the data or the url parameter is truncated, or > > dbconn.inc is the culprit. > > I've attached the two missing files, so this should help to diagnose > w