AltME: Databases

Messages

afsanehsamim
and what extension should i use ? .r ???/
Arnold
learning comes with a lot of try and err even for a 'simple' language as REBOL
Probably yes and have your apache server set up right for .r files
afsanehsamim
you're right,i configured  my apache server  for  cgi ... i think i should configure again
TomBon
just rename it to .cgi
you have the correct shebang at the top. apache should recognize it automatically.
don't forget to chmod your cgi to grant execution permission.
afsanehsamim
but my OS is windows 7
i am not using linux
BrianH
Then you don't have to chmod, you just have to put it in the right directory.
TomBon
correct

afsanehsamim
thank you Arnold.... i van fetch data from database :) ...i am working on compare two values (value that is entered by user and value that is correct )...
do you know for comparing which aommand should i use?
command for comparing values in mysql database ????
afsanehsamim
hey guys... do you know how  we can check values of two tables in mysql?????!!!!
Arnold
select * from table where answer = useranswer
select * form table1, table2 where table1.field = table2.field
Do you have google? Any MySQL tutorial out there holds the answer to your question.
Or want to compare from wihin your REBOL script? It is either [ left = right][do-something][do-else-thing].
afsanehsamim
i exactly meant that how we can use Mysql queries(checking two values in two different table) in Rebol script !!!!!
Arnold
so you have put the users answer also in a mySQL table?
read both tablerows from the tables into different variables and compare the subfields of the returned rows result1/fielda result2/fielda

afsanehsamim
if  user wants insert values to table and it should save in database ,what is the command for that ???
this command is correct ???  :  insert db ["insert into data1 values (?)" myfields name]
afsanehsamim
guys ,i want insert data into database ,i wrote the following codes but no value save !!...  :(
#! "C:/wamp/bin/apache/Apache2.2.11/cgi-bin/rebol-core-278-3-1.exe" -cs
REBOL [Title: "Table"]
do %mysql-protocol.r
db: open mysql://root@localhost/test
insert db { DROP TABLE IF EXISTS data1;
create table data1 (
    oneone        varchar(1),
    onetwo        varchar(1),  
    onethree      varchar(1),      
    twoone        varchar(1),
    twothree      varchar(1),
    threeone      varchar(1),
    threetwo      varchar(1),
    threethree    varchar(1)
  )}
print "content-type: text/html^/"
print [<HTML><BODY>]
print [<form><input type="submit" value=" submit !" />]
print [<TABLE  bgcolor="black" border="1">]
print {<tr bgcolor="white">
<td style="width:30px; height:30px;"><input name="oneone" type="text" size="1">}
insert db ["insert into data1 (oneone) values (?)" ]
results: copy db
print {</td>}
i do not know what  i should write for values(?)... plz help
Pekr

Last message posted 115 weeks ago.