- 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 reali
"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 englis
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
a
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 [mailto:[EMAI
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 P
I have following script:
If i dont execute $result=ifx_query("rollback work;", $db); and just call
ifx_close session is not closed and autmatic rollback is not execute (as it
must be) but connection to Informix database stays with lock on this row.
Usualy you must have rollback or commit; But
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 l
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: http://www.php.
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 applicat
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 actually
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
Not sure if this will actually deliver the functionality you're looking for
but it's worth a shot. As the documentation says, the end(array array)
actually returns the last element in the array. So it looks like you could
just use echo end(yourArrayName); or something like that and get what you're
On Wed, 24 Jul 2002 13:23:54 +1200
David Robley David Robley <[EMAIL PROTECTED]> wrote:
> In article <[EMAIL PROTECTED]>,
> [EMAIL PROTECTED] says...
> > I've run out of ideas. I want to store a variable name and a
> > function call in a text column of a MySQL database and have them
> > interpr
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 interprete
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 $
i would like to know the best way to combine result sets from a php query to
mysql
Ex:
$sql1 = "SELECT index, name FROM table WHERE field_A = 'ABC' ORDER BY
field_F";
$result1 = the results from a correctly executed query of $sql1.
$sql2 = "SELECT index, name FROM table WHERE field_A = 'DEF'
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');
$error=mssql_fetch_row($
$result=mssql_query($sql2)or die("sql2 failed" . mysql_errno() . ": " .
mysql_error());
At 04:48 PM 7/24/2002 -0700, Salve Tinkerworth wrote:
>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 t
Oops! Sorry all, wrong db.
At 05:05 PM 7/24/2002 -0700, Doug Durham wrote:
>$result=mssql_query($sql2)or die("sql2 failed" . mysql_errno() . ": "
>. mysql_error());
>
>At 04:48 PM 7/24/2002 -0700, Salve Tinkerworth wrote:
>>Does anyone have any good tips for error handling? I've tried different
This is what was there before I tried to replace it:
$sql2=mssql_query($sql2) or die ('failed inserting OPS');
This didn't work. It died everytime even though I could run the statement in
$sql2 in query analyzer without any problems. I inherited this thing but I'm
having fun learning PHP. :-)
Thank you very much for your help. It was a silly mistake. We had a few
sites affected. I was so worried that I overlooked the simple problem.
Thanks again. Mailing List is great (first time for me)!
Ruth
- Original Message -
From: "Beau Lebens" <[EMAIL PROTECTED]>
To: "'Ruth Zhai
On Thursday 25 July 2002 04:49, Raquel Rice wrote:
> On Wed, 24 Jul 2002 13:23:54 +1200
>
> David Robley David Robley <[EMAIL PROTECTED]> wrote:
> > In article <[EMAIL PROTECTED]>,
> > [EMAIL PROTECTED] says...
> >
> > > I've run out of ideas. I want to store a variable name and a
> > > function
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 evaluat
> 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
http://www.php.net/m
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 get
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 MySQ
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 echo
On Thursday 25 July 2002 13:34, Monty wrote:
> 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.
Yes, it's d
Do you know which page it's on? I've searched the MySQL online help for 40
minutes and can't find anything, which is why I asked here.
> From: [EMAIL PROTECTED] (Jason Wong)
> Organization: Gremlins Associates
> Reply-To: [EMAIL PROTECTED]
> Newsgroups: php.db
> Date: Thu, 25 Jul 2002 14:41:49 +
36 matches
Mail list logo
