[PHP-DB] Form not working...

2002-06-25 Thread NIPP, SCOTT V (SBCSI)
I am working on a Call Log application for our SA group. I currently have the database back-end configured and working OK. Right now I am working with 3 pages, one is to post new entries, the second is a log view of all entries, and the last is a page that updates an existing entry. I

[PHP-DB] Time difference question...

2002-06-25 Thread NIPP, SCOTT V (SBCSI)
I am working on a Call Log application, and need to calculate time. For example, if a page is received at 12:00, the page is returned at 12:10, and the call is resolved at 14:30... I need to be able to calculate the time to return the page, and also the time to resolve the call. I am

[PHP-DB] Populating a dropdown list with ENUM values...

2002-06-26 Thread NIPP, SCOTT V (SBCSI)
I am working on an application that has several different fields that are populated dropdown lists. In every case, this data is simply data from a MySQL table column and works great. I have run into a new difficulty though... One field that I am wanting to populate in a dropdown list

RE: [PHP-DB] Populating a dropdown list with ENUM values...

2002-06-26 Thread NIPP, SCOTT V (SBCSI)
Thanks to everyone who responded. I have found a function that fills the role perfectly. -Original Message- From: Russ [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 7:47 PM To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED] Subject: RE: [PHP-DB] Populating a dropdown list

[PHP-DB] MySQL Update failing...

2002-06-27 Thread NIPP, SCOTT V (SBCSI)
In need of some help. I have a PHP form page that is updating a MySQL database that is not working. Here is the code for the three pages that work together for this application. The oncall_new.php works fine to insert new records into the database, and the oncall_log.php works fine to

RE: [PHP-DB] MySQL Update failing...

2002-06-27 Thread NIPP, SCOTT V (SBCSI)
Figured it out. Thanks to anyone who started looking at this. The problem was not having my variables in the correct order in the $updateSQL. Once I corrected this, the posting now works fine. -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent

[PHP-DB] MySQL test database creation...

2002-07-05 Thread NIPP, SCOTT V (SBCSI)
Hey guys... I know that this is not specifically on topic for this group, but I promise this is an easy one. I am developing a web app, and need to create a development copy of the production database. I have created the new database, now I just need to export and import the

RE: [PHP-DB] MySQL test database creation...

2002-07-05 Thread NIPP, SCOTT V (SBCSI)
, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 12:26 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] MySQL test database creation... Hey guys... I know that this is not specifically on topic for this group, but I promise this is an easy one. I am developing

[PHP-DB] A real question this time...

2002-07-05 Thread NIPP, SCOTT V (SBCSI)
This time I have a real question that I need help with. I am not sure why something is not working the way I intend it. This is most likely a mistake in my understanding, but here goes... I have a section of code that populates a dropdown list with the results of a query on a

RE: [PHP-DB] another problem with mySQL server

2002-07-05 Thread NIPP, SCOTT V (SBCSI)
Since you are using phpMyAdmin, I would suggest taking a look at the user table in the mysql database. I would suspect that you do not have the proper permissions in the user table. If this 'admin' user should have full rights to the database, you will need to make sure that you have

RE: [PHP-DB] A real question this time...

