- Original Message -
From: Jason Wong [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 24, 2002 6:45 AM
Subject: Re: [PHP-DB] Global variables, $_GET problem
On Wednesday 24 July 2002 11:38, Ruth Zhai wrote:
We just upgraded our PHP to version 4.2.1. I realized that
Pentothal wrote:
I guess this is the wrong place to ask for a new PHP
feature, but ... I don't know where else to ask!
I just want to signal to C skilled (and willing) people
here that there is a new interesting RDBMS server called
picoSQL (www.picosoft.it).
This page has an english
There is another small RDBMS that supports subset of the ANSI-92 standart.
It's name is SQLite
there is a module for it here :http://sourceforge.net/projects/sqlite-php/
MOre info about SQLite here : http://www.hwaci.com/sw/sqlite/
Regards,
Andrey
- Original Message -
From: Pentothal
Here is my query(It is part of a search script and is dynamicly generated):
select 0 + article_keyword.weight * article_keyword.keyword like '%green%'
as score, article_keyword.aid, article_data.name, article_data.time,
article_data.description from article_keyword, article_data where score 0
In MySQL - SQL you can't use the column alias ('score' in your case)
until after the query has been executed.
There is a workaround though - see:
http://www.sitepointforums.com/showthread.php?s=postid=501671 for more
info.
Cheers.
Russ
-Original Message-
From: JJ Harrison
Thanks for the replies so far.
I see which method is best in 5-10 min.
My question is that if SQL/mySQL support some sort of function to see if a
database entry is in the supplied text?
--
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com
Jj Harrison [EMAIL PROTECTED] wrote in message
[EMAIL
I have following script:
?
$db=ifx_connect(db,uid,pwd);
$result=ifx_query(begin work,$db);
$result=ifx_query(insert into m_test1 (i) values('1');, $db);
$result=ifx_query(select * from m_test1;, $db);
while($row=ifx_fetch_row($result)) {
echo($row['i']);
}
$result=ifx_query(rollback
CLASSIFICATION: UNCLASSIFIED
I'm creating a script to upload documents (word, PDF, text, ppt, etc files)
to a PG 7.2 DB.
I currently can upload the file using pg_lo_import. I get back my OID which
I store in a separate table and I can remove the files using the unlink
command.
However for the
On Thu, 25 Jul 2002 09:27:04 +0200
Pentothal [EMAIL PROTECTED] wrote:
Last but not least: it distributed under GPL !
AFAIK, that may causes problems. We cannot link GPL with non GPLized codes.
pa
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
Hi Eric
I currently can upload the file using pg_lo_import. I get back my
OID which
I store in a separate table
I think this is the point. PostgreSQL doesn't store the uploaded file
physically in the table but only the OID which is a reference to the
file which is stored in a system catalogue.
I am trying to use encode/decode to store passwords in a database and then
retrieve it to email to a user who has forgotten their password.
I am using the following code to encode the password:
INSERT INTO users (name, password) VALUES ('$_POST[username]',
'ENCODE($_POST[password], encrypt)')
Hey guys. Thanks in advance for all the help that this group has
provided to me so far. I am still learning, so many of my questions have
been pretty simple. This may also be pretty simple, but I cannot for the
life of me figure out how to make this happen.
I have a Log
Try this syntax, it works for me
INSERT INTO users (name, password) VALUES ('$_POST[username]',
ENCRYPT('$_POST[password]','encrypt')
Explanation:
After VALUES, use
('variable', ENCRYPT('variable','key')
You've got it
('variable','ENCODE(variable,variable')
which makes the second entry
CLASSIFICATION: UNCLASSIFIED
It was my understanding (from a friend) that I could actually store the
files in the database and thereby eliminate me having to setup permissions
for folders etc..
Am I wrong?
Eric Jones (Contractor)
FDIC Web Enabler
E-mail: [EMAIL PROTECTED]
Office - 520-533-6628
You're trying to use double quotes, in which the variable is evaluated and the stored
value is shown, right? Try using single quotes. For example, with $name = Martin.
echo My name is $name.;
OUTPUT: My name is Martin.
echo 'My name is $name.';
OUTPUT: My name is $name.
It's interpreted
On Wed, 24 Jul 2002 16:49:38 -0400
Martin Clifford Martin Clifford [EMAIL PROTECTED] wrote:
You're trying to use double quotes, in which the variable is
evaluated and the stored value is shown, right? Try using single
quotes. For example, with $name = Martin.
echo My name is $name.;
Hi Eric
It was my understanding (from a friend) that I could actually store
the
files in the database and thereby eliminate me having to setup
permissions
If you use the large-objects-interface then the files go somewhere
else and the references (OIDs) are stored in the tables.
Another way
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
Hey guys. Thanks in advance for all the help that this group has
provided to me so far. I am still learning, so many of my questions have
been pretty simple. This may also be pretty simple, but I cannot for the
life of me
Does anyone have any good tips for error handling? I've tried different
methods to retrieve good error information from mssql_query but nothing
seems to be working.
Here's the latest attempt:
$result=mssql_query($sql2);
$result=mssql_query('SELECT ERROR As ErrorCode');
hi all,
I am trying to insert some data into access but I cant. I have no
option but to use access so has anyone inserted anything in a access db ?
pls help with a small code which sucessfully has inserted into access.
Thanks,
Vishal
--
PHP Database Mailing List (http://www.php.net/)
To
On Thursday 25 July 2002 05:11, Raquel Rice wrote:
Thank you, Martin, for your informative response. If I understand
correctly what you're saying, it would work to do (in psuedo code
and reduce to simplest form):
store_to_db(text = My name is $name.)
Here $name will be evaluated and
hi all,
I am trying to insert some data into access but I cant. I have no
option but to use access so has anyone inserted anything in a access db ?
pls help with a small code which sucessfully has inserted into access.
Thanks,
Vishal
You can do it via ODBC
I developed my site on a server where register_globals was off; now I'm
putting the site up on a server where they are on.
I know how to echo the value of a variable that is passed in the
querystring, but I'm having trouble echoing the value of a variable that is
in my select statement--I can
Is there a way to re-set the internal counter that automatically increments
auto_increment fields? While testing an app, I added a lot of test records
that I've deleted, so, I'd like to reset the counter back to the beginning
now.
Thanks.
--
PHP Database Mailing List (http://www.php.net/)
To
monty,
i found that if you do the command
DELETE FROM table
(with no WHERE clause) it deletes everything, and resets
Beau
// -Original Message-
// From: Monty [mailto:[EMAIL PROTECTED]]
// Sent: Thursday, 25 July 2002 1:34 PM
// To: [EMAIL PROTECTED]
// Subject: [PHP-DB] Resetting
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
I developed my site on a server where register_globals was off; now I'm
putting the site up on a server where they are on.
I know how to echo the value of a variable that is passed in the
querystring, but I'm having trouble echoing
26 matches
Mail list logo