Re: [PHP] Working with designers...SORRY

Oops !! Sorry, wrong list. Steve - Original Message - From: "Steve Osborne" <[EMAIL PROTECTED]> To: "MySQL (E-mail)" <[EMAIL PROTECTED]>; "Mike Eheler" <[EMAIL PROTECTED]> Sent: Tuesday, December 18, 2001 3:49 PM Subject: Re: [PHP] W

Re: [PHP] Working with designers...

it will protect you in the future if problems do arise. Good luck, Steve Osborne Database Programmer Chinook Multimedia Inc. [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual

SQL syntax question

n runsql() is as follows: function runsql($query) { global $debugit; global $dbname; global $mysql_link; $runresult = mysql_db_query($dbname, $query, $mysql_link); if (($debugit <> "") AND ($runresult == "")) { mysql_error($mysql_link); echo mysql_errno().&q

Re: Returning html code-PROB SOLVED

at escape problem characters in databases and unescape them when retrieved. Problem solved. Steve Osborne [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.

Returning html code

Does anyone know of an easy way to store html code in a mysql database, and then retreive it, in such a way that it can display the page as if it were a standard html page? Would using php be of benefit to me? Steve Osborne [EMAIL PROTECTED] * *(borrowed from Paul

Re: timestamp additional info-SOLVED

RegDate) > > VALUES ('$NameID','1','$RegNumc','NULL'); > > > > ProdRegDate is the field that I want to timestamp. (Again, I've tried > > passing '', NULL, and 'NULL'). > > > > Steve Osborne >

Fw: timestamp additional info

mysql (filter) Timestamp additional info: INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate) VALUES ('$NameID','1','$RegNumc','NULL'); ProdRegDate is the field that I want to timestamp. (Again, I've tried passing '', NULL, and 'NULL'). Steve -

timestamp additional info

Timestamp additional info: INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate) VALUES ('$NameID','1','$RegNumc','NULL'); ProdRegDate is the field that I want to timestamp. (Again, I've tried passing '', NULL, and 'NULL').

Re: Fw: timestamp

I've tried passing nothing '' and NULL and 'NULL', and still the zero's. In response to Mikel, the field is declared as NULL and default is NULL. I've experimented with changing the Null and Default columns in phpMyAdmin, but it stays as NULL and default

Fw: timestamp

Rick, Just add a field of type TIMESTAMP to your record. Whenever the field is added or updated, this field will be updated as well. The field is already a 'timestamp(14)' type field, but all that is being stored in the fields are zero's. Do you know what could be causing this?

timestamp

Is there a way that will allow a mysql database automatically add the current timestamp to a record when the record is added to the database? Would formatting it through php be useful, and if so, does anyone know how? Thanks, Steve Osborne Database Programmer Chinook Multimedia Inc. [EMAIL

Re: SELECT'ing only 1st matching row

I knew I had to be over thinking it thanks for the reminder about the LIMIT. Problem solved. Thanks, Steve. - Original Message - From: "Ron Jamison" <[EMAIL PROTECTED]> To: "Steve Osborne" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent

SELECT'ing only 1st matching row

need. (I know that duplicating values is not proper database form, however I need to allow the user to change their preferences on each owned product.) Any advice, Steve Osborne Database Programmer Chinook Multimedia Inc. [EMAIL PROT

Re: Query Question Additional Info

Thanks for all your suggestions, I apparently had a brain cramp. Problem solved. Thanks, Steve - Original Message - From: "Steve Osborne" <[EMAIL PROTECTED]> To: "MySQL (E-mail)" <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 1:36 PM Subject: Query

Query Question Additional Info

I am trying to validate a user in a login form. There are 3 things that must be true. User login name = email_login (from User table) User password = password (from User Table) User must be active: activeuser (from Owner table) = 'Y' The Owner table does have a common field with the User Table

Query question

I am trying to validate a user in a login form. There are 3 things that must be true. User login name = email_login (from User table) User password = password (from User Table) User must be active: activeuser (from Owner table) = 'Y' I don't know why I'm having so much difficulty with this SQL

removing PACK_KEYS

HELP PLEASE !! I have run into a problem where my ISP upgraded their mysql version, and now the dump files (.sql) from the mysqldump command cannot be restored on my local server. Unfortunately, I have to wait for our server to be updated, so the simplest solution is not an option. The error th

ALTER TABLE error

OR 2000: Access denied for user: '@localhost' to database 'dbname' Can anyone give me some insight as to why I cannot do this? Do I require root privileges to do this (right now I am logged in as a user, as this remote server is an ISP)? Steve Osborne Database

ISAM 2 MyISAM Conversion

I have an existing database with ISAM tables that I would like to convert to MyISAM tables. Using phpMyAdmin, I can change the table type using a drop-down box, however I do not know the repercussions of the table type conversion. Any advice, Steve Osborne Database Programmer Chinook

Re: SQL syntax error

? Steve [EMAIL PROTECTED] - Original Message - From: "Steve Werby" <[EMAIL PROTECTED]> To: "Steve Osborne" <[EMAIL PROTECTED]>; "MySQL (E-mail)" <[EMAIL PROTECTED]> Sent: Friday, November 30, 2001 2:58 PM Subject: Re: SQL syntax error > "

SQL syntax error

Sorry for the repost of this problem, but I can't find the answer anywhere, and I'm stuck here until I solve this. I am receiving the following error when I try to restore a database backup from an .sql file: ERROR 1064 at line 12: You have an error in your SQL syntax near 'PACK_KEYS=1' at line 1

PACK_KEYS error

I appreciate all the help that you all have provided I've got another one for you all. I am receiving the following error when I try to restore a database backup from an .sql file: ERROR 1064 at line 12: You have an error in your SQL syntax near 'PACK_KEYS=1' at line 11 Code used: DROP TABLE

Graphical Database Information

Is there a utility that will allow me to view a mysql database that is similar to an Access 2000 relationship diagram? Steve Osborne Database Programmer Chinook Multimedia Inc. - Before posting, please check: http

reset table w auto increment

I'm using a table joiner tabel with a auto-incrementing key field, and I would like to empty the table, and start fresh from key 1 (as compared to the next auto-incremented key). Can anyone tell me how to do this (in mysql or in php)? Steve Osborne Database Programmer Chinook Multimedi

Re: in_array function

Thanks for the help regarding my php question (in_array function) Sorry I posted it here; obviously I was a bit confused. Thanks again, Steve Osborne Database Programmer Chinook Multimedia Inc. - Before posting, please

Re: Dynamic arrays in table?

Ideally, you will want at least 2 tables. One for user info, and another for purchase information. One easy way to think of database normalization is to make sure that each table only has one purpose, ie user information. (Obviously, for security reasons, you would want to remove credit card inf

in_array function?

+, and Java, so feel free to be specific in your replies.) Thanks, Steve Osborne Database Programmer Chinook Multimedia Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://