[PHP-DB] Error 127

2001-07-19 Thread Cami


Hi everybody,
All of the sudden I got an error one of mysql tables.
Got error 127 from table handler.
Can't browse it not even from phpmyadmin get the same error. Anybody had
this before? What do I do to recuperate my table?
I really appreciate any help,
Thanks,
Cami


-- 
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]




Re: [PHP-DB] Error 127

2001-07-19 Thread John Pickett

Cami,

Here's what I found on the error and what to do about it:

http://www.mysql.com/doc/R/e/Repair.html

Hope that helps!

My 2 ¢
John Pickett
http://www.bvstudios.com/
Co-Author:  Inside Dreamweaver 4
http://www.amazon.com/exec/obidos/ASIN/0735710848/xtremist
  - Original Message - 
  From: Cami 
  To: [EMAIL PROTECTED] 
  Sent: Thursday, July 19, 2001 8:56 AM
  Subject: [PHP-DB] Error 127



  Hi everybody,
  All of the sudden I got an error one of mysql tables.
  Got error 127 from table handler.
  Can't browse it not even from phpmyadmin get the same error. Anybody had
  this before? What do I do to recuperate my table?
  I really appreciate any help,
  Thanks,
  Cami


  -- 
  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]





RE: [PHP-DB] Error 127

2001-07-19 Thread Cami


Thanks everybody for pointing me to the right place.
I manage to recover it.
Thank God.
Cami
-Original Message-
From: Cami [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 19, 2001 3:57 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Error 127



Hi everybody,
All of the sudden I got an error one of mysql tables.
Got error 127 from table handler.
Can't browse it not even from phpmyadmin get the same error. Anybody had
this before? What do I do to recuperate my table?
I really appreciate any help,
Thanks,
Cami


-- 
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 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]




Re: [PHP-DB] Error 127

2001-07-19 Thread Steve Brett

you know i did this last week and can't remember the functions is used.

i had exactly the same problem but had to dump the records as plain text
files.

i used get_html_translation_table . if you look at the example in the
compiled html help file for php there is a section of code that uses this
function and then array_flip to get the converted chars back into their
original symbols.

Steve

John Pickett [EMAIL PROTECTED] wrote in message
001f01c11064$d3fc8400$4c6146a6@notebook">news:001f01c11064$d3fc8400$4c6146a6@notebook...
 Howdy ;-)

 I have a problem when trying to display data in HTML from a MySQL query.
 Here's what happens:

 1)  I convert the text entered using htmlentities ().  I then insert it
into
 the database table.  If I do a query from a terminal on the data it looks
 fine.

 2)  When I do a select query on the data and then echo () it into a HTML
 page, all of the ' characters are preceded by an escape character \.  I
 don't want this to happen...

 A few questions...  First, would replacing the ' and  characters with
their
 HTML equiv pose problems when using them in say an img tag?  I mean, does
 HTML expect the actual ' and  characters instead of quot; or whatever it
 is?  If it doesn't matter, I can just convert everything to HTML.

 My other question requires explanation of what I'm doing...  I'm trying to
 make it so my client can add their own news updates.  Really simple stuff.
 However, sometimes I'll want to add news items for them that include some
 HTML (like an email link or whatever).  However, the  and  characters
are
 being converted to lt; and gt;  Will this actually work?  Or do I need
the
  and ?  If so, how can I convert everything BUT actual HTML tags...?
I'm
 not far enough along yet where I can test this stuff myself, sorry :-/

 Thanx!

 My 2 ¢
 John Pickett
 http://www.bvstudios.com/
 Co-Author:  Inside Dreamweaver 4
 http://www.amazon.com/exec/obidos/ASIN/0735710848/xtremist




-- 
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]