2002-07-05 Thread NIPP, SCOTT V (SBCSI)
Perfect. Why was I trying to make this more difficult??? Sometimes the simple solution is definitely the best. -Original Message- From: Shrock, Court [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 1:50 PM To: NIPP, SCOTT V (SBCSI); '[EMAIL PROTECTED]' Subject: RE: [PHP

[PHP-DB] MySQL Query problem...

2002-07-08 Thread NIPP, SCOTT V (SBCSI)
I seem to have run into another problem with a query that I am doing exactly like the example in the MySQL documentation, I think. The following query is not working on my PHP page, and it is not working from a MySQL command line either. This looks exactly the same as an example in the

[PHP-DB] Data Synchronization...

2002-07-16 Thread NIPP, SCOTT V (SBCSI)
This is actually more of a MySQL question, but here goes... I have two servers, one production and one development. I would like to use the development server as a backup for the production server. Is there a way to synchronize the MySQL databases between these two servers? I

[PHP-DB] Keeps prompting to download php page???

2002-07-16 Thread NIPP, SCOTT V (SBCSI)
I just upgraded to Apache 1.3.26, and everything it fine except PHP. Whenever I try to load a PHP page in the browser, the browser attempts to download the page. I know that I am missing something simple here. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web:

RE: [PHP-DB] Keeps prompting to download php page???

2002-07-17 Thread NIPP, SCOTT V (SBCSI)
that is working fine. I know that it shows .htm, but it works fine on my other server this way. Thanks again. -Original Message- From: Beau Lebens [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 8:04 PM To: NIPP, SCOTT V (SBCSI) Subject: RE: [PHP-DB] Keeps prompting to download php page

[PHP-DB] Log application...

2002-07-24 Thread NIPP, SCOTT V (SBCSI)
Hey guys. Thanks in advance for all the help that this group has provided to me so far. I am still learning, so many of my questions have been pretty simple. This may also be pretty simple, but I cannot for the life of me figure out how to make this happen. I have a Log

[PHP-DB] Dropdown list question...

2002-07-29 Thread NIPP, SCOTT V (SBCSI)
I am populating a dropdown list from a database. This is working fine with one minor glitch... For some reason, the first entry in the database does not seem to be getting populated into the list. I do not see anything wrong, and was hoping that someone else might be able to spot a

RE: [PHP-DB] Dropdown list question...

2002-07-29 Thread NIPP, SCOTT V (SBCSI)
Thanks for the answers. This has resolved my problem. -Original Message- From: Andrey Hristov [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 11:21 AM To: NIPP, SCOTT V (SBCSI) Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Dropdown list question... - Original

[PHP-DB] A little upgrade help...

2002-07-30 Thread NIPP, SCOTT V (SBCSI)
I am upgrading from PHP 4.1.2 to 4.2.2, and I cannot get the make install to work. I am doing this on HP-UX 11.00, and I have tried the suggestion of renaming the libphp4.sl files to libphp4.so, but I still get failures. Below is the output of the make install before changing the

[PHP-DB] Log Application Help...

2002-08-13 Thread NIPP, SCOTT V (SBCSI)
I have a Log Application that is fully functional, but I need to change a behavior and can't quite figure out how. This app has three pages, one for entering new entries, one to display all entries for the last 5 days, and the final page allows updating of existing entries. The problem

RE: [PHP-DB] Session understanding

2002-09-26 Thread NIPP, SCOTT V (SBCSI)
Can't you get around this by making the session code a separate, required file that is at the beginning of every protected page? I think this is basically the same thing, just making sure because I am about to try and implement some session controls myself. Thanks. -Original

RE: [PHP-DB] Noob questions...

2002-10-02 Thread NIPP, SCOTT V (SBCSI)
Give phpMyAdmin a try... http://www.phpmyadmin.net/ -Original Message- From: Brett Lathrope [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 8:55 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Noob questions... Ok, here's my scenario... My Web Host has all Root Admin

[PHP-DB] MySQL crypt test...

2002-10-23 Thread NIPP, SCOTT V (SBCSI)
I am having trouble with a canned calendar application and I think that maybe the problem is the crypt function. Does anyone know of a good way to test the crypt function? I need to figure out somehow if this is the source of the problem or not. Thanks. Scott Nipp Phone: (214)

[PHP-DB] Log Application Formatting Issue...

2002-10-18 Thread NIPP, SCOTT V (SBCSI)
I am trying to tweak an application that I have developed. The application is our On-Call Log. This application consists of three pages; one page to input new entries, one page to edit existing entries, and finally a log view page. The log view page displays all entries for the past 5

RE: [PHP-DB] Log Application Formatting Issue...

2002-10-18 Thread NIPP, SCOTT V (SBCSI)
[mailto:phplist;gremlins.com.hk] Sent: Friday, October 18, 2002 11:58 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Log Application Formatting Issue... On Saturday 19 October 2002 00:09, NIPP, SCOTT V (SBCSI) wrote: I am trying to tweak an application that I have developed. The application is our On-Call

[PHP-DB] Session Variable Question...

2002-11-01 Thread NIPP, SCOTT V (SBCSI)
I am a little confused by a specific behavior of a session variable. Here is an example of my confusion: ?php require_once('prod.lib.php'); session_start(); if (!isset($_SESSION['valid_user'])) { echo You must be logged in to use this application. br; echo Please a href=\login.php\

[PHP-DB] Variable from PHP to HTML...

2002-11-12 Thread NIPP, SCOTT V (SBCSI)
I am attempting to create a form of system names that is populated from a database query. The database query is working fine, and the form population is actually working fine also. The question I have is about organizing the variables that result from the form. I want to use the system

[PHP-DB] HTML Forms question...

2002-11-19 Thread NIPP, SCOTT V (SBCSI)
I know that this is not the forum for this question, I am only looking for a pointer in the right direction here. I need to gain a better understanding of HTML forms, specifically checkboxes. What I am looking for is once I present a list of checkboxes and the user makes his selections,

RE: [PHP-DB] HTML Forms question...

2002-11-19 Thread NIPP, SCOTT V (SBCSI)
is dependant on which method your form uses. :-) If it is not checked then there is no entry. in PHP with register_globals on the variable $checkbox1 will equal scoobydoo and not be set if the box is not checked. hope this helps... Ryan -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto

RE: [PHP-DB] HTML Forms question...

2002-11-19 Thread NIPP, SCOTT V (SBCSI)
: Tuesday, November 19, 2002 6:13 PM To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED] Subject: RE: [PHP-DB] HTML Forms question... If you name the checkbox as name=system[] then PHP will automatically create an array of the checkbox values which can be subsequently accessed via $_POST['system'][n

RE: [PHP-DB] HTML Forms question...

2002-11-19 Thread NIPP, SCOTT V (SBCSI)
- From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 19, 2002 11:11 AM To: NIPP, SCOTT V (SBCSI); 'Ryan Jameson (USA)'; [EMAIL PROTECTED] Subject: Re: [PHP-DB] HTML Forms question... OK. If I am using the POST method and the checkbox 'name' for all of the checkboxes

RE: [PHP-DB] HTML Forms question...

2002-11-19 Thread NIPP, SCOTT V (SBCSI)
DUH!!! I'm an idiot. That was quite obvious. Thanks. Sorry for the stupid question. -Original Message- From: Hutchins, Richard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 19, 2002 2:40 PM To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED] Subject: RE: [PHP-DB] HTML Forms

[PHP-DB] INSERT question...

2002-11-20 Thread NIPP, SCOTT V (SBCSI)
I have an INSERT statement that I cannot quiet get working. The table that this data is being put into has 7 columns, but I only care about putting in the data from the first two columns at this time. The first column is an array element, and the second column needs to be a timestamp.

RE: [PHP-DB] INSERT question...

2002-11-20 Thread NIPP, SCOTT V (SBCSI)
. Holmes'; NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED] Subject: RE: [PHP-DB] INSERT question... Hmm You learn something new everyday :) Aaron -Original Message- From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]] Sent: November 20, 2002 2:27 PM To: Aaron Wolski; 'NIPP, SCOTT V (SBCSI

RE: [PHP-DB] INSERT question...

2002-11-20 Thread NIPP, SCOTT V (SBCSI)
PROTECTED]] Sent: Wednesday, November 20, 2002 2:21 PM To: NIPP, SCOTT V (SBCSI); 'Aaron Wolski'; [EMAIL PROTECTED] Subject: Re: [PHP-DB] INSERT question... OK. This sounds great, but now I am getting a completely different error message. You have an error in your SQL syntax near '-sys) VALUES

RE: [PHP-DB] INSERT question...

2002-11-20 Thread NIPP, SCOTT V (SBCSI)
, November 20, 2002 2:47 PM To: NIPP, SCOTT V (SBCSI); 'Aaron Wolski'; [EMAIL PROTECTED] Subject: Re: [PHP-DB] INSERT question... $query = INSERT INTO accounts (`id-sys`, rtime) VALUES('.$accnts[0].', 'NOW()'); Remove the quotes around NOW(). It's a function, not a string. ---John Holmes

[PHP-DB] General How-to Question...

2002-11-20 Thread NIPP, SCOTT V (SBCSI)
Once again I am posting a bit off topic, so tell me to go away if this is bugging people... Thanks for all of the assistance so far in creating what will be a completely automated user account request system. I am now trying to figure out the mechanics of the account approval

[PHP-DB] Special URL Verification String...

2002-12-04 Thread NIPP, SCOTT V (SBCSI)
I am trying to implement an approval system that sends an e-mail to a user for approval linking them back to a special URL that matches database entries for a verification string. The verification string sent via the e-mail does not match that in the database and I am looking for help in

RE: [PHP-DB] Special URL Verification String... PS

2002-12-05 Thread NIPP, SCOTT V (SBCSI)
- From: Peter Lovatt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 4:45 PM To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED] Subject: RE: [PHP-DB] Special URL Verification String... PS Hi PS I would use $verify_string = md5(uniqid(rand())); to generate a random identifier

[PHP-DB] Newline help...

2002-12-05 Thread NIPP, SCOTT V (SBCSI)
I must be stupid, because I cannot for the life of me figure out why I am not getting newlines from some very simply 'echo' statements. Here is the portion of the code below, and I am getting everything run together on a single line: ?php do { echo $list['id-sys'] . \n; $sys =

RE: [PHP-DB] Newline help...

2002-12-05 Thread NIPP, SCOTT V (SBCSI)
]] Sent: Thursday, December 05, 2002 10:34 AM To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED] Subject: Re: [PHP-DB] Newline help... HTML doesn't render newlines, only BR. Look at your HTML source code and the newlines are there. or, if you're on windows, use \r\n for newlines. ---John Holmes

