php - MYSQL - First Database Structure help Please -



php - MYSQL - First Database Structure help Please -

thanks taking time read , attempting help me, appreciate information!

this first time making own mysql database, , hoping pointers. i've looked through previous questions , found possible search multiple tables @ once... expanded posibilities.

what trying do, have searchable / filterable listing of snowmobile clubs on php page.

these clubs should listable state, county or searchable name / other contained info.

i'd them alphabetized in results, despite order of entry.

currently mind in place of , have table ny, pa etc

with columns county(varchar), clubname(varchar), street address (long text) , phone (varchar) email (varchar) website address (varchar)

should making multiple tables each county, such ny.albany , ny.madison

are field formats have chosen sensible ones?

should address broken subcomponents... such street1, street2, city, state, zip

thank much input can provide

eventually, think i'd column "trailsopen" yes or no, , alter tr background greenish or reddish based on input.

hope makes sense... - john

here how setup db:

state id (tinyint) //primary key auto incremented unsigned short (varchar(2)) // stores ny, pa long (varchar(20)) // stores new york, pennsylvania county id (int) //primary key auto incremented unsigned state_id (tinyint) //points state.id name (varchar(50)) club_county id (int) //primary key auto incremented unsigned county_id (int) //points county.id club_id (int) //points club.id club id (int) //primary key auto incremented unsigned name (varchar(100)) address (varchar(100) city (varchar(25)) zip (int) etc...

php mysql table

Comments

Post a Comment

Popular posts from this blog

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer -

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer - when trying request rest service @ time of response getting exception.. feb 21, 2013 2:34:49 pm com.sun.jersey.spi.container.containerresponse mapmappablecontainerexception severe: exception contained within mappablecontainerexception not mapped response, re-throwing http container java.lang.noclassdeffounderror: not initialize class net.sf.cglib.proxy.enhancer @ org.hibernate.proxy.pojo.cglib.cgliblazyinitializer.getproxyfactory(cgliblazyinitializer.java:117) @ org.hibernate.proxy.pojo.cglib.cglibproxyfactory.postinstantiate(cglibproxyfactory.java:43) @ org.hibernate.tuple.entity.pojoentitytuplizer.buildproxyfactory(pojoentitytuplizer.java:162) @ org.hibernate.tuple.entity.abstractentitytuplizer.<init>(abstractentitytuplizer.java:135) @ org.hibernate.tuple.entity.pojoentitytuplizer.<init>(pojoentitytuplizer.java:55) @ org.hibernate.tuple.e...
Read more

Accessing MATLAB's unicode strings from C -

Accessing MATLAB's unicode strings from C - how can access underlying unicode info of matlab strings through matlab engine or mex c interfaces? here's example. let's set unicode characters in utf-8 encoded file test.txt, read as fid=fopen('test.txt','r','l','utf-8'); s=fscanf(fid, '%s') in matlab. now if first feature('defaultcharacterset', 'utf-8') , c engevalstring(ep, "s") , output text file utf-8. proves matlab stores unicode internally. if mxarraytostring(enggetvariable(ep, "s")) , unicode2native(s, 'latin-1') give me in matlab: non-latin-1 characters replaced character code 26. need getting access underlying unicode info c string in unicode format (utf-8, utf-16, etc.), , preserving non-latin-1 characters. is possible? my platform os x, matlab r2012b. addendum: documentation explicitly states "[mxarraytostring()] supports multibyte encoded characters...
Read more

javascript - mongodb won't find my schema method in nested container -

javascript - mongodb won't find my schema method in nested container - i trying access method of schema stored within mixed container. here situation : have cases model can many different things, have schema each of these things stored in "casecontent" mixed property. var caseschema = mongoose.schema({ casecontent : {}, object : {type:string, default : "null"}, collision : {type : boolean, default : false} }); the casecontent property filled model of 1 of schemas, 1 exemple : var treeschema = new mongoose.schema({ applecount : {type : number, default : 3} }); treeschema.methods.dostuff = function (data) { console.log('hey, listen'); homecoming true; }; then, want utilize method of schema original container : caseschema.methods.dostuff = function (data) { if (this.casecontent.dostuff !== undefined) { this.casecontent.dostuff(); console.log('it worked'); } else { ...
Read more