UKuser wrote:
Hi Guys,
Does anybody know where I can get a very basic view/add/edit script for
a single table? I need to view all the rows at the same time and be
able to edit from that point.
I have 4 fields called id, lowerval, upperval, result. Table is called
fig_lookup. I am very new indeed to mysql, so if you know of any basic
code which would suffice, or could post some that would be brill.
Do you mean sql queries? The term script confuses me as you didn't
mention any programming language for the script. So here are the plain
sql queries. I hope you know how to use them in your script:
insert into fig_lookup(id,loweval,upperval,result) values('1','1','1','1');
insert into fig_lookup(id,loweval,upperval,result) values('2','2','2','2');
update fig_lookup set lowerval='10',upperval='20' where id='2';
select * from fig_lookup;