3 messages in com.mysql.lists.win32Re: Columns will not populate?| From | Sent On | Attachments |
|---|---|---|
| Chris Chadwick | 16 Nov 1999 15:34 | |
| Steve Ruby | 16 Nov 1999 15:42 | |
| Steve Ruby | 16 Nov 1999 16:04 |
| Subject: | Re: Columns will not populate? |
|---|---|
| From: | Steve Ruby (ste...@seawingsub.com) |
| Date: | 11/16/1999 04:04:57 PM |
| List: | com.mysql.lists.win32 |
Chris Chadwick wrote:
OK the table is being populated by this script $sql = "INSERT INTO faq_main (entered_by,oem,keywords,page_title,faq_title,step_1,pic_1,step_2,pic_2,step _3,pic_3,step_4,pic_4,step_5,pic_5,step_6,pic_6,step_7,pic_7,step_8,pic_8,st ep_9,pic_9,step_10,pic_10,step_11,pic_11,step_12,pic_12,step_13,pic_13,step_ 14,pic_14,step_15,pic_15,step_16,pic_16,step_17,pic_17,step_18,pic_18,step_1 9,pic_19,step_20,pic_20) VALUES ('$entered_by','$oem','$keywords','$page_title','$faq_title','$step_1','$pic _1','$step_2','$pic_2','$step_3','$pic_3','$step_4','$pic_4','$step_5','$pic _5','$step_6','$pic_6','$step_7','$pic_7','$step_8','$pic_8','$step_9','$pic _9','$step_10','$pic_10','$step_11','$pic_11','$step_12','$pic_12','$step_13 ','$pic_13','$step_14','$pic_14','$step_15','$pic_15','$step_16','$pic_16',' $step_17','$pic_17','$step_18','$pic_18','$step_19','$pic_19','$step_20','$p ic_20')";
the fields that are not populating are step_4 and step_18 or pic_18 I cant tell. How would I capture the describe table info so I can show you?
run the mysql client program (mysql.exe usualy in c:\mysql\bin) and type at the prompt mysql> use dbname mysql> describe faq_main;
then you can copy and paste the output into an email.
or you can from the command line
c:\mysql\bin> mysql -te "describe faq_main" dbname
and copy the output of that.
You would probably find your database easier to work with if you "normalized" your data better. For example you might want to move your step and pic columns to another table and reference them back with a faq_id or something unique to this table.
Is it possible that any of the variables have ' in their values?
Can you post result of:
describe tablename;
and the exact query you user using to populate them?
and any error that you are getting upon execution of your query.
thanks
Chris Chadwick wrote:
I have created a table with 47 columns in it I have populated it with data and column 4 and 18 do not take the data both are varchar(255), I have altered the columns to test and back to varchar but they still will not populate. any suggestions are appreciated.