Search found 10 matches

by Jacques
Fri Dec 20, 2002 3:45 pm
Forum: mySQL & php coding
Topic: Update multiple rows from html form to mysql table
Replies: 2
Views: 2041

Turning in circle with simple insert!!!

Hello everyone, I am attempting to insert into table2 2 values drawn from same drop down box. The values are taken from table1 I can do it with one value. The other one is driving in circle. Can anyone help me please Thanks $sql = mysql_query("select category from catlisting") or d...
by Jacques
Thu Nov 21, 2002 12:59 pm
Forum: PHP coding => General
Topic: I really need help with this code... Ready to shoot myself!
Replies: 1
Views: 994

Never mind. I found a solution.
by Jacques
Thu Nov 21, 2002 11:32 am
Forum: PHP coding => General
Topic: I really need help with this code... Ready to shoot myself!
Replies: 1
Views: 994

I really need help with this code... Ready to shoot myself!

I am trying to do a multiple insert. $sdcount=10; for ($i=0;$i<$stdcount;$i++){ $query = "Insert into $mysql_cat (id, user, category) values ('', '$user','$category[$i]')"; $result = mysql_query($query) or die("ERROR: cannot INSERT data into database"); } // for ($i = 0; $i < $stdcount; $i ++) ?> <f...
by Jacques
Thu Nov 21, 2002 9:59 am
Forum: PHP General
Topic: Can someone please help with this code
Replies: 1
Views: 1466

Can someone please help with this code

I am trying to do a multiple insert. $sdcount=10; for ($i=0;$i<$stdcount;$i++){ $query = "Insert into $mysql_cat (id, user, category) values ('', '$user','$category[$i]')"; $result = mysql_query($query) or die("ERROR: cannot INSERT data into database"); } // for ($i = 0; $i < $stdcount; $i ++) ?> <f...
by Jacques
Wed Nov 20, 2002 12:50 pm
Forum: PHP coding => General
Topic: Uploading multiple files @ once..?
Replies: 25
Views: 10310

Hello Pejone

I have a question re your code. Instead of uploading multiple files, what if I wanted to upload multiple values into the same table. ie: red, (next record:) blue, (next record:) green Is there something to replace copy ($HTTP_POST_FILES[$filename]['tmp_name'], $i); by an insert? I have been struggli...
by Jacques
Tue Nov 19, 2002 12:12 pm
Forum: PHP coding => General
Topic: Insert multiple rows into one table
Replies: 1
Views: 992

Insert multiple rows into one table

I have searched for this one for ages before resorting to ask for help! I have two tables Members and Categories I want members to insert their data into table.members and up to 4 categories into table.categories I have no problem with the first insert. The second insert though always show the last ...
by Jacques
Tue Oct 22, 2002 8:32 am
Forum: PHP coding => General
Topic: Multiple table update
Replies: 1
Views: 1007

Multiple table update

I am playing with a membership database. I have 2 tables freemembers: id,user,pass,address approvedmembers: if,user,pass,interest Once a member has been approved I would like him/her to be able to update his/her info held on both tables using one form. I can do one table at the time. I understand my...
by Jacques
Mon Oct 21, 2002 6:40 am
Forum: PHP coding => General
Topic: A question about layout
Replies: 6
Views: 1962

So much to learn

Thank you guys. There is so much to learn. I am doing it from books and looking at freecodes that I collect throughout the websites. Not always easy at the early stage to know when a code is well written or not. Guess this will come with experience. I am having a great time though. I hope you won't ...
by Jacques
Fri Oct 18, 2002 11:14 am
Forum: PHP coding => General
Topic: A question about layout
Replies: 6
Views: 1962

Layout

Thank you Jay. Your help has improved the layout. I have one more question This line print "<td class=sidemenu onMouseOver='mOvr(this,sideover);' onMouseOut='mOut(this,sideover);' bgcolor=#777777 width=28 align=center><b>$i</b></td>\n"; uses a style defined for all the pages. Is php able to read it?...
by Jacques
Fri Oct 18, 2002 8:12 am
Forum: PHP coding => General
Topic: A question about layout
Replies: 6
Views: 1962

A question about layout

Hello, The following is the code I am working on. It works fine but puts Prev, the number of pages and next in one single cel. I am trying to put them in separate cell. ie one cell for Prev, one for page1, one for page2 etc... Any idea how I can achieve this? Thanks a million. Jacques <? } // while ...