[PHP-DB] MySQL editor
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
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
[PHP-DB] MySQL full text search
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 columns to inputted data ( in a Select statement):
$result = mysql_query(SELECT * FROM Biblio WHERE MATCH (title) AGAINST
('$searchString'));
It gives me this error: Can't find FULLTEXT index matching the column list. It appears
that i cant just compare a single fulltext indexed column if there are other fulltext
indexed columns. When I try it with both columns then it works but I just want to
compare 1 column. eg:
$result = mysql_query(SELECT * FROM Biblio WHERE MATCH (title, abstract) AGAINST
('$searchString'));
So is there anyway that I can just compare 1 column with text entered? Do I have t
make some sort of temporary table to do this? All the examples I have found show the
select statement with 2 columns or if they use 1 coumn its because there is only 1
column in their table.
Any help would be appreciated!
TIA
Angelo
Re: [PHP-DB] [SPAM?] [PHP-DB] Appeal For Assitance
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 attached along with this report, so you can recognize or block similar unwanted mail in future. See http://spamassassin.org/tag/ for more details. Content preview: Dear Sir, Appeal For Assitance I wish to write you pleading with you to be my Investor trustee over $12.5million. My late Husband was a rich oil Contractor in South Africa, But before his death in July 29th 1999. He deposited the sum of ($12,500,000.00) USD in a safe keeping company in Europe through Debt Reconciliation Committee (DRC). [...] Content analysis details: (6.60 points, 5 required) RATWARE_OE_MALFORMED (2.9 points) X-Mailer contains malformed Outlook Express version DEAR_SOMETHING (2.6 points) BODY: Contains 'Dear (something)' US_DOLLARS_3 (0.9 points) BODY: Nigerian scam key phrase ($NN,NNN,NNN.NN) MIME_LONG_LINE_QP (0.2 points) RAW: Quoted-printable line longer than 76 characters -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] transaction locking
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 about the values that you already have in your field. I assume that they are all unique and that you want to start the increment from the last value +1. anyway hope this helps. Angelo Disclaimer This e-mail transmission contains confidential information, which is the property of the sender. The information in this e-mail or attachments thereto is intended for the attention and use only of the addressee. Should you have received this e-mail in error, please delete and destroy it and any attachments thereto immediately. Under no circumstances will the Cape Technikon or the sender of this e-mail be liable to any party for any direct, indirect, special or other consequential damages for any use of this e-mail. For the detailed e-mail disclaimer please refer to http://www.ctech.ac.za/polic or call +27 (0)21 460 3911 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] HELP!
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 a guestbook and... I'm having trouble getting a certain amount of entries per page. Please help, a snippet of a code would be nice. Thanks! -Akmal- --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Disclaimer This e-mail transmission contains confidential information, which is the property of the sender. The information in this e-mail or attachments thereto is intended for the attention and use only of the addressee. Should you have received this e-mail in error, please delete and destroy it and any attachments thereto immediately. Under no circumstances will the Cape Technikon or the sender of this e-mail be liable to any party for any direct, indirect, special or other consequential damages for any use of this e-mail. For the detailed e-mail disclaimer please refer to http://www.ctech.ac.za/polic or call +27 (0)21 460 3911 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] date problem in MySQL DB
Hi guys This might be slightly off topic but hopefully someone can help. I have a field that is a varchar and I stored dates in it. But now I want to change the type of the column to date, but I have a problem that the formats differ: my format: mm/dd/ mySQL format: -mm-dd So can I 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 confidential information, which is the property of the sender. The information in this e-mail or attachments thereto is intended for the attention and use only of the addressee. Should you have received this e-mail in error, please delete and destroy it and any attachments thereto immediately. Under no circumstances will the Cape Technikon or the sender of this e-mail be liable to any party for any direct, indirect, special or other consequential damages for any use of this e-mail. For the detailed e-mail disclaimer please refer to http://www.ctech.ac.za/polic or call +27 (0)21 460 3911 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Windows 2003 Server
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
-Original Message-
From: Andrea Fenilxxx [mailto:[EMAIL PROTECTED]
Sent: Monday, January 19, 2004 1:09 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Windows 2003 Server
Sto realizzando una pagina di invio mail per una mailing list.
La mail parte regolarmente.
Sul mio pc (Win Xp si vede bene, così come su molti altri pc)
Qualcuno sa spiegarmi perchè, su alcuni windows ('98), invece dell'html mi
genera una mail NON html (quindi si vede solo il codice... una
schifezza!!!).
Forse sbaglio charset=iso-8859???
Sono stressato!
$messaggio è una concatenazioni di header.$corpo.footer
Il corpo è generato da una textarea
---
?php
$oggetto=Newsletter 4winds - OFFERTE di VIAGGIO;
$messaggio= '
html
head
titleTitolo/title
/head
body
Corpo header
/body
/html
'
.$corpo.
'
html
head
/head
body
Corpo footer
/body
/html
';
// l'intestazione Content-type per inviare email in formato HTML
$intestazioni = MIME-Version: 1.0\r\n;
$intestazioni .= Content-type: text/html; charset=iso-8859-1\r\n;
// intestazioni addizionali - From
$intestazioni .= gestore mailing list ;
//destinatari
$to = - destinatari - ;
mail($to, $oggetto, $messaggio, $intestazioni);
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Disclaimer
This e-mail transmission contains confidential information,
which is the property of the sender.
The information in this e-mail or attachments thereto is
intended for the attention and use only of the addressee.
Should you have received this e-mail in error, please delete
and destroy it and any attachments thereto immediately.
Under no circumstances will the Cape Technikon or the sender
of this e-mail be liable to any party for any direct, indirect,
special or other consequential damages for any use of this e-mail.
For the detailed e-mail disclaimer please refer to
http://www.ctech.ac.za/polic or call +27 (0)21 460 3911
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] how can I delete a record from txt file
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 each record is stored with a primary (unique) key, and secondly each record has its own row. to delete it you loop through the rows and every row check if the key to be deleted is the key of that row, if so then delete the row, you will need to use some string functions mid, left right, instr etc... see the documentation for that. I havent given you any code but thats how you would do it in theory just use the manual to develop what ive said into php code. good luck -Original Message- From: Gamze Basaran [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 10:46 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] how can I delete a record from txt file Hi; I take users from Active Directory with ldap functions and put them in a list menu. I have got two txt files. One of them hold the users which have got internet access and one of them holds the users which have got speedily internet access. Also may be a third file that hold the users which have got limited internet access. In my program I must write the selected users to these files. And may be sometimes I must delete some users from these files. How can delete a user from txt file. These files are also in use with some other programs. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Disclaimer This e-mail transmission contains confidential information, which is the property of the sender. The information in this e-mail or attachments thereto is intended for the attention and use only of the addressee. Should you have received this e-mail in error, please delete and destroy it and any attachments thereto immediately. Under no circumstances will the Cape Technikon or the sender of this e-mail be liable to any party for any direct, indirect, special or other consequential damages for any use of this e-mail. For the detailed e-mail disclaimer please refer to http://www.ctech.ac.za/polic or call +27 (0)21 460 3911 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] sql, problem with join and presentation
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 I display a list of classes. Simplified SQL and display below: SELECT * FROM classes WHERE classCategory='$Category' AND classDeleted=0 ORDER BY $order $reorder The presentation is: +--+--++ | CLASS TITLE | LOCATION | CLASS CODE | +--+--++ | CLASS DESCRIPTION br/br/ | | CLASS INSTRUCTOR br/br/ | | CLASS TIME | +--+ Now, things are getting a little more complicated. Each class is going to have sections. So the display will be: CLASS TITLE CLASS DESCRIPTION CLASS CODE : CLASS SECTION .. LOCATION .. CLASS TIME .. INSTRUCTOR example (simplified) +-+ | INTRO TO AAA| +-+ | This is a really interesting | | | +-+-+++ |HT-111:A | NYC | 12:00-4:00 | Albert Alkin | |HT-111:B | JC | 2:00-6:00 | Bob Bailey | |HT-111:C | BX | 4:00-8:00 | Chris Cawley | +-+-+++ I'm having a really hard time coming up with the sql for this. I want to (pseudo) select * from classes and classSections where classDeleted=0 and group by classCode tables below CLASSES classID classDescription classTexts classCost classDeleted CLASSCODES classCodeID classID classCodeSection classDate classTime classLocation classInstructor I'm going nuts trying to get this. I must be missing something simple. (using mysql) thx for any clues Gil -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Disclaimer This e-mail transmission contains confidential information, which is the property of the sender. The information in this e-mail or attachments thereto is intended for the attention and use only of the addressee. Should you have received this e-mail in error, please delete and destroy it and any attachments thereto immediately. Under no circumstances will the Cape Technikon or the sender of this e-mail be liable to any party for any direct, indirect, special or other consequential damages for any use of this e-mail. For the detailed e-mail disclaimer please refer to http://www.ctech.ac.za/polic or call +27 (0)21 460 3911 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] resultset problem
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 doesnt give me anything after the first space. I have looked at the manual but as far as im concerned its really vague in its description of alot of the mysql functions. any idea what could be causing this?? thanx Angelo Disclaimer This e-mail transmission contains confidential information, which is the property of the sender. The information in this e-mail or attachments thereto is intended for the attention and use only of the addressee. Should you have received this e-mail in error, please delete and destroy it and any attachments thereto immediately. Under no circumstances will the Cape Technikon or the sender of this e-mail be liable to any party for any direct, indirect, special or other consequential damages for any use of this e-mail. For the detailed e-mail disclaimer please refer to http://www.ctech.ac.za/polic or call +27 (0)21 460 3911 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] FW: sql bind parameter problem
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: sorry for the off topic post. Angelo Disclaimer This e-mail transmission contains confidential information, which is the property of the sender. The information in this e-mail or attachments thereto is intended for the attention and use only of the addressee. Should you have received this e-mail in error, please delete and destroy it and any attachments thereto immediately. Under no circumstances will the Cape Technikon or the sender of this e-mail be liable to any party for any direct, indirect, special or other consequential damages for any use of this e-mail. For the detailed e-mail disclaimer please refer to http://www.ctech.ac.za/polic or call +27 (0)21 460 3911 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Version Upgrade
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: Hutchins, Richard [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 2:06 PM To: DBList Subject: RE: [PHP-DB] Version Upgrade The folks at PHP.NET have an excellent resource to help answer questions like these. Check out this link: http://www.php.net/releases.php#4.3.0 You're going to have to read the material and compare it against what you're doing in your scripts to see if the 4.3.0 release is going to do anything to your code. Rich -Original Message- From: Ng Hwee Hwee [mailto:[EMAIL PROTECTED] Sent: Thursday, May 20, 2004 9:07 PM To: DBList Subject: Re: [PHP-DB] Version Upgrade hi all, Sorry, I meant to say PHP 4.3. Will it be very different from PHP4.2.2 that my programs may perform strangely if I upgrade to PHP4.3? many thanks, Hwee - Original Message - From: Gary Every [EMAIL PROTECTED] To: Ng Hwee Hwee [EMAIL PROTECTED] Sent: Thursday, May 20, 2004 9:23 PM Subject: RE: [PHP-DB] Version Upgrade MySQL 4.0.19 is the latest stable release, and PHP 4.2.3 will work well for you. MySQL 4.1 is still in beta. Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram Blvd, La Vergne, TN 37089 Pay It Forward! -Original Message- From: Ng Hwee Hwee [mailto:[EMAIL PROTECTED] Sent: Thursday, May 20, 2004 5:15 AM To: DBList Subject: [PHP-DB] Version Upgrade Hi all, I'm running on PHP 4.2.2 and MySQL 3.23.54 I would like to do an upgrade... What would be the highest version number that I can upgrade to without causing any possible conflict? I'm thinking of upgrading to PHP 4.2.3 and MySQL 4.0.4 because they have some features that I need. But I will like to be more adventurous so will PHP 4.2.3 and MySQL 4.1 be advisable? Many thanks, Hwee Hwee -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Disclaimer This e-mail transmission contains confidential information, which is the property of the sender. The information in this e-mail or attachments thereto is intended for the attention and use only of the addressee. Should you have received this e-mail in error, please delete and destroy it and any attachments thereto immediately. Under no circumstances will the Cape Technikon or the sender of this e-mail be liable to any party for any direct, indirect, special or other consequential damages for any use of this e-mail. For the detailed e-mail disclaimer please refer to http://www.ctech.ac.za/polic or call +27 (0)21 460 3911 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
