sql database quiery
Posted: Sat Apr 23, 2011 6:07 pm
hello guys.
was wondering if someone could help me out at all please?
this is my problem:
in my form where the client has to choose which games he/she has i have the following code:
now for the information to be stored in my sql database i have this code:
the part that says:
do i have this part correct?
also for the client to select which country they are from i have this code:
and again for the information to be collected in my sql database i have this code:
do i have that right at all?
thanks in advance
dang it, i just realised i have posted this in the wrong part of the forum when it should be posted in the msql section.
sorry about that, please move to the correct section if this is the wrong place please.
[...Moved to Databases forum by moderator...]
again sorry about that
was wondering if someone could help me out at all please?
this is my problem:
in my form where the client has to choose which games he/she has i have the following code:
Code: Select all
<tr><td align='right' valign='top'> <b>Select Games You Own:</b></td>
<td align='left'>
<input type='checkbox' name='games[]' value='CODUO'> Call Of Duty United Offensive<br>
<input type='checkbox' name='games[]' value='COD2'> Call Of Duty 2<br>
<input type='checkbox' name='games[]' value='COD4MW'> Call Of Duty 4 Modern Warfare<br>
<input type='checkbox' name='games[]' value='CODWAW'> Call Of Duty 5 World At War<br>
<input type='checkbox' name='games[]' value='CODMW2'> Call Of Duty 6 Modern Warfare 2<br>
<input type='checkbox' name='games[]' value='CODBO'> Call Of Duty 7 Black Ops<br>
</td></tr>Code: Select all
$db->sql_query("CREATE TABLE ".$prefix."_joinus_apps (
aid INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
realname VARCHAR( 25 ) NOT NULL ,
gamename VARCHAR( 25 ) NOT NULL ,
email VARCHAR( 50 ) NOT NULL ,
gender INT( 1 ) NOT NULL ,
day VARCHAR( 2 ) NOT NULL ,
month VARCHAR( 2 ) NOT NULL ,
year VARCHAR( 4 ) NOT NULL ,
country INT( 1 ) NOT NULL ,
xfire VARCHAR (25) NOT NULL ,
games INT( 1 ) NOT NULL ,
microphone INT( 1 ) NOT NULL ,
teamspeak2 INT( 1 ) NOT NULL ,
date VARCHAR( 10 ) NOT NULL)");Code: Select all
games INT( 1 ) NOT NULL ,also for the client to select which country they are from i have this code:
Code: Select all
<tr><td align='right'><b>Country:</b><br></td>
<td align='left'><select name ='country' value='$country'>
<option value=''></option>
<option value='Albania'>Albania</option>
<option value='Andorra'>Andorra </option>
<option value='Argentina'>Argentina </option>
<option value='Australia'>Australia </option>
<option value='Austria'>Austria </option>
<option value='Belarus'>Belarus </option>
<option value='Belgium'>Belgium </option>
<option value='Brazil'>Brazil </option>
<option value='Bolivia'>Bolivia </option>
<option value='Bosnia'>Bosnia </option>
<option value='Bulgaria'>Bulgaria </option>
<option value='Canada'>Canada </option>
<option value='Chile'>Chile </option>
<option value='China'>China </option>
<option value='Colombia'>Colombia </option>
<option value='Croatia'>Croatia </option>
<option value='Cyprus'>Cyprus </option>
<option value='CzechRep'>CzechRep </option>
<option value='Denmark'>Denmark </option>
<option value='England'>England </option>
<option value='Estonia'>Estonia </option>
<option value='Finland'>Finland </option>
<option value='France'>France </option>
<option value='Germany'>Germany </option>
<option value='Greece'>Greece </option>
<option value='Hungary'>Hungary </option>
<option value='Iceland'>Iceland </option>
<option value='India'>India </option>
<option value='Iraq'>Iraq </option>
<option value='Ireland'>Ireland </option>
<option value='Israel'>Israel </option>
<option value='Italy'>Italy </option>
<option value='Jamaica'>Jamaica </option>
<option value='Japan'>Japan </option>
<option value='Korea'>Korea </option>
<option value='Latvia'>Latvia </option>
<option value='Liechtenstein'>Liechtenstein </option>
<option value='Lithuania'>Lithuania </option>
<option value='Luxembourg'>Luxembourg </option>
<option value='Macedonia'>Macedonia </option>
<option value='Malta'>Malta </option>
<option value='Mexico'>Mexico </option>
<option value='Moldova'>Moldova </option>
<option value='Monaco'>Monaco </option>
<option value='Morocco'>Morocco </option>
<option value='Netherlands'>Netherlands </option>
<option value='New Zealand'>New Zealand </option>
<option value='Nigeria'>Nigeria </option>
<option value='Norway'>Norway </option>
<option value='Paraguay'>Paraguay </option>
<option value='Poland'>Poland </option>
<option value='Portugal'>Portugal </option>
<option value='Romania'>Romania </option>
<option value='Russia'>Russia </option>
<option value='San Marino'>San Marino </option>
<option value='Scotland'>Scotland </option>
<option value='Singapore'>Singapore </option>
<option value='Slovakia'>Slovakia </option>
<option value='Slovenia'>Slovenia </option>
<option value='South Africa'>South Africa </option>
<option value='Spain'>Spain</option>
<option value='Sweden'>Sweden</option>
<option value='Switzerland'>Switzerland</option>
<option value='Tunisia'>Tunisia</option>
<option value='Turkey'>Turkey</option>
<option value='Ukraine'>Ukraine</option>
<option value='United States'>United States </option>
<option value='Uraguay'>Uraguay</option>
<option value='Venezuela'>Venezuela</option>
<option value='Wales'>Wales</option>
<option value='Yugoslavia'>Yugoslavia</option>
</select><br></td></tr> Code: Select all
country INT( 1 ) NOT NULL ,thanks in advance
dang it, i just realised i have posted this in the wrong part of the forum when it should be posted in the msql section.
sorry about that, please move to the correct section if this is the wrong place please.
[...Moved to Databases forum by moderator...]
again sorry about that

