Re: [PHP-DB] Concept help required

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 those

Re: [PHP-DB] Updating table with data from another table in the same database

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 one

[PHP-DB] simple question

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.

RE: [PHP-DB] simple question

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

[PHP-DB] Record Page Through sqlServer Woes

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

[PHP-DB] how to use MS Access file

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]... ?php mysql_connect ('dbhost','user','pass'); mysql_select_db ('db'); $ircname2 = htmlspecialchars($ircname); $result =

Re: [PHP-DB] Re: [PHP] need help looping through each record with a query -stumped

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

Re: [PHP-DB] how to use MS Access file

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,

[PHP-DB] How to connect MS accsess file

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]

[PHP-DB] How can I use MS access file and PHP?

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]

Re: [PHP-DB] Concept help required

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

[PHP-DB] How to use PHP and MS Access?

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]

[PHP-DB] count

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;

[PHP-DB] A phpnuke / phpgroupware question..please help me.

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

Re: [PHP-DB] count

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

[PHP-DB] Please help, On phpnuke and phpgroupware.

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.

Re: [PHP-DB] Concept help required

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

Re: [PHP-DB] Please help, On phpnuke and phpgroupware.

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

Re: [PHP-DB] Please help, On phpnuke and phpgroupware.

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 Thursday

Re: [PHP-DB] Please help, On phpnuke and phpgroupware.

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

Re: [PHP-DB] Please help, On phpnuke and phpgroupware.

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,

[PHP-DB] MySQL Result Resource

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

Re: [PHP-DB] Please help, On phpnuke and phpgroupware.

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 become

Re: [PHP-DB] Concept help required

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 Miles, I

[PHP-DB] Re: [PHP] Query Optimizing on sum() function

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

Re: [PHP-DB] Concept help required

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 these

Re: [PHP-DB] MySQL Result Resource

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

[PHP-DB] Problem with PHP, MySQL and Apache System

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

RE: [PHP-DB] MySQL Result Resource

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

[PHP-DB] Query Optimizing on sum() function

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;

Re: [PHP-DB] Problem with PHP, MySQL and Apache System

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?

Re: [PHP-DB] Concept help required

=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 their

RE: [PHP-DB] MySQL Result Resource

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

Re: [PHP-DB] Concept help required

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,

RE: [PHP-DB] MySQL Result Resource

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

RE: [PHP-DB] MySQL Result Resource

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

RE: [PHP-DB] MySQL Result Resource

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

Re: [PHP-DB] MySQL Result Resource

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

RE: [PHP-DB] MySQL Result Resource

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

Re: [PHP-DB] MySQL Result Resource

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 error...

RE: [PHP-DB] MySQL Result Resource

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 - Miles

RE: [PHP-DB] MySQL Result Resource

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

AW: [PHP-DB] Problem with PHP, MySQL and Apache System

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

RE: [PHP-DB] MySQL Result Resource

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

RE: [PHP-DB] MySQL Result Resource

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

Re: [PHP-DB] MySQL Result Resource

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 Result

[PHP-DB] simultaneous dual table entry

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/) To

[PHP-DB] simultaneous dual table entry

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

Re: [PHP-DB] simultaneous dual table entry

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

[PHP-DB] PHP/MySQL Library Catalog System

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: [PHP-DB] PHP/MySQL Library Catalog System

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 out

Re: [PHP-DB] PHP/MySQL Library Catalog System

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

Re: [PHP-DB] Concept help required

** 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' will

RE: [PHP-DB] MySQL Result Resource

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 your

Re: [PHP-DB] Query Optimizing on sum() function

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 to return

[PHP-DB] PHP blocks

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.

Re: [PHP-DB] Concept help required

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 do

[PHP-DB] Updating a value usins MsAccess db?

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

Re: [PHP-DB] Concept help required

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 preference

[PHP-DB] Re: Record Page Through sqlServer Woes

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,

[PHP-DB] Re: Query Optimizing on sum() function

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;

Re: [PHP-DB] PHP/MySQL Library Catalog System

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 etc.

RE: [PHP-DB] MySQL Result Resource

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

[PHP-DB] Saving sessions info in MySql DB

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

Re: [PHP-DB] MySQL Result Resource

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

[PHP-DB] Re: Saving sessions info in MySql DB

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

[PHP-DB] RE: Pulling a long list of data stalls PHP

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 works

[PHP-DB] Re: Saving sessions info in MySql DB

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, FALSE for

RE: [PHP-DB] MySQL Result Resource

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

RE: [PHP-DB] MySQL Result Resource

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

Re: [PHP-DB] MySQL Result Resource

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 I get now

[PHP-DB] display text in screen

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

Re: [PHP-DB] PHP/MySQL Library Catalog System

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