Home > Archive > PHP Language > July 2006 > Using arrays to take records from a html table and update database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Using arrays to take records from a html table and update database
|
|
| Ian Davies 2006-07-25, 6:56 pm |
| 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>
****************************************
********************
| |
| PSI_Orion 2006-07-26, 7:56 am |
| 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['duratio
n']));
?>
<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></div>
<?
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>".$dataArray['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>
>
> ****************************************
********************
>
>
| |
| Ian Davies 2006-07-26, 6:57 pm |
| 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['duratio
n']));
> ?>
> <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></div>
> <?
> 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...
a[color=darkred]
$row['typedesc'];[color=darkred]
$commindex;[color=darkred]
>
>
| |
| PSI_Orion 2006-07-26, 6:57 pm |
| 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...
> have
> loop
> str_replace("\r","<BR>",$dataArray['starring']);
> str_replace("\r","<BR>",$dataArray['synopsis']);
> align="left"><b><u><?=$dataArray['title']?></u></b><p><u>Starring:</u><br><i
> onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>
> ',img_<?=$recordCount?>.width
> onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>
> ',img_<?=$recordCount?>.width
> src='images/certs/".$certImage[$dataArray['certificate']].".gif'><BR>".$data
> Array['title'];
> a
> $row['typedesc'];
> $commindex;
>
>
| |
| Ian Davies 2006-07-27, 3:57 am |
| 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...
records[color=darkred]
users[color=darkred]
a[color=darkred]
and[color=darkred]
some[color=darkred]
it[color=darkred]
code[color=darkred]
align="left"><b><u><?=$dataArray['title']?></u></b><p><u>Starring:</u><br><i[color=darkred]
>
>
onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>[color=darkred]
onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>[color=darkred]
src='images/certs/".$certImage[$dataArray['certificate']].".gif'><BR>".$data[color=darkred]
the[color=darkred]
something[color=darkred]
of[color=darkred]
go[color=darkred]
****************************************
******************************[color=dar
kred]
=[color=darkred]
</td>[color=darkred]
>
>
| |
| PSI_Orion 2006-07-27, 7:56 am |
| 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...
> if
> records
> users
> a
> and
> some
> it
> code
> align="left"><b><u><?=$dataArray['title']?></u></b><p><u>Starring:</u><br><i
> onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>
> onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>
> src='images/certs/".$certImage[$dataArray['certificate']].".gif'><BR>".$data
> the
> something
> of
> go
> ****************************************
******************************
> =
> </td>
>
>
| |
| Ian Davies 2006-07-27, 7:56 am |
| 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...
of[color=darkred]
adjust[color=darkred]
but[color=darkred]
on[color=darkred]
database,[color=darkred]
I[color=darkred]
as[color=darkred]
while[color=darkred]
+[color=darkred]
align="left"><b><u><?=$dataArray['title']?></u></b><p><u>Starring:</u><br><i[color=darkred]
>
v[color=darkred]
onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>[color=darkred]
onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>[color=darkred]
src='images/certs/".$certImage[$dataArray['certificate']].".gif'><BR>".$data[color=darkred]
of[color=darkred]
have[color=darkred]
and[color=darkred]
each[color=darkred]
arrays[color=darkred]
should[color=darkred]
username[color=darkred]
?>"><?php[color=darkred]
>
>
| |
| Ian Davies 2006-07-27, 7:56 am |
| '....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...
is[color=darkred]
> of
to[color=darkred]
> adjust
> but
arrays[color=darkred]
the[color=darkred]
displated[color=darkred]
> on
click[color=darkred]
button[color=darkred]
> database,
way[color=darkred]
> I
elements[color=darkred]
> as
> while
database[color=darkred]
width="30"><?=($recordCount[color=darkred]
> +
400px;[color=darkred]
>
align="left"><b><u><?=$dataArray['title']?></u></b><p><u>Starring:</u><br><i
>
> v
>
onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>
>
onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>
>
src='images/certs/".$certImage[$dataArray['certificate']].".gif'><BR>".$data
> of
> have
> and
> each
> arrays
> should
> username
> ?>"><?php
<textarea[color=darkred]
>
>
| |
| PSI_Orion 2006-07-27, 6:56 pm |
| 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...
> subsequent
> in
> is
> to
> arrays
> the
> displated
> click
> button
> way
> elements
> database
> width="30"><?=($recordCount
> 400px;
> align="left"><b><u><?=$dataArray['title']?></u></b><p><u>Starring:</u><br><i
> onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>
> onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>
> src='images/certs/".$certImage[$dataArray['certificate']].".gif'><BR>".$data
> <textarea
>
>
| |
| Ian Davies 2006-07-27, 6:56 pm |
| 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...
them[color=darkred]
category[color=darkred]
a[color=darkred]
trying[color=darkred]
the[color=darkred]
each[color=darkred]
same[color=darkred]
your[color=darkred]
ie:[color=darkred]
$allRecords;[color=darkred]
id="infoLayer_<?=$recordCount?>"[color=darkred]
align="left"><b><u><?=$dataArray['title']?></u></b><p><u>Starring:</u><br><i[color=darkred]
>
i[color=darkred]
onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>[color=darkred]
onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>[color=darkred]
src='images/certs/".$certImage[$dataArray['certificate']].".gif'><BR>".$data[color=darkred]
I[color=darkred]
take[color=darkred]
****************************************
******************************[color=dar
kred]
cellspacing="2"[color=darkred]
echo[color=darkred]
$comment;[color=darkred]
>
>
| |
| PSI_Orion 2006-07-27, 6:56 pm |
| OK, take a look now. I have deliberately deleted IDs 3, 7 and 8 to show it
matches the necessary ID of all found items.
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...
> lines.
> but
> them
> category
> a
> trying
> the
> each
> same
> your
> ie:
> $allRecords;
> id="infoLayer_<?=$recordCount?>"
> align="left"><b><u><?=$dataArray['title']?></u></b><p><u>Starring:</u><br><i
> i
> onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>
> onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>
> src='images/certs/".$certImage[$dataArray['certificate']].".gif'><BR>".$data
> I
> take
> ****************************************
******************************
> cellspacing="2"
> echo
> $comment;
>
>
| |
| PSI_Orion 2006-07-27, 6:56 pm |
| 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...
> lines.
> but
> them
> category
> a
> trying
> the
> each
> same
> your
> ie:
> $allRecords;
> id="infoLayer_<?=$recordCount?>"
> align="left"><b><u><?=$dataArray['title']?></u></b><p><u>Starring:</u><br><i
> i
> onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>
> onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>
> src='images/certs/".$certImage[$dataArray['certificate']].".gif'><BR>".$data
> I
> take
> ****************************************
******************************
> cellspacing="2"
> echo
> $comment;
>
>
| |
| Ian Davies 2006-07-27, 6:56 pm |
| yes
I think that is what im looking for but your code isnt visible
Did you use arrays?
"PSI_Orion" <orion@psiss.com> wrote in message
news:ZN9yg.71$ts3.49@newsfe2-gui.ntli.net...
> OK, take a look now. I have deliberately deleted IDs 3, 7 and 8 to show
it
> matches the necessary ID of all found items.
>
> http://www.psiss.com/dummy
>
> Chris
> "Ian Davies" <iandan.dav@virgin.net> wrote in message
> news:357yg.26$WY2.16@newsfe3-gui.ntli.net...
changes[color=darkred]
be[color=darkred]
be[color=darkred]
more[color=darkred]
the[color=darkred]
to[color=darkred]
try[color=darkred]
in[color=darkred]
modify[color=darkred]
using[color=darkred]
to[color=darkred]
width:[color=darkred]
align="left"><b><u><?=$dataArray['title']?></u></b><p><u>Starring:</u><br><i[color=darkred]
>
d[color=darkred]
onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>[color=darkred]
onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>[color=darkred]
src='images/certs/".$certImage[$dataArray['certificate']].".gif'><BR>".$data[color=darkred]
so[color=darkred]
dropdown[color=darkred]
WHERE[color=darkred]
class="bodytext"><input[color=darkred]
?>>[color=darkred]
****************************************
********************[color=darkred]
>
>
| |
| Ian Davies 2006-07-28, 7:57 am |
| 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...
changes[color=darkred]
be[color=darkred]
be[color=darkred]
more[color=darkred]
the[color=darkred]
to[color=darkred]
try[color=darkred]
in[color=darkred]
modify[color=darkred]
using[color=darkred]
to[color=darkred]
width:[color=darkred]
align="left"><b><u><?=$dataArray['title']?></u></b><p><u>Starring:</u><br><i[color=darkred]
>
d[color=darkred]
onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>[color=darkred]
onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>[color=darkred]
src='images/certs/".$certImage[$dataArray['certificate']].".gif'><BR>".$data[color=darkred]
so[color=darkred]
dropdown[color=darkred]
WHERE[color=darkred]
class="bodytext"><input[color=darkred]
?>>[color=darkred]
****************************************
********************[color=darkred]
>
>
| |
| PSI_Orion 2006-07-28, 6:57 pm |
| 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...
> changes
> be
> be
> more
> the
> to
> try
> in
> modify
> using
> to
> width:
> align="left"><b><u><?=$dataArray['title']?></u></b><p><u>Starring:</u><br><i
> d
> onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>
> onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>
> src='images/certs/".$certImage[$dataArray['certificate']].".gif'><BR>".$data
> so
> dropdown
> WHERE
> class="bodytext"><input
> ?>>
> ****************************************
********************
>
>
| |
| PSI_Orion 2006-07-28, 6:57 pm |
| 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...
>
>
| |
| Ian Davies 2006-07-29, 3:57 am |
| 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...
update[color=darkred]
wouldnt[color=darkred]
I[color=darkred]
table[color=darkred]
right[color=darkred]
would[color=darkred]
to[color=darkred]
use[color=darkred]
integer[color=darkred]
come[color=darkred]
are[color=darkred]
will[color=darkred]
is[color=darkred]
clicking[color=darkred]
the[color=darkred]
DVD[color=darkred]
align="left"><b><u><?=$dataArray['title']?></u></b><p><u>Starring:</u><br><i[color=darkred]
>
</[color=darkred]
height="70"[color=darkred]
onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>[color=darkred]
height="70"[color=darkred]
onmouseover="popShow(this,img_<?=$recordCount?>,'infoLayer_<?=$recordCount?>[color=darkred]
src='images/certs/".$certImage[$dataArray['certificate']].".gif'><BR>".$data[color=darkred]
src="images/ratings/pips<?=$dataArray['rating']?>.gif"></td>[color=darkred]
the[color=darkred]
sql[color=darkred]
table.[color=darkred]
****************************************
******************************[color=dar
kred]
echo[color=darkred]
share($available);[color=darkred]
>
>
|
|
|
|
|