Re: PHP and Mysql

; > Thanks, > > Kevin Smith > Netsmith Limited Use mysql_error() 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

Re: Insert queries add TWO records to database

gt; John Stoops > Software Engineer > -Original 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

Re: Insert queries add TWO records to database

2001-07-03 2003-07-03 NULL > NULL0 > > (2 row(s) affected) > Looks like you are using PHP - and it seems like you might be running the insert in a function given that you are returning a value?? Can you show a little more of your code? -- David Robley Tec

Re: INSERT problem

("Unable to connect to SQL server"); > > mysql_select_db("blah") or die("Unable to select database"); > > mysql_query($query) or die("Insert Failed!"); Add here if(mysql_errno) { echo 'Error: ' . mysql_error() . ''; } and if there

Re: using a variable to search a database

thing similar to perl's $variable=? Just how > do I do this type of search? That looks like PHP scripting (and probably 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 M

Re: Errors on Mysql page

ver, if you judiciously utilise PHP function mysql_error() immediately after your calls to the DB, all may be revealed :-) -- David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA I still miss my ex-wife.

Re: LIKE

E incorrectly? Does MySQL have to match the first > LIKE operator before the second? > > Much thanks, > > 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

Re: Mysql error (Index page)

w the user access to the database. -- David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA "So this is where they make movies," Tom said studiously. -

Re: Query Slowness

t; 4 rows in set (0.03 sec) > > mysql> > > The only problem is that it takes 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

Re: message traffic

Either way allows for flawless filtering. > > > Thanks! > Dave You seem 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 Robl

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

s 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, Web

Re: databases disappear...

the problem is not with Mysql - perhaps if you were 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 w

Re: Grant/Revoke dialogue doesn't open

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

Re: Join mysticism

cond. > Best Regards. > Nick. heh. I'm afraid your red markings don't show up at all well on my text only mail package :-) But have you tried EXPLAIN to try and get some information on how Mysql deals with the different queries? -- David Robley Techno-JoaT, Web Maintain

Re: Grant/Revoke dialogue doesn't open

remains the same. The only resizing that > can be done is horizontal. > > Please let me know if any further info is needed. Forgot - mysqlgui 1.7.5 (according to the download, but help shows 1.7.4) and the problem also exists in the table hierarchy window --

Grant/Revoke dialogue doesn't open

the first 'line' of the dialogue having the Grant checkbox and username text 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