[PHP-DB] Function questions...

2002-12-06 Thread NIPP, SCOTT V (SBCSI)
I am trying to convert something that I have working in a PHP script to be a function in a library type of file. The code contained in the function works fine in another script, but I am currently getting no output from the function. I have a question about the nature of functions that

RE: [PHP-DB] Function questions...

2002-12-06 Thread NIPP, SCOTT V (SBCSI)
, December 06, 2002 1:58 PM To: '[EMAIL PROTECTED]' Subject: Re: [PHP-DB] Function questions... $sys is an array, so echoing $sys will cause problems. Are you trying to get a 4xN table of values and checkboxes? There's got to be an easier way... --- NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED] wrote

RE: [PHP-DB] Function questions...

2002-12-06 Thread NIPP, SCOTT V (SBCSI)
, December 06, 2002 1:58 PM To: '[EMAIL PROTECTED]' Subject: Re: [PHP-DB] Function questions... $sys is an array, so echoing $sys will cause problems. Are you trying to get a 4xN table of values and checkboxes? There's got to be an easier way... --- NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED] wrote

RE: [PHP-DB] Function questions...

2002-12-06 Thread NIPP, SCOTT V (SBCSI)
07 December 2002 04:12, NIPP, SCOTT V (SBCSI) wrote: OK. Stumped once again. This function is now properly generating and displaying the form as I intend it to. The only problem is that the optional text and button at the end of the function is actually displaying above the choices provided

