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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by fredericvandenplas
-
insert row into existing table
I agree with imstillatwork that the table(s) or are wrongly linked or the tables are wrongly designed- fredericvandenplas
- Post #9
- Forum: MySQL
-
sql problem
Well i managed it on my own ( only today i succeeded) with this sql. I even had to add some more joins thank you for the reply SELECT main.Idnumber, `Referentie`, `Omschrijving1`As Omschrijving, `Prijs`, `Pk`, `Type`, `Bouwjaar`, `Uren`, `Banden_voor`, `Banden_achter`, ja_neen1.ja_neen1 As...- fredericvandenplas
- Post #3
- Forum: MySQL
-
insert row into existing table
if you take care of your ID's yourself, you just could move the the Id's up by adding the number of rows that you want to insert to the Id: UPDATE set newId=ID+NumberOfrowsToInsert Of course if it is a linked table it would give you problems as you would have to update it also to the sub-tables...- fredericvandenplas
- Post #7
- Forum: MySQL
-
sql problem
Hello there. I have a form with 5 yes/no dropdown fields. I want to display col1 (yes/no in dutch) or col2(yes/no in french) col3(yes/no in english) my main table has as fields Airco, hydraulics etc... The yes_no has to come from a table as depending on the language choosen i gets col1,col2 or...- fredericvandenplas
- Thread
- Replies: 2
- Forum: MySQL
