Re: [PHP-DB] Upgrading from php -4.0.3

2002-02-27 Thread Paul Burney
on 2/27/02 2:51 AM, Marco Coletta at [EMAIL PROTECTED] appended the following bits to my mbox: I would like to upgrade to newer version of php, ho can supply detailed instructions. You can start here: http://www.php.net/manual/en/installation.php And if you have difficulty, post your

[PHP-DB] Re: php-db Finding records with NULL values

2002-02-27 Thread Robin McKenzie
That may work for a single field in a record that is NULL, but I'm trying to join two tables, and report the lines that do not have an entry in the second thus: Question Table Q_idQuestion 1Question 1 2Question 2 3Question 3 4Question 4 Response Table

Re: [PHP-DB] Re: php-db Finding records with NULL values

2002-02-27 Thread DL Neil
Robin That may work for a single field in a record that is NULL, but I'm trying to join two tables, and report the lines that do not have an entry in the second thus: Question Table Q_idQuestion 1Question 1 2Question 2 3Question 3 4Question 4

[PHP-DB] forced page links...

2002-02-27 Thread jas
I am wondering if there is a good tutorial on how to use php to make users come from a page before they can access another. For instance, say you have one page called index.php which contains a form that once filled in links to a confirmation page to verify the users data was entered correctly

[PHP-DB] Re: forced page links...

2002-02-27 Thread Lerp
Hi there :) I use session variables to do this, once the user has logged in and you know they are who they say they are, set a session variable using session_register(isloggedin); $isloggedin = yes; And at the top of every page you want protected simply do a check to see if it is set or not.

[PHP-DB] Re: Advantage Database Server

