RE: [PHP-DB] write to word..

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

[PHP-DB] odbc going nuts

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.

RE: [PHP-DB] Re: odbc going nuts

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, Just finishing off a site using odbc and Access and it's thrown up a problem that wasn't there yesterday

[PHP-DB] ODBC equiv for mysql_insert_id

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:

RE: [PHP-DB] Re: Now, how about Roman Numerals?

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 Hugh

RE: [PHP-DB] ODBC and error management

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

RE: [PHP-DB] session and header(location....)

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

RE: [PHP-DB] Query Help...

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]'

RE: [PHP-DB] Checkboxes to gather rows to delete

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

RE: [PHP-DB] BinaryWrite in PHP?

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, ?php $fpd = path2file . $fp . .pdf; $len = filesize($fpd); header(Content-Type: application/pdf); // change to suit your file type

RE: [PHP-DB] Code for drop down lists

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: ?php $drop_down_list = select name=HEI_ID; $link = mysql_connect ('localhost', 'user', 'password') //

[PHP-DB] Inserting URL into table

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-38 Hythe Bridge Street, Oxford, OX1 2ET T +44

RE: [PHP-DB] Inserting URL into table - SOLVED

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:

[PHP-DB] More linking problems but slightly OT

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 Pitcher

RE: [PHP-DB] More linking problems but slightly OT

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 displaying them. The links

[PHP-DB] Dumping MySQL rows into a 2D array

]; } } 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 with the last record in it. Any suggestions? George === George Pitcher HERON Technical Manager Ingenta plc 23-38 Hythe Bridge Street, Oxford

RE: [PHP-DB] Re: Dumping MySQL rows into a 2D array

