Jump to content

MicroShaft

Members
  • Posts

    4
  • Joined

  • Last visited

    Never

Contact Methods

  • Website URL
    http://

Profile Information

  • Gender
    Not Telling
  • Location
    Stoke on Trent (I know but someone has to live there)

MicroShaft's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Ive been reading up on full text search and gone throught the tutorial on this site. Read in many places the FTS is better and faster than a LIKE when dealing with a lot of records. Im tryin to create a search which show all rows which has the word smith in when they search for smith for example smith coppersmith blacksmith smithson currently the full text search works for smith fine when only searching for smith. The only way i could make it show all the other words is by tagging OR fieldname LIKE '%smith%' on the end Am i doing this right or is there another way of doing this. ive also realised if i want to do a full text search on two tables (one field from each) on a inner join its faster using the boolean. can someone confirm this Thanks
  2. Okay, i just done some investigation. The raw data was originally posted via text area to the db. the data was pasted into a text area. for some reason even though a 1000 rows were pasted into the text area only 855 got inserted into the db which is a memo field. so the multiple insert was right. Now any ideas why the text area only inserted 855 rows into the memo field
  3. Im trying to insert 1080 records into mysql. I extract the raw data from a table. place into a array. which is then split into an array (each element containing a record) I run a FOR loop to insert into the db. The problem: Only 855 records seem to get inserted : with no errors $thedata_rawL1=explode("\n",$thedata_raw); foreach ($thedata_rawL1 as $v) { $sql_insertloop="INSERT INTO ori_data (LOAD_ID,THEDATA) Values('$new_LOAD_ID','$v')"; $change_rs = mysql_db_query("originsuk",$sql_insertloop,$connect); } Can any one shed some light why i can only enter 855 when i have over 1000. I dont get no error messages. im using mysql 4 with php 4
  4. can some one advise on this. i have been given a mysql db. i have found a field which contains text which start with a hyphen such as -Tuesday im trying make a select box option selected if the values from the db field match the values in the select box(also contain hypens) using Jscript . if i remove the hyphen in the DB it works fine can someone tell me why? cheers
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.