RE: [PHP-DB] Data not entering DB

2002-12-06 Thread NIPP, SCOTT V (SBCSI)
Yes, and yes. -Original Message- From: John [mailto:[EMAIL PROTECTED]] Sent: Friday, December 06, 2002 2:41 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Data not entering DB Questions: Is this the right email addy to post help questions, and may I post the php code within the

[PHP-DB] Form Best Practice/Help...

2002-12-10 Thread NIPP, SCOTT V (SBCSI)
I am working on an application and I am not having a lot of luck getting a form to behave the way I want. I am trying to keep the form self referencing, not sure if that is the correct terminology. The form is an approval form that queries a database to create a list of checkboxes.

[PHP-DB] Update Query Help...

2002-12-10 Thread NIPP, SCOTT V (SBCSI)
I am attempting to UPDATE a table and I have having absolutely ZERO success. Here is the query: $tmp = $_POST['sbcuid'].-.$_POST['system'][$a]; $update = UPDATE accounts SET atime='NOW()' WHERE \id-sys\='.$tmp.'; echo $update; $result1 =

RE: [PHP-DB] Update Query Help...

2002-12-10 Thread NIPP, SCOTT V (SBCSI)
John W. Holmes [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 1:45 PM To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED] Subject: Re: [PHP-DB] Update Query Help... $tmp = $_POST['sbcuid'].-.$_POST['system'][$a]; $update = UPDATE accounts SET atime='NOW()' WHERE \id-sys\='.$tmp.'; echo

RE: [PHP-DB] Update Query Help...

