Re: [PHP-DB] HTML mail

2003-11-02 Thread Jonathan Villa
Set Content-Type: text/html in your headers And just enter in html as your body example $body = "\n the rest of your html "; mail($to,$subject,$body,$headers) get the picture? On Sun, 2003-11-02 at 19:20, Ronald Wiplinger wrote: > I got an interesting program to do: > > For a

Re: [PHP-DB] Excel file into MySQL

2003-09-30 Thread Jonathan Villa
right... I was just looking for a quick answer without having to look for it myself... (I tend to be a little self-centered sometimes, sorry) On Tue, 2003-09-30 at 13:29, Jason Wong wrote: > On Wednesday 01 October 2003 02:23, Jonathan Villa wrote: > > On Tue, 2003-09-30 at 10:31,

Re: [PHP-DB] Excel file into MySQL

2003-09-30 Thread Jonathan Villa
On Tue, 2003-09-30 at 10:31, Jonathan Villa wrote: > Is it possible to transfer information from an excel file (33,000 rows) > into MySQL using phpMyAdmin or MySQL CC? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Excel file into MySQL

2003-09-30 Thread Jonathan Villa
Is it possible to transfer information from an excel file (33,000 rows) into MySQL using phpMyAdmin or MySQL CC? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Working query not able to run with PHP script.

2003-09-18 Thread Jonathan Villa
Sorry, I meant referenced in another table not database On Thu, 2003-09-18 at 16:09, Jonathan Villa wrote: > I have several tables I want to delete as well as their reference in > another database > > The query prod

[PHP-DB] Working query not able to run with PHP script.

2003-09-18 Thread Jonathan Villa
I have several tables I want to delete as well as their reference in another database The query produced is this: === DROP TABLE xxx.zorder_47629403705b7e7f0c97387559d8c811; DELETE FROM orders WHERE table_name = "zorder_476294

Re: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-16 Thread Jonathan Villa
: > El Lun 15 Sep 2003 17:47, Jonathan Villa escribió: > > I believe this would need php to installed as a cgi, which I prefer not > > to do... > > If you don't want to because of security resons, please install it and don't > leave it in the hands of the web server.

