Re: PHP and Mysql

2001-07-08 Thread David Robley
() after your database call to get any error messages that mysql returns. -- David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA The guy who writes all those bumper stickers HATES New York

Re: Insert queries add TWO records to database

2001-07-05 Thread David Robley
Message- From: David Robley [mailto:[EMAIL PROTECTED]] Sent: 05 July 2001 03:48 To: [EMAIL PROTECTED] Subject: Re: Insert queries add TWO records to database On Wed, 4 Jul 2001 21:22, you wrote: I think I saw on the mysql list you had pinned this problem on IE? OK - for a further

Re: INSERT problem

2001-07-03 Thread David Robley
'; } and if there is an error returned by mysql it will be displayed. When I add data via the form, npthing seems to happen, it does not add the data to the databse, nor does it pop any errors. Any help would be appreciated...tia -- David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc CENTRE

Re: Insert queries add TWO records to database

2001-07-03 Thread David Robley
are returning a value?? Can you show a little more of your code? -- David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA Enter any 11-digit prime number to continue

Re: LIKE

2001-07-02 Thread David Robley
, Eric Indeed you are doing it wrong. Try select * from table_name where column_1 LIKE %word2% OR column_1 LIKE %word1%; -- David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA Honk if you love peace

Re: Errors on Mysql page

2001-07-02 Thread David Robley
that I and others can login to make changes in areas granted. Without code snippets it's not possible to say what your problem is. However, if you judiciously utilise PHP function mysql_error() immediately after your calls to the DB, all may be revealed :-) -- David Robley Techno-JoaT

Re: using a variable to search a database

2001-07-02 Thread David Robley
eighteen other languages as well) If PHP, then if INPUT TYPE=text has the name request, it's value will be in $request. -- David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA A cat will go quack - if you

Re: message traffic

2001-06-28 Thread David Robley
to be using Pegasus Mail. Set up your filter using a standard header match triggered by the text [EMAIL PROTECTED] in the To or Cc fields. The same filter works just fine for me in KMail :-) -- David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc CENTRE FOR INJURY STUDIES Flinders

Re: Query Slowness

2001-06-28 Thread David Robley
anywhere between 10seconds-1 minute to search the database. there is ~8.5 million records in it though. Anyone know howto speed this up? Kind Regards Kris Amy Wouldn't you be better off to use Char or Varchar types for that sort of information? -- David Robley Techno-JoaT, Web

Re: How do I stop this script running when the page is loaded?

2001-06-27 Thread David Robley
button has been clicked? Test to see if the variable $Submit is empty - if not the button has been clicked and you can do the insert (after you validate the incoming data, of course). You might want to only show the input fields if the action is not an insert. -- David Robley Techno-JoaT

Grant/Revoke dialogue doesn't open

2001-06-26 Thread David Robley
box. I can minimise and restore the window; maximising causes it to widen to screen width but the height remains the same. The only resizing that can be done is horizontal. Please query me if any further info is needed. -- David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc

Re: Grant/Revoke dialogue doesn't open

2001-06-26 Thread David Robley
-- David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA The Definition of an Upgrade: Take old bugs out, put new ones in. - Before posting

Re: Grant/Revoke dialogue doesn't open

2001-06-26 Thread David Robley
On Tue, 26 Jun 2001 22:29, Sinisa Milivojevic wrote: David Robley writes: I came across this discussion from April 2001 on the archives, but nothing more recent. I also have encountered the problem, and thought I could submit a bit more information. OS - Linux 2.4.3 XFree

Re: databases disappear...

2001-06-26 Thread David Robley
to enquire on the PHP list with a code sample? -- David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA I was arrested for selling illegal sized paper