2002-12-10 Thread NIPP, SCOTT V (SBCSI)
changed and take this as a lesson never to use '-' in a column name again. Thanks again for the help. Maybe we all learned something from this. -Original Message- From: DL Neil [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 2:00 PM To: NIPP, SCOTT V (SBCSI); '1LT John W

[PHP-DB] Remote Oracle database questions...

2002-12-11 Thread NIPP, SCOTT V (SBCSI)
I have now been granted access to a remote Oracle database that I need to query. All of the work that I have done with databases and PHP has been focused on MySQL, does anyone know of a good tutorial for PHP with Oracle? My immediate question is how do I get logged into the remote

RE: [PHP-DB] Remote Oracle database questions...

2002-12-11 Thread NIPP, SCOTT V (SBCSI)
used Oracle since 8i came out... but I'm pretty sure this is accurate. Except the guess about how PHP does it. Ryan -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 9:24 AM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Remote Oracle

[PHP-DB] Oracle/PHP question...

2002-12-16 Thread NIPP, SCOTT V (SBCSI)
I am now trying to setup connectivity to a remote Oracle database for my PHP/Apache web server. I am attempting to verify connectivity to the database by: ?php $connection = OCILogon(user, password) or die (Unable to logon to database.); ? I have installed the Oracle client on

RE: [PHP-DB] Oracle/PHP question...

2002-12-16 Thread NIPP, SCOTT V (SBCSI)
webserver is win32 then you need to uncomment the line in php.ini that says : ;extension=php_oci8.dll if it is unix based I am not sure what you need to do. Ryan -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:58 PM

RE: [PHP-DB] Oracle/PHP question...

2002-12-16 Thread NIPP, SCOTT V (SBCSI)
jobs... PHP is much more powerful then anything m$ offers. Ryan -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 2:08 PM To: Ryan Jameson (USA); [EMAIL PROTECTED] Subject: RE: [PHP-DB] Oracle/PHP question... Thanks, but my

RE: [PHP-DB] Oracle/PHP question...

2002-12-17 Thread NIPP, SCOTT V (SBCSI)
Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:58 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Oracle/PHP question... I am now trying to setup connectivity to a remote Oracle database for my PHP/Apache web server. I am

RE: [PHP-DB] Oracle/PHP question...

2002-12-17 Thread NIPP, SCOTT V (SBCSI)
the SID and the HOME so that's fine. Just compile new binary Regards, Andrey - Original Message - From: NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED] To: 'Andrey Hristov' [EMAIL PROTECTED]; xxx [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 4:37 PM Subject: RE: [PHP-DB

[PHP-DB] PHP/Oracle Install questions...

2002-12-17 Thread NIPP, SCOTT V (SBCSI)
I am attempting to recompile PHP 4.2.3 on HP-UX 11.00 for connectivity to both a MySQL and a remote Oracle server. I am not having much luck with this right now. Currently I am getting a couple of different errors that are of concern for me. First of all, in the Apache error log I am

[PHP-DB] FW: PHP/Oracle Install questions...

2002-12-17 Thread NIPP, SCOTT V (SBCSI)
Message- From: NIPP, SCOTT V (SBCSI) Sent: Tuesday, December 17, 2002 9:56 AM To: '[EMAIL PROTECTED]' Subject: PHP/Oracle Install questions... I am attempting to recompile PHP 4.2.3 on HP-UX 11.00 for connectivity to both a MySQL and a remote Oracle server. I am

[PHP-DB] Oracle connectivity question...

2002-12-18 Thread NIPP, SCOTT V (SBCSI)
OK. I think I now have Oracle support built into PHP/Apache. The biggest hiccup for HP-UX seems to be that once you add Oracle support to PHP, you CANNOT built PHP as a DSO, PHP MUST be compiled into Apache. Once again, I think this is the case, I am still not completely sure at this

RE: [PHP-DB] Newbie PHP/MySQL question

2002-12-20 Thread NIPP, SCOTT V (SBCSI)
I would say his problem is the IIS 5.0. Switch to some non-MS operating system running Apache as a web server and that should clear up your problems. :) -Original Message- From: Jason Wong [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 11:24 AM To: [EMAIL PROTECTED]

[PHP-DB] Sore head...

2003-01-07 Thread NIPP, SCOTT V (SBCSI)
My head is sore from banging my head on my desk, so I will now ask the gurus... I am trying to get a canned Calendar application working, and I am running into problems. The application is phpCommunityCalendar by AppIdeas.com. The calendar is currently semi-functional, but for

[PHP-DB] Mouseover question...

2003-01-08 Thread NIPP, SCOTT V (SBCSI)
OK, this isn't really a DB question, but it is definitely a PHP question. I am working on customizing a calendar application for my group's use and noticed that there is a function that has to do with a mouseover effect. The problem is that this mouseover does not appear to do anything.

RE: [PHP-DB] Mouseover question...

2003-01-08 Thread NIPP, SCOTT V (SBCSI)
. -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 11:56 AM To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED] Subject: RE: [PHP-DB] Mouseover question... OK, this isn't really a DB question, but it is definitely a PHP question. I am

