Having email issues with my host. Kept getting rejected email Mail
Daemon errors from my host. Thanks Jim for letting me know that the
list was receiving the posts. :)
:)
Gale L. Allen Jr
Macintosh Support Specialist
Phone: 919/412-5039
Homepage:
Hello,
I'm looking at using md5() and mysql for user auth to some of the data
in a table. I found the following on the php md5 manual page,
$query = INSERT INTO user VALUES ('DummyUser',md5('DummyPassword'));
$password = md5($password);
$query = SELECT * FROM user WHERE username='DummyUser'
Mike Baerwolf wrote:
I'm looking at using md5() and mysql for user auth to some of the data
in a table. I found the following on the php md5 manual page,
$query = INSERT INTO user VALUES ('DummyUser',md5('DummyPassword'));
$password = md5($password);
$query = SELECT * FROM user WHERE
Hello,
Beta 2 of plPHP has been released. This version contains many bug
fixes. For example, if you write bad plphp code and try to execute it,
the code will no longer crash PostgreSQL ;).
The URL is here: http://www.commandprompt.com/entry.lxp?lxpe=260
There are precompiled binaries for
Hello Everyone,
I am working on PHP and PostGREsql.My doubt is first i am
inserting my required information to the table after that i am updating
one field with same information for all the records, now i want to update
a particular record , i am able to update in database, but
Hi guys,
This is weird to me..
I got this script
---
?php
if ($_GET[login] == 'forgot')
{
echo Sorry I forgot my password;
}
else { echo you are good to go; }
?
I am querying a database just fine.
Getting back what I expect, just fine.
But now I've been thrown a wrench in the form of double row display.
my client wants...
a b
c d
e f
...
Well, I've reached the end on my PHP/SQL knowledge (which really isn't all
that far!)
Right
I'm not sure i understand the problem.
Do a,c,e come from one query result and b,d,f from another?
If it's all from the same query why not do :
$result=mysql_query(.
TABLE
While($row = mysql_fetch_object($result)) {
EchoTRTD$row-feild_A/TDTD$row-feild_B/TD/TR;
}
/TABLE
Sincerely
berber
This is the SoBig.F virus.
It hijacks a random email address form an infected persons phone book, uses
that address as the SENDER, and then proceeds to mail out copies of itself
to everyone in he infected persons phone book.
I've had my address hijacked twice now.
So, be warned, clean your
Boaz Yahav [EMAIL PROTECTED] wrote in message
I'm not sure i understand the problem.
a,c,e come from one query result and b,d,f from another?
No, they all come from the same table, but the same field name but from
different rows of the database.
If it's all from the same query why not do :
Quoting [EMAIL PROTECTED]:
From: Gnanavel [EMAIL PROTECTED]
I have problem in executing linux command
$output=exec(ls -a);
echo pre$output/pre;
the above coding works, but
$output=exec(cp file1 file2);
echo pre$output/pre;
does not works. can any one help me out of
One question:
Do you mean that a b are from the same column but are row 1 2 from
your query result.?
If so, you can possibly write a loop like so
Dump all your records in an array;
Start loop for as long you find records in array
{
Take the first record from your array and dump it
You can do:
while ($row = $result-fetchRow(DB_FETCHMODE_ASSOC))
{
extract ($row);
echo $feild_A . 'nbsp';
$row = $result-fetchRow(DB_FETCHMODE_ASSOC);
extract ($row);
echo $feild_A . 'br /';
}
Tiberiu
- Original Message -
From:
Try:
if ($_GET['login'] == 'forgot')
- Original Message -
From: OpenSource [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 29, 2003 7:38 AM
Subject: [PHP-DB] weird php error
Hi guys,
This is weird to me..
I got this script
On 29 August 2003 05:27, Joshua D. Drake wrote:
Hello,
Beta 2 of plPHP has been released. This version contains many bug
fixes. For example, if you write bad plphp code and try to
execute it,
the code will no longer crash PostgreSQL ;).
It would be nice if you told us what plPHP
On 29 August 2003 06:39, OpenSource wrote:
Hi guys,
This is weird to me..
I got this script
--- ?php
if ($_GET[login] == 'forgot')
{
echo Sorry I forgot my password;
} else { echo you are
Hi,
How can I SELECT a portion of a field in a table for example the first
character, or the second two characters etc?
Thanks for your help
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
SUBSTRING()
_
- Original Message -
From: Shaun [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 29, 2003 11:57 AM
Subject: [PHP-DB] SELECT Part of a Field
Hi,
How can I SELECT a portion of a field in a table for example the first
character, or
Depending on the database you are using
Substring()
Substr()
Functions do what you want
jack
-Original Message-
From: Shaun [mailto:[EMAIL PROTECTED]
Sent: Friday, August 29, 2003 11:58 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] SELECT Part of a Field
Hi,
How can I SELECT a
El Vie 29 Ago 2003 06:15, Ford, Mike [LSS] escribió:
On 29 August 2003 05:27, Joshua D. Drake wrote:
Hello,
Beta 2 of plPHP has been released. This version contains many bug
fixes. For example, if you write bad plphp code and try to
execute it,
the code will no longer crash
Hi there,
I would like to delete a row inside a mysql table. To find out which
rows are affected the system has to check another table.
Somehow I am doing this statement wrong and I cant find out why. Does
anybody see the error?
Thanx for any help on that.
DELETE
FROM $table1 pi
RIGHT
Merlin wrote:
I would like to delete a row inside a mysql table. To find out which
rows are affected the system has to check another table.
Somehow I am doing this statement wrong and I cant find out why. Does
anybody see the error?
Thanx for any help on that.
DELETE
FROM $table1 pi
RIGHT
try
if (isset($_GET['login']) AND $_GET['login'] == 'forgot')
KD
On Fri, 29 Aug 2003, Tiberiu Ardeleanu wrote:
Try:
if ($_GET['login'] == 'forgot')
- Original Message -
From: OpenSource [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 29, 2003 7:38 AM
Subject:
Hi John,
I am using MySQL 3.x
My guess is that it does not support a query like this. If so, I am sure
that there is a workaround I just dont know about. The values $tablex
are present.
This is the error msg:
Error: 1064 You have an error in your SQL syntax near 'pi INNER JOIN
table2 AS p
Merlin wrote:
Hi John,
I am using MySQL 3.x
My guess is that it does not support a query like this. If so, I am sure
that there is a workaround I just dont know about. The values $tablex
are present.
This is the error msg:
Error: 1064 You have an error in your SQL syntax near 'pi INNER
At 09:33 AM 8/29/2003, you wrote:
You can do:
while ($row = $result-fetchRow(DB_FETCHMODE_ASSOC))
{
extract ($row);
echo $feild_A . 'nbsp';
$row = $result-fetchRow(DB_FETCHMODE_ASSOC);
extract ($row);
echo $feild_A . 'br /';
}
close, but
Error: 1064 You have an error in your SQL syntax near 'pi
INNER JOIN
table2 AS p ON p.ID = pi.product_id WHERE p.ow' at line 3
pi() is a mysql function that returns the value of pi. Could the pi in your
query be causing some confusion? It seems that MySql may be expecting pi()
not
At 09:33 AM 8/29/2003, you wrote:
You can do:
while ($row = $result-fetchRow(DB_FETCHMODE_ASSOC))
{
extract ($row);
echo $feild_A . 'nbsp';
$row = $result-fetchRow(DB_FETCHMODE_ASSOC);
extract ($row);
echo $feild_A . 'br /';
}
close,
Is anybody else getting returned mail notices from the qmail-send program at
pb1.pair.com? I seem to get one with each post I send to the list and I
don't know what's happening with my posts.
Not that they're pure gold or anything, but could somebody just confirm
that my posts are getting through
El Vie 29 Ago 2003 11:51, Hutchins, Richard escribió:
Is anybody else getting returned mail notices from the qmail-send program
at pb1.pair.com? I seem to get one with each post I send to the list and I
don't know what's happening with my posts.
Not that they're pure gold or anything, but
My code:
$query=
CREATE TABLE IF NOT EXISTS temp3 UNIQUE(CON175)
IGNORE SELECT DISTINCT CONCAT($tbl2.this,$tbl2.that) AS CON175 FROM
$tbl2
WHERE $tbl2.this='$rcc'
;
gives error:
Query failed: BLOB column 'CON175' used in key specification without a key
length.
Manual
Fellow PHP-DB listers:
Thank you to those of you who replied to let me know that I am not the only
one experiencing this problem. For everybody else's edification, some of the
other members of this list have stated that they have notified the
postmaster of the problem. It's really just an
You should be very wary of the CREATE TABLE ... SELECT statement.
From experience, the types created are not always conform to intuition -
I've had my share of nasty surprises
Much safer to do a CREATE TABLE statement defining the column types, then do
an INSERT INTO ... SELECT
Ignatius
Hi there everyone,
I have created a newsletter system where you can do lots of nice things, one of the
things is to be able to upload your images for the newsletter via the interface,
unfortunately you have to do them 1 at a time. Is it possible to be able to select
multiple images in 1 go?
Well...
Having never done this I would assume it's the same with and form field
you want to use as an array (multiple selections).
Create a few different fileselect fields all with the same name but
adding in [] to make it an array.
Then just loop through the array.. copying the file to the
Hi there,
U you know what they say, keep it simple and you're probably right you
know, I was thinking it would be more complex but i'll have a play with that
idea (Isn't it amazing how sometime we try to make things harder for
ourselves than they need be?).
Thanks for pointing that solution
The other option is...
You create a pop-up menu system.
That have the file form field to select from a location. When you upload
the image it populates a HTML display table so you can see it and also
allows you to select another image.
When you are done.. you close the pop-up menu and that's
Very simple...
Call you files being uplaoded file1, file2, fileX in the HTML form..
[html]
form method=post action=uploadprocess.php enctype=multipart/form-data
input type=file name=file1 size=20
input type=file name=file2 size=20
input type=file name=file3 size=20
input type=submit name=submit
This is what I use...
// Pull in DB PEAR Collection
require_once 'DB.php';
// What kind of database server are we connecting too?
$db_type = 'mysql';
// local connectivity data
$db_host = 'localhost';
$db_user = 'dbUsername
$db_pass = 'dbUserPW';
$db_name = 'dbName';
// Data Source Name: This
39 matches
Mail list logo