hai friends,
i am going to provide a query service.
for that i am using a Mysql database server for
mainting the databse.i will provide my user with a
query form that contains several fields.the user is
free at his selection of the fields of course atleast
one.in case if he selects
one.in case if he selects multiple fields, how could i
provide my user with all set of records which contains
what all data he placed in query form.
I think you want to study a bit more on MySQL and PHP. If you take the time
to go to sites like www.devshed.com you might get an idea of how
hi,
i'm writing a book (wrox publishers) which uses mysql for the sample
database.
i seem to have encountered a problem with an SQL query.
its a simple voting application, with a candidate table, and a vote table:
create table candidate (
candidatenumber integer not null auto_increment,
PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: SQL query problem with mysql.
hi,
i'm writing a book (wrox publishers) which uses mysql for the sample
database.
i seem to have encountered a problem with an SQL query.
its a simple voting application, with a candidate table, and a vote table
Cc: [EMAIL PROTECTED]
Sent: Monday, March 05, 2001 3:54 AM
Subject: SQL query problem with mysql.
hi,
i'm writing a book (wrox publishers) which uses mysql for the sample
database.
i seem to have encountered a problem with an SQL query.
its a simple voting application, with a candidate table,
hi,
i'm writing a book (wrox publishers) which uses mysql for the sample
database.
i seem to have encountered a problem with an SQL query.
its a simple voting application, with a candidate table, and a vote table:
create table candidate (
candidatenumber integer not null auto_increment,
I have a problem in 3.23.32,
The query
select * from table
repalce table values('','nextval+1)
returns me always nextval=1.
table has 1 row and the query runs fine in mysql 3.22.x
Any idea?
Thanks.
On 24-Jan-01 Jesús Gómez Pastor wrote:
I have a problem in 3.23.32,
The query
select * from table
repalce table values('','nextval+1)
^^ ^
these might be a problem, in addition to your select/replace/(update)
confusion.
returns me always nextval=1.
no, it