[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

[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

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 this case

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 here, is this just

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=flucol=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

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=flucol=1,2 the php script should read the index.csv and variables fromthe url and display

[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 'a align=leftSelect Correct

[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 web

[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

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 in

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 'a align=leftSelect