[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 This is an

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

RE: [PHP-DB] MySQL Query Weirdness

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

[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] 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'

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 user) I

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 you

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

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

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

[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

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 with username

[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

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

[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 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 andy, Andy,