products table

4 posts Page 1 of 1
Contributors
User avatar
seeker
New Member
New Member
Posts: 11
Joined: Fri Sep 09, 2011 6:26 pm

products table
seeker
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
User avatar
mandai
Coding God
Coding God
Posts: 2585
Joined: Mon Apr 26, 2010 6:51 pm

Re: products table
mandai
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;
User avatar
seeker
New Member
New Member
Posts: 11
Joined: Fri Sep 09, 2011 6:26 pm

Re: products table
seeker
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
User avatar
mandai
Coding God
Coding God
Posts: 2585
Joined: Mon Apr 26, 2010 6:51 pm

Re: products table
mandai
That code would work if you were connected to the database with a command line client.

PHP has its own MySQL functions for sending queries. See: http://php.net/manual/en/book.mysql.php
4 posts Page 1 of 1
Return to “Help & Support”