SQL syntax question

$mysql_link; $runresult = mysql_db_query($dbname, $query, $mysql_link); if (($debugit ) AND ($runresult == )) { mysql_error($mysql_link); echo mysql_errno().: .mysql_error($mysql_link). on database $dbnameBR; echo While running SQL: $queryBR; } return ($runresult); } Any advice? Steve Osborne

Re: [PHP] Working with designers...

), as 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

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] Working with designers... As a designer and a coder, I

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] ?php /* Happy Holidays */ mysql_select_db

Re: Returning html code-PROB SOLVED

that escape problem characters in databases and unescape them when retrieved. Problem solved. Steve Osborne [EMAIL PROTECTED] ?php /* Happy Holidays */ mysql_select_db('North_Pole'); mysql_query('SELECT reindeer FROM stable WHERE nose_color=red

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

Fw: timestamp

Rick, snip Just add a field of type TIMESTAMP to your record. Whenever the field is added or updated, this field will be updated as well. /snip 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

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 as NULL. Steve. Steve Osborne wrote

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'). Steve Osborne Database Programmer Chinook Multimedia Inc. [EMAIL

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

Re: timestamp additional info-SOLVED

. (Again, I've tried passing '', NULL, and 'NULL'). Steve Osborne Database Programmer Chinook Multimedia Inc. [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual

SELECT'ing only 1st matching row

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

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: Thursday, December 13, 2001 11:58 AM Subject: RE

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

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

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 Question Additional Info I am trying

ALTER TABLE error

denied for user: '@localhost' to database 'dbname' screen contents end 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 Programmer Chinook Multimedia Inc

removing PACK_KEYS

is getting put off trying to solve it. Is there anyone who has a solution? Steve Osborne Database Programmer Chinook Multimedia Inc. [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual

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

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 Multimedia Inc

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

PACK_KEYS error

=root -p backupdatabasenamefilename.sql Can anybody help me? Steve Osborne Database Programmer Chinook Multimedia Inc. [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

SQL syntax error

from sql: mysql --user=root -p backupdatabasenamefilename.sql Can anybody help me? Steve Osborne Database Programmer Chinook Multimedia Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: SQL syntax error

] - 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 Steve Osborne [EMAIL PROTECTED] wrote: I am receiving the following error when I try

in_array function?

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://lists.mysql.com

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