2002-02-27 Thread Lerp
Hi there :) I believe you can connect to an Advantage Db through unified odbc functions. Check the manual at www.php.net Cheers, Joe :) Stewart Gateley [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Has anybody had any luck or tried connecting to ADS from PHP?

[PHP-DB] Re: Advantage Database Server

2002-02-27 Thread Chuck Vertrees
Hello- We are currently developing a PHP client for the Advantage Database Server and expect to have it released in approx. 2 weeks. As mentioned in the previous post, it will access ADS through a unified ODBC method. Please contact me directly for additional information or if you are

[PHP-DB] Re: forced page links...

2002-02-27 Thread jas
Can you accomplish this without having the user logged in? I am unconcerned with whether or not the user has logged in, I simply need the user to not be able to bypass a page with a form to go directly to the end page which will connect and store the form contents into a db. Thanks in advance,

Re: [PHP-DB] Re: forced page links...

2002-02-27 Thread Dan Brunner
Hello!! What I would do is have both the 2 page and the last page on the the same page!! All my pages are only two...a form page and a processing page...that's it However You could also have a variable pass from page to page, like a hidden variable, either in a form, or with

Re: [PHP-DB] Re: forced page links...

2002-02-27 Thread Andrés Felipe Hernández
hi jas, am sure you asked this before and i already replied. Anyway miles posted this which is more elaborated than the one i proposed: *** This is at the top of every file requiring an authenticated user on one of our sites: ? include(secure.php)? and secure.php consists of this, all on one

[PHP-DB] Sorting the result

2002-02-27 Thread Kristjan Kanarik
Hi, I've come across a problem and I'm affraid that I'm lacking the skills of writing proper SQL queries in order to solve this. I'm building a little search engine for my site (yes, from scratch! It doesn't have to be the best, but I think that for my personal use it will be enough) and the bit

RE: [PHP-DB] Re: forced page links...

2002-02-27 Thread David Redmond
Jas, Try looking into the $HTTP_REFERER variable, for example; ? if ($HTTP_REFERER != PageItShouldBeComingFrom.php) { Header (Location: index.php); } // blah blah ? Cheers -Original Message- From: jas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 27 February 2002 6:04 PM To:

Re: [PHP-DB] Sorting the result

2002-02-27 Thread William Fong
$article_query = mysql_query(select article_name, article_text from articles where article_name LIKE '%$q%' ORDER BY $q_count DESC ) or die (mysql_error()); Put the ORDER BY $q_count DESC in your SQL statement and that will make MySQL do the sorting for you. PHP will get it already sorted.

[PHP-DB] pg_pconnect Causing SegFaults?!?!

2002-02-27 Thread Kevin Traas
Greetings everyone, I've been having a very frustrating problem over the past few months that I've ***finally*** tracked down the cause of Any questions/comments/thoughts/ideas you can provide would be *greatly* appreciated. Symptoms: - IE, Opera, Lynx all report page cannot be displayed

[PHP-DB] why won't session_start() work?

2002-02-27 Thread Ryan Snow
when I do: session_start(); session_register('signor'); session_register('username'); I get: Warning: Cannot send session cookie - headers already sent by (output started at /var/www/html/index.php:3) in /var/www/html/index.php on line 14 Warning: Cannot send

RE: [PHP-DB] why won't session_start() work?

2002-02-27 Thread Beau Lebens
Ryan, you need to make all of those calls *before* ANY output has been sent by your script, otherwise you can't send a header any more. so the TOP of a script might look like ?php session_start(); $signor = $monsieur + $madame; session_register(signor); // the rest of your code goes here ? html

[PHP-DB] accessing system cmds w/ PHP

2002-02-27 Thread Jeremiah Jester
Can anyone tell me how to access linux system commands using php. Tried the system() cmd but no luck. Does it require a wrapper to work?Thanks, JJ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] accessing system cmds w/ PHP

2002-02-27 Thread Kearns, Terry
Have a look at trying backticks. http://www.php.net/manual/en/language.operators.execution.php [TK] -Original Message- From: Jeremiah Jester [mailto:[EMAIL PROTECTED]] Sent: Thursday, 28 February 2002 12:37 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] accessing system cmds w/ PHP

RE: [PHP-DB] accessing system cmds w/ PHP

2002-02-27 Thread Beau Lebens
JJ, I seem to recall most people saying that the shorthand works best $output = `chmod -R 777 *'; HTH beau // -Original Message- // From: Jeremiah Jester [mailto:[EMAIL PROTECTED]] // Sent: Thursday, 28 February 2002 9:37 AM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] accessing

[PHP-DB] Question about advanced SQL

2002-02-27 Thread Adam Royle
Hi. I need some guidance for writing an effective query (instead of processing through PHP). I lets says I have two tables, tblCDs and tblOrders. tblCD cdID| cdTitle | cdArtist -- 1 | Great Hits | Bon Jovi 2 | Forever

RE: [PHP-DB] Question about advanced SQL

2002-02-27 Thread Kearns, Terry
SELECT tblCD.cdID, tblCD.cdTitle, tblCD.cdArtist FROM tblCD, tblOrders WHERE tblOrders.cdID = tblCD.cdID AND tblCD.cdID NOT IN ( SELECT cdID FROM tblOrders ) The support for this sort of nested query will very

RE: [PHP-DB] accessing system cmds w/ PHP

2002-02-27 Thread Dan Brunner
Hello... Try exec() I know it works moving files. Dan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 7:37 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] accessing system cmds w/ PHP Can anyone tell me how to access linux

Re: [PHP-DB] Question about advanced SQL

2002-02-27 Thread Bill Morrow
select * from tblCd where cdId not in (select distinct cdId from tblOrders); On Thu, Feb 28, 2002 at 12:37:49PM +1000, Adam Royle wrote: Hi. I need some guidance for writing an effective query (instead of processing through PHP). I lets says I have two tables, tblCDs and tblOrders.

[PHP-DB] Storing image path to database

2002-02-27 Thread Jennifer Downey
Hi, Woud someone be able to help? I can't for the life of me figure out how to get this to store a image path instead of the image itself. In other words I want to make this so that the user isn't uploading an image. I want to use a radio or check box that they pick from. Any help would be

Re: [PHP-DB] Question about advanced SQL

2002-02-27 Thread Sommai Fongnamthip
Hi, I assumed that you was used MySQL for database. With MySQL you can used this SQL to find different row select tblcd.* from tblcd left join tblorder on tblcd.cdid=tblorder.cdid where tblorder.cdid is null sommai At 12:37 28/2/2002 +1000, Adam Royle wrote: Hi. I need

[PHP-DB] Object Base Database Access

2002-02-27 Thread Enrico Weigelt
Hi folks, i'm currently developing an module which provides an object based access to databases content (does not mean that i use OOP) for example we have defined an class descriptor for person, which specifies, that an person-record consists of the fields ID (which is the OID, fetched from

[PHP-DB] Force Refresh on Another Window w/ Javascript

2002-02-27 Thread Shahmat Dahlan
I have a question, let's say i have my main page (so called) called indexphp I have also displayed a buttonin indexphp, which i will used the onClick event to trigger a windowopen function to the same main page, indexphp (but with parameters) input type=button value=Add New Records

Re: [PHP-DB] Force Refresh on Another Window w/ Javascript

2002-02-27 Thread Shahmat Dahlan
Sorry about the priority, guess it was set unintentionally, out of habit from my working place, I think. Beau Lebens wrote: please don't use the important (X-Priority header) on your message - we're all important here :) anyway, your question - it's actually JavaScript that you want, and

[PHP-DB] errorr log

2002-02-27 Thread Erwien Samantha Y
Hello guys, anyone can help me with this kind of error log tail -f /www/log/error_log [ cut ] PHP Warning: Failed to write session data (files) Please verify that the current setting of sessionsave_path is correct (/tmp) in Unknown on line 0 PHP Warning: Failed to write session data (files)

[PHP-DB] Question about setting up multiple relations

2002-02-27 Thread Monty
Hi, I have an Image table in a MySQL database that will be used to store the location of all images used on my site Some images will relate to an Article table (articleid) and some images may relate to a Member table (memberid) As it's possible that there may be an articleid that is the same as

Re: [PHP-DB] errorr log

2002-02-27 Thread Marius Ursache
check if YOU can write/read on tmp. Erwien Samantha Y a écrit : Hello guys, anyone can help me with this kind of error log tail -f /www/log/error_log [ cut ] PHP Warning: Failed to write session data (files). Please verify that the current setting of session.save_path is correct

Re: [PHP-DB] errorr log

2002-02-27 Thread Erwien Samantha Y
the permision in /tmp it's OK , because my session it's work already in /tmp , but the i stil got an error message bellow. wIEn [EMAIL PROTECTED] wrote: check if YOU can write/read on tmp. Erwien Samantha Y a écrit : Hello guys, anyone can help me with this kind of error log tail -f