How can I convert from FoxPro to MySQL, any tools to help ?
Thanks
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
the user and date fields
>
> George Pitcher wrote:
> >
> > Hi all,
> >
> > I'm having a problem inserting some php stuff into an Access table.
> >
> > This is what is being sent to Access:
> >
> > INSERT INTO ActivityLog (U
Ah, I just knew there must be an easy way of doing it. Thanks Rick !
Is there a good reference on stuff like this with some examples ?
Am I pushing the friendship ? :-)
Rick Emery wrote:
>
> $HTTP_POST_VARS or $_POST is an associative array that holds the keys and
> values for all inputs/select
rning.
> (Something other than chickadees, blue jays, crows and starlings.) And the
> coltsfoot bloomed on the edge of the ditch last Fri. /mt
>
> At 04:23 PM 4/3/2002 +0100, George Pitcher wrote:
> >Hi all,
> >
> >I'm having a problem inserting some php stuff into
Here's a start - take a look at the results in
phpmyadmin to get an idea of how to loop the result
SELECT url, author, name, category FROM hwureviews
GROUP BY category
olinux
--- Alex Behrens <[EMAIL PROTECTED]> wrote:
> Hey Guys,
>
> I'm trying to get my script to group all my reviews
> by ca
One way you can do that is create a local variable and have that
variable referenced in your form in either a hidden field or a text
field.
EXAMPLE
$date = date("l F d, Y") (outputted that would be say Thursday April 4,
2002)
then your field would look something like this depending how you wri
, Time, CourseRef)
> VALUES
> (6, '15381', 20020403, '146.176.13.99', '15:08', 'Counselling')
>
> The error is:
>
> SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT
> INTO statement., SQL state 37000
>
Hey Guys,
I'm trying to get my script to group all my reviews by category now but now
it just displays them all in a row a bunch of times and doesn't group them
how I want it to group them. I want it too look like this:
Processor Reviews
- Review
- Review
Motherboard Reviews
- Review
-Review
H
It would seem that on the page that you post your form to, you'll need to
have a $date = date( "m.d.Y" ); to generate the actual date value.. That is
if I understand correctly the date() function and the question.
Later,
Bob Weaver
- Original Message -
From: "Jennifer Downey" <[EMAIL PR
Jennifer,
assuming you are using MySQL, then I would imagine the field which is
updating itself automatically is actually a TIMESTAMP type, rather than
plain DATE (or perhaps DATESTAMP?)
The *STAMP ones will update themselves I am pretty sure - but you might want
to check this.
HTH
Beau
// ---
Hi all,
If I have a feild called 'date' and the type is date when a form is
submitted isn't it suppose to automatically enter the date or do I need to
somehow enter it through the form?
The reason I ask is that I have another form with a date type and no
reference to it in the form and it is al
Hello,
I have two Oracle instances running on a Mandrake 8.1 box.
SIDs are PM and QA.
All the Oracle environment variables are set on Apache startup. And
$ORACLE_SID=pm is set to.
So connecting via ocilogon($user, $pass, '') to the db with SID=pm without
specifying a service it works.
As soon a
Rick, thanks a ton.
Do you think you could help me construct to two selects? I am very new at
this and don't know what I'm doing quite yet.
Thanks!
-Alex "Big Al" Behrens
E-mail: [EMAIL PROTECTED]
Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)
P
First, please respond on list.
Second, I know what max does. However, you'll be disappointed in its use
here. This while() will execute ONLY ONCE so a while() construct is of no
use here.
The syntax I sent you is correct. It will select all categories and IDs by
category, then ID in a descend
you just cross-posted this to the mysql mailing list.
is this a mysql issue or PHP issue?
-Original Message-
From: Alex Behrens [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 4:33 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] sorting by colum name with nested loops
Hey Guys,
Hey Guys,
I need to reorganize the list of reviews on my site so they are displayed by
category. However, I want it to display all the reviews from all categories
at once. How do I do this? Here is my syntax now for display all reviews at
once, but not sorted by category:
Hardware Reviews - %s A
or:
mysqlhotcopy database /path/to/some/dir
info here:
http://www.mysql.com/doc/B/a/Backup.html
mark
Jason Wong wrote:
> On Thursday 04 April 2002 01:29, andy wrote:
> > oh ... on MySQL
>
> mysqldump --opt dbname > /some/where/backup.sql
>
> --
> Jason Wong -> Gremlins Associates -> www.grem
On Thursday 04 April 2002 01:29, andy wrote:
> oh ... on MySQL
mysqldump --opt dbname > /some/where/backup.sql
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
He who is in love with himself has at least this advantage -- he won't
encounter many rivals.
-- Geor
oh ... on MySQL
"Andy" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi there,
>
> how would a backup procedure look like on a mysql server with root access
to
> make a backup while the db is up and running. As fast as possible The db
is
> more than 1
Hi there,
how would a backup procedure look like on a mysql server with root access to
make a backup while the db is up and running. As fast as possible The db is
more than 100 MB.
Would this be:
- lock all tables writing (how would I do this on the whole db containing
lots of tables?)
- flusch
To add to that, yes, the column must be numeric and it must also be your
PRIMARY KEY column to be able to have the autoincrement attribute, not just
a regular index.
- J
-Original Message-
From: Glenn Holden [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 6:12 PM
To: [EMAIL PROT
serting some php stuff into an Access table.
>
> This is what is being sent to Access:
>
> INSERT INTO ActivityLog (User, Docid, Date, ClientIP, Time, CourseRef)
> VALUES
> (6, '15381', 20020403, '146.176.13.99', '15:08', 'Counselling&#x
Hi all,
I'm having a problem inserting some php stuff into an Access table.
This is what is being sent to Access:
INSERT INTO ActivityLog (User, Docid, Date, ClientIP, Time, CourseRef)
VALUES
(6, '15381', 20020403, '146.176.13.99', '15:08', 'C
$HTTP_POST_VARS or $_POST is an associative array that holds the keys and
values for all inputs/selects in form from the submitted page. Use
array_keys() to determine the names of all your list boxes to examine each
key and its value. Or you can use the list($key,$val) =
each($HTTP_POST_VARS) c
Hi Rick,
Here's a code snippet (less error checking). Basically there could be as
many as twnety questions listed with their associated listboxes of
possible answers. Also be aware that ms-sql identity type is similar to
mysqls autoincrement type except that once a record is deleted, that
identit
On RH 7.2, Apache 1.3.22, PHP 4.1 and ASE 11.9.2 I get :
"Warning: Sybase: Unable to allocate connection record"
Env $SYBASE is set ok as it is seen by PHP.
After restarting apache (compiled with php and php is with-sybase-ct) it
works well for about 3 hours than I start receiving this annoying m
"Ron Allen" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I have a problem with the inital load of my page
>
> When it loads it says that the variable is not defined. When I click on
> search after that it works fine.
>
> How do I get PHP to recognize a varia
what happened when you extracted the form field names from the DB?
-Original Message-
From: Chris MacKenzie [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 3:13 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Submitting Dynamic Form
Hi All,
I'm pretty new to the whole php thing a
The net result is almost the same with the exception that by using
ora_bind you don't have to worry about 'SQL Injection' techniques that
could compromise your site. If you construct the DML statement in one
big string, double check that you have escaped or otherwise nullified
'undesireable' chara
show your code
-Original Message-
From: Ron Allen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 5:43 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Problem with the beginning variable
I have a problem with the inital load of my page
When it loads it says that the variable is n
Try odbc connection pooling. That should help.
"Maris Kalnins" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> When connecting to database (Sybase) through ODBC it takes some time to
> establish odbc connection with:
>
> $cx=odbc_pconnect($G_dbname, $G_dblogin,
Don't forget to quote the strings and run addslashes.
"Christian Schneider" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi,
>
> sorry to post just after subscribing but I didn't find anything in the
faqs.
>
> I have to port an Oracle-based system to MySQL a
Hi,
sorry to post just after subscribing but I didn't find anything in the faqs.
I have to port an Oracle-based system to MySQL and am now investigating
how to get rid of the Oracle specialities. I neither wrote the system
nor do I fully understand how it's working yet, so I might miss somethi
I have a problem with the inital load of my page
When it loads it says that the variable is not defined. When I click on
search after that it works fine.
How do I get PHP to recognize a variable as a certain value without making
it a static value?
--
PHP Database Mailing List (http://www.php
Hi All,
I'm pretty new to the whole php thing and I'm currently making an
multiple choice exam type of thing with php/mssql.
The two tables concerned are called tbl_exam_questions and
tbl_exam_questions which are defined like so.
[tbl_exam_questions] (
[question_id] [int] IDENTITY (1,
35 matches
Mail list logo
