|
|
Posted by Ian Davies on 07/29/06 09:21
sorry
try
ianDOTdandavATvirginDOTnet
"PSI_Orion" <orion@psiss.com> wrote in message
news:Orxyg.59928$ST2.54210@newsfe5-win.ntli.net...
> Well, it would have been if the email addy was correct...
>
> "PSI_Orion" <orion@psiss.com> wrote in message
> news:mexyg.3457$v4.1602@newsfe3-win.ntli.net...
> > File sent.
> >
> > "Ian Davies" <iandan.dav@virgin.net> wrote in message
> > news:Q0oyg.57825$ST2.5343@newsfe5-win.ntli.net...
> >> Cheers.
> >> that would be great
> >> Ian
> >>
> >> "PSI_Orion" <orion@psiss.com> wrote in message
> >> news:vnbyg.47047$1g.3775@newsfe1-win.ntli.net...
> >>> OK. I think it's all done as your require. Let me know and then I'll
> >>> forward the code.
> >>>
> >>> http://www.psiss.com/dummy
> >>>
> >>> Chris
> >>>
> >>> "Ian Davies" <iandan.dav@virgin.net> wrote in message
> >>> news:357yg.26$WY2.16@newsfe3-gui.ntli.net...
> >>> > Yes thats exactly what I have so far. except I dont have an update
> >>> > check
> >>> > box, which I didnt include because I suspect some users would make
> >> changes
> >>> > to the comments and categories etc but would forget to tick the
update
> >>> > check
> >>> > box. My solution was to update ALL the displayed records. this
wouldnt
> >> be
> >>> > a
> >>> > problem as there would only be about between 5 and 100 so not a big
> >>> > deal
> >>> > if
> >>> > some are updated despite no changes being made. Also I dont have the
> >>> > ID
> >>> > displayed (its meaninless to the user), its in a hidden field which
I
> >>> > planned to use to reference the correct record from the database
table
> >>> >
> >>> > ian
> >>> >
> >>> > "PSI_Orion" <orion@psiss.com> wrote in message
> >>> > news:aE4yg.68433$sz1.47146@newsfe6-gui.ntli.net...
> >>> >> Take a look at http://www.psiss.com/dummy to see if I'm on the
right
> >>> > lines.
> >>> >> Obviously it's not nicely formatted and the "Update" checkboxes
would
> >> be
> >>> >> hidden and automatically set on an onchange event in the fields.
> >>> >> Also,
> >>> >> it
> >>> >> doesn't actually do any changes right now as I need to work on that
> >> more
> >>> > but
> >>> >> I wanted to make sure I'm on the right lines first. Just tick some
> >>> >> update
> >>> >> checkboxes, click submit and see if that's what you are after.
> >>> >>
> >>> >> Chris
> >>> >>
> >>> >> "Ian Davies" <iandan.dav@virgin.net> wrote in message
> >>> >> news:KL2yg.63521$Z61.2758@newsfe4-win.ntli.net...
> >>> >> > '....and a hidden field to contain...'
> >>> >> > SHOULD READ
> >>> >> > '....and I also have a hidden field that contains...'
> >>> >> >
> >>> >> >
> >>> >> > ian
> >>> >> >
> >>> >> >
> >>> >> > "Ian Davies" <iandan.dav@virgin.net> wrote in message
> >>> >> > news:EJ2yg.63520$Z61.54928@newsfe4-win.ntli.net...
> >>> >> >> Hello
> >>> >> >> That is correct. also comment is a textarea. and a hidden field
to
> >>> >> >> contain
> >>> >> >> the index of each row to use to update the correct record in the
> >>> >> > subsequent
> >>> >> >> sql statement.
> >>> >> >>
> >>> >> >> Is your solution somehow based on creating an array from each of
> >>> >> >> the
> >>> >> >> elements.
> >>> >> >> The solution i was trying to do was to get 4 arrays and somehow
> >>> >> >> use
> >>> > them
> >>> >> > in
> >>> >> >> a loop with an sql update. But Im lost as to how to create and
use
> >> the
> >>> >> >> arrays appropriately
> >>> >> >>
> >>> >> >> Cheers
> >>> >> >> Ian
> >>> >> >> also I greatly appreciate your assistance
> >>> >> >>
> >>> >> >>
> >>> >> >> "PSI_Orion" <orion@psiss.com> wrote in message
> >>> >> >> news:e71yg.46974$1g.21477@newsfe1-win.ntli.net...
> >>> >> >> > I'm presuming comment is the textbox (or do you use textarea),
> >>> > category
> >>> >> > is
> >>> >> >> > the dropdown and share is the checkbox?
> >>> >> >> >
> >>> >> >> > I'm working on a solution now so I'm hoping I have it right.
> >>> >> >> >
> >>> >> >> > PSI_Orion
> >>> >> >> >
> >>> >> >> > "Ian Davies" <iandan.dav@virgin.net> wrote in message
> >>> >> >> > news:Q9%xg.52408$IU2.3744@newsfe2-win.ntli.net...
> >>> >> >> > > Hi
> >>> >> >> > > I am trying to amend three fields all one text and two
integer
> >>> >> >> > > In my original code you will see what I mean
> >>> >> >> > > The values for the text field would come from a textarea in
> >>> >> >> > > one
> >>> >> >> > > column
> >>> >> >> of
> >>> >> >> > > the table and the values for the two integer fields would
come
> >>> >> >> > > from
> >>> > a
> >>> >> >> > > dropdown list and a tick box which are in the other columns.
> >>> >> >> > > Ian
> >>> >> >> > >
> >>> >> >> > >
> >>> >> >> > > "PSI_Orion" <orion@psiss.com> wrote in message
> >>> >> >> > > news:MQSxg.1434$v4.793@newsfe3-win.ntli.net...
> >>> >> >> > >> Yes, that explains it much better. Which field is it you
are
> >>> > trying
> >>> >> > to
> >>> >> >> > >> amend? Is it a simple yes/no type field? If so then you
> >>> >> >> > >> need
> >> to
> >>> >> >> adjust
> >>> >> >> > >> your query accordingly. I don't have time right now to
> >>> >> >> > >> explain
> >>> >> >> > >> fully
> >>> >> >> but
> >>> >> >> > > if
> >>> >> >> > >> you send me a personal email to orion at psiss dot com I
will
> >> try
> >>> >> >> > >> and
> >>> >> >> > >> explain how I would approach it.
> >>> >> >> > >>
> >>> >> >> > >> Regards
> >>> >> >> > >>
> >>> >> >> > >> PSI_Orion
> >>> >> >> > >>
> >>> >> >> > >> "Ian Davies" <iandan.dav@virgin.net> wrote in message
> >>> >> >> > >> news:BwPxg.46899$1g.19898@newsfe1-win.ntli.net...
> >>> >> >> > >> > Thanks for the reply
> >>> >> >> > >> > The problem Im having isnt creating a table with the
> >>> >> >> > >> > records
> >> in
> >>> >> >> > >> > it.
> >>> >> >> > >> > That
> >>> >> >> > >> > works fine. Im trying to find a way where the users can
> >> modify
> >>> > the
> >>> >> >> > > records
> >>> >> >> > >> > in a table and they are all updated in one go. I thought
> >> using
> >>> >> > arrays
> >>> >> >> > >> > would
> >>> >> >> > >> > be the answer, but Im not that familiar with them. At the
> >>> >> >> > >> > moment
> >>> >> > the
> >>> >> >> > > users
> >>> >> >> > >> > click a button at the begining of a row and that record
is
> >>> >> > displated
> >>> >> >> on
> >>> >> >> > > a
> >>> >> >> > >> > new page where it can be updated. But this requires the
> >>> >> >> > >> > user
> >> to
> >>> >> > click
> >>> >> >> > > and
> >>> >> >> > >> > update one record at a time. Whereas I wish them to make
> >>> >> >> > >> > all
> >>> >> >> > >> > the
> >>> >> >> > >> > changes
> >>> >> >> > >> > to
> >>> >> >> > >> > all the records they want in the table and then on
clicking
> >>> >> >> > >> > a
> >>> >> > button
> >>> >> >> > > some
> >>> >> >> > >> > script would take each row in turn and update that row in
> >>> >> >> > >> > te
> >>> >> >> database,
> >>> >> >> > > it
> >>> >> >> > >> > would then loop through all the rows in the table and
> >>> >> >> > >> > update
> >>> > each
> >>> >> >> > >> > accordingly
> >>> >> >> > >> >
> >>> >> >> > >> > Hope this explains it better
> >>> >> >> > >> >
> >>> >> >> > >> > Ian
> >>> >> >> > >> >
> >>> >> >> > >> > "PSI_Orion" <orion@psiss.com> wrote in message
> >>> >> >> > >> > news:uFIxg.62841$sz1.6724@newsfe6-gui.ntli.net...
> >>> >> >> > >> >> If I understand you correctly, the way I would do it is
> >>> >> >> > >> >> the
> >>> > same
> >>> >> > way
> >>> >> >> I
> >>> >> >> > >> > have
> >>> >> >> > >> >> my DVD database. This is rather than have the name of
the
> >>> >> > elements
> >>> >> >> as
> >>> >> >> > >> >> "commindex[]" etc, actually place the table creation
> >>> >> >> > >> >> inside
> >>> > your
> >>> >> >> while
> >>> >> >> > >> > loop
> >>> >> >> > >> >> and increment the naming field using the i variable you
> >>> >> >> > >> >> use,
> >>> > ie:
> >>> >> >> > >> >> "commindex[<?=$i?>]".
> >>> >> >> > >> >>
> >>> >> >> > >> >> As an example of what I mean, here is an excerpt of my
DVD
> >>> >> > database
> >>> >> >> > > code
> >>> >> >> > >> >> which you can view at "http:// mydvds . psiss . com"
> >>> >> >> > >> >>
> >>> >> >> > >> >> ------------------------------------------------------
> >>> >> >> > >> >> if($allRecords > 0)
> >>> >> >> > >> >> {
> >>> >> >> > >> >> $recordCount = 0;
> >>> >> >> > >> >> while($recordCount < $allRecords)
> >>> >> >> > >> >> {
> >>> >> >> > >> >> if(($recordCount / 2) % 2 == 1)
> >>> >> >> > >> >> {
> >>> >> >> > >> >> ?>
> >>> >> >> > >> >> <tr align="center" class="tr_even">
> >>> >> >> > >> >> <?
> >>> >> >> > >> >> }
> >>> >> >> > >> >> else
> >>> >> >> > >> >> {
> >>> >> >> > >> >> ?>
> >>> >> >> > >> >> <tr align="center" class="tr_odd">
> >>> >> >> > >> >> <?
> >>> >> >> > >> >> }
> >>> >> >> > >> >> for($colCount = 0; $colCount < 2 && $recordCount <
> >>> > $allRecords;
> >>> >> >> > >> >> $colCount++)
> >>> >> >> > >> >> {
> >>> >> >> > >> >> $dataArray = mysql_fetch_array($result);
> >>> >> >> > >> >> $dataArray['starring'] =
> >>> >> >> > >> > str_replace("\r","<BR>",$dataArray['starring']);
> >>> >> >> > >> >> $dataArray['synopsis'] =
> >>> >> >> > >> > str_replace("\r","<BR>",$dataArray['synopsis']);
> >>> >> >> > >> >> $dataArray['duration'] =
> >>> >> >> > >> >> date('H:i',strtotime($dataArray['duration']));
> >>> >> >> > >> >> ?>
> >>> >> >> > >> >> <td background="images/barSilver.jpg"
> >>> >> > width="30"><?=($recordCount
> >>> >> >> +
> >>> >> >> > >> >> 1)?></td>
> >>> >> >> > >> >> <td width="4"> </td>
> >>> >> >> > >> >> <td>
> >>> >> >> > >> >> <div class="div_info" style="position: absolute;
> >> width:
> >>> >> > 400px;
> >>> >> >> > >> >> z-index: 1; visibility: hidden;"
> >>> > id="infoLayer_<?=$recordCount?>"
> >>> >> >> > >> >>
> >>> >> >> > >> >
> >>> >> >> > >
> >>> >> >>
> >>> >> >
> >>> >
> >>
align="left"><b><u><?=$dataArray['title']?></u></b><p><u>Starring:</u><br><i
> >>> >> >> > >>
> >>> >> >> >
> >>> >> >>
> >>> >>
> >>>
>
>>>>>>><?=$dataArray['starring']?></i></p><p><?=$dataArray['synopsis']?></p>
</
> >> d
> >>> > i
> >>> >> >> v
> >>> >> >> > >>
> >>> >> >> > >> >> <?
> >>> >> >> > >> >> if($dataArray['dvd_image'] == "None")
> >>> >> >> > >> >> {
> >>> >> >> > >> >> ?>
> >>> >> >> > >> >> <img id="img_<?=$recordCount?>" width="50"
height="70"
> >>> >> >> > >> >> src="images/dvds/none_small.jpg"
> >>> >> >> > >> >>
> >>> >> >> > >> >
> >>> >> >> > >
> >>> >> >>
> >>> >> >
> >>> >
> >>
onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>
> >>> >> >> > >> > ',img_<?=$recordCount?>.width
> >>> >> >> > >> >> + 5,5)"
> >>> >> >> > >> >> onmouseout="popHide('infoLayer_<?=$recordCount?>')">
> >>> >> >> > >> >> <?
> >>> >> >> > >> >> }
> >>> >> >> > >> >> else
> >>> >> >> > >> >> {
> >>> >> >> > >> >> ?>
> >>> >> >> > >> >> <img id="img_<?=$recordCount?>" width="50"
height="70"
> >>> >> >> > >> >> src="images/dvds/<?=$dataArray['dvd_image']?>"
> >>> >> >> > >> >>
> >>> >> >> > >> >
> >>> >> >> > >
> >>> >> >>
> >>> >> >
> >>> >
> >>
onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>
> >>> >> >> > >> > ',img_<?=$recordCount?>.width
> >>> >> >> > >> >> + 5,5)"
> >>> >> >> > >> >> onmouseout="popHide('infoLayer_<?=$recordCount?>')">
> >>> >> >> > >> >> <?
> >>> >> >> > >> >> }
> >>> >> >> > >> >> echo " <img
> >>> >> >> > >> >>
> >>> >> >> > >> >
> >>> >> >> > >
> >>> >> >>
> >>> >> >
> >>> >
> >>
src='images/certs/".$certImage[$dataArray['certificate']].".gif'><BR>".$data
> >>> >> >> > >> > Array['title'];
> >>> >> >> > >> >> ?>
> >>> >> >> > >> >> </td>
> >>> >> >> > >> >> <td width="4"> </td>
> >>> >> >> > >> >> <td><b>Released</b><br><?=$dataArray['year']?><br>
> >>> >> >> > >> >> <b>Duration</b><br><?=$dataArray['duration']?><br>
> >>> >> >> > >> >> <b>Rating</b><br><img alt="Rating:
> >>> >> >> > >> >> <?=$dataArray['rating']/2?>"
> >>> >> >> > >> >> align="absmiddle"
> >>> >> >> > >> >>
src="images/ratings/pips<?=$dataArray['rating']?>.gif"></td>
> >>> >> >> > >> >> <td width="4"> </td>
> >>> >> >> > >> >> <?
> >>> >> >> > >> >> $recordCount++;
> >>> >> >> > >> >> }
> >>> >> >> > >> >> ?>
> >>> >> >> > >> >> </tr>
> >>> >> >> > >> >> <?
> >>> >> >> > >> >> }
> >>> >> >> > >> >> }
> >>> >> >> > >> >> ----------------------------------
> >>> >> >> > >> >>
> >>> >> >> > >> >>
> >>> >> >> > >> >> "Ian Davies" <iandan.dav@virgin.net> wrote in message
> >>> >> >> > >> >> news:j3wxg.1067$u4.703@newsfe3-win.ntli.net...
> >>> >> >> > >> >> > Hello
> >>> >> >> > >> >> > Needing help with a suitable solution.
> >>> >> >> > >> >> > I have extracted records into a table under three
> >>> >> >> > >> >> > columns
> >>> >> >> > >> >> > 'category',
> >>> >> >> > >> >> > 'comment' and share (the category column also holds
the
> >>> >> >> > >> >> > index
> >>> >> >> > >> >> > no
> >>> >> >> of
> >>> >> >> > > the
> >>> >> >> > >> >> > record in a hidden field)
> >>> >> >> > >> >> > I wish the user to be able to edit the data in the
> >>> >> >> > >> >> > table,
> >> so
> >>> > I
> >>> >> >> have
> >>> >> >> > >> >> > extracted the records into hiddenfield, textareas,
> >> dropdown
> >>> >> >> > >> >> > list
> >>> >> >> and
> >>> >> >> > >> >> > checkbox so that they can make changes.
> >>> >> >> > >> >> > I named these elements as arrays and wish to run an
sql
> >>> >> >> > >> >> > to
> >>> > take
> >>> >> >> each
> >>> >> >> > >> >> > row
> >>> >> >> > >> >> > in
> >>> >> >> > >> >> > turn (and any changes made) and update the mysql
table.
> >>> >> >> > >> >> > I
> >>> >> >> > >> >> > did
> >>> >> >> > > something
> >>> >> >> > >> >> > similar with just one record but am stuck as to how I
> >>> >> >> > >> >> > use
> >>> >> >> > >> >> > the
> >>> >> >> arrays
> >>> >> >> > > of
> >>> >> >> > >> > a
> >>> >> >> > >> >> > number of form elements together
> >>> >> >> > >> >> >
> >>> >> >> > >> >> > My code for the table is below but I dont know how the
> >>> >> >> > >> >> > script
> >>> >> >> should
> >>> >> >> > > go
> >>> >> >> > >> >> > when
> >>> >> >> > >> >> > the form is submitted to add each row in turn
> >>> >> >> > >> >> > Help greatly appreciated
> >>> >> >> > >> >> > Ian
> >>> >> >> > >> >> >
> >>> >> >> > >
> >>> >
**********************************************************************
> >>> >> >> > >> >> > <form action="commentselect.php" method="post"
> >>> >> >> > >> >> > enctype="multipart/form-data"
> >>> >> >> > >> >> > name="UpdateComments">
> >>> >> >> > >> >> > <table width="100%" border="0" cellpadding="0"
> >>> > cellspacing="2"
> >>> >> >> > >> >> > bgcolor="#FFFFFF">
> >>> >> >> > >> >> > <tr align="center" class="ListHeading">
> >>> >> >> > >> >> > <td width="20%" height="31">Category</td>
> >>> >> >> > >> >> > <td width="60%" height="31">Comment</td>
> >>> >> >> > >> >> > <td width="10%" height="31">Share</td>
> >>> >> >> > >> >> > </tr>
> >>> >> >> > >> >> > <tr class="BodyText">
> >>> >> >> > >> >> > <?php
> >>> >> >> > >> >> > while($row =& mysql_fetch_array($commentresults)) {
> >>> >> >> > >> >> > extract($row);
> >>> >> >> > >> >> >
> >>> >> >> > >> >> > if ($i%2) {
> >>> >> >> > >> >> > $class = 'row1';
> >>> >> >> > >> >> > echo "<TR bgcolor=\"#CCCCCC\">\n";
> >>> >> >> > >> >> >
> >>> >> >> > >> >> > } else {
> >>> >> >> > >> >> > $class = 'row2';
> >>> >> >> > >> >> > echo "<TR bgcolor=\"white\">\n";
> >>> >> >> > >> >> > }
> >>> >> >> > >> >> > $i += 1;
> >>> >> >> > >> >> > ?>
> >>> >> >> > >> >> > <td width="20%" align="left"
> >>> >> >> > >> >> > class="bodytext"><select
> >>> >> >> > >> >> > name="category[]" style="WIDTH: 90%">
> >>> >> >> > >> >> > <option value="<?php echo $row['TypeID']; ?>"><?php
echo
> >>> >> >> > >> > $row['typedesc'];
> >>> >> >> > >> >> > ?></option>
> >>> >> >> > >> >> > <?php
> >>> >> >> > >> >> > $commenttype = mysql_query("SELECT * FROM commenttype
> >> WHERE
> >>> >> >> username
> >>> >> >> > > =
> >>> >> >> > >> >> > '$username'");
> >>> >> >> > >> >> > if (!$commenttype) {
> >>> >> >> > >> >> > exit('<p>Error performing query: ' . mysql_error() .
> >>> >> >> > >> >> > '</p>');
> >>> >> >> > >> >> > }
> >>> >> >> > >> >> > while($row1 =& mysql_fetch_array($commenttype)) {
> >>> >> >> > >> >> > extract($row1);
> >>> >> >> > >> >> > ?>
> >>> >> >> > >> >> > <option value="<?php echo
> >>> >> >> > >> >> > $row1['TypeID'];
> >>> >> >> ?>"><?php
> >>> >> >> > >> >> > echo
> >>> >> >> > >> >> > $row1['typedesc']; ?><br>
> >>> >> >> > >> >> > </option>
> >>> >> >> > >> >> > <?php
> >>> >> >> > >> >> > }
> >>> >> >> > >> >> > ?>
> >>> >> >> > >> >> > </select>
> >>> >> >> > >> >> > <input name="commindex[]" type="hidden"
> >>> >> >> > >> >> > value="<?php
> >>> > echo
> >>> >> >> > >> > $commindex;
> >>> >> >> > >> >> > ?>"></td>
> >>> >> >> > >> >> > <td width="60%" align="left" class="bodytext">
> >>> >> > <textarea
> >>> >> >> > >> >> > name="comm[]" rows="2" style="WIDTH: 99%"><?php echo
> >>> > $comment;
> >>> >> >> > >> >> > ?></textarea></td>
> >>> >> >> > >> >> > <td width="10%" align="center"
> >> class="bodytext"><input
> >>> >> >> > >> >> > type="checkbox"
> >>> >> >> > >> >> > name="avail[]" value="checkbox" <?php
share($available);
> >> ?>>
> >>> >> >> > > </td>
> >>> >> >> > >> >> > </tr>
> >>> >> >> > >> >> > <?php
> >>> >> >> > >> >> > }
> >>> >> >> > >> >> > ?>
> >>> >> >> > >> >> > </table>
> >>> >> >> > >> >> > </form>
> >>> >> >> > >> >> >
> >>> >> >> > >> >> >
> >> ************************************************************
> >>> >> >> > >> >> >
> >>> >> >> > >> >> >
> >>> >> >> > >> >>
> >>> >> >> > >> >>
> >>> >> >> > >> >
> >>> >> >> > >> >
> >>> >> >> > >>
> >>> >> >> > >>
> >>> >> >> > >
> >>> >> >> > >
> >>> >> >> >
> >>> >> >> >
> >>> >> >>
> >>> >> >>
> >>> >> >
> >>> >> >
> >>> >>
> >>> >>
> >>> >
> >>> >
> >>>
> >>>
> >>
> >>
> >
> >
>
>
Navigation:
[Reply to this message]
|