[PHP-DB] Stumped...

2003-01-09 Thread NIPP, SCOTT V (SBCSI)
I am getting an error that is proving very difficult to isolate and was hoping for help. The error is: Column count doesn't match value count at row 1. I would include the code, but it is about 350 lines, and I am not sure where to narrow it down at. Any ideas? Thanks. Scott Nipp

RE: [PHP-DB] Stumped...

2003-01-09 Thread NIPP, SCOTT V (SBCSI)
, SCOTT V (SBCSI); '[EMAIL PROTECTED]' Subject: RE: [PHP-DB] Stumped... Post your SQL statement. -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 1:37 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Stumped... I am

[PHP-DB] Date math functions...

2003-01-15 Thread NIPP, SCOTT V (SBCSI)
I have a question about using DATE_ADD in MySQL. I am not sure if this is the most effective way of dealing with this problem so I am asking here. The situation is that I am working on modifying a calendar system for our use. Our On-Call rotation is such that when someone is On-Call

RE: [PHP-DB] Date math functions...

2003-01-15 Thread NIPP, SCOTT V (SBCSI)
Thanks. I was noticing that it was not working. Let me give this a try and see how things go. -Original Message- From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 15, 2003 10:32 AM To: 1LT John W. Holmes; NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED

RE: [PHP-DB] Date math functions...

