There may be a better way, but in migrating from Filemaker to MySQL, I
encountered similar problems. My solution was to pass the data through Excel
and use that to convert the dates into the required format (CTRL-1, Custom,
-mm-dd). Of course, you ned to watch out for those nasty ' "' ' that
E
Hi all,
I've been working with PHP/MySQL on Win NT and Win 2000 for a few weeks.
I've now set up a Linux machine (Mandrake 8.1 on Dell laptop) and have moved
my files across.
I use an include file which logs on to the MySQL server and then connects to
the database. It performs the login ok but n
Greg, et al,
This is the contents of the include file:
I have also tried it with the following:
";
mysql_select_db ('Heronsql');
echo mysql_errno().": ".mysql_error()."";
?>
Te results for this were:
0:0
0:0
I have reinstalled my Mandrake (MySQL/PHP4.0.6/Apache) and I am about to
retest
login to server and stalled on the select db part?
George
- Original Message -
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "'George Pitcher'" <[EMAIL PROTECTED]>; "Greg Donald"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent:
an it is correct. Am I missing something else
which is obvious?
George
- Original Message -
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "'George Pitcher'" <[EMAIL PROTECTED]>; "Rick Emery" <[EMAIL PROTECTED]>;
"Greg Donald&qu
Emery" <[EMAIL PROTECTED]>
To: "'George Pitcher'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, February 18, 2002 3:46 PM
Subject: RE: [PHP-DB] Problem connecting to db on Linux
> what is the error message you get?
> do you print otu mysql
Hi all,
I've just moved my MySQL db and php scripts over from W2K to Linux and for
some reason my dates are coming across as '-00-00' even though, viewing
the db in MySQLFront, they look fine (actual dates).
When I hosted this on Win2K it worked fine.
I use a function to convert the date fo
Hi all,
I have a site where dates are being displayed and also entered by users. I
don't want to offend them by asking them to use the -mm-dd format or to
split the date into its constituent parts.
I am displaying by using the MySQL Date_Format syntax and that's fine. I get
dd/mm/ and I
Bartek,
This is snipped from a working form on my site:
contains
exact match
begins with
and it works.
George
- Original Message -
From: "Bartek Pawlik" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 26, 2002 10:49 AM
Subject: Odp: [PHP-DB] PHP pro
Hi all,
I'm having a small problem with a biggish query.
The query:
$Itemlistquery= "select [a whole load of fields from 3 tables] ending with
";
$Itemlistquery.= "transactions.Pdownload ";
$Itemlistquery.= "from bib_extract,scanrates,transactions where ";
$Itemlistquery.= "(transactions.Course
ing results using PHP/Mysql
> transactions.CourseID='$Course_ID' is not the same as the three part join
> that you have in that query. Are your sure your other two joins aren't
> restricting the query?
>
> -Original Message-
> From: George Pitcher [mailto:[EMAIL PROTECT
Hi all,
Posted this yesterday and got no response. Trying again today.
I'm having a small problem with a biggish query.
The query:
$Itemlistquery= "select [a whole load of fields from 3 tables] ending with
";
$Itemlistquery.= "transactions.Pdownload ";
$Itemlistquery.= "from bib_extract,scanra
ransferred values.
Any ideas as to where it going wrong?
I'm using PHP-4.1.1, Apache (console) on Win 2000Pro.
Regards
George
George Pitcher is Technical Manager for the HERON Project
at Napier University, Edinburgh.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscri
rom: "Doug Thompson" <[EMAIL PROTECTED]>
To: "George Pitcher" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, March 13, 2002 5:59 PM
Subject: Re: Conflicting results using PHP/Mysql
> I would guess it's because only
Thanks to Kevin, who yesterday emailed me with a solution to my JOIN
problem.
Thanks to all who helped me see the wood for the trees.
George
- Original Message -
From: "Doug Thompson" <[EMAIL PROTECTED]>
To: "George Pitcher" <[EMAIL PROTECTED]>; <[E
Hi all,
One of the pages in my site takes up to 10 seconds to display (depending on
number of records (30 records takes 10 secs).
The cause of the problem is the amount of information I am displaying for
each record. I do multiple queries for each record to find out different
things such as its
Hi,
I'm working on a small Access 2000-based project and I'm getting a SQL Error
.
This is the query (built in PHP):
SELECT * FROM 'Documents'WHERE (CourseRef='4712' AND
Valid_From<=#26/03/2002# AND Valid_Until>=#26/03/2002#) Order by
Author,Title
Any clues or pointers?
George
--
PHP Datab
Adam,
Thanks for the assist.
The query works fine without the ( ) arount the conditions.
Now on to the next part.
George
- Original Message -
From: "Adam Royle" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, March 26, 2002 10:03 PM
Subject: [PHP-DB] Re
Something I used to do about 17-18 years ago to analyse typeseting code was
to use DOS's 'Debug'. It gave a hex value for each character in one panel
while scrolling thru the file. Compare this against the Excel printout and
you should find what code is being used for lf.
Hoping that debug is sti
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', 'Counselling')
The error is:
SQL error: [Micr
t one solution is to ditch the primary key (not really needed in
this table) and just insert the values into the table without specifying the
recipient fields (it is a log table).
George
- Original Message -
From: "Miles Thompson" <[EMAIL PROTECTED]>
To: "George
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
You can't have NOT NULL assigned to a text field.
george
- Original Message -
From: "Lisi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 08, 2002 10:11 AM
Subject: [PHP-DB] Error creating new table
> I am trying to create the following table using PHPMyAdmin:
>
> CRE
Hi all,
I want to report some figures to my colleagues.
My database (2 fields: Customer, Order date) contains over 15000 records
dating back to 1999.
I want to be able to show, in a web page, the following information
Month Customers placing orders Orders placed
Average O
Suman,
Firstly, it's a bit longer than necessary.
Make your form a 'POST' rather than 'GET' and you'll hide your query and
will then be the equivalent.
I presume that you have been able to display other PHP stuff?
Check your php.ini file and make sure that the part that allows you to use
th
Just a thought.
Try putting quotes around the 'True'.
George (no expert - not even a novice - yet)
- Original Message -
From: "Daniel J Owen-Mcgee" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 04, 2002 2:29 PM
Subject: [PHP-DB] Microsoft Access & PHP
Hi,
I'm gleani
eorge in Oxford
===
George Pitcher
HERON Technical Manager
Ingenta plc
23-38 Hythe Bridge Street, Oxford, OX1 2ET
T +44 (0)1865 799137 direct
T +44 (0)1865 799000 switchboard
F +44 (0)1865 799134
E [EMAIL PROTECTED]
www.ingenta.com
Ingenta: Empowering the exchange of academic and professional
Hi all,
This sounds to me like a common question but I haven't found quite what I
want anywaher (maybe I've been looking in the wrong place). So apologies
from a complete newbie.
I have built a database with 6 tables. The Master table contains keys to the
other 5 tables. I want to be able to dis
Hi all,
Well, I played about abit more and discivered that I as overcomplicating
things by specifying the tablename in field to be displayed. Once I set it
to just display the fieldname it worked swimmingly.
Now I can really get going.
George
- Original Message -
From: George Pitcher
Hi all,
I have a MySQL table with approx 350,000 records (US aviation register) and
the way the FAA produce it is without the 'N' prefix which I wish to add.
Can anyone point me to a sql command which will upodate the N-Number field
to 'N' + N-Number field?
George, Edinburgh
_
Hi all,
I'm trying to compile PHP 4.0.6 on LinuxPPC and I keep tripping over the
MySQL part. It just won't compile (can't find headers during the MySQL bit).
All the documentation points to there being a /usr/local/mysql/ folder but
after my MySQL install (rpm) I don't have such a folder. The ne
'/usr/src/mysql-3.23.37/sql'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory '/usr/src/mysql-3.23.37'
make: *** [all-recursive] Error 2
Any suggestions
Regards
George Pitcher
Technical Manager
HERON Project
Napier University
Edinburgh EH10 5DT
[EMAIL PROTE
Justin,
Thanks. It appears to happen in the same place each time I try (4 attempts
as its not that quick [about 1 hr each try]).
So should I download a new compiler (is it the gcc++ or if not, what?)?
George
- Original Message -
From: Justin Buist <[EMAIL PROTECTED]>
To: George P
esult));
} else {print ("Sorry, no aircraft matching your criteria were found.");}
?>
=
Any suggestions as to where I'm going wrong?
Regards
George Pitcher
Technical Manager
HERON Project
Napier University
Edinburgh EH10 5DT
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[E
27;
> > ORDER BY ID");
> > ?>
> >
> > TABLE STUFF HERE
> >
> > > if ($row=mysql_fetch_array($result)) { # this is line 32
> > do {
> > print ("");
> > print $row['ID'];
> > print ("&qu
');
> > if ($Serial == "")
> > {$Serial = '%';}
> > if ($Type == "")
> > {$Type = '%';}
> > if ($Con == "")
> > {$Con = '%';}
> > $result=mysql_query ("SELECT * FROM biz WHERE
> > ID LIKE
P-DB] newbie having problem
>
> - Original Message -----
> From: George Pitcher <[EMAIL PROTECTED]>
> To: Torgil Zechel <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Monday, September 03, 2001 11:19 PM
> Subject: Re: [PHP-DB] newbie having problem
>
Oops, I forgot to say that I can handle this db as a client on the command
line and it shows up under mysqlshow.
George
- Original Message -
From: George Pitcher <[EMAIL PROTECTED]>
To: Jason Wong <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, Septembe
Hi all,
In trying to learn PHP (and MySQL), I am attempting to replicate a
database-web solution built previously using Filemaker Pro and Lasso (on
NT). I am currently working with PHP/MySQL on NT and will be moving this to
Linux before the end of January.
Filemaker is able to perform calculatio
can think of
at least one other query which would be needed to cover another process.
If a single query is taking so long, what will 6 do to my database's overall
performance? Would indexing help?
George
- Original Message -
From: "Miles Thompson" <[EMAIL PROTECTED]&g
DL Neil,
Thanks for your response.
> =As a general comment, it is always dangerous to "replicate" when shifting
platforms, better to reverse engineer
> and then implement anew and taking advantages of the strengths of the new
tools. This particularly when moving
> into the relational field...
P
ur comments tomorrow when I get back in.
Regards
George
- Original Message -
From: "DL Neil" <[EMAIL PROTECTED]>
To: "George Pitcher" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, January 08, 2002 1:07 PM
Subject: Re: [PHP-DB] Concept help
David,
> =Prevailing wisdom in system design suggests that the data should be
'designed' first, and 'code'/processing
> only later (relational or structured design philosophy, even
object-oriented design). Accordingly I recommend
> considering which parts of your current files should be converted
David,
> =I'm feeling a little 'at sea' here, because we had established that you
want to learn more about "joining", yet
> you recognise the word "normalisation" straight off. I don't want to
insult you by 'talking down'/teaching
> grandma to suck eggs... Please be sure it is not another one of
David,
> =ex-Navy guys are always "at sea" - however they never let me near the
ships, but I guess that's another
> story...
ex RAF myself (almost 30 years ago though), so I suppose I might be all 'up
in the air'?
>
> > > level). Once again we draw boxes (I have some wonderful s/w for doing
> >
rname will be substituted inside the single quotes, eg
>
> SELECT Month, Score FROM scores WHERE Username = 'George Pitcher'
>
> =The second line throws the query at MySQL and receives two results by
return. Firstly the logical: "did the
> call work or not?" w
I was having something similar and solved it by wrapping the column names in
parentheses:
select password, 1 as auth from acl where (username='andrewd' and
password=MD5(andrewd.madonna));
It might help. or eliminate something if I'm not right.
George
- Original Message -
From: "Necro"
Sander,
I'm also in Europe but here in the UK we prefer dd/mm/ and I've cobbled
together a couple of functions to handle this for me.
function dbdate($input)
{
$today = explode("-",$input);
$month = $today[1];
$day = $today[2];
$year = $today[0];
$p_date = $day . "/" . $month . "/" . $y
Hi,
Is there a way to grab the ID (from ID field) while INSERTing a new record?
I am currently doing a separate INSERT then a SELECT query to find the most
recently added record by that user:
select ID from table where user = '$user' order by ID DESC limit 0,1
This does the trick but it may no
values('') - > id will be 2
>
> this is auto_increment, so your trick isn't need.
>
> More in manula of mysql.
> regards.
> I piasecki - www.b-c.pl
>
>
>
>
> - Original Message -
> From: "George Pitcher" <[EMAIL PROTECTE
mand, use the call:
> $ID = mysql_insert_id();
>
> The $ID is now the primary key for the record you just inserted.
>
>
> -Original Message-
> From: George Pitcher [mailto:[EMAIL PROTECTED]]
> Sent: 14 January 2002 14:56
> To: Ireneusz Piasecki; [EMAIL PROTECTED]
queries. That was why the WHERE
user='$user' was there.
George
- Original Message -
From: "Sam Masiello" <[EMAIL PROTECTED]>
To: "George Pitcher" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, January 14, 2002 3:21 PM
Subject: Re:
Hi all,
Trying to move code into MySQL rather than php, but can't find any examples
of what I want to do.
I have a number of fields and want to be able to check a number of fields
(most containing workflow dates or text) and return a 'message' for web
display. The message will take the form of
If I perform the following query in MySQL_Front, It works but I get no
records returned (there should be 10 records).
If I use it with php on my web page, I get an error: "Supplied argument is
not a valid MySQL result resource in [script name]" which is probably
because of the zero return.
The s
If I perform the following query in MySQL_Front, It works but I get no
records returned (there should be 10 records).
If I use it with php on my web page, I get an error: "Supplied argument is
not a valid MySQL result resource in [script name]" which is probably
because of the zero return.
The s
I have a page that displays a book and some of its chapters (not all
chapters are recorded) and I want to do a layout like this:
ISN: 012345678X
Book Title: A Christmas Carol
Book Author: Dickens, C.
Publisher:Victorian Press
Year: 1934
Dickens, C Ch
=
George Pitcher
Technical Manager, HERON, Napier University, Edinburgh
0131-455 2435 .. [EMAIL PROTECTED] .. [EMAIL PROTECTED]
__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
stsubmitted, Packorder)"
$uquery1.="VALUES "
$uquery1.="('$d1', '$Packorder')"
$uquery1.=" WHERE RecID= '$tr_id'"
mysql_query($uquery1);
}elseif($activity=='Delete'){
$uquery1 ="update Transactions ";
$uquery1
stsubmitted, Packorder)"
$uquery1.="VALUES "
$uquery1.="('$d1', '$Packorder')"
$uquery1.=" WHERE RecID= '$tr_id'"
mysql_query($uquery1);
}elseif($activity=='Delete'){
$uquery1 ="update Transactions ";
$uquery1
];
$dbRow['ev_sd']= $row["start_day"];
$dbRow['ev_ed']= $row["end_day"];
}
}
In my sample database, I have two records which are both found with the
query (tested in MySQLFront) but the array ends up with 3 rows each w
the ones bevor.
> so add those brackets: []:
> $dbRow['ev_id'][]= $row["id"];
> $dbRow['ev_uid'][] = $row["user_id"];
>
>
>
> HTH,
> Bastian
>
> George Pitcher schrieb:
>
> > Hi all,
>
NULL/www.yahoo.co.uk/')'
Well there's nothing helpful in the MySQL Manual so can someone point me in
the right direction.
I am expecting that some form of encoding should take place - but which one?
Cheers
George in Oxford
===
George Pitcher
HERON Technical Manager
Ingenta plc
23-3
Well, all I can say is Doh! as Homer would put it! Somehow when I created my
table, the link_url field was set is INT with a length of 3! Changing it to
a much longer char field sorted it.
Cheers
George
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.ne
Hi,
Now that I can store - and rebuild my link (URL), I'm having a problem
displaying them.
The links are being displayed into a frame and the link is being prefixed
with the default url for the frameset.
Does anyone know how I can get rid of the prefix?
Cheers
George
===
George Pi
-Original Message-
From: George Pitcher [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 11:12 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] More linking problems but slightly OT
Hi,
Now that I can store - and rebuild my link (URL), I'm having a problem
dis
Ali,
SELECT DATE_FORMAT('1997-10-04','%d/%m/%b/%Y');
gives you '04/10/1997'.
replace the date with the column name and I would suggest giving it an alias
such as eurodate or whatever fits your application.
HTH
George in Oxford
> -Original Message-
> From: Bernain, Fernando G. [mailto:[
If the list is something that may change more than just coccasionally, then
use the database field value. If its going to be really static, then hard
code it into the web form.
Now the code:
";
$link = mysql_connect ('localhost', 'user', 'password') // Connects to
database server
or die ("Could n
Stefan,
This works for me.
Some of my users (and me on some PCs) get a message alerting them about an
Active-X component, but if you ignore it, it has no affect,
George
> -Original Message-
> From: Ohlson Stefan [mailto:[EMAIL PROTECTED]]
> Sent: 12 February 2003 10:05 am
> To: [EMAIL
Hi all,
Can I raise a point of principle here.
My databases never have records deleted - instead they are marked as being
deleted in a status field. That way, they are always there for reference.
Unless you are running a system that needs the space or has extremely high
turnover of deleted recor
Scott,
'Group' is a reserved word so you can't use it for a column name. try
changing it to 'groups' or soething else that makes sense but is safe.
George
> -Original Message-
> From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
> Sent: 10 March 2003 5:24 pm
> To: '[EMAIL PROTECTED]'
Lars,
I'm not sure if this is related (possibly), but I has similar problems with
cookies.
I doiscovered that the cookie was only being set if the page that set it
actually produced HTML. By redirecting, you cut out the HTML-writing.
Why not redirect the user if the test fails instead.
HTH
Geo
Nico,
I'm using MyODBC to query MySQL (because my client want's it to work in
Access, and I don't and this leaves the least amount of code to change).
I don't get an error message if the result is empty (no records). I do a
while loop and add to a counter and if the counter <1 then its empty
othe
That's great, but what about the reverse: Roman to Arabic?
George in Oxford
> -Original Message-
> From: nabil [mailto:[EMAIL PROTECTED]
> Sent: 11 June 2003 9:26 am
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Re: Now, how about Roman Numerals?
>
>
> That's is wonderfull Hugh..
> Nabil
Hi,
I am connecting to MySQL (4.1) using ODBC (I have my reasons) and am looking
for an equivalent to the mysql_insert_id() function so that I can get the ID
of the record just created.
Cheers
George
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net
Hi all,
Just finishing off a site using odbc and Access and it's thrown up a problem
that wasn't there yesterday.
I have a simple login with a username and password. If either are blank, the
user gets bumped to the login page. otherwise the user table is searched for
the username and password.
m
her db -
> client choice)
>
> Oh dear.. Access is a real pain in the butt and we now NEVER deal with a
> client that selects Access. Never had any complaints since.
>
> suggestions - mysql - postgresql - Firebird ...
>
> Pete
>
> George Pitcher wrote:
> > Hi all,
Better still,
Take a look at RTF as a file format. Its readable in Word, looks like a Word
doc and can be saved with a '.doc' extension and you can store placeholders
that php can use to 'mail-merge' with.
Works for me.
Cheers
George
> -Original Message-
> From: Peter Lovatt [mailto:[E
77 matches
Mail list logo
