[PHP-DB] MySQL editor

2003-06-19 Thread Angelo Zanetti
Hi all. I need to get a program (interface) for MySQL, I was using MySQL Front but they've discontinued its use. Any suggestions. thanx in advance -Angelo

[PHP-DB] Full text search

2003-07-17 Thread Angelo Zanetti
Hi guys can anyone point me to some resources with regard to doing full-text searches in php. I looked at the mySQL docs and there doesnt seem to be much there. TIA. Angelo

[PHP-DB] PHP Full Text SOLVED-dont worry

2003-07-17 Thread Angelo Zanetti

[PHP-DB] MySQL full text search

2003-07-18 Thread Angelo Zanetti
Hi I have a table which contains 3 fields (ID, Title, Abstract) the title and abstract fields have been fulltext indexes like this: ALTER TABLE biblio ADD FULLTEXT (title,abstract); that worked fine, however my problem is whenever I want to do a select statement only comparing 1 of the

Re: [PHP-DB] [SPAM?] [PHP-DB] Appeal For Assitance

2003-07-30 Thread Angelo Zanetti
why doesnt she stick the money up her a$$ - Original Message - From: Mrs. Fatima Abdul [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 11:06 AM Subject: [PHP-DB] [SPAM?] [PHP-DB] Appeal For Assitance This mail is probably spam. The original message has been

RE: [PHP-DB] transaction locking

2003-12-08 Thread Angelo Zanetti
Hi ALek, Yes you can make the column auto_increment. YOu can also make the incrementations start at a particular value by using the ALTER command. EG: ALTER TABLE mytable AUTO_INCREMENT = 99; it will start your next inserted record with 99 for that specific column value. I am not 100% sure

RE: [PHP-DB] HELP!

2003-12-08 Thread Angelo Zanetti
your post is abit vague, give more details or code then we can try help. Its kinda like you saying, help my car wont go. -Original Message- From: Akmal [mailto:[EMAIL PROTECTED] Sent: Saturday, December 06, 2003 5:43 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] HELP! I'm trying to create

[PHP-DB] date problem in MySQL DB

2004-01-13 Thread Angelo Zanetti
either: a. change the format of the date format or b. do i have to write a function that changes my format to the mySQL before changing the column type?? TIA Angelo Zanetti Disclaimer This e-mail transmission contains

RE: [PHP-DB] Windows 2003 Server

2004-01-19 Thread Angelo Zanetti
dove stai mandando questi email? FOrse certe mailing lists non cianno supporto per HTML e solo text normale. Win98 non lo so perche ti fa vedere il codice, penso che non capiscono il HTML e anche qualche impostazione deve essere cambiato per accetare HTML. spero che questo to aiutera

RE: [PHP-DB] how can I delete a record from txt file

2004-01-23 Thread Angelo Zanetti
well you gotta make sure that the record that you are deleting is not being used by another program, you will have to look at the other program and determine when they run, it will be difficult to automate that. to physically delete a record you have to find the id of the record ( i presume that

RE: [PHP-DB] sql, problem with join and presentation

2004-02-17 Thread Angelo Zanetti
i think the newer versions of MYSQL allow for subselects and I think that is what you want. see www.mysql.net -Original Message- From: mayo [mailto:[EMAIL PROTECTED] Sent: Sunday, February 15, 2004 11:56 PM To: php-db Subject: [PHP-DB] sql, problem with join and presentation Currently

[PHP-DB] resultset problem

2004-02-17 Thread Angelo Zanetti
HI all, I am querying a db and getting the resultset, then to get out each individual field of the resultset (which is a single unique line all the time) as mysql_result($result2, 0, p_company). the problem is that if the actual field has a space in it say Sun microsystems, I only get sun and it

[PHP-DB] FW: sql bind parameter problem

2004-02-23 Thread Angelo Zanetti
HI, I have this error after my database crashed (power failure) but have already repaired the database. sql bind parameter not used for all parameters. not sure what the error is. cant find much on the net about this error. if anyone can give me some info or links, ill appreciate it. ps:

RE: [PHP-DB] Version Upgrade

2004-05-21 Thread Angelo Zanetti
I upgraded from mysql version 3.23.54 to version 4.1.1a-alpha and there have been no problems whatsoever, I suggest go to mysql.com for readup, I might not be using all the features and perhaps some of these features might be affected. hope this helps angelo -Original Message- From: