Re: [PHP-DB] Paging help needed :-(

2001-07-11 Thread Dobromir Velev
Hi, First you'll have to modify your query to show only ten rows. $sql = "SELECT id, email, name, subject, url, image2, comments, dat FROM users ORDER BY id DESC LIMIT $start,10"; The $start variable shows the number of the first row to show The links for the previous and next

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

2001-07-11 Thread Matthew Loff
What about... SELECT WLPbib.bibID, WLPbib.title, WLPbib.publisher, WLPbib.publicationDate, WLPaddress.city, WLPaddress.state, WLPprofile.firstName, WLPprofile.lastName, WLPprofile.organization, WLPcountry.languageName FROM

Re: [PHP-DB] pulling my hair out

2001-07-11 Thread Dobromir Velev
Hi, As I can see you're trying to set a cookie that has expired an hour ago. May be you could try to modify the setcookie() arguments to something like this setcookie ("logged_in", "yes", time() + 3600); setcookie ("logged_user_name", "brad", time() + 3600); This will make your cookies to expire

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

2001-07-11 Thread Dobromir Velev
Hi, Did you try to use something like this. mysql_query("SELECT DISTINCT WLPbib.bibID, WLPbib.title, WLPbib.publisher, WLPbib.publicationDate, WLPaddress.city, WLPaddress.state, WLPprofile.firstName, WLPprofile.lastName

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=46&cat=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,

RE: [PHP-DB] Need a shopping cart

2001-07-11 Thread Matthew Loff
Ha ha... It makes perfect sense! I just assumed that since he was asking, he was implying that he didn't have the ability (due to administrative reasons) to install mysql. Good point, though. :) -Original Message- From: Tom Peck [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12,

RE: [PHP-DB] Need a shopping cart

2001-07-11 Thread Tom Peck
Matthew So what's so funny about installing MySQL on a NT system that is already running Perl and PHP? I think it makes perfect sense :-). Tom At 00:52 12/07/2001 -0400, you wrote: >Everyone suggesting "Easy! Just install Mysql!" makes me laugh... :) > >Jeff-- I suggest you check: > >1) htt

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,

[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: then all the HTML and display bits (Example at www.planetoxygene.com in the guestbook). Now my questio

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: >-- >$status = 0; >if (isset($myTstCky) && ($myTstCky == "ChocChip")) $status =

Re: [PHP-DB] pulling my hair out

2001-07-11 Thread Tom Peck
Brad Try this: -- Cookie Check Cookie Check Status: %s ;', $status ? "00FF00" : "FF", $status ? "PASSED!" : "FAILED!"); ?> --- It's taken from here: http://www.php.net/manual/en/function.setcookie.php If that still fails to work

[PHP-DB] pulling my hair out

2001-07-11 Thread Brad Lipovsky
I have one script that looks like this: SENT and another that looks like this: "; echo $HTTP_COOKIE_VARS["logged_in"]; print ""; echo $logged_user_name; print ""; print "end"; ?> which I have also tried like this: "; echo $logged_in; print ""; echo $logged_user_name; ?> It seems like

[PHP-DB] ocifetchstatement in mysql = ?

2001-07-11 Thread Jimmy Brake
Hi! Is there a command like ocifetchstatement() for mysql? I looked and looked and ... well it just does not seem to be there :-), So I got ambitous and tried just making one... function MyDataArray($query) { $this->result = @mysql_query($query, $this->id) or

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... http://shop.barnesandnoble.com/booksearch/result

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 a

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 B

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

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] 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] Subj

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, WLPprofile.l

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

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

[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 Windows

[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 WLPbib.b

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; Sort By Position which sets the value of the empty $sort input field to "position" and th

RE: [PHP-DB] Authomatic Sorting

2001-07-11 Thread Craig Vincent
But instead I end up with the following: 001 user1 003 user3 Any idea or comment? The auto incrementing feature of mysql unfortunately will always increase by 1 based on the (MAX) primary key ID number. Questions about this have been made to the MySQL development team as to if they would m

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

2001-07-11 Thread Hugh Bothwell
"Ken Sommers" <[EMAIL PROTECTED]> wrote in message 000a01c10a32$a8ec8540$7344500c@zeospantera">news:000a01c10a32$a8ec8540$7344500c@zeospantera... > What is function overloading? Overloading is the ability to define several functions by the same name but with different parameter lists and let th

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() f

[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 red

Re: [PHP-DB] Re: MySQL Database Locking - needed?

2001-07-11 Thread John Lim
Hi You don't need a text file. Just store a version number for each table row and increment on every change. Check to see if the version number has incremented means that the row has been updated. This is called optimistic locking. Regards, John "Raquel Rice" <[EMAIL PROTECTED]> wrote in messag

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' sec

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 O

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 ha

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 Orac

[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

[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] 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?

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 s

[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, dat

[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: 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 n

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 the

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 proc

[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 id

[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 : /htdo

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 versio

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 fie

[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".

[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] 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 (http://www.php.net/)

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: http://www.p