[PHP-DB] error checking question

2003-06-26 Thread dpgirago
Hello everyone, I've been experimenting with checking for errors in data inserted into a table using an html form. The main page displays the result of a select * from the_table at the top of the page, with the form for inserting the data beneath. The SQL for the insert occurs on a

Re: [PHP-DB] Auto inc in MySQL

2003-07-09 Thread dpgirago
Tris, make the the field, id_number, an auto_increment field. [EMAIL PROTECTED] on 07/09/2003 07:44:34 AM To: [EMAIL PROTECTED] cc:(bcc: David P. Giragosian/MDACC) Subject: [PHP-DB] Auto inc in MySQL I know I'll get flamed for askign such a simple question, but here goes...

[PHP-DB] PHP - Apache config problem

2003-07-14 Thread dpgirago
Howdy everyone, I'm in the process of setting up a new development environment with Apache 1.3.27 and PHP 4.3.2 on a Win2k machine with SP2. I'm getting an error message from apache saying that it can't find the c:/php/sapi/php4apache.dll . However, that is indeed where the dll is located.

Re: [PHP-DB] PHP - Apache config problem

2003-07-14 Thread dpgirago
FYI: OOPS!! I dug around in the install.txt file in PHP, and found that php4ts.dll needs to be relocated to either where apache.exe resides, where php4apache.dll resides, or in the windows system directory. All now works as expected. David [EMAIL PROTECTED] on 07/14/2003 11:35:42 AM To:

[PHP-DB] PDF Implementation

2003-07-17 Thread dpgirago
Good Morning All , Has anyone successfully implemented PDF functionality within their PHP / MySQL projects? My needs are very basic, so I'd like to use something like ezPDF creation to avoid buying a license. But I haven't yet got ezPDF to work correctly. Set up is Win2k, PHP 4.3.2, Apache

[PHP-DB] imagetypes( ) function

