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
> 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 (DRO
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
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
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 f
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 add
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 out";
unset ($login_user);
unset ($login_password);
uns
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 h
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"
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/)
T
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 in
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:
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
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
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 phpMy
Don't know about phpAdmin, but in straight PHP, after you've connected to
database, etc.
$sql = "drop table tablename";
$result = mysql_query( $sql );
if you want to test for the table before deleting use
$sql = "drop table if exist tablename";
HTH - Miles
At 03:30 PM 8/3/01 +0200, thomas wr
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 whic
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 byte
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 byte
19 matches
Mail list logo