[PHP-DB] HTML stored in a text field
I have a database which has a BLOB field storing text... It should probably be in a text field, but I don't think that's the problem... The field has HTML control codes, such as b, /b, and p. When I echo them from the database, a la: echo td . $row['textfield'] . /td I get the contents of the field with the tags showing up, isntead of applying to the HTML. How can I get these tags to aplpy to the text in the field? Thanks! Gabe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] SQL help
I'm using PHP with ADOdb ( and an MS Access 2000 db ) to write a simple SQL statement but was running into some case sensitivity issues. Here's my SQL currently: SELECT autoQuesID,fldQuesTitle,fldBody FROM tblFAQ_Question WHERE fldBody LIKE '%$strSearchFor%'; All I'm trying to do is have the users search string searched for in the fldBody field. However, I'm having problems trying to get it so that the search is case-insensitive. For instance: If I search on Airline, I get 1 record. If I search on airline, I get 0 records. I make the value of $strSearchFor lower case ( using strtolower() ), but I don't know how to get it so that the contents of the fldBody field is lower case also. I can't seem to find any functions or operators that remove the case-sensitivity. Any help would be much appreciated! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] SQL help
I have tried that and I don't get an error, but I don't get any records returned either. And I have lowered the search string like you mentioned. Here's what I tried ( Access syntax ): SELECT autoQuesID,fldQuesTitle,fldBody FROM tblFAQ_Question WHERE LCase(fldBody) LIKE '%$strSearchFor%'; Nicole Swan wrote: Have you tried lowering the fldBody as well? Like: SELECT autoQuesID,fldQuesTitle,fldBody FROM tblFAQ_Question WHERE LOWER(fldBody) LIKE '%$strSearchFor%'; And $strSearchFor has already been lowered, of course. --Nicole --- Nicole Swan Web Programming Specialist Carroll College CCIT (406)447-4310 -Original Message- From: Gabe [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 23, 2004 8:59 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] SQL help I'm using PHP with ADOdb ( and an MS Access 2000 db ) to write a simple SQL statement but was running into some case sensitivity issues. Here's my SQL currently: SELECT autoQuesID,fldQuesTitle,fldBody FROM tblFAQ_Question WHERE fldBody LIKE '%$strSearchFor%'; All I'm trying to do is have the users search string searched for in the fldBody field. However, I'm having problems trying to get it so that the search is case-insensitive. For instance: If I search on Airline, I get 1 record. If I search on airline, I get 0 records. I make the value of $strSearchFor lower case ( using strtolower() ), but I don't know how to get it so that the contents of the fldBody field is lower case also. I can't seem to find any functions or operators that remove the case-sensitivity. Any help would be much appreciated! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] restoring mysql db after mysqldump
I know nothing about this, but did you investigate 'SHOW TABLE STATUS' for any clues? In article 018601c12b3c$2c2970b0$6e00a8c0@webdesign, [EMAIL PROTECTED] (Jay Paulson) wrote: I've checked and the ROOT user has access to everything... but still no luck.. when i run the mysql -u root -p 'all_databases.sql' it gets to the first table and tries to insert some information into it and says blah table is read only and it stops... jay -- __ Gabe da Silveira, Web Designer Twin Cities Student Unions University of Minnesota http://www.coffman.umn.edu wFone: (612)624-7270 eMail: [EMAIL PROTECTED] hPage: http://www.visi.com/~jiblet -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: MySQL read only?
This would probably be a better question for a MySQL newsgroup... Anyway, I am just talking off the top of myhead since I never did anything like this, but i don't think copying DB files is the proper way to move databases. I believe there is some MySQL dump utility you need to create one transferable file that you can then import on the other machine. In article 00da01c12b1d$6fefb170$6e00a8c0@webdesign, [EMAIL PROTECTED] (Jay Paulson) wrote: Anyone know why a MySQL table is set to read only? I'm logged in as the root user of MySQL and I have checked the privalages of the root user in the MySQL table and everything is set to Yes and I'm able to add and delete users in the MySQL table. Here's what I did... I had a database on my Win2k machine and I just ftp'ed those files over to MySQL running on RedHat. I noticed that the permissions of the files on the RedHat box were different than the MySQL database so I changed the permissions on those files I ftp'ed over. But to no evail it still doesn't work correctly. Would it make a difference if I was using a earlier version of MySQL on my Win2k machine than on the RedHat machine? Anyway, I'm at a total lost here so any help would be great! Thanks, Jay -- __ Gabe da Silveira, Web Designer Twin Cities Student Unions University of Minnesota http://www.coffman.umn.edu wFone: (612)624-7270 eMail: [EMAIL PROTECTED] hPage: http://www.visi.com/~jiblet -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]