{ Learn Code. Share Code. Teach Code. Love Code. }

  • products table

 #53150  by seeker
 Mon Sep 12, 2011 3:38 pm
i want to add some categories in mysql. such as casual dresses, party wear dress, bridal dresses. how to create table in mysql. and also tell me that for dresses of images there must be save path of images in mysql?? i dont know how to add it?? plz reply me
 #53162  by mandai
 Mon Sep 12, 2011 7:31 pm
This MySQL command can be used to create a table with the dress code as a text column:
Code: Select all
CREATE TABLE `database1`.`table1` (`index` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, `dressCode` VARCHAR(45) NOT NULL, PRIMARY KEY (`index`) ) ENGINE = InnoDB;
 #53349  by seeker
 Thu Sep 15, 2011 6:42 pm
i have made main page in which there are categories(casual, partywear,bridal dresses)
i have give link on these catogories to open in seprate pages.


secondly where to write code of sql connection n query for reteriving data??

for example for casual dresses where to write code that images appaear in casaul.php