'][] = $row[user_id]; HTH, Bastian George Pitcher schrieb: Hi all, I want to grab the resul from a db query and store it in an array so that I can selectively grab the data later. This is what I'm doing: $dbRowCount = mysql_num_rows( $result ); for ($i = 1

[PHP-DB] Oracle9i and PHP

=== 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 content online

Re: [PHP-DB] Microsoft Access PHP

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 gleaning

Re: [PHP-DB] problem with a small script

Suman, Firstly, it's a bit longer than necessary. Make your form a 'POST' rather than 'GET' and you'll hide your query and ?php echo $fname; ? 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

[PHP-DB] Complicated query on very simple database - pointers sought

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

Re: [PHP-DB] csv without line feed

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

Re: [PHP-DB] Re: PHP/Access problem

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:

[PHP-DB] variation on(Speed Up Code?)

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

[PHP-DB] PHP/Access problem

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

[PHP-DB] Re: Conflicting results using PHP/Mysql

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 three records match the ANDed tests in the WHERE clause (last 3 lines

[PHP-DB] Re: Conflicting results using PHP/Mysql

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]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday

[PHP-DB] Stange 'page-loading' effect

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 unsubscribe, visit: http

Re: [PHP-DB] Conflicting 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 PROTECTED]] Sent: Wednesday, March 13, 2002 10:09 AM To: [EMAIL PROTECTED

[PHP-DB] Conflicting results using PHP/Mysql

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

[PHP-DB] conflicting result problem with MySQL/php

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.CourseID =

[PHP-DB] Euro Dates into MySQL

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

Re: [PHP-DB] PHP problem

Bartek, This is snipped from a working form on my site: select name=ASOp option value=cn selectedcontains option value=eqexact match option value=bwbegins with /select and it works. George - Original Message - From: Bartek Pawlik [EMAIL PROTECTED] To: [EMAIL PROTECTED]

[PHP-DB] Problem displaying dates

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

Re: [PHP-DB] Problem connecting to db on Linux

Greg, et al, This is the contents of the include file: ?php $link = mysql_connect ('localhost', 'root', '*') or die (Could not select db); mysql_select_db ('Heronsql') or die (Could not connect); ? I have also tried it with the following: ?php $link = mysql_connect ('localhost',

Re: [PHP-DB] Problem connecting to db on Linux

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: Monday, February 18, 2002 2:31 PM Subject: RE: [PHP-DB] Problem connecting to db on Linux Have you

Re: [PHP-DB] Problem connecting to db on Linux

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 [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, February 18, 2002 3:19 PM Subject: RE: [PHP-DB

Re: [PHP-DB] Problem connecting to db on Linux

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_error() ? -Original Message- From: George Pitcher [mailto:[EMAIL

Re: [PHP-DB] problem with LOAD DATA INFILE for date format

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

[PHP-DB] Looping advice sought

= 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 http

[PHP-DB] Re: Looping advice sought

$uquery1.=0 $uquery1.= WHERE RecID= '$tr_id' mysql_query($uquery1); } = = = = = = George - Original Message - From: Miles Thompson [EMAIL PROTECTED] To: George Pitcher [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, January 22, 2002 11:49 AM Subject: Re: [PHP-DB] Looping advice sought

Re: [PHP-DB] Looping advice sought

$uquery1.=0 $uquery1.= WHERE RecID= '$tr_id' mysql_query($uquery1); } = = = = = = George - Original Message - From: Miles Thompson [EMAIL PROTECTED] To: George Pitcher [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, January 22, 2002 11:49 AM Subject: Re: [PHP-DB] Looping advice sought

[PHP-DB] 1 query or 2 queries

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

[PHP-DB] Problem with BIG MySQL query

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

[PHP-DB] Problem with BIG MySQL query

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

[PHP-DB] REQ code help for case statement

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

Re: [PHP-DB] convert yyyy/mm/dd to mm/dd/yyyy, how?

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 . / . $year ;

[PHP-DB] grabbing id from new record

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

Re: [PHP-DB] grabbing id from new record

. regards. I piasecki - www.b-c.pl - Original Message - From: George Pitcher [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 14, 2002 3:23 PM Subject: [PHP-DB] grabbing id from new record Hi, Is there a way to grab the ID (from ID field) while INSERTing a new

Re: [PHP-DB] grabbing id from new record

= 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] Subject: Re: [PHP-DB] grabbing id from new record I am sorry, I

Re: [PHP-DB] grabbing id from new record

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: [PHP-DB] grabbing id from new record That actually isn't

Re: [PHP-DB] Concept help required

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 those

Re: [PHP-DB] Concept help required

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 these

Re: [PHP-DB] Concept help required

) or die( Cannot execute query . mysql_error () ) ; =This is PHP code. The first line of which builds a SQL SELECT statement where the contents of the PHP variable $Username will be substituted inside the single quotes, eg SELECT Month, Score FROM scores WHERE Username = 'George Pitcher

Re: [PHP-DB] MySQL Result Resource

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

Re: [PHP-DB] Concept help required

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

Re: [PHP-DB] Concept help required

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 required George, =As a general comment, it is always dangerous

[PHP-DB] Concept help required

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

Re: [PHP-DB] Concept help required

. 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] To: George Pitcher [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, January 07, 2002 1:29 PM Subject: Re: [PHP-DB

Re: [PHP-DB] Concept help required

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...

Re: [PHP-DB] newbie having problem

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 if( $result == FALSE ) { echo mysql_error(); } Yes

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, September 05, 2001 7:46 AM Subject: Re

[PHP-DB] newbie having problem

=mysql_fetch_array($result)); } 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] [EMAIL PROTECTED

Re: [PHP-DB] newbie having problem

suggestions as to where I'm going wrong? Regards George Pitcher Technical Manager HERON Project Napier University Edinburgh EH10 5DT [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] http://www.heron.ac.uk programmer

[PHP-DB] Compiling MySQL Database on LinuxPPC

/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 PROTECTED] [EMAIL PROTECTED] [EMAIL

Re: [PHP-DB] Compiling MySQL Database on LinuxPPC

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 Pitcher

[PHP-DB] displaying related data from MySQL

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

[PHP-DB] Re: displaying related data from MySQL [SOLVED]

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