2003-07-28 Thread dpgirago
Good day all, Anyone have an idea why I receive a call to undefined function error message when I use the imagetypes() function on PHP versions 4.2.3 and 4.3.2 ?? The code to test for PNG image handling is right from the manual... ?php if ( imagetypes() IMG_PNG) { echo PNG Support

Re: [PHP-DB] imagetypes( ) function

2003-07-28 Thread dpgirago
Ah, you know, when I removed the semi-colon and restarted apache, I got an error saying that the module couldn't be found or started... Wonder why it is not available. I downloaded PHP 4.3.2 php.net just last week. BTW, I'm on Win 2k, also. Any ideas? [EMAIL PROTECTED] on 07/28/2003

Re: [PHP-DB] imagetypes( ) function

2003-07-28 Thread dpgirago
thanks, I was gonna repost to let everyone know that I was being a dummy because I hadn't indicated in php.ini where the extensions directory was located. I added the path, and uncommented the extension=php_gd2.dll, and all is ok in php-land. Thanks, again [EMAIL PROTECTED] on 07/28/2003

[PHP-DB] SESSION SID Question

2003-08-28 Thread dpgirago
Howdy Listers, Can someone explain to me the mechanism by which SID acquires a value? For example, $FOO = SID; echo $FOO; produces something like PHPSESSID=ade4055eef947f1a00cdb280470e859b when IE is first opened and the page is loaded, whereas reloading of the page produces an empty string

[PHP-DB] SESSION SID Question

2003-08-28 Thread dpgirago
Howdy Listers, Can someone explain to me the mechanism by which SID acquires a value? For example, $FOO = SID; echo $FOO; produces something like PHPSESSID=ade4055eef947f1a00cdb280470e859b when IE is first opened and the page is loaded, whereas reloading of the page produces an empty string

Re: [PHP-DB] Viewing Data From MySQL

2003-09-03 Thread dpgirago
Yes, easily. Use the 'if' conditional in mysql... select if(col_name = 1, 'yes', 'no') from table_name; David Shaun [EMAIL PROTECTED] 09/03/2003 10:32 AM To: [EMAIL PROTECTED] cc: Subject: [PHP-DB] Viewing Data From MySQL Hi, Is it possible to change the way a query is

[PHP-DB] Links within this list

2003-09-18 Thread dpgirago
IMHO I would be extremely reluctant to open any link sent to this list. The last time I did so, not only did it connect me to a porno site, it created a link in my favorites folder, causing me to have a lot of explaining to do ( as I access this list through my place of employment ). So,

[PHP-DB] Query Filter in GUI

2003-09-22 Thread dpgirago
Good Morning PHP-DB Listers, I have a PHP GUI in which a select box gets populated by a query of a MySQL DB for all CD's by all artists when the page is first opened. I am now trying to implement the same query but with a WHERE clause that filters the returned CD's to be displayed in the same

[PHP-DB] Query FIlter in GUI

2003-09-22 Thread dpgirago
Thank you CPT John W. Holmes. I'll give it a try. David

[PHP-DB] Storing Session Variables

2003-09-24 Thread dpgirago
Just wondering... Is there a limit to the number of session variables one can create/store ? Or is the limit imposed by the size of the file ? I'm on a Windows 2000 machine, and the variables are being saved in notepad. David

Re: [PHP-DB] Storing Session Variables

2003-09-24 Thread dpgirago
Define 'too much' please... David CPT John W. Holmes [EMAIL PROTECTED] 09/24/2003 10:29 AM Please respond to CPT John W. Holmes To: [EMAIL PROTECTED], [EMAIL PROTECTED] cc: Subject: Re: [PHP-DB] Storing Session Variables From: [EMAIL PROTECTED] Is there a limit to the number

Re: [PHP-DB] Storing Session Variables

2003-09-24 Thread dpgirago
Get serious for a second here... Why not explain why you're asking this question? If you're going to store a huge amount of data in a session, explain why. OK. Today I'm working on a prototype GUI for a medical setting ( the production GUI will be done in C++, I believe). The GUI must keep

Re: [PHP-DB] Query's

2003-09-29 Thread dpgirago
Are you asking for help with the query, or with having the query populate a select box? If you are planning to be able to manually enter search criteria, then you do not want a select box, you want a text type input. David Andrew R [EMAIL PROTECTED] 09/29/2003 05:01 PM To: [EMAIL

[PHP-DB] How to open PDF File on Server on Local Client

2003-10-14 Thread dpgirago
Good Day All, I have an intranet GUI that allows users to select, insert, and update data in a db. When data is entered into one of the screens, a C program is called which does some calculations and then creates a PDF file on the server. I want the user to then see the PDF file opened on

Re: [PHP-DB] How to open PDF File on Server on Local Client

2003-10-14 Thread dpgirago
OK. So if I understand corectly, a link with the path to the file on the server will work. How do I have a new browser opened displaying the PDF more or less automatically, ie, without the user clicking anything? Is this a Header() function? David

RE: [PHP-DB] How to open PDF File on Server on Local Client

2003-10-14 Thread dpgirago
Richard and Karen, Thanks for your help this morning with my PDF question. I created the link dynamically as you suggested. In retrospect, I also think that I was seeking a javascript solution, i.e., now that the PDF file exists on the web server : ?php $openPDF = SCRIPT

Re: [PHP-DB] Retreive data from multiple columns by ['tablename.colname']

2003-10-16 Thread dpgirago
Hi Erik, I think you can use ** $line['cases.id'] ** if you individually identify each column selected, rather than using the * symbol. David Erik Björling [EMAIL PROTECTED] 10/16/2003 10:57 AM To: [EMAIL PROTECTED] cc: Subject: [PHP-DB] Retreive data from multiple columns

[PHP-DB] Extracting values from an array (I think)

2003-11-24 Thread dpgirago
Hello All, I'm familiar and comfortable with selecting and utilizing one record at a time in my php-mysql gui / application. But now I'm faced with having to select one field from 24 records and assign the results to 24 different variables. Table structure: CONFIG

Re: [PHP-DB] Extracting values from an array (I think)

2003-11-24 Thread dpgirago
Thanks for your kind reply, John. I've not used the variable variable technique before but do recall reading about it in the PHP Bible. I'll give it a try. David John Krewson [EMAIL PROTECTED] 11/24/2003 01:33 PM To: [EMAIL PROTECTED] cc: Subject: Re: [PHP-DB] Extracting

Re: [PHP-DB] Extracting values from an array (I think)

2003-11-24 Thread dpgirago
I'm getting the correct output from the following query: $selectLabelQuery = SELECT short_label FROM config ORDER BY meter_num; $resultSelectLabelQuery = mysql_query($selectLabelQuery) or

[PHP-DB] Seeking Opinions about PHP Directory Organization and Permissions on Linux

2004-01-09 Thread dpgirago
Howdy all, I have been using PHP, MySQL and Apache on Win2K for about a year now and have recently begun the process of switching development to Linux -- RH9.0. Yesterday (by using the excellent reference by Patrick Harper, http://www.internetsecurityguru.com/documents/snort_acid_rh9.pdf ) I

[PHP-DB] passing a $_POST variable

2004-01-16 Thread dpgirago
Good day all, This may be easier than I'm imagining... The question: When using the header(location: ...) method for inserting or updating some $_POST['variable']'s into a MySQL db (preventing repeat insertions or updates when 'refreshing', etc...), is it possible to return a

RE: [PHP-DB] CREATE TABLE problem

2004-01-22 Thread dpgirago
Regarding... -- $query = CREATE TABLE staff ( -- staffid INT(3) NOT NULL AUTO_INCREMENT UNSIGNED, -- name VARCHAR(255) NOT NULL, -- login VARCHAR(10) NOT NULL, -- password VARCHAR(8) NOT NULL, -- picaddy VARCHAR(255) NOT NULL, -- email VARCHAR(255) NOT NULL, -- staffbio TEXT NOT NULL, --

[PHP-DB] Unexpected Session Behavior on Mozilla

2004-01-28 Thread dpgirago
Hello PHP-DB listers, I've a PHP, MySQL Web Page script that branches according to browser (e.g., MSIE, or Mozilla ) and which uses a small number of session variables. I've noticed that when connecting through Explorer, for each browser / page instance opened on the same machine, there is a

Re: [PHP-DB] Associated popup menu (php/mysql)

2004-02-06 Thread dpgirago
Let's see if I'm understanding you correctly. You want to have a form with 2 or more popup menus, where a choice of `country` in the first menu then populates a second popup menu with the `states` located in that country? If this is what you're asking, I do this all the time using select (or

[PHP-DB] mail() and sendmail configuration

2004-02-23 Thread dpgirago
Good Morning, This post is somewhat OT -- please forgive me. I've spent over 3 days trying to get sendmail configured and I've lost some patience and reasoning ability in the process. I have a Linux (RH9), Apache 2.0.48, PHP 4.3.4, MySQL GUI that creates a PDF document on the server for web

Re: [PHP-DB] mail() and sendmail configuration

2004-02-23 Thread dpgirago
Jason, Thanks for the suggestions. In regard to your question, no. A simple mail() invocation without the attachment does not work, hence my sense that the problem is the sendmail config. I'm in the process of checking the logs and will repost if anything looks promising. David Jason

[PHP-DB] Automatically Refreshing png-Image'd Web Page

2004-03-19 Thread dpgirago
Howdy Listers, The Background: I am making dynamic, color-coded, png images of the floor plan of a building and displaying them in a browser. Numerous radioactivity sensors throughout the building send their readings to a MySQL dB, and the web page queries the dB, and depending on the

RE: [PHP-DB] Automatically Refreshing png-Image'd Web Page

2004-03-19 Thread dpgirago
Thanks, Paul, you got it right. I was trying to do it all in one file/page. I'll have a go at your suggestion. dave I might be reading this wrong, but I do not think you should put your meta refresh request in the png creation script. It should be in the html body script. Index.php

RE: [PHP-DB] question on select

2004-05-12 Thread dpgirago
Thanks so much but I am so new to all this so need more explanation please. I think at this point I don't mind the round trip to the server side till I find a better way. But for now I think I have what you are suggesting but then why my echo is not retuning anything : form name=fcountry

Re: [PHP-DB] Re: inserting data into database!

2004-05-14 Thread dpgirago
Here is my code now, but I am getting a parsing error Parse error: parse error, unexpected $end $db_table = 'log'; $conn = mysql_connect($db_host,$db_user,$db_pass); if ($conn == true) { $insert = INSERT INTO $db_table SET ; $insert .= Base = ' . $row-Base . ', ; $insert .=

[PHP-DB] Convert HTML Table to Tab Delimited .TXT file

2004-05-24 Thread dpgirago
Howdy All, I've PHP / Apache / MySQL running on a Linux machine where a GUI allows an administrator to track changes made to computers on our intranet. I've been asked to add an 'history' button so that all changes made to one or more computers can be put into a table, displayed on client

Re: [PHP-DB] Re: Convert HTML Table to Tab Delimited .TXT file

2004-05-24 Thread dpgirago
Thanks for responding, Torsten. If I'm understanding your suggestion, then what happens where the data from the dB already has a ; (semi-colon) in it? Wouldn't this corrupt the import into excel? dave My question is whether there might be a more direct way to get the dB data into excel on

Re: [PHP-DB] Re: Convert HTML Table to Tab Delimited .TXT file

2004-05-24 Thread dpgirago
There definitely are colons, and there is a 'comments' field and semi-colons may appear there. However I think I will include a note in the help file for the admin to avoid using semi-colons in this field. Seems the best solution. And you are right: A .csv is seen as an excel file, so opening

Re: [PHP-DB] Re: Convert HTML Table to Tab Delimited .TXT file

2004-05-24 Thread dpgirago
Thanks, Christian, and all who responded. I think this is almost exactly as it will work. The problem with using some kind of MySQL frontend is that this would involve some knowledge of dB's and SQL (can't be certain of this), and that it would be additional steps. For example, the GUI already

Re: [PHP-DB] Convert HTML Table to Tab Delimited .TXT file

2004-05-24 Thread dpgirago
Wow, thanks. I'm gonna give this a try right now. dave Mark Weinstock at [EMAIL PROTECTED] recently wrote... Maybe I'm missing something (quite possible), but you can make the work happen autogically by using http headers. header(Content-type: application/octet-stream);

Re: [PHP-DB] Convert HTML Table to Tab Delimited .TXT file

2004-05-24 Thread dpgirago
I've used the header function before for redirection with success, but in the current situation I'm not sure where to put the 2 calls to it. I'm making the web page on the fly -- querying the dB, writing out the string including html tags and the query result, using fopen to create the file,

[PHP-DB] MySQL_unbuffered_query() and MySQL_free_result()

2004-06-30 Thread dpgirago
Howdy All, If one were to use mysql_unbuffered_query() instead of mysql_query(), are calls to mysql_free_result still needed? or valid? I'm asking because when I make this change in one of my scripts, mysql_free_result throws a warning: 'xxx' is not a valid result resource... The application

Re: [PHP-DB] [slightly OT] OOP syntax

2004-06-30 Thread dpgirago
Jeff, From my recent readings, and others please correct me here, I think you need to first declare the variables inside the Class, i.e., var $srvr['etime'] = array(); var $srvr['etime']['server']; -- then assign a value to them: var $srvr['etime']['server'] = '27.22.1.5:1433'; In other

RE: [PHP-DB] Turning off Save Password

2004-07-01 Thread dpgirago
I'd bet I'm in the minority here, but I don't mind at all the occasional, OT post. Hell, most of life seems OT, doesn't it? BTW, your solution provides me with very helpful information. Thanks much. dave Fixed my own problem. Within the tag, you can use autocomplete=off To turn off the

[PHP-DB] PHP-4.3.7 and OpenSSL Version

2004-07-07 Thread dpgirago
OT If anyone 'listening' has the php 4.3.7 binary installed on Windows, would you kindly run phpinfo() and let me know what version of OpenSSL is bundled with the release ( should be either 0.9.7c or 0.9.7d ). /OT Thanks, dave

Re: [PHP-DB] PHP-4.3.7 and OpenSSL Version

2004-07-07 Thread dpgirago
Thanks Marie and MeX for having a look. dave

Re: [PHP-DB] MySQL software question

2004-07-28 Thread dpgirago
I have ERwin 4.1.2208 installed, and it connects to MySQL only through ODBC, so one needs to have the MyODBC.dll installed. You can then make an ODBC connection with it. But ERwin is probably a $4,000.00 software package. Pretty steep for an individual... dave May be ERwin or BPwin can help

Re: [PHP-DB] Don't mean to be repetitive - Session Variables

2004-10-11 Thread dpgirago
Have you assigned the values in the $_SESSION['l_industry'] array to those specific local variables, $l_industry['0'], $l_industry['1']... ? dave Stuart Felenstein [EMAIL PROTECTED] 10/11/2004 10:20 AM To: [EMAIL PROTECTED] cc: Subject: Re: [PHP-DB] Don't mean to be

Re: [PHP-DB] INNO tables - will I have problems?

2004-10-13 Thread dpgirago
[EMAIL PROTECTED] 10/13/2004 12:11 PM To: [EMAIL PROTECTED] cc: Subject: Re: [PHP-DB] INNO tables - will I have problems? To quote the Mighty Gerard Samuel [EMAIL PROTECTED]: Julian Madle wrote: I obviously have no control of which ISP and end-user may choose, although our

Re: [PHP-DB] INNO tables - will I have problems?

2004-10-13 Thread dpgirago
right, so after you define the fields of the table, you add type=innodb simple as that dave Gerard Samuel [EMAIL PROTECTED] 10/13/2004 02:34 PM To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: [PHP-DB] INNO tables - will I have problems? [EMAIL

Re: [PHP-DB] setting root password

2004-10-18 Thread dpgirago
If you haven't yet deleted the localhost root account, you can log onto the mysql client with: mysql mysql -uroot -p then press enter again when it prompts you for a password. You should now be able to manage all your account info. dave Perry, Matthew (Fire Marshal's Office) [EMAIL

RE: [PHP-DB] setting root password

2004-10-19 Thread dpgirago
Matt, Is there a space between PASSWORD and the opening parenthesis? There shouldn't be, if there is. Otherwise, your statement worked without errors for me on MySQL Version 4.0.16.max-nt. Make sure that you are logged in as root. C : \ select user(); Sometimes MySQL is cryptic about its

RE: [PHP-DB] How to send a SID in a security way - SOLVED!!!

2004-10-22 Thread dpgirago
Andre, Did you intend to write that both sessions have the same name? Doesn't that result in the same issue with the session identification? dave Andre Matos [EMAIL PROTECTED] 10/22/2004 03:25 PM To: [EMAIL PROTECTED] cc: Subject: RE: [PHP-DB] How to send a SID in a security way

RE: [PHP-DB] How to send a SID in a security way - SOLVED!!!

2004-10-25 Thread dpgirago
Just wanted to clarify. The devil is always in the details. dave *** --- Bart Baaten

RE: [PHP-DB] backing up database with mysqldump

2004-10-25 Thread dpgirago
C:\mysqldump -uadministrator -p test test.sql Enter password: ** Perry, Matthew (Fire Marshal's Office) [EMAIL PROTECTED] 10/25/2004 01:53 PM To: [EMAIL PROTECTED] cc: Subject: RE: [PHP-DB] backing up database with mysqldump How do I provide a password? I

RE: [PHP-DB] Book recommendation for using MySQL w. PHP

2004-11-05 Thread dpgirago
Rene, I've gotten a lot of mileage lately out of 'The PHP Anthology, Volumes I and II' by Harry Fuecks and published by SitePoint. The author demonstrates IMO fairly sophisticated usage of OOP techniques in constructing classes for MySQL, in particular. And the coding examples are robust

RE: [PHP-DB] how to find

2004-11-11 Thread dpgirago
Martin, Thanks for your kind words to the new guy. I really don't understand why others don't simply refrain from responding rather than burn bandwidth with their rants of RTFM or or Off Topic - go somewhere else. I really appreciate all the posts folks make as I tend to learn something, even

RE: [PHP-DB] mysql db dump with php

2004-11-17 Thread dpgirago
Nate, Don't know if this is the case or not, but the destination database has to already exist on the upload server. dave Nate Nielsen [EMAIL PROTECTED] 11/17/2004 10:08 AM To: [EMAIL PROTECTED] cc: Subject: RE: [PHP-DB] mysql db dump with php I tried this but to no avail.

RE: [PHP-DB] Transaction suddenly not working

2004-11-29 Thread dpgirago
--- Ford, Mike [EMAIL PROTECTED] wrote: 0: INSERT INTO Table1 (LurkID, ProfileName, Edu, WorkAuth, WorkExp, CarLev, Secu, Confi, Relo, Telecomu, City1, State1, City2, State2, TravelPref, SalaryAnnual, SalaryHourly, Available) VALUES (47, '', 7, 2, 1015, 5, , '', '', '',

Re: [PHP-DB] Use of 'as' name in where sub-clause

2004-12-01 Thread dpgirago
Ross, If someone can give me a good reason why this is so, it will stop it annoying me so much. From the MySQL manual for version 4.0.16: It is not allowed to use a column alias in a WHERE clause, because the column value may not yet be determined when the WHERE clause is executed. See

Re: [PHP-DB] Insert db values into dropdown box error

2004-12-09 Thread dpgirago
It looks like the parenthesis on the line with the 'while' loop is an opening parenthesis instead of a closing parenthesis. while($row=mysql_fetch_array($result)({ ^ dave

[PHP-DB] List Active??

2004-12-29 Thread dpgirago
Just testing the list mail server as I haven't received any posts for days now. dave

Re: [PHP-DB] mysql - image storing

2005-01-18 Thread dpgirago
Jason, can you explain why stripslashes should not be used on data taken from the db? when you store data in the db i thought it was good practice to addslashes, when you retrieve from the db, you will need to use stripslashes to remove the extra \ If I may step in... Assuming a MySQL db,

Re: [PHP-DB] max character size mysql can contain

2005-02-25 Thread dpgirago
Yemi Obembe wondered: Hi guiz, I was just wondering if anyone has an idea the maximum size of characters(in bytes) a mysql database can contain thanx * This is determined by the OS file-size limit as MyQSL stores its data in regular files. I

Re: [PHP-DB] Re: paginating : optimising queries

2005-03-22 Thread dpgirago
On a side note, who's sick of seeing the word optimizing misspelled in the title? :) Ah, the things we do to keep a thread clean. -- - Martin Norland, Sys Admin / Database / Web Developer, International Well, of course, _optimise_ is the British spelling of _optimize_ . Afterall, this

Re: [PHP-DB] Re: paginating : optimising queries

2005-03-22 Thread dpgirago
[EMAIL PROTECTED] wrote: On a side note, who's sick of seeing the word optimizing misspelled in the title? :) Ah, the things we do to keep a thread clean. [snip] Well, of course, _optimise_ is the British spelling of _optimize_ . Afterall, this __is__ an international list ;-

RE: [PHP-DB] What wrong with my Query??

2005-03-25 Thread dpgirago
Harry, I think you could also just use backticks around `limit` as occurs in the table creation statement below. David limit is a mysql keyword...change that field name and the corresonding names in your sql bastien From: HarryG [EMAIL PROTECTED] To: php-db@lists.php.net Subject:

RE: [PHP-DB] What wrong with my Query??

2005-03-25 Thread dpgirago
Either syntax is correct. From section 6.4.3 of the MySQL Manual: INSERT [LOW_PRIORITY | DELAYED] [IGNORE] [INTO] tbl_name [(col_name,...)] VALUES ((expression | DEFAULT),...),(...),... [ ON DUPLICATE KEY UPDATE col_name=expression, ... ] or INSERT [LOW_PRIORITY |

[PHP-DB] How to Disable Daylight Savings Time on RedHat 9.0

2005-04-05 Thread dpgirago
We have created a MySQL/ C application that gathers environmental data and does inserts into the db once per minute. A set of PHP applications reads this data and does some graphical display of the values. Changing from Standard Time to Daylight Savings Time causes minor problems, but in the

Re: [PHP-DB] Pre-Include File -- Global Include Pre/Post by filename

2005-04-05 Thread dpgirago
Peter, Perhaps you are referring to these directive in php.ini: ; Automatically add files before or after any PHP document. auto_prepend_file = auto_append_file = David Peter Beckman [EMAIL PROTECTED] 04/05/2005 03:39 PM To: PHP-DB Mailing List php-db@lists.php.net cc:

Re: [PHP-DB] How to Disable Daylight Savings Time on RedHat 9.0

2005-04-05 Thread dpgirago
We have created a MySQL/ C application that gathers environmental data and does inserts into the db once per minute. A set of PHP applications reads this data and does some graphical display of the values. Changing from Standard Time to Daylight Savings Time causes minor problems, but

Re: [PHP-DB] Transfering post data to a series of pages.

2005-05-04 Thread dpgirago
Perry, Matthew (Fire Marshal's Office) wrote: Is there a way to transfer post data to a series of PHP pages? For example, lets say I have the following 4 pages: Page1.php - this page has my original post form Page2.php - this page does one thing with the post data Page3.php - this page does

[PHP-DB] Creating an Associative Array

2005-06-08 Thread dpgirago
This question will probably be off-topic for some, but it does relate to a database application so please bear with me. I'm pulling date-times out of a MySQL db: mysql select date_format(`date_time`, '%Y.%m.%d %H:%i:%s') as rightNow from location1 order by date_time desc limit 1;

[PHP-DB] Re: Subject: Creating an Associative Array

2005-06-09 Thread dpgirago
Thank you kindly, Neil Smith and Brent Baisley. I now see the error of my approach. --- $dateArray = array(); for($counter = 0; $counter = 3600; $counter++) { $dateArray[

[PHP-DB] Re: Subject: Creating an Associative Array

2005-06-09 Thread dpgirago
Thank you kindly, Neil Smith and Brent Baisley. I now see the error of my approach. --- $dateArray = array(); for($counter = 0; $counter = 3600; $counter++) { $dateArray[

[PHP-DB] Re: Subject: Creating an Associative Array

2005-06-09 Thread dpgirago
Thank you kindly, Neil Smith and Brent Baisley. I now see the error of my approach. --- $dateArray = array(); for($counter = 0; $counter = 3600; $counter++) { $dateArray[

[PHP-DB] Re: Subject: Creating an Associative Array

2005-06-10 Thread dpgirago
Thank you kindly, Neil Smith and Brent Baisley. I now see the error of my approach. --- $dateArray = array(); for($counter = 0; $counter = 3600; $counter++) { $dateArray[

[PHP-DB] Re: Subject: Creating an Associative Array

2005-06-10 Thread dpgirago
Thank you kindly, Neil Smith and Brent Baisley. I now see the error of my approach. --- $dateArray = array(); for($counter = 0; $counter = 3600; $counter++) { $dateArray[

Re: [PHP-DB] mysqldump but exclude one table. .

2005-06-14 Thread dpgirago
C:\mysqldump --version mysqldump Ver 9.09 Distrib 4.0.16, for Win95/Win98 (i32) C:\mysqldump --help | grep table STDIN 6 Dumping definition and data mysql database or table STDIN 7 Usage: mysqldump [OPTIONS] database [tables] STDIN 22--add-drop-tableAdd a 'drop

[PHP-DB] MySQL 4.1 as Backend

2005-07-05 Thread dpgirago
Anyone using MySQL 4.1 as a backend to their PHP apps? I'm particularly interested in the cluster software that the docs say are part of 4.1. I have some apps that would benefit from a high uptime db backend but I'm a bit concerned about the 'not enterprise-ready' disclaimer on the mysql

Re: [PHP-DB] load data infile -- problem

2005-08-18 Thread dpgirago
You can definitely do a load file from within the mysql client, so I'd guess you can do it through mysql_query, too. I'm wondering about the semi-colon within the query. Maybe it needs to be escaped, too. David I could be 100% wrong on this, but I do not think that a command line statement

RE: [PHP-DB] retrieve text from pdf

2005-09-07 Thread dpgirago
Hello Yui, We use an executable called pdftotext.exe to extract text from pdf's. You can find it here: - http://www.foolabs.com/xpdf/download.html Although we use it from the command line, I'd guess that it can be used satisfactorily with exec() within a PHP script, also. David Bastien

Re: [PHP-DB] connection to mysql db

2005-10-11 Thread dpgirago
You need to use the username and password of the database, not the OS, to connect to MySQL. You would also need to set up an account for the username/host name of the remote computer within MySQL for this to work successfully. If this is a new installation of MySQL, try leaving username and

Re: [PHP-DB] Google Style Search Results

2005-12-07 Thread dpgirago
It's possible that the keywords wouldn't be in the first X numbers of characters. |-+-- | | | | | | | | Joseph

Re: [PHP-DB] Re: SQL Insert INTO question

2005-12-08 Thread dpgirago
In full agreement here. I scratched my head this morning, then looked up INSERT in the MySQL Docs for a sanity check. It must be an UPDATE statement to work as indicated below. David Sorry David Mitchell == Is that a

Re: [PHP-DB] Minor Change

2005-12-12 Thread dpgirago
Ken: Echo out the query. Check it. Run it from the MySQL client. What does the error message say? Does the table 109fh6 actually exist in the database? David # Ken responded: # # After adding echo mysql_error(); I get the same result. I tried changing # the query to include 109fh7 (a

[PHP-DB] Dynamic Navigation Bar

2005-12-22 Thread dpgirago
Results from full-text searches on a documents database are returning sometimes 300-400 hits, so I'm gonna need to implement a dynamic navigation bar. Perhaps this a stupid question, but it seems from a brief googling that navigation bars - dynamic or not - operate by appending variables and

RE: [PHP-DB] Dynamic Navigation Bar

2005-12-22 Thread dpgirago
Thanks for the quick response, Bastien. I was thinking that using hidden fields may be another way to go. But how would I assign a value to a form variable via clicking on a link? No, you could try keeping that data in sessions or in hidded form fields in the page...note that the latter

Re: Fw: [PHP-DB] Dynamic Navigation Bar

2005-12-23 Thread dpgirago
Thanks for weighing in on the question, Julien. It's an intranet application, and I have some influence with the users' browser settings, so I used Javascript. I have to admit though that I was unaware you could pass a function from an anchor href tag (a

[PHP-DB] Page Caching after DB Query

2006-01-05 Thread dpgirago
How can I force the browser to re-display the last dynamically created page when using the back button, for example, rather than re-issuing the query. Are there any complications because we are using the https protocol on Apache? David -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] Page Caching after DB Query

2006-01-05 Thread dpgirago
/* for the archives */ Ah, it's in the manual, isn't it? I was calling session_start() on the page, so the session.cache_limiter value of 'nocache' in php.ini was overriding all attempts to cache the page. Calling session_cache_limiter('private') before session_start() did the trick. David

[PHP-DB] No posts in 36 hours??

2006-01-11 Thread dpgirago
List Active? David -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Mirroring two DB

2006-02-28 Thread dpgirago
I want to know how to mirror one MySQL database installed in two different servers so they can be synchronized. Any idea? Search the MySQL docs/manual for master and/or slave. There are good examples for setting up replication from many different web sites as well. David -- PHP Database

Re: [PHP-DB] Problem with a login page.

2006-03-06 Thread dpgirago
snip... // check passwords match $_POST['password'] = stripslashes($_POST['password']); $info['password'] = stripslashes($info['password']); $_POST['password'] = $_POST['password']; if ($_POST['password'] != $info['password']) { die('Incorrect password, please try

Re: [PHP-DB] MySQL - Unable to run service

2006-03-15 Thread dpgirago
I have been using MySQL for quite some time and am now running Server 4.1. I have been developing custom web-based software for a customer and recently moved their server to a different machine. I have everything running smoothly EXCEPT for mySQL. Any time I try to start the service I get an

Re: [PHP-DB] Quiet lately....

2006-04-04 Thread dpgirago
^bump^ its too quiet in here! Has something exciting happened in the U.S. of A. ?? A certain Texas politician under indictment for felony charges announced he is going to resign in June, but surely this is off-topic. [hehehehehehehe] David -- PHP Database Mailing List

Re: [PHP-DB] short text strings with apostrophes and forms

2006-04-20 Thread dpgirago
I have an application which calls up some data from a MySQL table and puts it into a web form for users to modify. One of the cells holds a text string which is put into a text input field. However, if that text string includes an apostrophe, all text after the apostrophe disappears. For

Re: [PHP-DB] Single quotes in INSERT statements?

2006-04-25 Thread dpgirago
Skip Evens wrote: Hello all, I'm brand spanking new to the list and have a quick question. I was under the impression that addslashes() would handle single quote marks in INSERT statements, but when I execute the following: $sql=UPDATE images SET orderno=$orderno,

Re: [PHP-DB] Single quotes in INSERT statements?

2006-04-26 Thread dpgirago
Skip Evans wrote: Hello all, I'm brand spanking new to the list and have a quick question. I was under the impression that addslashes() would handle single quote marks in INSERT statements, but when I execute the following: $sql=UPDATE images SET orderno=$orderno, url='.addslashes($url).',

  1   2   >