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 PROTECTED]
Subject: [PHP-DB] How to access a MS Access DB
I need to know
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 PROTECTED]
Subject
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(x,x,x);
[ ... ]
but what I'm missing
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($res...))
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.3.1 to
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,
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
META HTTP-EQUIV=refresh CONTENT=5;url=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
META HTTP-EQUIV=refresh CONTENT=5;url=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
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 PROTECTED]
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
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 Something'
[EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent
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
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:
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
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
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 =
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_cart WHERE order_id =
(SELECT
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:
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]
$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
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, SCOTT V
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]
Subject: RE: [PHP-DB] Easy array question...
Sorry, I just reread your post
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
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
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.
?php
include_once(../common/store_config.php);
Jim,
I don't think that matters. One can escape into PHP in several ways
(depending on the php.ini config of course)
1. ?php
2. ?
3. script language=php
4. %
5. ?= (to echo something right away)
Anyway, I tried that and it still doesn't work.
--- Jonathan
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.?php
2.?
3.script language=php
4
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
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 than 24 hours. That part I can do, my question is
how
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 ?
Interesting... how does this fair concerning security? So I'll have
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 produced
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
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
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, Jonathan Villa
35 matches
Mail list logo
