If you have the ability to say '1234 is your leaser code', why not just
insert 1234 into the database?
Have a page where the leaser enters their name (and password, perhaps?). The
next page will learn the leaser ID, and has the form with all the other info
you need. it will have a
...
Siggy
Im kinda new to the php/mysql world of stuff, and i took over working on a
project called BlazeBoard http://www.bbhacks.com Anywayz, im running into a
problem where to index loads horribly slow with large amounts of date.
However the forumdisplay and viewthread all work fast and good. The forum im
OK,
i have a mySQL database with 3 tables that work together.
Leasers | Apartments | ApartmentFeatures
Leasers - contains contact info for the property owners, and LeaserID as
primary key [auto-incrementing]
Apartments - contains apartment address, the corresponding LeaserID, and
aptID [the apa
When: very easy. Add a TIMESTAMP field to the table; this is automatically
updated everytime the contents of the row are altered.
Who: almost as easy. Add an IP column; When updating/inserting a row; set it
to $REMOTE_ADDR. You can use ip2long function to make the IP only 4 bytes so
that it doesn
This is related to SQL ... Look up the syntax for SELECT, especially for
things like DISTINCT (fieldname) and COUNT (fieldname). You should'nt need
to 'add a flag' anywhere.
When you do the 'add person to database', just see with a simple SELECT if
there already that name in the database!
Siggy
We have a Linux/Apache/PHP combination working with Informix and Oracle.
The first thing we do is to get the Apache and PHP sources. After that
is needed to compile Apache. With both PHP extensions (Oracle
or Informix) you must install the development libraries, installing
the server or client.
dsi safir wrote:
> Hi,
> I'm just looking at the configuration parameters of my
> installation (Apache1.3.14 + PHP4.04pl1 + support for Oracle
> 8.0.5 with OCI, all on HP-UX 11).
> In the oci8 section, there's nothing indicated for the
> "Libraries Used" parameter => is it normal ?
>
This
In article <95erfd$neg$[EMAIL PROTECTED]>, [EMAIL PROTECTED]
("iGuru") wrote:
> I have a little problem. I have a listbox (multiline combo box) on my web
> page. When I sellect multiple items from the list box and submit the for to
> enter the values of the listbox items in the database, then on
Hello
I have a little problem. I have a listbox (multiline combo box) on my web
page. When I sellect multiple items from the list box and submit the form to
enter the values of the listbox items in the database, then only last
selected item of the listbox is entered in the MySQL database.
Does a
Hello
I have a little problem. I have a listbox (multiline combo box) on my web
page. When I sellect multiple items from the list box and submit the for to
enter the values of the listbox items in the database, then only last
selected item of the listbox is entered in the MySQL database.
Does an
Hi,
I'm just looking at the configuration parameters of my
installation (Apache1.3.14 + PHP4.04pl1 + support for Oracle
8.0.5 with OCI, all on HP-UX 11).
In the oci8 section, there's nothing indicated for the
"Libraries Used" parameter => is it normal ?
Thanks for any help.
Emmanuel Nect
At 9:13 AM + 2/2/01, Ben Cairns wrote:
>I have a date stored in a MySQL field in a format like this:
>
>For example, 02/02/2001 (Today) would be stored as:
>02022001
>
>What I need to do is to format that so that it looks like:
>02/02/2001
I assume you really have this stored as a CHAR column
Greetings.
Is it possible to log who and when changes are made to a mysql database ?
If not, is there another open source DB that you could recommend ?
Thanks,
KennM
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:
>How many of you have Oracle working with PHP4? What version of the Oracle
>drivers? Are you accessing a local db or a remote one? Did you have to
>tweak any settings to make it work? Windows or Unix?
PHP 3.0.16 / PHP 4.0.3
ORACLE 8.1.6
Remote + Local
No Problems with the "TNS No Service".
try:
$date=substr("$dat", 0,2)."/".substr("$dat",2,2)."/".substr("$dat",-4);
- Original Message -
From: "Ben Cairns" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 02, 2001 3:13 AM
Subject: [PHP-DB] Returning a formated dat
> I have a date stored in a MySQL field in
Hi all,
i am new in the list and I would like to ask you a question.
I am using Mysql-3.23.30 and php 4.0 to develop a recruitment
application.
I have a table where I store candidate details and one of the fields is
the candidate_name. The Id of each candidate is unique but it appends
that some ca
I am running Oracle 8.0.5 Net8 drivers on a Win95 system using Apache
and PHP4.04pl1. I'm getting consistent TNS No service errors from PHP
using all three methods of accessing Oracle (oracle,oci,odbc). ODBC works
fine in other apps, and the SQLPlus and tnsping work fine (even when
called from a
Ben,
The easiest (and quickest) way I've done this in the past is to use
MySQL's DATE_FORMAT function when doing the SELECT. To format it like you
want try this:
SELECT DATE_FORMAT(date_column, '%m/%d/%y') as f_date FROM Table_name;
Be sure to use the correct name for the column tha
Hello, "Richard S. Crawford"!
You wrote:
> ocifetchstatement(). However, I cannot figure out how to
> get the results
> out of the array. Help!
With ocifetchstatement() you get a hash with column name as
keys and array of column data as values.
--
Piloteers do it on the road
--
PHP Dat
Hello, "Sridhar Ranganathan"!
You wrote:
> What should I do?
>
See the strip_tags() function.
--
Piloteers do it on the road
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list a
I have a date stored in a MySQL field in a format like this:
For example, 02/02/2001 (Today) would be stored as:
02022001
What I need to do is to format that so that it looks like:
02/02/2001
-- Ben Cairns - Head Of Technical Operations
intasept.COM
Tel: 01332 365333
Fax: 01332 346010
E-Mail: [
22 matches
Mail list logo