RE: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread Jonathan Villa
/file.php > > Just a thought, > Ryan > > -Original Message- > From: Jonathan Villa [mailto:[EMAIL PROTECTED] > Sent: Monday, September 15, 2003 3:28 PM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Need to Run a PHP script using CRON or ? > > > > Inter

Re: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread Jonathan Villa
15 at 14:49, CPT John W. Holmes wrote: > From: "Jonathan Villa" <[EMAIL PROTECTED]> > > > > I have an application which creates temporary tables. My plan is to > > remove them after a 24 hour period and only those which are have a > > created time greater

[PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread Jonathan Villa
I have an application which creates temporary tables. My plan is to remove them after a 24 hour period and only those which are have a created time greater than 24 hours. That part I can do, my question is how will I be able to run this script which is a 2 part script. First thing I do is pull t

RE: [PHP-DB] Define()

2003-03-18 Thread Jonathan Villa
2:43 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Define() Where is the $-sign in front of the vars??? Edwin Jonathan Villa wrote: > Jim, > > I don't think that matters. One can escape into PHP in several ways > (depending on the php.ini config of course) > > 1. 2. 3.

RE: [PHP-DB] Define()

2003-03-12 Thread Jonathan Villa
Jim, I don't think that matters. One can escape into PHP in several ways (depending on the php.ini config of course) 1. Jonathan -Original Message- From: Jim Hunter [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 2:59 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-D

RE: [PHP-DB] Define()

2003-03-12 Thread Jonathan Villa
For starters, and in general, does anyone know why a view source would not work in IE 6? This hasn't worked for weeks, so I usually have to use Mozilla to view the source. Anyway, Jim, this is my basic page setup. This is where my HTML codes goes. So for example, a link to another page woul

RE: [PHP-DB] Define()

2003-03-12 Thread Jonathan Villa
Jim, Thanks for reply. I haven't moved this into production yet, the d:/is/ was just for testing as well as because when I use /client_name, the links do not work. I will to use the variable names instead of the define and see where this gets me. Just to note, I tried define(IMG_HOME_ROOT

[PHP-DB] Define()

2003-03-12 Thread Jonathan Villa
I am developing an app which needs 3 constants. The value of these constants comes from a database result. This works fine. My problem is that they do not work very well. I am developing on both windows/Linux (depending what I boot into). This is the effect I want $doc_dir = the string of d:

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

2003-03-12 Thread Jonathan Villa
tly, from this code the output I am actually getting is: Array Thanks again. -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] Subj

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

2003-03-12 Thread Jonathan Villa
Sorry, I just reread your post $array_copy = array(); array_push($array_copy, $original_array); echo $array_copy[0];//or whatever to test ---> Jonathan -Original Message- From: Jonathan Villa [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 10:56 AM To: 'NIPP,

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

2003-03-12 Thread Jonathan Villa
$array_copy = array(); array_push($array_copy, $_SESSION['original_array']); echo $array_copy[0];//or whatever to test ---> Jonathan -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 10:43 AM To: 'Hutchins, Richard'; '[EMAIL

RE: [PHP-DB] Searchform to results.php

2003-03-07 Thread Jonathan Villa
"SELECT .. FROM ".$_POST['searchtype']; I'm not to sure if this is just for easy ready, but I haven't too many instances where the query is in all caps. Anyone, does case matter in a query? ---> Jonathan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

RE: [PHP-DB] How to access a MS Access DB

2003-03-03 Thread Jonathan Villa
I believe I posted that thread. Try odbc_exec instead of odbc_prepare Let me know if have more problems ---> Jonathan -Original Message- From: Beverly Steiner [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 3:11 PM To: [EMAIL PROTECTED] Cc: Beverly Steiner Subject: RE: [

RE: [PHP-DB] Help with a query

2003-03-03 Thread Jonathan Villa
with a query on 3/31/03 10:41 AM, Jonathan Villa at [EMAIL PROTECTED] appended the following bits to my mbox: > I want to pull data from 2 tables but using a primary key from one. > > Here is what I think it should look like. > > SELECT item_id, subtotal, quantity from shopping_car

[PHP-DB] Help with a query

2003-03-03 Thread Jonathan Villa
I can't figure this query out. I want to pull data from 2 tables but using a primary key from one. Here is what I think it should look like. SELECT item_id, subtotal, quantity from shopping_cart WHERE order_id = (SELECT order_id FROM orders WHERE session_id = session_id()) AND customer_id = $cu

RE: [PHP-DB] Customer id

2003-02-28 Thread Jonathan Villa
Create a customer_id field in the database, make it primary, int, and autoincrement ---> Jonathan -Original Message- From: Dan Kelly [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 6:52 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Customer id How do I write a script that

[PHP-DB] phpMyAdmin

2003-02-28 Thread Jonathan Villa
Ok, maybe this is strictly a phpMyAdmin Q, but I'm sure many of use it =) I have a server at home which runs phpMyAdmin. I also run it locally on my laptop. The cfg_uri for both is http://localhost/phpMyAdmin/ When I open a web browser (IE), I go to http://mydomainonmyserverathome/phpMyAdmin Th

RE: [PHP-DB] Storing an array in the database

2003-02-28 Thread Jonathan Villa
Thanks! I checked out the php docs, serialize() returns a string containing a byte-stream representation of value that can be stored anywhere. Perfect! ---> Jonathan -Original Message- From: Chris Boget [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 10:43 AM To: [EM

[PHP-DB] Storing an array in the database

2003-02-28 Thread Jonathan Villa
How would I store an array in the database? I want to store 2 things. One array of shirt sizes and one array of which holds other arrays. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Processing Page

2003-02-27 Thread Jonathan Villa
e script here is unpridictable and it is expected that it may vary according to the job given thus I cannot hardcode the refresh time . Regads, V Kashyap - Original Message - From: "Jonathan Villa" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "'Aspire

RE: [PHP-DB] Re: Processing Page

2003-02-27 Thread Jonathan Villa
Oops, I sent my message without finishing it (that's what I get for having to many windows open). I think your #2 option would work. It's very similar to what I have done in the pass . I forgot exactly how I did it, I would have to look in my archives, but I'm pretty sure it was something like th

RE: [PHP-DB] Re: Processing Page

2003-02-27 Thread Jonathan Villa
I guess I was thinking of a "success only" scenario. If the backend never failed, then an easy Meta redirect would work, (if given enough time to process). However, in the "real world", assuming success is a foolish mistake. ---> Jonathan -Original Message- From: [EMAIL PROTEC

RE: [PHP-DB] Processing Page

2003-02-27 Thread Jonathan Villa
http://yourpagehere";> 5 = time to wait ---> Jonathan -Original Message- From: John A DAVIS [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 2:23 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Processing Page What are the correct META tags? I could use this functiona

RE: [PHP-DB] Processing Page

2003-02-27 Thread Jonathan Villa
http://yourpagehere";> 5 = time to wait ---> Jonathan -Original Message- From: Jonathan Villa [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 2:10 PM To: 'Aspire Something'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Processing Page You could do t

RE: [PHP-DB] Processing Page

2003-02-27 Thread Jonathan Villa
You could do this very easily using a HTML page with the correct META tags. I am working on a Domino Project right now that does just that. After a page is submitted, the user is directed to an html page which sits for about 45 seconds. This HTML page just says something like "Your information i

RE: [PHP-DB] Get MySQL table schema for a dump

2003-02-27 Thread Jonathan Villa
I never thought of mysql_fetch_row. What I ended up using was $row = mysql_fetch_array($result_id); echo $row[1]; I'll probably use fetch_row as it makes more sense. Thanks. ---> Jonathan -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Thursday, Feb

Re: [PHP-DB] php-dbase on RedHat 8.0

2003-02-27 Thread Jonathan Villa
That's odd. I haven't tried 4.3.1, but I do have 4.3.0 running on apache 2.0.44. I'll try 4.3.1 today and see if I come across anything. At Thursday, 27 February 2003, Roger Boily <[EMAIL PROTECTED]> wrote: >Hi, >I have upgrated to RedHat 8.0 that unfortunatly "downgrade" my working >php 4.

RE: [PHP-DB] Get MySQL table schema for a dump

2003-02-26 Thread Jonathan Villa
Ok, that works great. Now, what is the best way to echo the result. For example $connection = mysql_connect("localhost","u","p"); mysql_select_db("killerspin_com", $connection); $sql = "SHOW CREATE TABLE update_list"; $result_id = mysql_query($sql,$connection); then what, if (mysql_num_rows($

RE: [PHP-DB] Re: Get MySQL table schema for a dump

2003-02-26 Thread Jonathan Villa
ble schema for a dump [EMAIL PROTECTED] (Jonathan Villa) writes: > Is there was to get a database's table schema? I don't think it's called schemas in mysql, but I'm not sure :-) > So far, I have a simple function which will output > INSERT INTO table (x,x,x,) VALUES(

[PHP-DB] Get MySQL table schema for a dump

2003-02-26 Thread Jonathan Villa
Is there was to get a database's table schema? For example, I want to be able to click on a link and then create a .txt file of a table (or even better a databases) schema. So far, I have a simple function which will output INSERT INTO table (x,x,x,) VALUES(x,x,x); INSERT INTO table (x,x,x,) VA

[PHP-DB] RE: your odbc problem can be solved

2003-02-14 Thread Jonathan Villa
l [mailto:[EMAIL PROTECTED]] Sent: Friday, February 14, 2003 3:38 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] How to access a MS Access DB to set up a DSN go to control panel and then Administrative Tools then into Data Sources and then add a new system DSN. you can probably

RE: [PHP-DB] How to access a MS Access DB

2003-02-14 Thread Jonathan Villa
up a DSN go to control panel and then Administrative Tools then into Data Sources and then add a new system DSN. you can probably work the rest out as its fairly straight forward. -Original Message- From: Jonathan Villa [mailto:[EMAIL PROTECTED]] Sent: 13 February 2003 22:48 To: [EMAIL PROTE

[PHP-DB] How to access a MS Access DB

2003-02-13 Thread Jonathan Villa
I need to know exactly how to hook up to an Access database under Office Xp. I normally use MySQL, but the current site sits on Windows servers. I am using php 4.3.0 Office Xp Pro w/ Access I'm running Apache 2.0.43 I need to know how to check if ODBC is set up on my machine (I hear that by def