[PHP-DB] MSSQL - NT - ntext data type

I've got a problem in fetching (SELECT-statement) data type ntext out of MS SQL Server 7.0 As sonn as I include the 'ntext'-column in the SELECT-Staement: the following happens:  - Using 'ODBC': the apache writes into error log the message: FATAL: emalloc():  Unable to allocate 1073741824

[PHP-DB] MSSQL - NT - ntext data type

I've got a problem in fetching (SELECT-statement) data type ntext out of MS SQL Server 7.0 As sonn as I include the 'ntext'-column in the SELECT-Staement: the following happens: - Using 'ODBC': the apache writes into error log the message: FATAL: emalloc(): Unable to allocate 1073741824

[PHP-DB] Re: UPDATE Not Updating

I echoed out the $update_contact_sql and I'm getting FirstName='Value', etc. WHERE ContactID='' There is no value in ContactID. I've changed the double quotes to single quotes and dropped the quotes all together with $ContactID. I ran the query in MySQL client and gave the ContactID a value

Re: [PHP-DB] phpMyAdmin: delete table

Hi I think you don't have php running on your machine. you need php in order to use php myadmin. Joris - Original Message - From: thomas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 03, 2001 3:30 PM Subject: [PHP-DB] phpMyAdmin: delete table Hi, I'm new to phpMyAdmin

[PHP-DB] Permissions

I'm trying to build a menu page that builds links based upon specified permissions that are associated with a username or userid. I figure it might be best to associate individual privleges to specific menu items within the usertable (using checkboxes, etc). then building the menu based upon the

[PHP-DB] Re: Allowing refresh without form processing?

What are you using to process your form with? Do you fopen () a page and write to it - or store info in a MySQL database and retrieve it? -Stoney -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To

[PHP-DB] #usr showing up

Hi, I am running php as cgi. The top line , #/usr/bin/lib, is showing up on the php page when the script executes. How can I avoid this. Please help. Thank you, Vipin. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:

[PHP-DB] using text files with email in php

Hello, I want to use one of my php script to send my customer an email however I want it to send the the contents of a text file in the same directory. so that way all I have to do is modify the test file if I want it changed w/o changing the php script. I would also like to make variables

Re: [PHP-DB] Connect to MySQL through Proxy?

Or write a mysql-http pipe... that shouldn't be very hard write a php script that would echo all data on the source side, and a php script that would fopen the url of the source server, and put everything into the database. Stéphane -- PHP Database Mailing List (http://www.php.net/)

[PHP-DB] Setting up authentication with redirect

I recently got a copy of that PHP and MySQL Web Development book and found a script that lets you do a simple authorization script with a login popup box where you have to enter the username and password to continue. The code in the book has it where it shows text like authorization successful

Re: [PHP-DB] auto fill field with value from another

At 03.08.2001 20:38, you wrote: Is there a way to have a field in a MySQL table automatically be filled whenever that row is created or updated with the value of another field in the same table? Is there a way to have it filled with a calculation based on another field? thanks, bill hollett

[PHP-DB] Re: MySQL/PHP Troubles :( anyone have a solution?

You're not echoing anything back to the browser. For example change this: if ($action == logout) { unset ($login_user); unset ($login_password); unset ($action); } to this: if ($action == logout) { echo You chose to log outbr; unset ($login_user); unset ($login_password); unset

[PHP-DB] Inserting NULL?

I have a variable that is either Yes or No. I would like NULL to be inserted if it's No. Can I do this? if ($variable == 'No') { $variable = 'NULL'; } then INSERT it. Thanks. Jeff Oien -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For

RE: [PHP-DB] Inserting NULL?

Jeff, So you are relly looking at an effect similar to a check box. I'll admit I prefer explicit yes's and no's; if a field is just empty I wonder if it somehow got missed. Different styles. Miles At 03:35 PM 8/3/01 -0500, Jeff Oien wrote: What I want in the output from the database is for

Re: [PHP-DB] Configuration

On Fri, 3 Aug 2001, Robert Fitzpatrick wrote: Hello: I configured PHP originally --with-mysql and now I want to also use PostgreSQL with PHP. Can I just re-run the './configure --with-mysql --with-pgsql --enable-track-vars' again. Then do another 'make' and 'make install'? Thanks for the

[PHP-DB] Re: Array and ID

Hi, I have a drop-down menu that has been prepopulated with an array from a column name CompanyName. What I need to do is take the CompanyName lookup the CompanyID in the company table and insert the CompanyID into a row in a table called contacts with a CompnayID column. [...] Is this a

Re: [PHP-DB] phpMyAdmin: delete table

Don't know about phpAdmin, but in straight PHP, after you've connected to database, etc. $sql = drop table tablename; $result = mysql_query( $sql ); Do yuo use PHP anyway? the comment on that was probably it. Otherwise, if you ahve command line access to mysql then the above SQL (DROP

Re: [PHP-DB] Connect to MySQL through Proxy?

At 03.08.2001 13:36, David Viner wrote: Does anyone know if it is possible to make a MySQL connection (using mysql_connect or mysql_pconnect) through a proxy server? I need to be able to synchronise from one server on an internal network through to one on the web - doing it when a proxy is not