[PHP-DB] Re: MSSQL question

2001-09-21 Thread John Lim
Just install php and enable in your php.ini file the line extension=php_mssql.dll And make sure this dll is in your php extension folder. Regards, John "Sharif Islam" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > I already have a MSSQL 7 installed in win

Re: [PHP-DB] How to make it case sensitive?

2001-09-21 Thread David Bullock
On Fri, 21 Sep 2001 14:28:52 -0400, [EMAIL PROTECTED] (Jason Stechschulte) wrote: >On Fri, Sep 21, 2001 at 05:02:14PM +0100, Denny Suvanto wrote: >> The script is just fine until I notice that the >> username is case insensitive. So, if a member has a >> username "andy" he can log in using >> "a

Re: [PHP-DB] How to do this with PHP

2001-09-21 Thread Meir Kriheli
On Friday 21 September 2001 21:47, Rick Emery wrote: > SELECT * FROM mytable LIMIT 0,5 > SELECT * FROM mytable LIMIT 6,5 > SELECT * FROM mytable LIMIT 11,5 > SELECT * FROM mytable LIMIT 16,5 It is advised to add ORDER BY _col_name_here_ to guarantee the order of rows retrieved (otherwise, you

[PHP-DB] MSSQL question

2001-09-21 Thread Sharif Islam
I already have a MSSQL 7 installed in win2k with IIS. I want to install php. Do i need to configure anything with mssql? thanks ) (( |""|-. | :|/' -`--'- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:

RE: [PHP-DB] How to do this with PHP

2001-09-21 Thread Rick Emery
SELECT * FROM mytable LIMIT 0,5 SELECT * FROM mytable LIMIT 6,5 SELECT * FROM mytable LIMIT 11,5 SELECT * FROM mytable LIMIT 16,5 -Original Message- From: Alawi Albaity [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 1:44 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] How to do th

[PHP-DB] How to do this with PHP

2001-09-21 Thread Alawi Albaity
I have a table .. this table have 20 record.. I want to view this record in the 4 pages (5 record by page).. how can I do that !! __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com

Re: [PHP-DB] How to make it case sensitive?

2001-09-21 Thread Jason Stechschulte
On Fri, Sep 21, 2001 at 05:02:14PM +0100, Denny Suvanto wrote: > The script is just fine until I notice that the > username is case insensitive. So, if a member has a > username "andy" he can log in using > "andy", "Andy", "aNdY", "andY", and so on. I also > notice that I can't enter a new member

[PHP-DB] Re: ELF Header problem

2001-09-21 Thread lo-tek
To begin with, ELF is a Linux executable file format, whereas .DLL denotes a Windows dynamic link library (equivalent functionally to a .SO). looks like youre mixing PHP components across OSes Vipin <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi, > Please c

[PHP-DB] Re: How to test if mysql_fetch_array returns no results ?

2001-09-21 Thread Bill Blancett
Disregard the previous post. I figured out that mysql_num_rows() returns the number of rows from the result of a SELECT query. "Bill Blancett" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I am new to PHP so I am need someone to explain this problem to me. I

[PHP-DB] sybase-ct lib, Sybase ASE 12.5, Linux

2001-09-21 Thread Carlo Borreo
Did someone succeed installing Php with sybase-ct extension, on a Linux system containing ASE 12.5? When compiling, it doesn't find the include, because with the new version of ASE the are in $SYBASE/OSE/include, rather than $SYBASE/include. I moved the include file where compiler could find it, a

[PHP-DB] How to test if mysql_fetch_array returns no results ?

2001-09-21 Thread Bill Blancett
I am new to PHP so I am need someone to explain this problem to me. I am trying to read items from a table and store them into an array. My current function of choice to use is "mysql_fetch_array". The documentation says that it returns FALSE if there are no more rows returned, but yet when the q

[PHP-DB] How to make it case sensitive?

2001-09-21 Thread Denny Suvanto
I have a web site backup with PHP& MySQL. I write a script, so a member can log in into the member area. I build a database for the username, password, and some other information for the member. I set the username (which type is varchar) as the primary key. For the authentication scheme I use :

Re: [PHP-DB] Searching MySQL using LIKE

2001-09-21 Thread Hugh Bothwell
"Jason Wong" <[EMAIL PROTECTED]> wrote in message news:000301c1428d$f11b3a80$[EMAIL PROTECTED]... > The obvious first thing to do is to screen your keywords. Do not search on > common words such as: > > and, if, the, in etc. An easy way to do this is to set up an array of words to exclude. Then

RE: [PHP-DB] INSERT prob

2001-09-21 Thread Jason Wong
>Hallo everyone >I am, as one might say, 'near yet so far' > >* I have a page of user subscription info generated on the fly >* I want an administrator to check a box on each result set >* The info from each checked result set should be inserted into >another table (A new row/tuple for >each u

Re: [PHP-DB] INSERT prob

2001-09-21 Thread Rick Gardner
What are the values for your checkbox? I would consider making the value the index for the corresponding element. So <.input type=checkbox name='approved[]' value=0> <.input type='text' name='name[1]' value='John Smith'> <.input type=checkbox name='approved[]' value=1> <.input type='text' nam

[PHP-DB] INSERT prob

2001-09-21 Thread Russ Michell
Hallo everyone I am, as one might say, 'near yet so far' * I have a page of user subscription info generated on the fly * I want an administrator to check a box on each result set * The info from each checked result set should be inserted into another table (A new row/tuple for each user)

RE: [PHP-DB] MySQL Query Weirdness

2001-09-21 Thread Rick Emery
easier solution: while ($line = mysql_fetch_array($result)) { print "\t\n\t\t".$line['first_name']."\n\t\n"; } -Original Message- From: Steve Cayford [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 20, 2001 5:16 PM To: Chris S. Cc: [EMAIL PROTECTED] Subject: Re:

Re: RE: [PHP-DB] Searching MySQL using LIKE

2001-09-21 Thread Russ Michell
Try: REGEXP 'keyword?'; //Matches Zero or one instances of 'keyword' REGEXP 'keyword+'; //Matches One or more instances of 'keyword' REGEXP 'keyword*'; //Matches Zero or more instances of 'keyword' Cheers. Russ '; On Fri, 21 Sep 2001 04:14:47 -0700 Ralph G

[PHP-DB] Re: cross tab with mssql

2001-09-21 Thread amtd
Your can use ODBC. "Sommai Fongnamthip" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi, > I was used MS Access to make cross tab query with MS SQL. How could I do > this with PHP? I was used syntax of MySQL but It did not work. > > Thank you, > SF > > Thi