mysql database question

what affects the rows in the host table of database mysql? is it when a particular host logs in the server's mysql console? or is it when a user browses a web file that launches a script to access a database? or both? thanks jembo

Re: Large Memo Type Field

You never considered reading the manual, eh? Look up types in the manual - check out TEXT type -Jason Garber IonZoft.com At 08:12 AM 10/18/2001 -0500, Purcell, Scott wrote: >Hello, >I am working on a school project and I want to use mysql db, as a back end. >Anyway, I want to make a column rea

Re: PHP variable conversion problem.

Neil, Please indicate what you mean by converting the string "x" to a percent value??? -Jason Garber www.deltacron.com At 08:51 AM 9/21/2001 +1000, Neil Silvester wrote: >Another PHP problem has kept me up all night, scouring through my database >books and trying everything I could think of.

1030: Got error 127 from table handler on record 1382

Regarding error 127 from table handler... I thought this may be helpful to anyone that is having this problem: I tried to back up my database using mysqldump: [pad@gamma dbbackup]$ mysqldump -u padadmin --password --verbose paddata | gzip > /home/pad/dbbackup/20010908a.gz Enter password: # Conn

1030: Got error 127 from table handler on record 1382

I thought this may be helpful to anyone that is having this problem. I tried to back up my database using mysqldump: [pad@gamma dbbackup]$ mysqldump -u padadmin --password --verbose paddata | gzip > /home/pad/dbbackup/20010908a.gz Enter password: # Connecting to localhost... # Retrieving table

Re: 4 fields to form key

I am not sure about the primary key. You can create a UNIQUE index on (field1, field2, field3, field4)... (I have done this) This will prevent any duplicate rows from being inserted. Hope it Helps, -Jason Garber Lead Programmer - pulseaday.com At 08:07 AM 8/23/2001 -0400, you wrote: >Hi > >I

Re: Data Encryption

If I am not mistaken... You could write a script that uses PHP to look at the database, create a file, and download it to the browser over an HTTPS connection (128 bit ssl). You would need some sound security protecting access to the download page. You could use the same script to accept a f

Re: numrows

Another tip that I have used ALOT... When a query fails, go to the command line and try executing it and variations of it there to find the problem. -Jason Garber At 10:48 AM 8/23/2001 +0200, you wrote: >This is the error I get: MySQL Query Failed. Error 1030: Got error -1 from >table handl

Re: numrows

problem is... -Jason Garber At 01:36 AM 8/23/2001 -0700, you wrote: >On Thu, Aug 23, 2001 at 04:32:57AM -0400, Jason G. wrote: > > > > NOT EQUAL is != rather than <> > >Really? I've used them both with good success. Where does one >succeed and the other f

Re: numrows

Jeremy, Do you stay up all night also, reading and responding to the MySQL mailing list? :) Thanks for the answer on your MySQL setup. I had mistakenly taken 15 connections to be 15 queries. However, I am impressed with the preformance of MySQL. Do you have any data on how many Connections

Re: numrows

First, Try this: NOT EQUAL is != rather than <> $query = "SELECT * FROM question WHERE answer != '1' AND id>250 ORDER BY id DESC"; $result = mysql_query($query) or die('MySQL Query Failed. Error '.mysql_errno().': '.mysql_error()); $number = mysql_num_rows($result); -Jason Garber Lead Progr