2003-01-15 Thread NIPP, SCOTT V (SBCSI)
W. Holmes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 15, 2003 10:32 AM To: 1LT John W. Holmes; NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED] Subject: Re: [PHP-DB] Date math functions... [snip] if ($dateDiff == 3) { mysql($DBName,UPDATE Balances SET CompEarned=CompTaken+8 WHERE said

[PHP-DB] Duplicate keys...

2003-01-15 Thread NIPP, SCOTT V (SBCSI)
OK, I cannot figure out why I keep getting errors about Duplicate entry for key 1. Someone please come to my rescue here as this is truly kicking my but. if ($dateDiff == 2) { mysql($DBName,INSERT INTO phpCalendar_Details VALUES ( '$said','Comp day for weekend

RE: [PHP-DB] Send mail with a file

2003-01-16 Thread NIPP, SCOTT V (SBCSI)
Under Unix I don't know that this is possible, but hopefully someone else will know of a way. I would love to be able to e-mail some Excel files that I generate with a Perl cron job, but there does not appear to be any practical way to do this in Unix. -Original Message- From:

RE: [PHP-DB] Duplicate keys...

2003-01-16 Thread NIPP, SCOTT V (SBCSI)
poorly coded piece of software, and if I as a relative PHP newbie know this, it is really bad. -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 15, 2003 10:07 PM To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED] Subject: RE: [PHP-DB] Duplicate keys

[PHP-DB] Date Range Question...

2003-02-04 Thread NIPP, SCOTT V (SBCSI)
I am working on an app that needs to post information to a website based on date. The tricky part for me is that the date is a range that spans either 2 or 3 days. I want the web page to dynamically populate this information based on a query. The query will look something like this:

RE: [PHP-DB] Date Range Question...

2003-02-04 Thread NIPP, SCOTT V (SBCSI)
the difference of 2 or 3 days? -Original Message- From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 04, 2003 10:04 AM To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED] Subject: Re: [PHP-DB] Date Range Question... I am working on an app that needs to post information to a website

RE: [PHP-DB] matching data from one table with another and displaying results?

2003-02-04 Thread NIPP, SCOTT V (SBCSI)
I have a JOIN that is not working, and figured I would piggie-back on this thread to see if someone could give me a quick answer... Here is the JOIN syntax. This is my very first attempt at a JOIN statement, so I may be doing something blatantly wrong here. SELECT 'A.Title' FROM

[PHP-DB] A little JOIN help please...

2003-02-04 Thread NIPP, SCOTT V (SBCSI)
This is more of an SQL question, but I am not sure where else to turn for help. I am trying a JOIN, for the first time ever, and it is NOT working for me. The following is what I am attempting; SELECT 'A.Title' FROM `phpCalendar_Daily` AS 'B' JOIN 'phpCalendar_Details' AS 'A' ON

RE: [PHP-DB] A little JOIN help please...

2003-02-04 Thread NIPP, SCOTT V (SBCSI)
AND A.StopDate -Original Message- From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 04, 2003 1:36 PM To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED] Subject: Re: [PHP-DB] A little JOIN help please... SELECT 'A.Title' FROM `phpCalendar_Daily` AS 'B' JOIN

[PHP-DB] Weird PHP behavior...

2003-02-06 Thread NIPP, SCOTT V (SBCSI)
I developed some dynamic content for a larger web page, and once I pasted the code into the appropriate area of the page I am seeing the strangest error. Here is the error: Warning: Failed opening '/www/DW/index1.htm' for inclusion (include_path='.:/usr/local/lib/php') in Unknown on line

RE: [PHP-DB] Weird PHP behavior...

2003-02-06 Thread NIPP, SCOTT V (SBCSI)
requests call the Help Desk/span/h4 ...snip -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 11:09 AM To: NIPP, SCOTT V (SBCSI) Subject: RE: [PHP-DB] Weird PHP behavior... well show the working code and then show just a portion

RE: [PHP-DB] Weird PHP behavior...

2003-02-06 Thread NIPP, SCOTT V (SBCSI)
It turned out to be just a simple file permissions issue. -Original Message- From: Mohammad Saad [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 12:31 PM To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Weird PHP behavior

RE: [PHP-DB] Code for drop down lists

2003-02-11 Thread NIPP, SCOTT V (SBCSI)
I would most definitely recommend pulling them from a DB table rather than hard coding these into a page. Here is a code snippet that I use to do this on one of my pages: mysql_select_db($Prod, $Prod); $query_systems = SELECT Name FROM systems ORDER BY Name ASC; $systems =

[PHP-DB] Query Help...

2003-03-10 Thread NIPP, SCOTT V (SBCSI)
I am having a lot of trouble with a query that works fine from a basic SQL command line, but fails in my web script. Here is the portion of code including the query: mysql_select_db($database, $Prod); $query_groups = SELECT name FROM group; $groups = mysql_query($query_groups, $Prod) or

RE: [PHP-DB] Query Help...

2003-03-10 Thread NIPP, SCOTT V (SBCSI)
To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Query Help... - Original Message - From: NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 10, 2003 9:23 AM Subject: [PHP-DB] Query Help... I am having a lot of trouble with a query that works fine from a basic SQL

[PHP-DB] Stumped again...

2003-03-11 Thread NIPP, SCOTT V (SBCSI)
OK... I have once again thought of something cool to do, and can't quite figure out how to make it happen. I am developing a user account request system for work. Things are coming along nicely. The user logs into the system, kind of, selects the systems that he wants to have accounts

[PHP-DB] RE: Stumped again...

2003-03-11 Thread NIPP, SCOTT V (SBCSI)
I don't really understand this suggestion. Could someone possibly expound on this further? Maybe an example? Thanks. -Original Message- From: Ben Walling [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 12:19 PM To: NIPP, SCOTT V (SBCSI) Subject: Re: Stumped again

[PHP-DB] RE: Stumped again...

2003-03-11 Thread NIPP, SCOTT V (SBCSI)
populated into the array in the first place. -Original Message- From: Ben Walling [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 1:48 PM To: NIPP, SCOTT V (SBCSI) Cc: [EMAIL PROTECTED] Subject: RE: Stumped again... Your code: while($name = mysql_fetch_row($groups_tmp

[PHP-DB] Easy array question...

2003-03-12 Thread NIPP, SCOTT V (SBCSI)
I create an array on one page and then process it on the next page as I have registered the array as a session variable. I need to basically process one of these arrays twice, so I want to make a copy of the array. The question is how do I do this? I have tried the following: $array2 =

RE: [PHP-DB] Easy array question...

2003-03-12 Thread NIPP, SCOTT V (SBCSI)
] Sent: Wednesday, March 12, 2003 10:40 AM To: '[EMAIL PROTECTED]' Subject: RE: [PHP-DB] Easy array question... Are you using: $array2 = $_SESSION[array1]; Not sure that will do the trick, but it was my first inclination. Rich -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto

RE: [PHP-DB] Easy array question...

2003-03-12 Thread NIPP, SCOTT V (SBCSI)
. -Original Message- From: Jonathan Villa [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 10:58 AM To: [EMAIL PROTECTED]; NIPP, SCOTT V (SBCSI); 'Hutchins, Richard'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Easy array question... Sorry, I just reread your post $array_copy = array

RE: [PHP-DB] Easy array question...

2003-03-12 Thread NIPP, SCOTT V (SBCSI)
-Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 11:10 AM To: '[EMAIL PROTECTED]'; 'Hutchins, Richard'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Easy array question... Here is basically what I have and what I am getting

[PHP-DB] Login and link back...

2003-03-19 Thread NIPP, SCOTT V (SBCSI)
I am curious about what you guys may have along the lines of best practices for forwarding from a URL to a login, and then jumping back to the original URL automatically. I have several separate applications that all need to utilize the same login mechanism. I want the user to be able to

RE: [PHP-DB] compare php and perl

2003-03-20 Thread NIPP, SCOTT V (SBCSI)
In response to your bullet points... 1. Built in mysql_ functions in php (does perl have this?) Perl does not have built in functions for MySQL or any other database. The Perl functions are all added through modules. This is somewhat annoying as compared to PHP

[PHP-DB] Empty display loop...

2003-03-25 Thread NIPP, SCOTT V (SBCSI)
I am working on a page that displays a line of information with a checkbox at the end. I began by getting all of the information I wanted displayed working properly and now I am adding the checkbox. Everything is going find with the exception that all of a sudden with the checkbox code

[PHP-DB] Design question...

2003-03-26 Thread NIPP, SCOTT V (SBCSI)
Anyone have an links to websites that offer good tutorials on web design? I am most interested in learning about templates and how to design these for use with PHP pages. I am using DreamWeaver MX as a development environment and would really like some help with DreamWeaver templates if

RE: [PHP-DB] Re: Empty display loop...

2003-03-26 Thread NIPP, SCOTT V (SBCSI)
OK... I moved the form tag up before the table tag and added a tr tag to the beginning of the first line of display in the loop. No difference in the output. The first line of the output loop is still a completely empty line. -Original Message- From: [EMAIL PROTECTED]

RE: [PHP-DB] Datetime help in an INSERT...

2003-06-06 Thread NIPP, SCOTT V (SBCSI)
from the original query than perform another database query to populate this value yet again. Thanks yet again for the help. -Original Message- From: CPT John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 2:14 PM To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED] Cc: [EMAIL

RE: [PHP-DB] Datetime help in an INSERT...

2003-06-06 Thread NIPP, SCOTT V (SBCSI)
, 2003 9:06 AM To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Datetime help in an INSERT... I have actually discovered that the $td value is blank. The reason appears to be that the page is reloading when a button is pushed, and that is when the $td

RE: [PHP-DB] Datetime help in an INSERT...

2003-06-06 Thread NIPP, SCOTT V (SBCSI)
: Thursday, June 05, 2003 9:01 AM To: NIPP, SCOTT V (SBCSI) Subject: RE: [PHP-DB] Datetime help in an INSERT... You could alway place it as a GET echo a href=\yourscript.com/yourpage.php?td=$td\; Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto

RE: [PHP-DB] Datetime help in an INSERT...

2003-06-06 Thread NIPP, SCOTT V (SBCSI)
] Sent: Thursday, June 05, 2003 9:48 AM To: NIPP, SCOTT V (SBCSI) Subject: RE: [PHP-DB] Datetime help in an INSERT... a button is being pressed? so it is processing a form? if its in a form just pass along the value of $td via hidden input data... input type=hidden name=td value=? echo $td; ? jay

RE: [PHP-DB] Datetime help in an INSERT...

2003-06-06 Thread NIPP, SCOTT V (SBCSI)
. I am guessing that you guys will need more info to help out with this now. Just let me know what you want. Thanks again. -Original Message- From: CPT John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 10:07 AM To: NIPP, SCOTT V (SBCSI) Subject: Re: [PHP-DB] Datetime

  1   2   >