I have a form which captures US addresses ( address, city, state ) and
telephone numbers ( 10 digit ) and am writing this data to a MySQL table. I
need to expand this to capture non-US info, so I was hoping for some
guidance on forms and table structures. I have googled this to death and
still
Does anyone know of any articles on integrating PHP, MySQL and Flash to
perform a drag and drop routine for updating a db?
Specifically, I have a client who is _INSISTING_ that I integrate a drag and
drop feature into his railcar storage application. He wants to be able to
view two railcar
If you are using MySql with the date field is of type timestamp, you should
have to insert anything using the query. It will update automatically when
the record is inserted and/or updated.
ie; $denylog = INSERT INTO deny (account, td ) VALUES ($tmp, $td );
Randy
-Original Message-
($tmp, $td );
Randy
-Original Message-
From: Rankin, Randy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 1:56 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] Datetime help in an INSERT...
If you are using MySql with the date field is of type timestamp, you should
have to insert
Thanks to everyone for your help. I was able to work out the logic last
night based on your fine suggestions and all is well!
Thanks again.
Randy
-Original Message-
From: 1LT John W. Holmes [EMAIL PROTECTED]
Sent: Monday, March 03, 2003 10:30 AM
To: Rankin, Randy
Hello All,
This may be a bit off topic. If so, my apololgies.
A client of mine, a rail car storage company, has asked that I create a
PHP/MySQL application in which they will maintain and track rail cars. I am
having a bit of trouble however working through one of thier requirements.
They need
Thanks to everyone for the help.
For those interested, I have posted the final code below. It functions
beautifully with one exception: the resized image quality is rather poor. I
am now reading through the php manual and newsgroups for a solution, but if
anyone knows how to handle this it would
Good morning all.
I am attempting to create a table in which there is a title cell populated
with a training wave number and then I would like to echo all members of
each training wave below the title cell (See example below for
clarification). All seems to be working with one exception. The
[EMAIL PROTECTED]
Sent: Monday, October 14, 2002 7:17 AM
To: Rankin, Randy
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] First record of array not being echoed
It seems to me that the first time you go through the loop, if
$record-wave_num is != $prior_wave then you print the wave
I have two MySQL tables, groups and users:
groups: group_id, group_name
users: user_id, user_name, group_id, etc.
I would like to produce one table for each group which will list all the
members for that particular group. For example:
Blue (group_id 1)
Tom (group_id
(0,0,0,9,30,date(Y)));
}
echo Start of Period: $period_first_daybr;
echo End of Period: $period_last_day;
?
-Original Message-
From: Rankin, Randy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 8:57 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Determine last quarter
Hello
Hello all,
Does anyone know how I might determine the start date and end date of the
previous calendar quarter based on today's date. For example, today is
2002-03-19, so the previous quarter start date would return 2001-10-01 and
the previous quarter end date would return 2001-12-31. I am
Try this:
$six_months_from_now = date(Y-m-d, mktime(0,0,0, date(m)+6, date(1),
date(Y)));
echo Six Months From Now: $six_months_from_nowP;
-Original Message-
From: its me [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 17, 2002 12:28 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] increase
Chad,
Try something like this:
-
?
$qry = SELECT category_id, category_name from tblCategories;
$result = mysql_query($query);
?
form method=POST name=criteria action=my_postpage.php
select name=categories
Does anyone know how I might populate a drop down box based on the users
selection from a previous drop down box? For example, if I have a table
called 'autos' with 2 fields, 'make' and 'model'. I select distinct 'make'
and populate the first drop down box. Based on the user selection, the 2nd
I have a form (criteria.php) that includes two drop down lists from which a
user can select a start period and an end period from a MySQL table. This
form posts to a form called order_summary.php on which I am using the
$start_period and $end_period variables from the criteria.php form to pull
Does anyone know how to grab only the first and last record of a query.
I have a table named periods with two fields, period_id and period_name. The
user will select a start period and an end period from a drop down list,
assigning $start_period and $end_period variables based on the period id.
Message -
From: Rankin, Randy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 13, 2002 12:32 PM
Subject: [PHP-DB] First and Last Record Query
Does anyone know how to grab only the first and last record of a query.
I have a table named periods with two fields, period_id
We are using OCI to query an Oracle DB. Everything seems to work fine (i.e;
data is returned to the browser), however, the first record of every
recordset is NOT returned. I can run the same query in SQLPlus and all
records are returned. It seems something in PHP is stripping of the first
record
Nevermind, I figured it out. There was a duplicate OCIfetchinto statement
in the script.
Randy
-Original Message-
From: Rankin, Randy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 10:12 AM
To: PHP List
Cc: Barker, John
Subject: [PHP-DB] OCI Query Results
We are using
Rafael,
I am assuming you can connect to your Oracle server from your client (using
net8 for example).
Did you recompile PHP with Oracle OCI support on your web server?
Run ?phpinfo()? and see if there is a section on Oracle OCI. If not, that
may be at least part of your problem. Remember
I am connecting to an Oracle 8 server using OCI, PHP and Apache on a RH
Linux 7.1 box.
All works well until I try to query an Oracle dynamic view like the
following:
$query = SELECT instance_name, host_name FROM v$instance;
When I execute this query, the server returns the following error.
To: Rankin, Randy; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Escaping
Please explain the dynamic link .
is that in the documentation somewhere?
Kne
- Original Message -
From: Rankin, Randy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 12, 2001 8:18 AM
Subject: [PHP-DB
Hello,
I have a table in a MySQL DB (RH Linux/Apache) with a field called
customer_name. Some of the customer names have an ampersand in them (ie; X
X Supply). I am performing a select statement on this table to create a
sales summary with customer name and total sales.
This works fine;
http://www.microsoft.com/KB/Articles/Q128/8/08.HTM
-Original Message-
From: Dalyyla [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 22, 2001 7:32 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] odbc with ms access
hi,
Access to data with ms access via odbc is kinda slow . I would like to
Try this:
http://www.devshed.com/Server_Side/PHP/SoothinglySeamless/
Randy Rankin
Ben Cairns wrote:
I have nearly 18 Months devel on Windows, but we are now moving to Linux,
I have never installed PHP On Linux before, so could someone pls give me
an
'Installation Guide' to follow for
26 matches
Mail list logo