how to add my own table in database?

[developer_x]

hi all,

 

i want to add a new table to the mysql database. i will be retrieving data from one of its fields to display them as a drop down menu box. this drop down menu box will be in the search info box.

i also need to know how can we make available a certain table's fields and data to a certain php page?

[Jack_mcs]

Open one of the contributions that creates a table and see by example. Here's a small example

CREATE TABLE some_table (
 date datetime NOT NULL default '0000-00-00 00:00:00',
 some_name varchar(100) default NULL
);

Any page in your shop has access to the database (provising it has the proper includes). Just do a query on the table to get the data.

 

Jack

[developer_x]

i know how to make a table. i just want to know how can i include a certain table to a certain page.

[Jack_mcs]

OK, your title asked how to add it to the db - thus my answer. As far as inclucding a certain table on a certain page, it may again be a lack of understanding as far as what you mean, but I've answered the question already. When you open whatever file you want the table data on, just query the db. Are asking how to quey the db?

 

Jack

[developer_x]

OK, your title asked how to add it to the db - thus my answer. 

yes u seem 2 be rite. apologies :)

 

As far as inclucding a certain table on a certain page, it may again be a lack of understanding as far as what you mean, but I've answered the question already. When you open whatever file you want the table data on, just query the db. 

 

oh dats gr8. i though there might be some restrictions on some tables. like....the pages of customers wont be able to use the table used for storing administrator's info. anyways it isn't a serious issue.

thanx for response.

[developer_x]

yes u seem 2 be rite. apologies :)

oh dats gr8. i though there might be some restrictions on some tables. like....the pages of customers wont be able to use the table used for storing administrator's info. anyways it isn't a serious issue.

thanx for response.

<{POST_SNAPBACK}>

 

 

dat was easy. i am done away with it.