[PHP-DB] Domain registration

A while ago, there was an exchange about alternative domain registration organizations, ie other than Network Solutions. I intended to save the messages but seemingly deleted them. Could someone remind me what the alternatives are. Thanks (and sorry!) Regards Mick Lloyd [EMAIL PROTECTED] Tel: +4

RE: [PHP-DB] MSSQL Identity Column

I don't have the full answer off hand, but I do remember that if you do: sp_columns your_table_name One of the columns of that result is a numeric value that indicates whether the column is a primary key. I think I had to create a test table with a primary key to figure out what the column and n

[PHP-DB] Escape for MSSQL?

Hi! Does anybody know how I can store a double-quote (") within a string in a MSSQL-database? For a single-quote (') I can use a single quote as esc.-char (''), but that doesn't work with double quotes? Isn't there a common escape-char or sequenz like the backslash in C? Many thanks in advance

[PHP-DB] Re: Domain registration

Try http://www.Below10Domain.com They register domains for just $9.95 per year. Best regards, Lisa Elita [EMAIL PROTECTED] - Original Message - From: "Mick Lloyd" <[EMAIL PROTECTED]> To: "Database Help PHP" <[EMAIL PROTECTED]> Date: Fri, 13 Apr 2001 08:50:49 +0100 Subject: Domain regist

Re: [PHP-DB] Escape for MSSQL?

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... } }Does anybody know how I can store a double-quote (") within a string in }a MSSQL-database? } See: http://www.mysql.com/doc/S/t/String_syntax.html And the handy PHP function addslashes() http://www.php.net/manual/en/function.addslashes

RE: [PHP-DB] Escape for MSSQL?

You may also double it : "" Manuel Prieur -Message d'origine- De : Jeff Carnahan [mailto:[EMAIL PROTECTED]] Envoyé : vendredi 13 avril 2001 20:02 À : [EMAIL PROTECTED] Objet : Re: [PHP-DB] Escape for MSSQL? In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... } }Does anybody know

Re: [PHP-DB] Escape for MSSQL?

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... }In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... }} }}Does anybody know how I can store a double-quote (") within a string in }}a MSSQL-database? }} } }See: http://www.mysql.com/doc/S/t/String_syntax.html } }And the handy PHP fun

[PHP-DB] SELECT query

I have three table called table1, table2, table3 all having fields like: table1 contain id and username and id referencing table4 table2 contains id and parallel_username and id referencing table4 table3 contains id and other_username and id referencing table4 table4 is the main table containing

Re: [PHP-DB] SELECT query

Have you thought about normalizing your data model? It could make your task a lot easier. Doug At 11:33 PM 4/13/01 +0530, Sharmad Naik wrote: >I have three table called table1, table2, table3 all having fields like: >table1 contain id and username and id referencing table4 >table2 contains id a

Re: [PHP-DB] SELECT query

On Fri, Apr 13, 2001 at 02:23:50PM -0400, Doug Semig wrote: > Have you thought about normalizing your data model? It could make your > task a lot easier. I have normalized my table structure this is just a practice model i m trying I want that the search should be on username whereby first i se

Re: [PHP-DB] diferent user passwords

* Romeo Manzur ([EMAIL PROTECTED]) wrote: > how could I configure diferent user password to each database on my > server??? You can probably achieve this with grant statements. Grant SELECT on test.* to myuser@localhost identified by 'pass1'; Grant SELECT on other.* to myuser@localhost identifi

[PHP-DB] odbc_fetch_row

When I run a query, even if it is empty I still get a valid identifier for the result. How do I determine that there is nothing in the result, even though the result is valid (just empty)? I thought about odbc_fetch_row, but that moves the pointer forward and I don't want that; there may be va

RE: [PHP-DB] odbc_fetch_row

maybe you could try odbc_num_rows($yourResultID) this will return 0 if there is nothing in the result set or the number of rows otherwise look in the php manual for more info http://www.php.net/manual/en/function.odbc-num-rows.php note that it might return -1 (thus not work as intended) with som

Re: [PHP-DB] Escape for MSSQL?

Hello! Many thanks for the answers and the link, I'll check on Tuesday in the office. Cu, Thomas Jeff Carnahan wrote: > In article <[EMAIL PROTECTED]>, > [EMAIL PROTECTED] says... > }In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... > }} > }}Does anybody know how I can store a double-

RE: [PHP-DB] oracle 8i client/ PHP 4.0.4pl1 breaks

I think if you compile php into apache (not as a DSO), you'll see the errors. I believe you're on the right track though, you might wanna check your env. to see if $ORACLE_HOME/lib is set in $LD_LIBRARY_PATH or not. - panya -Original Message- From: Dave Thomas [mailto:[EMAIL PROTECTED]]

[PHP-DB] Postgres auto increment.

I've been using mysql too much lately. Can anyone tell me how to set up an auto increment in postgres? I need to select a row based on a user's menu selection. Requiring them to type in a text entry and get it right would obviously be pretty inefficient. Thanks, John -- PHP Database Mailing

RE: [PHP-DB] Postgres auto increment.

> I've been using mysql too much lately. > > Can anyone tell me how to set up an auto increment in postgres? I need > to select a row based on a user's menu selection. Requiring them to type > in a text entry and get it right would obviously be pretty inefficient. Either user a data type of 'ser

Re: [PHP-DB] Postgres auto increment.

Just off the top of my head...so please forgive any typos or blatant mistakes... CREATE SEQUENCE sequencename; CREATE TABLE mytable ( id int DEFAULT NEXTVAL('sequencename'), whatever varchar(32), PRIMARY KEY(id) ); Doug At 11:28 PM 4/13/01 -0600, John Starkey wrote: >I've been using mysql