[PHP-DB] Guru Question

2004-10-19 Thread pete M
I have 2 tables, job_stats (the job statuses) and works which are job items I want to count the number of jobs not completed , however I also want all the statuses, ie even a status with a zero value.. select job_stats.job_stat_id, job_stat_color, concat_ws(': ', job_stats.job_stat_code,

RE: [PHP-DB] setting root password

2004-10-19 Thread Perry, Matthew (Fire Marshal's Office)
After going to the command prompt I have done exactly this: c:\cd C:\mysql\bin c:\mysql\binmysql -uroot -p mysqlSET PASSWORD FOR [EMAIL PROTECTED]('mypassword'); I get the following familiar message: You have an error on your SQL syntax. Check the manual that corresponds to your

RE: [PHP-DB] setting root password

2004-10-19 Thread dpgirago
Matt, Is there a space between PASSWORD and the opening parenthesis? There shouldn't be, if there is. Otherwise, your statement worked without errors for me on MySQL Version 4.0.16.max-nt. Make sure that you are logged in as root. C : \ select user(); Sometimes MySQL is cryptic about its

RE: [PHP-DB] setting root password

2004-10-19 Thread Bastien Koert
try set password for 'root'@'localhost' = PASSWORD('somepassword'); bastien From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] setting root password Date: Tue, 19 Oct 2004 08:36:37 -0500 Matt, Is there a space between PASSWORD and the opening parenthesis? There shouldn't be, if

RE: [PHP-DB] setting root password

2004-10-19 Thread Perry, Matthew (Fire Marshal's Office)
I entered select user(); It outputs: --- user() [EMAIL PROTECTED] --- After I enter: SET PASSWORD FOR [EMAIL PROTECTED]('mypassword'); ERROR 1146: Table mysql.user does not exist. How is this possible? - Matt -Original Message- From: [EMAIL

RE: [PHP-DB] setting root password

2004-10-19 Thread Perry, Matthew (Fire Marshal's Office)
How embarrassing. Yes I must have accidentally deleted the table. I reinstalled and it works fine now. Thank you very much for your help. -Matt _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 19, 2004 11:14 AM To: Perry, Matthew (Fire Marshal's

[PHP-DB] php mssql

2004-10-19 Thread Dale Hersowitz
Recently, I had to format my db server and when I re-attached the database, I noticed some unusal behavior. I have some fields in certain tables with a width of 60. When I would extract data from the table for that specific field, the data would contain extra blank chars. As a result, I am forced

RE: [PHP-DB] setting root password

2004-10-19 Thread Bastien Koert
when you log on, there is no default database set to use type: use mysql bastien From: Perry, Matthew (Fire Marshal's Office) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] setting root password Date: Tue, 19 Oct 2004 11:09:56 -0500 I entered select user(); It outputs:

RE: [PHP-DB] php mssql

2004-10-19 Thread Bastien Koert
Th cols are likely defined as CHAR not as VARCHAR. CHAR cols will pad out the length of the value to the full width of the column...change the type to varchar... bastien From: Dale Hersowitz [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] php mssql Date: Tue, 19 Oct 2004 09:36:25

[PHP-DB] Question: Copy and paste text into mysql text column

2004-10-19 Thread Stuart Felenstein
I have a textarea field that will allow users to copy and paste text into , it might be plain text, or it might come out of word. I'm wondering what type of validations I should perform on this field ? Any suggestions / ideas ? Thank you, Stuart -- PHP Database Mailing List

RE: [PHP-DB] Question: Copy and paste text into mysql text column

2004-10-19 Thread Ed Lazor
I have a textarea field that will allow users to copy and paste text into , it might be plain text, or it might come out of word. I'm wondering what type of validations I should perform on this field ? Any suggestions / ideas ? Hi Stuart, Check out the strip_tags and mysql_escape_string

[PHP-DB] Reverse (or backward?) Infinity Loop

2004-10-19 Thread Bruno B B Magalhães
Hi guys, I have a normal categories table: catId catParentId catName catStatus But I want when a user enters on: http://hostname/site/products/catId1/catId7/catId13/../../contentId.html A listing should apear like that: Category 1 Category 7 Category 13 Category 2 Category 3

RE: [PHP-DB] Generate Menu based on database structure

2004-10-19 Thread Gavin Amm
Thanks for the link. I've got a working JavaScript menu system; I wanted a PHP script that runs once/day to generate the tree structure in the JavaScript config file. That way each time I added a page to the database, it would be automatically added to the menu system. I'm still interested in the