Maybe it works like this:
SELECT pages.user_id, pages.name
FROM pages
where
user_id not in ( select user_id from pageread )
and user_id not in (select user_id from pagewrite)
Have tried that in an ACCESS-Database for four users and it
is working. Maybe the syntax for MYSQL is slightly...
Thanks a lot.
Yes I want dynamically name the input fields and
dynamically fill the values for the input field.
<name=\"$fld\"> is quiet clear now to me, thanks. But what to fill into the value field? I have something like a
query: "Select * from table_name where ..." and have to post the...
Thanks for your answer. Seems I haven't explained properly.
I'll display a list of records via a SQL query. The user hits the edit link and the record should be displayed in a HTML form for editing. I fetched the "describe" query to get the columns name and build a string like
<input...
I want to display a Mysql Querie in a form.
Like this:
First show a list of all records. Then, pressing the
edit link, a single record is displayed in a form.
I tried this way
- "Describe my_table" to get the column names
- build a form and echo the values.
I should work for different tables...
Well,
I tried to build a sql string with PHP.
When echoed it looks like that:
Insert into personal ( f_name, s_name, genus, kita_function, kita_group, start_date) values( '$f_name', '$s_name', '$genus', '$kita_function', '$kita_group', '$start_date')
In the fields like $f_name values are...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.