Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Displaying Mysql querie in a form
Thanks a lot. It is now working. Now I'm going back to fight for editing the recordset *LOL* Jokobe -
Selecting entries which are NOT in lookup
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... -
Displaying Mysql querie in a form
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... -
Displaying Mysql querie in a form
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... -
Displaying Mysql querie in a form
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... -
Building a SQL string with PHP
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...
