[PHP-DB] cookie problems

2001-07-11 Thread Brad Lipovsky
can anyone help me with this code? i cant believe it wont work, it seems pretty simple! ?php setcookie (logged_in, logged in, time() - 3600); setcookie (logged_user_name, logged user name, time() - 3600); print $logged_in br; print $logged_user_name; ? brad -- PHP Database Mailing List

Re: [PHP-DB] cookie problems

2001-07-11 Thread Ken Sommers
HI, my guess is is that the cookies will be killed the NEXT time you run this script. Ken - Original Message - From: Brad Lipovsky [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 11:24 PM Subject: [PHP-DB] cookie problems can anyone help me with this code? i cant

Re: [PHP-DB] PHP4 + interbase = bug?

2001-07-11 Thread Dobromir Velev
Hi, What version of php4 you're running and on what OS. I had this problem too but when I switched to php 4.06 on win2000 the interbase dll worked just fine. Dobromir Velev -Original Message- From: Wagner R. Landgraf [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date:

Re: [PHP-DB] losing data from a mysql database field

2001-07-11 Thread Dobromir Velev
Hi, did you try to use quotes around the field value input type=text name=your_text value=value or echo input type='text' name='field_name' value='$field_value'; Dobromir Velev -Original Message- From: Geoffrey Makstutis [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date:

Re: [PHP-DB] cookie problems

2001-07-11 Thread Tom
The variables wont become available until the cookies are read - which happens when the script is first loaded. Normally the cookies are set, then a header is sent to reload the page - but be carful not to create an endless loop of browser reloading... Check out the examples on:

[PHP-DB] Update records on MySql with a form.......

2001-07-11 Thread Rayman
Hello all, I have a form with my fileds filled with ECHO strings from a query, in order to get the values of a product stored in MySql. The question is: wich is the string in order to update the fields I change in the form ThankĀ“s all -- PHP Database Mailing List

[PHP-DB] Php and Mysql: Aborted connection to mySQL with PHP4

2001-07-11 Thread Andreas Persson
I'm using Php 4.0.1 pl2-9 and Mysql 3.23.22 and gets the following error in Mysqls logfile: 010711 10:58:52 Aborted connection 381 to db: 'improvement' user: 'webusr' host: `web.local' (Got an error reading communication packets) After a while mysql doesn't accept more connection because it has

[PHP-DB] Row order

2001-07-11 Thread Stefan Doverud
Hello! I have this little problem sorting a search result by different fieldnames. I do my search, get a quite impressive amount of variables that I use in my MySQL-query, and by default use ORDER BY name. But I want to be able to klick on different headers to sort like ORDER BY $order. The

Re: [PHP-DB] Row order

2001-07-11 Thread Tom
Cookie or session? A little extreme, but if you don't want it in the url then that's the only other way I can think of to remember a variable when the page is refreshed.. Tom At 13:09 11/07/2001 +0200, you wrote: Hello! I have this little problem sorting a search result by different

Re: [PHP-DB] PHP4 + interbase = bug?

2001-07-11 Thread Wagner R. Landgraf
Hi. I was using Apache 1.3.12 + Win 95 + PHP 4.06. - Original Message - From: Dobromir Velev [EMAIL PROTECTED] To: Wagner R. Landgraf [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 11, 2001 4:15 AM Subject: Re: [PHP-DB] PHP4 + interbase = bug? Hi, What version of php4

[PHP-DB] Re: image mapping

2001-07-11 Thread Hugh Bothwell
Ken Sommers [EMAIL PROTECTED] wrote in message 001301c10994$717b4b80$0343500c@zeospantera">news:001301c10994$717b4b80$0343500c@zeospantera... Hello, pure HTML server question: images like (backgroundimage.jpg) stored on server at: /htdocs/img util.showpic.html is stored at : /htdocs/util/

[PHP-DB] Warning: Page has Expired

2001-07-11 Thread Keith Spiller
I've setup a members directory in mysql that is searchable via different field and I limit the number of records. I use session variables to remember the number of records to display, what the starting record is, what the search string and search fields are. At anytime a user can click on an

RE: [PHP-DB] Re: problem running stored MsSQL procedure

2001-07-11 Thread Michael Yevdokimov
So what is actually the problem with running sp in mssql? Mike -Original Message- From: Carpe Diem Support [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 11, 2001 3:32 PM To: Hugh Bothwell; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Re: problem running stored MsSQL

RE: [PHP-DB] Warning: Page has Expired

2001-07-11 Thread Ben Bleything
Keith, I believe this happens because most browsers feel that it is important to regenerate any page that was generated with form input when you go 'Back' to it. Therefore, there's not much you can do about it... I suppose you could make links from the expiring page open in new windows, so

[PHP-DB] Re: Warning: Page has Expired

2001-07-11 Thread Jonathan Hilgeman
I had this problem, too. It seems as though when using session variables and POST forms, you get this error when trying to go back to a POSTed page. I believe I read somewhere that the error is more of a security issue - to keep others from simply going back and seeing any private data, but I'm

[PHP-DB] Re: Warning: Page has Expired

2001-07-11 Thread Jonathan Hilgeman
You can also change your form to use the GET method instead. That works without changing your php.ini file. But don't use GET methods for logging in or passing secure information. It's much more insecure than POSTing (not that POSTing variables is a 100% secure method, either)... Keith Spiller

[PHP-DB] RE: Row order

2001-07-11 Thread Mikusch, Rita
Good Morning, You could create a form and save your variables as hidden elements of your form. I've never tried it without having an actual visible form on the page with a submit button and everything, but it should work. The only other ways I can think of are pretty long winded...cookies,

Re: [PHP-DB] Re: Warning: Page has Expired

2001-07-11 Thread Keith Spiller
Thanks Jonathan, The Microsoft site says just that, that it is a security precaution. http://support.microsoft.com/support/kb/articles/q183/7/63.asp But I wonder, is it only caused by PHP or ASP pages? If so, what is to stop me from creating an line in my .htaccess file that forces the Apache

[PHP-DB] Production: Linux/Apache/PHP -- FreeTDS -- W2K/MSSQL 7.0

2001-07-11 Thread E. Peter K. Chan
Hi I am developing my website with this combo: W2K/IIS/PHP -- W2K/MSSQL7.0 When I switch to production I intend to use: Linux/Apache/PHP -- FreeTDS -- W2K/MSSQL7.0 My question is this: Will I be able to use ALL the PHP MSSQL functions (as listed in the PHP docs) when on the Linux combo? I am

[PHP-DB] alphanumeric

2001-07-11 Thread Jennifer Arcino Demeterio
the ctype_alnum is experimental. is there an easy way wherein i can identify if the input is an alphanumeric? thanks for your help.

[PHP-DB] Oracle Client Libraries?

2001-07-11 Thread Tom Tsongas
Hi all. Where can I get the Oracle client libraries for PHP4? I am running Apache and PHP4 on my NT Server and I will be connecting to an Oracle database on a Solaris server via remote connect? I saw some threads earlier indicating that they could be found at download.swwwing.com but that server

RE: [PHP-DB] Oracle Client Libraries?

2001-07-11 Thread Anthony Carlos
Tom: Go to technet.oracle.com and download Oracle 8i Database for WinNT. When you run the installer, you can do a custom set-up to only install the networking libraries (Net8). Run Net8 Easy Config. That will get you started. I'm not sure how much it costs officially. You'll have to call up

RE: [PHP-DB] Oracle Client Libraries?

2001-07-11 Thread Brian S. Dunworth
The Oracle Client for Windows NT/2000 and for Windows NT discs are both included in the CD-ROM distribution pack for Sun SPARC Solaris. You don't indicate which version you're running, but I've found the Windows (whatever flavor) Client software to be included in every Oracle version we've

RE: [PHP-DB] Oracle Client Libraries?

2001-07-11 Thread Andrew Hill
Tom, From Oracle :) Alternativley you can use the OpenLink Multi-Tier ODBC driver at www.openlinksw.com. It downloads with a free 2-connection license, and has free support available at www.openlinksw.com/support/suppindx.htm HTH! Best regards, Andrew Hill Director of Technology Evangelism

Re: [PHP-DB] Oracle Client Libraries?

2001-07-11 Thread Tom Tsongas
Hi again. I just found an above message that states the DLLs I need are in the PHP package I installed and I just need to uncomment them from php.ini. Am I off the beaten track or is that true? I found the listings for php_oracle.dll and php_oci8.dll in php.ini under the 'Dynamic Extensions'

[PHP-DB] Are PHP user-defined functions recursive?

2001-07-11 Thread Ken Sommers
Manual says: --- Any valid PHP code may appear inside a function, even other functions and class definitions. In PHP 3, functions must be defined before they are referenced. No such requirement exists in PHP 4. PHP does not support function overloading, nor is it possible to undefine or

Re: [PHP-DB] TO_DAYS() equivalent?

2001-07-11 Thread Noah Spitzer-Williams
check out the mktime() function David W. Banks [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Is there some way to get the equivalent of select TO_DAYS(NOW()) out of PHP without querying MySQL (or whatever.) Some formatting character for the date() function

RE: [PHP-DB] RE: Row order

2001-07-11 Thread Beau Lebens
If you created each column name on the table (i assume that's how this is working) and then as rita said, dump the searched variables as hidden inputs, then you could have something like this happen; form name=reorder action=?php echo $PHP_SELF ? method=POST input type=hidden name=first_var

[PHP-DB] Left Join is producing duplicate results - MySQL relational tables

2001-07-11 Thread Mike Gifford
Hello, I posted this to the general list this morning got a couple of good leads, but they weren't able to actually fix the problem, so I'm posting here to the db list. I'm making some headway on joining three MySQL tables. However, when I run this query: mysql_query(SELECT

[PHP-DB] Need a shopping cart

2001-07-11 Thread Jeff @ HookedOnThe.Net
Can anyone direct me to a shopping cart package (preferrably in PHP, although PERL would possibly work) which utilizes either an MS Access database or flat files? I've found several shopping carts, but they all seem to require MySQL which I do not have access to on my server. My server is

Re: [PHP-DB] Need a shopping cart

2001-07-11 Thread Tom Peck
Jeff Have you tried: http://www.hotscripts.com it seems to have a huge selection of PHP scripts - i'm not sure if it has what you are after though. Why don't you have MySQL installed on your NT machine? It is a LOT quicker than any MS Access database, or flat file - especially if you are

Re: [PHP-DB] Left Join is producing duplicate results - MySQL relational tables

2001-07-11 Thread Ken
Mike - I'm not certain but it sounds like you might be looking for GROUP BY. Do GROUP BY and then the columns that are identical in your results. - Ken At 09:46 PM 7/11/01 -0400, Mike Gifford wrote: Hello, I posted this to the general list this morning got a couple of good leads, but they

Re: [PHP-DB] Left Join is producing duplicate results - MySQL relational tables

2001-07-11 Thread Mike Gifford
It looked good, but it gave me an error.. Sorry Database error: Invalid SQL: SELECT WLPbib.bibID, WLPbib.title, WLPbib.publisher, WLPbib.publicationDate, WLPaddress.city, WLPaddress.state, WLPprofile.firstName,

RE: [PHP-DB] Need a shopping cart

2001-07-11 Thread David Balatero
Probably cause his host is extremely ghetto and refuses to install anything non M$FT =P ...and he doesn't have full admin access to the server. -- David Balatero -Original Message- From: Tom Peck [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 11, 2001 6:53 PM To: [EMAIL PROTECTED]

Re: [PHP-DB] Left Join is producing duplicate results - MySQL relational tables

2001-07-11 Thread Ken
Mike - In general, you should always be reading the manual first. From the SELECT syntax at http://www.mysql.com/doc/S/E/SELECT.html GROUP BY must be indicated before ORDER BY. So reverse the order of those portions. - Ken At 10:35 PM 7/11/01 -0400, Mike Gifford wrote: It looked good, but it

Re: [PHP-DB] Left Join is producing duplicate results - MySQL relational tables

2001-07-11 Thread Mike Gifford
Sorry Ken, I'm trying to learn a few too many things at once. Switching it around eliminated the error message but not the duplication. I'm eliminating as much of the code as I can to see that it isn't coming from PHP. Thanks again for your help. Mike Ken wrote: In general, you should

Re: [PHP-DB] Left Join is producing duplicate results - MySQL relational tables

2001-07-11 Thread Kevin Johnson
Just build the SQL statement piece by piece instead of all at once. Be sure that your tables are setup properly, allowing you to make joins properly. Try not to rush, cause you might miss a couple of little things along the way. Kevin Johnson - Original Message - From: Mike Gifford

RE: [PHP-DB] Left Join is producing duplicate results - MySQL relational tables

2001-07-11 Thread Beau Lebens
altho this may not help at all, rather than bashing away with php+SQL statements, i usually just pilot my sql in phpmyadmin, then once it works with set values (ie SELECT * FROM people WHERE personID='3' rahter than personID='$personID' or something) i can then drop that SQL into my script. HTH

Re: [PHP-DB] Left Join is producing duplicate results - MySQL relational tables

2001-07-11 Thread Mike Gifford
phpMyAdmin is great! And I hear that they are coming out with a new version pretty soon (or is it here - haven't checked).. However I don't think that you can join tables in phpMyAdmin.. Perhaps I don't know the app well enough though. Mike Beau Lebens wrote: altho this may not help at

Re: [PHP-DB] Need a shopping cart

2001-07-11 Thread leo g. divinagracia iii
ummm... why not install MYSQL on your server? you can have the apache/mysql/php triad. all free/open sourced... then there are a few shopping carts already written. the book titled, PHP and MySQL Web Development has a shopping cart example...

[PHP-DB] pulling my hair out

2001-07-11 Thread Brad Lipovsky
I have one script that looks like this: ?php setcookie (logged_in, yes, time() - 3600); setcookie (logged_user_name, brad, time() - 3600); ? html head /head body SENT /body /html and another that looks like this: ?php print start br; echo $HTTP_COOKIE_VARS[logged_in]; print br; echo

Re: [PHP-DB] pulling my hair out

2001-07-11 Thread Tom Peck
Brad Try this: -- ?php $status = 0; if (isset($myTstCky) ($myTstCky == ChocChip)) $status = 1; if (!isset($CCHK)) { setcookie(myTstCky, ChocChip); header(Location: $PHP_SELF?CCHK=1); exit; } ? html headtitleCookie Check/title/head body bgcolor=#FF text=#00 Cookie

Re: [PHP-DB] pulling my hair out

2001-07-11 Thread Tom Peck
Stupid html e-mail... That code may not come through properly... copy it from the site, as what's below is only half complete. Tom At 16:23 12/07/2001 +1200, you wrote: Brad Try this: -- ?php $status = 0; if (isset($myTstCky) ($myTstCky == ChocChip)) $status = 1;

[PHP-DB] Paging help needed :-(

2001-07-11 Thread chris
Hi there Everyone, I currently have a dedicated Apache server with PHP 4.06, MySQL etc .. installed and running fine. Below is alittle peice of code that I would love an answer to: ?php $connection = mysql_connect(Localhost,username!!!,password!!!) or die(Couldn't make a connection.); $db

RE: [PHP-DB] Need a shopping cart

2001-07-11 Thread Matthew Loff
Everyone suggesting Easy! Just install Mysql! makes me laugh... :) Jeff-- I suggest you check: 1) http://www.hotscripts.com/ 2) http://www.zend.com/ 3) http://www.sourceforge.com/ 4) http://www.mysql.com/ (Just kidding!) Any shopping cart that uses ODBC should work just fine-- and moreso,

RE: [PHP-DB] Need a shopping cart

2001-07-11 Thread support
Here's a list of some free shopping cart stuff http://www.missoulaweb.com/help/index.phtml?qid=46cat=11 -- Allen Lee http://MissoulaWeb.com $10/month PHP4 MySQL Hosting On Thu, 12 Jul 2001, Matthew Loff wrote: Ha ha... It makes perfect sense! I just assumed that since he was asking, he