Sorry if you are a newbie..
but if might help if you delete the records before you select them to display in
html
ie: put the delete query at the top of the page, just after this line:
require (templates/db_connect.php);
adam
I have a simple form which queries the database based on 2 pop-up menu
choices and keywords entered by the user,
it passes on the variables as follows:
pop-up1=choice1, pop-up2=choice2, textfield=user specified data
use :
$pop-up1 = $HTTP_POST_VARS[pop-up1];
... each variables you
Hello,
in PostgreSQL I have this:
select date_part('dow', timestamp_name), count(id) from table_name group by
date_part('dow',timestamp_name);
and I get a record count list grouped by week days.
E.g.:
---+--
0 | 123
1 | 16
2 | 45
... |
6 | 9
I just want the day's
Ugh! Thanks, Adam. I knew it would be something stupid. Although I am kind
of new (less than 6 months) to PHP, I'm really not that bad with it (IMHO).
I really thought I had tried putting the DELETE stuff where you said to put
it and it didn't work. However, new day, fresh eyes, your advice...it
on 7/2/02 8:20 PM, Jefferson Cowart at [EMAIL PROTECTED] appended the
following bits to my mbox:
I'm trying to write a PDF form that people can fill in. I want to then
take the data, store it in my database, and then recall the data, and
display a filled in form with that data. I see two
Hello. I was curious if any one is using PHP4.2x with SQLserver 7(or 2000)
and having luck with the datetime type. No matter the datetime in the
database PHP 4.1.2 is always returning Feb 06 2036 6:37AM . The insert is
correct, its only the select that this happens on.
There was a bug report,
I'm having a problem with cookies over several pages. I've tried to set
them up per the manual, ie: prior to header, and using
setcookie('cookiename',$value,time()+3600). The cookie seems to be
created fine on the first page, and passed to the second page, but is
not maintained when the pages
Is this a issue with register _globals = off. try referencing it with
$_COOKIE['user_data'].
Also isn't 3600 only an hour. 60secs * 60mins? i think 6 weeks would
be... 151200 60 * 60 * 42days
does that work?
Jeff
Password Field: INPUT TYPE=PASSWORD
An INPUT element with `TYPE=PASSWORD' is a text field as above, except that
the value is obscured as it is entered. (see also: section Security
Considerations).
For example:
pName: input name=login Password: input type=password name=passwd
Bartosz Matosiuk
Banging my head against a wall with this !
Hope someone can help !
Using MySQL
Trying to list cities with events for that month
I've correctly (i think) formatted my date to a datetime style for MySQL
$month is there chosen one
$tosearch = date(Y-$month-d 00:00:00);
And then this is my
1) no, the commented
setcookie(user_data,,time()+(3600));// set for 6 weeks *24*7*6
I would move the *24*7*6 back into the (3600) to make it so. I just
want to test for an hour
2) so maybe this is a problem with the server? I've been tearing my hair
out because neither cookies
as in
if (!isset($_COOKIE['user_data'])) {
setcookie(user_data,,time()+(3600));// set for 6 weeks
*24*7*6
}
??
nah.. that doesn't work either. It still creates a new cookie.
On Wednesday, July 3, 2002, at 10:05 AM, [EMAIL PROTECTED] wrote:
Is this a
One thing I did find was to look at your php.ini file and see where the
session.save_path=/tmp this is now pointing to your server /tmp not the
apache directory anymore so you will either have to change the permissions
on that folder so apache can write there or make a directory somewhere
just checked and the server is running Apache 1.6.19 and PHP 4.0.6
Terry
On Wednesday, July 3, 2002, at 09:52 AM,
[EMAIL PROTECTED] wrote:
Trust me this does not work with php 4.2.1 and apache 2.0.39 from what
I am told if you get the cvs for apache 2.0.4 it should but I just down
graded
Banging my head against a wall with this !
Hope someone can help !
Using MySQL
Trying to list cities with events for that month
I've correctly (i think) formatted my date to a datetime style for MySQL
$month is there chosen one
$tosearch = date(Y-$month-d 00:00:00);
And then this is my
hey all,
i have this
?php
$today = getdate();
$month = $today['mon'];
$day = $today['mday'];
$year = $today['year'];
$date=$month.-.$day;
$command=mysqldump -uroot --password=* iktato intrat2003 tt.sql;
$test=system($command);
?
When $command=mysqldump -uroot --password=* iktato
Hi there,
Can anybody help me?
I'm building a webinterface to an existing MSSQL database. When displaying
text from the database, strange characters like
?
show up, when I'm supposed to get æ, ø and å (Danish charset).
We're talking PHP4 on IIS5, W2K server. The MSSQL server is on a different
I already got some replies for this but it wasn't it, here is the problem:
I have a simple form which queries the database based on 2 pop-up menu
choices and keywords entered by the user,
it passes on the variables as follows:
pop-up1=choice1, pop-up2=choice2, textfield=user specified data
... At least, I found it challenging. Hopefully someone here will find this a lot
easier =)
I am developing a website wherein customers can log in, enter in the name and type
of their business (rather like the yellow pages.) I have a database of all the
customers, and each table in the
From your query, it looks as if you are letting the user select the table that they
can query with $pop-up1. Is that correct?
If so, do all the available choices of tables have the same column names? Other than
that I can't see why this query would fail.
Martin
eat pasta type fasta [EMAIL
RE: PHP with htaccess files...
Has anyone used basic http authentication with htaccess files that reference password
files and used PHP scripts that could add new users to the password file?
I wanted to use a PHP login page, but most of the site I want to protect is already
written in html
hello.
we are new to this list and new to php so forgive me if this is a dumb
question but we are stuck...
we are trying to setup the event calendar script that
http://www.php.net uses on their front page. The only problem I'm having is
getting the information from the mysql database to the
I am writing scripts to load user data into a MySQL database. I have
tables in the DB called People and PeopleEmail. The PeopleEmail table
stores one email address per record with one of the columns
corresponding to the PID of the people table. Is there a way to run a
single query that will
Could this be as simple as a typo?
textfield
texfield
Jen Swofford
[EMAIL PROTECTED]
-Original Message-
From: eat pasta type fasta [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 3:27 PM
To: PHP LIST
Subject: [PHP-DB] Strange MySQL Query Problem
I already got some
On Wednesday 03 July 2002 13:27, you wrote:
... At least, I found it challenging. Hopefully someone here will find
this a lot easier =)
I am developing a website wherein customers can log in, enter in the
name and type of their business (rather like the yellow pages.) I have a
25 matches
Mail list logo
