On Thursday 10 January 2002 22:26, you wrote:
> Hi all,
> I've noted that a least a couple of people on this list work with
> library catalog systems - I'm interested in finding out whether any of
> these systems are open-source or are available for a nominal fee. I'm
> familiar enough with
Hi,
I have easy problem to ask someone. I wrote PHP to update data with many
step and need to display comment or detail in each step. But I got all
comment or detail display after it finished update all step. How could I
display each step comment immediately??
Sommai Fongnamthip
On Friday 11 January 2002 10:33, Necro wrote:
> Ok,
>
>
> I have tried to go to PASSWORD after none of the suggestions worked out.
>
> The current statement is:
> $arg = "select password, 1 as auth from acl where username='$username' and
> password = 'PASSWORD($password)'";
>
> But the error
http://www.hotscripts.com/Detailed/4219.html <<--- that is the script
But I cannot use crypt() on a winodws system. So I tried MD5, now I try
PASSWORD.
Any one got any idea how to make the script work with either of those??
Andrew
-Original Message-
From: Necro [mailto:[EMAIL PROTECTE
Daniel,
I had tried both with and without quotes. Neither work.
Without quotes I get:
select password, 1 as auth from acl where username='andrewd' and password =
PASSWORD(madonna)1054 : Unknown column 'madonna' in 'where clause'
Notice that madonna has not been crypted by the PASSWORD call eith
Thanks! Saved me a huge headache!
"Yasuo Ohgaki" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Your save handler has some problem...
>
> Except read functin, all return values from handler is converted to
> boolean and you should return TRUE for success, FALS
At 08:03 AM 1/9/2002 -0800, Max wrote:
>Just curious, but which version of PHP are you using, the ISAPI or CGI.
>I've tried the isapi version before and had problems like this. PHP
>would crash and leave orphaned instances of php. If your using the
>isapi version try the cgi and see if it work
Your save handler has some problem...
Except read functin, all return values from handler is converted to
boolean and you should return TRUE for success, FALSE for failure.
For read function, you MUST return string *always*. Return "" (null
string) if there is nothing to read.
I've updated ma
Andrew:
Don't put quotes around your MySQL function call.
i.e.
PASSWORD($password)
not
'PASSWORD($password)'
p.s. Looking at this thread, it seems like most of the errors you're encountering have
nothing to do with md5() or password(), but with syntax, like placement of quotes, or
whether th
We recently upgraded to php4.1.0 from 4.0.6 and now our custom session
handling doesn't work! We are running on linux with apache, attempting to
save session info to a MySQL database (I have session.save_handler=user).
There are a couple issues:
1) Occassionally (can't seem to pin down exactly w
Ok,
I have tried to go to PASSWORD after none of the suggestions worked out.
The current statement is:
$arg = "select password, 1 as auth from acl where username='$username' and
password = 'PASSWORD($password)'";
But the error I get now is:
select password, 1 as auth from acl where use
Hi again everyone,
Alnisa Allgood wrote:
> You may want to check HotScripts, or the PHP Resource Index
> (http://www.hotscripts.com) and (http://php.resourceindex.com). These
> locations will most likely have an array of free or low-cost library
> solutions.
>
Thanks all for the HotScripts
Hello,
Lerp wrote:
>
> Hi all, I have a small php app where I'd like to incorporate page throughs
> of records, say 10 at a time.
>
> I'm using sqlServer and have run into a problem using the LIMIT statement
> within my query.
>
> Code:
> $sqls = "SELECT consultantid, firstname, lastname, city
Hi Rick,
> many people have a very shallow understanding of SQL - particularly
> [he says generalising like crazy] people who 'fall into it' from
> (say) PHP programming... This shallow understanding means that
> 'they' will tend to do too much in PHP (assuming they know it better)
> in prefere
I was just wondering if anybody knew how to update values using an access
db? (using odbc_exec()?). I have it all setup to display the results, just
cant seem to update it, I always get errors. Heres my code:
if($da != 0)
{
$cnx = odbc_connect( 'a' , $u, $p );
if( ! $cnx )
{ echo "Err
Hello,
Nomor Satu Bajingan wrote:
>
> Hello Friends,
> I've some performance problem, when I do sum() functions on my tables it
> took 5-7 minutes to return the results.. here is my story:
> I've table with 2461566 rows here is my table structure:
> mysql> describe imp_log;
> +--+---
At 12:53 PM + 1/7/02, George Pitcher wrote:
>
>One of the features of the FMPro solution is that when a user is looking at
>a list of resources (in fact, university course packs) each row will display
>the number of associated records from the 'books' database. Now which is the
>best method to
On these web portals they have things call blocks that arrange the layout of the site.
Where can one go to learn how to do this sort of layout.
Addressed to: "Nomor Satu Bajingan" <[EMAIL PROTECTED]>
[EMAIL PROTECTED]
** Reply to note from "Nomor Satu Bajingan" <[EMAIL PROTECTED]> Thu, 10
Jan 2002 13:51:06 +
>
> Hello Friends,
> I've some performance problem, when I do sum() functions on my tables it
> took 5-7 minutes
Addressed to: "Necro" <[EMAIL PROTECTED]>
[EMAIL PROTECTED]
** Reply to note from "Necro" <[EMAIL PROTECTED]> Fri, 11 Jan 2002 03:41:43 +1100
> select password, 1 as auth from acl where (username='andrewd' and
> password=(163e06103a371fd95b21b4a849bb4b91))1064 : You have an error in
** Reply to note from "DL Neil" <[EMAIL PROTECTED]> Thu, 10 Jan 2002
14:48:02 -
> many people have a very shallow understanding of SQL - particularly
> [he says generalising like crazy] people who 'fall into it' from
> (say) PHP programming... This shallow understanding means that
> 'they'
At 12:26 PM -0800 1/10/02, Daniel Barton wrote:
>Hi all,
> I've noted that a least a couple of people on this list work with
>library catalog systems - I'm interested in finding out whether any of
>these systems are open-source or are available for a nominal fee. I'm
>familiar enough with PHP
I just saw this which is new on Hotscripts
PhpMyLibrary
http://www.hotscripts.com/Detailed/13279.html
On Thursday 10 January 2002 15:26, Daniel Barton wrote:
> Hi all,
> I've noted that a least a couple of people on this list work with
> library catalog systems - I'm interested in finding ou
Hi all,
I've noted that a least a couple of people on this list work with
library catalog systems - I'm interested in finding out whether any of
these systems are open-source or are available for a nominal fee. I'm
familiar enough with PHP/MySQL to make one, but I'd also like to avoid
re-inve
Marc,
You just use two separate insert statements, one for each table.
Miles Thompson
At 12:47 PM 1/10/2002 -0500, Marc S. Bragg wrote:
>Hi,
>
>Is there a process / command for inserting information from one form one
>input into two separate tables in the same database? Anyone have the
>basic c
Hi,
Is there a process / command for inserting information from one form one
input into two separate tables in the same database? Anyone have the
basic command statement?
thanx mucho'
Marc
--
Marc S. Bragg
[EMAIL PROTECTED]
Bialecki & Bragg, PC
p: 610-444-7508
f: 610-444-7548
http://www.chesco
Hi,
Is there a process for entry from one form to
--
Marc S. Bragg
[EMAIL PROTECTED]
Bialecki & Bragg, PC
p: 610-444-7508
f: 610-444-7548
http://www.chescolawyers.com/BB
"Legal Directory, Services & Consumer Information for Chester County"
--
PHP Database Mailing List (http://www.php.net/)
Well, strip the brackets from around the hash value.
Miles
At 03:41 AM 1/11/2002 +1100, Necro wrote:
>On further investigation it appears to get the correct MD5 value the correct
>synatx is:
>
>$passhash = MD5("$username.$password"); <<--- needs the "
>
>The the error resulting from this is:
>
>
try :
$arg = "select password, 1 as auth from acl where (username='andrewd') and
password=MD5(concat(username,password))";
HTH
Andrey
- Original Message -
From: "Necro" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 10, 2002 6:29 PM
Subject: RE: [PHP-DB] MySQL Res
On further investigation it appears to get the correct MD5 value the correct
synatx is:
$passhash = MD5("$username.$password"); <<--- needs the "
The the error resulting from this is:
select password, 1 as auth from acl where (username='andrewd' and
password=(163e06103a371fd95b21b4a849bb4b91)
Miles,
You must MD5 the value outside of mysql for it to evaluate it, from the
error I just got.
i have tried
$passhash = MD5($username.$password);
$arg = "select password, 1 as auth from acl where (username='andrewd' and
password=($passhash))";
And get the following error...
select password, 1
Hi Miles,
First of all: THANK YOU!
It seems, that the header() was causing the problem. After disabeling some
"foreign" code used for Banner mamangement i could not reproduce the hang
(hopefully...)
What is the problem with the header() - just curious...
Anyway, here what would have been my an
Parse error: parse error in d:\htdocs\infekt\packages\auth.inc on line 104
$arg = "select password, 1 as auth from acl where (username='andrewd' and
password=MD5("andrewd.madonna"))";
Nope :(
-Original Message-
From: Andrey Hristov [mailto:[EMAIL PROTECTED]]
Sent: Friday, 11 January
LIGHT just came on!!! Why does ittake so long.
MD5(andrew.madonna) - I think you're goint to have to do this
$passhash = $username . $password
and use MD5($passhash).
MySQL is looking for a table "andrewd" with the field "madonna" in the way
the MD5() is presently structured.
Go to it - Mile
try this :
select password, 1 as auth from acl where (username='andrewd' and
password=MD5("andrewd.madonna"));
- Original Message -
From: "Necro" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 10, 2002 6:18 PM
Subject: RE: [PHP-DB] MySQL Result Resource
> Same err
Same error...
select password, 1 as auth from acl where (username='andrewd' and
password=MD5(andrewd.madonna))1109 : Unknown table 'andrewd' in where clause
Andrew
-Original Message-
From: George Pitcher [mailto:[EMAIL PROTECTED]]
Sent: Friday, 11 January 2002 3:10 AM
To: Necro; [EMAIL
I was having something similar and solved it by wrapping the column names in
parentheses:
select password, 1 as auth from acl where (username='andrewd' and
password=MD5(andrewd.madonna));
It might help. or eliminate something if I'm not right.
George
- Original Message -
From: "Necro"
Yep,
andrewd is the username im trying to get this script to work with, its an
authentication script..
The result of echo $arg is the following:
select password, 1 as auth from acl where username='andrewd' and
password=MD5(andrewd.madonna)1109 : Unknown table 'andrewd' in where clause
Andrew
Can you try this puppy at the MySQL console? I'd dearly love to know where
"andrewd" is coming from, it sounds like your username.
Before executing mysql_query(), echo $arg and see what it prints.
This is strange, but better than what we had - Miles Thompson
At 02:54 AM 1/11/2002 +1100, Necro
Ok,
I have tried a few things now. I finally got it to echo the errors, firstly
there was still a prob with MD5 values being in the apostrophes.
Then next error was no db was selected. So i added a mysql_select_db
statement.
Now i get this:
1109 : Unknown table 'andrewd' in where clause
andrewd
dn -
thanks SO much for your detailed reply. :)
yes there are tons of problems :( the "last 3 consecutive Months" issue is
tricky enough - but the fact that the database is set up all wrong for this
type of query is the real problem.
unfortunately changing the structure and field formats then
David,
> =there's a bunch of fast-mover jockies and helo boys who never have to pay
for their drinks when any of my guys
> are around...
>
Air Traffic Control was my area, though we did have to put up with some of
your lot when Ark Royal was in dock as we were a Buccaneer base.
>
> =Sorry, misun
Break up the code.
I assume you are connecting to the database with mysql_connect() or
mysql_pconnect(). If not, do that.
Echo your query so that you know it contains valid values.
Break $row = mysql_fetch_array(mysql_db_query( DATABASE, $arg ));
into
$result = mysql_query( $arg ) or die(mysq
> > =ex-Navy guys are always "at sea" - however they never let me near the
> ships, but I guess that's another
> > story...
> ex RAF myself (almost 30 years ago though), so I suppose I might be all 'up
> in the air'?
=there's a bunch of fast-mover jockies and helo boys who never have to pay for t
Is it possible to go upload an earlier version of one of the pages and hit
it repeatedly to see if you get the same behaviour?
When you get the blank page, what do you see in "View Source"?
What are browser settings for reloading the page?
What happens with other browsers, NS 4.x, NS 6.2, Opera?
Yeh, I notice now the MD5 was wrong.
But I still get the same error on line 104. If I try and replace it with the
current query function then I get two errors.
e.g.
Warning: Supplied argument is not a valid MySQL-Link resource in
d:\htdocs\infekt\packages\auth.inc on line 104
Warning: Supplied
Hi all!
I do not know, if this is the right forum, but I need help .
We have a stable Website, that handeled several thousand visitors a day
before xmas. We did some additional programming (mostly PHP) and are running
into problems right now, that can be reproduced, but we do not know wher
The use of the MD5 function in the query doesn't look quite right.
Shouldn't it be MD5('$password') or MD5('$username'.'$password') if
concatenating?
Also, mysql_db_query() has been a deprecated function for some time now,
mysql_query() is recommended.
Hope this gets you going - Miles Thomps
David,
> =ex-Navy guys are always "at sea" - however they never let me near the
ships, but I guess that's another
> story...
ex RAF myself (almost 30 years ago though), so I suppose I might be all 'up
in the air'?
>
> > > level). Once again we draw boxes (I have some wonderful s/w for doing
> >
1. Please don't cross-post -- it just confuses us. The reply is going to
php-db.
2. It seems that you are using imp_log incorrectly. Either you add a record
to it for each hit, or for a camp_id value you update the impressions
field. Which is it? If the former, then a count() will give you wh
Hi George,
> > =I'm feeling a little 'at sea' here, because we had established that you
> want to learn more about "joining", yet
> > you recognise the word "normalisation" straight off...
> Feel free to realign my approach...
> No need to feel at sea. After an earlier response from either you or
On Thursday 10 January 2002 22:15, HiM wrote:
> Jason,
> phpNuke problem fixed after downgrade to 4.0.6
Glad to hear.
> Thanks !
You're welcome :)
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
Falling in love is a lot like dying. You never get to do it enough to
becom
Lo all,
Slight problem on an auth script...
Warning: Supplied argument is not a valid MySQL result resource in
d:\htdocs\infekt\packages\auth.inc on line 104
Line 26: define( "DATABASE", "imanager" );
Line 103: $arg = "select password, 1 as auth from acl where
username='$username' and passwo
Jason,
phpNuke problem fixed after downgrade to 4.0.6
Thanks !
And I am still solving to problem with phpgroupware.
Nori
-
- Original Message -
From: "Jason Wong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday
On Thursday 10 January 2002 21:53, HiM wrote:
> Jason,
> But after downgrade to 4.0.6, is there any new feature I can't use?
>
> Nori Chan
If you're going to be using only PHPNuke and/or PHPGroupware and they haven't
been updated for 4.1.1 then they won't be using any of the new features of
Hello Friends,
I've some performance problem, when I do sum() functions on my tables it
took 5-7 minutes to return the results.. here is my story:
I've table with 2461566 rows here is my table structure:
mysql> describe imp_log;
+--+--+--+-+-+--
Jason,
But after downgrade to 4.0.6, is there any new feature I can't use?
Nori Chan
- Original Message -
From: "Jason Wong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 10, 2002 9:41 PM
Subject: Re: [PHP-DB] Please help, On phpnuke and phpgroupware.
> On Thu
On Thursday 10 January 2002 21:28, HiM wrote:
> I am sorry that last message haven't give the URL...:(
>
> http://nori.dns2go.com:8080/phpnuke/html/admin.php
> http://nori.dns2go.com:8080/phpgroupware/setup/config.php
>
> I was trying to use to phpnuke system and also the phpgroupware.
> I have f
Olinux,
> Haven't been following and not sure if this is what
> you're after, but these are some great data models:
> http://www.databaseanswers.com/data_models/index.htm
Thanks for this. I came across this site/these diagrams before, but thought them to be
too 'introductory' and
vague for use
I am sorry that last message haven't give the URL...:(
http://nori.dns2go.com:8080/phpnuke/html/admin.php
http://nori.dns2go.com:8080/phpgroupware/setup/config.php
I was trying to use to phpnuke system and also the phpgroupware.
I have followed the instruction listed in INSTALL step by step.
But
Barry,
I can't see where you've created $topictest.
Maybe, just before you define $queyr2, you should have the line
$topictest = $row[ "topcitext"];
I also think xp_stories_topicid should be xp_stories.topicid
Try echo 'ing $query2 and see what is printed.
Hope this helps, and that I've not m
I was trying to use to phpnuke system and also the phpgroupware.
I have followed the instruction listed in INSTALL step by step.
But I don't know why there's so many error even in phpnuke / phpgroupware
I am using Windows2000 server and apache, php 4.1.1 and mysql 3.23
Please help , I have to bu
I'm trying to do the following query:
$db_connect = mysql_connect($sqlhostname,$login,$password);
$base_selection = mysql_select_db($base,$db_connect);
$query = "SELECT DISTINCT * FROM xp_topics WHERE artist_count='artist' AND topictext
LIKE
'A%' ORDER BY artist_count ASC limit 0,5";
How can read date and put it into and out of (name.mdb) with SQL query
Sergey
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
> You wouldn't happen to have a spare ELH diagram (or two) lying around
> that one could take a look at, would you?
Hah TIM now you've got me!
I 'do' diagrams. I don't 'do' neat! [no need to move over Matisse]
The longer answer is that I have diagrams coming out of my ears (well, computer), but
How can I raed and write data to My_file.mdb
through PHP with SQL qyery
Sergey
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
HOw can i read and put data into or out of name.mdb file with sql query
Sergey
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
At 17:25 10.01.02 +0600, Sergey wrote:
>How can read and put data into or out of file.mdb with sql query
With ODBC. Have a look on http://www.unixodbc.org
Regards,
Ruprecht
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-
Brian,
> first off, Martin your suggestion looks great but I don't think its SQL
> syntax is supported by MySQL. It's a good start though - gives me something
> to work with :)
=until it is tried, you won't know! From an SQL point of view it looks ok. In fairness
to Martin, from the
'further in
How can read and put data into or out of file.mdb with sql query
Sergey
"Rick Emery" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
> mysql_connect ('dbhost','user','pass');
> mysql_select_db ('db');
>
> $ircname2 = htmlspecialchars($ircname);
>
> $result
Hi all, I have a small php app where I'd like to incorporate page throughs
of records, say 10 at a time.
I'm using sqlServer and have run into a problem using the LIMIT statement
within my query.
Code:
$sqls = "SELECT consultantid, firstname, lastname, city, country, category,
yearsexp FROM CONS
not tried it, but according to the manual, it should be something like..
SELECT * FROM Bands WHERE Name REGEXP "^[0-9]";
check out the relevant page and see what you think:
http://www.mysql.com/doc/S/t/String_comparison_functions.html
regards,
Matt
-Original Message-
From: Barry Rums
I have a colum with the numbers between 0-9 ( table is a list of bands )eg. 2 live
crew , 2pac , 1 maniacs also in this table Ihave normal names like : abba , queen
, police etc..
How would I query the table to list only the ones starting with numbers.
On Wednesday 09 January 2002 19:49, you wrote:
> =A daunting task indeed, however it's a move for the better, so more power
> to your right arm/kung-fu grip... However let's not jump to quickly to PHP,
> and keep it all within MySQL if we can...
I was hoping we could ;-)
> =So you started with
David,
> =I'm feeling a little 'at sea' here, because we had established that you
want to learn more about "joining", yet
> you recognise the word "normalisation" straight off. I don't want to
insult you by 'talking down'/teaching
> grandma to suck eggs... Please be sure it is not another one of
75 matches
Mail list logo
