Hi,
I've read through the above and looked at the DA guide, however, i have a client who had a site built a while ago and it's now a little bit difficult to redo the database info to update the order of how the information is sorted (they want it done Music Name alphabetically). I was wondering therefore, if there is a way to just update the code rather than go through the recordset panels etc...I noticed a way to do it for PowerStore but not for DA
Currently the code for the layout is
<table class="WADAResultsTable" border="0" cellpadding="0" cellspacing="0">
<tr>
<th class="WADAResultsTableHeader">Item ID:</th>
<th class="WADAResultsTableHeader">Music Name:</th>
<th class="WADAResultsTableHeader">Music Description:</th>
<th class="WADAResultsTableHeader">Music Type:</th>
<th> </th>
</tr>
<?php do { ?>
<tr class="<?php echo $WARRT_AltClass1->getClass(true); ?>">
<td class="WADAResultsTableCell" style="width:60px;"><?php echo($row_WADAmusicuploads['ItemID']); ?></td>
<td class="WADAResultsTableCell" style="width:155px;"><a href="musicuploads_Detail.php?ItemID=<?php echo(rawurlencode($row_WADAmusicuploads['ItemID'])); ?>" ><?php echo($row_WADAmusicuploads['ItemName']); ?></a></td>
<td class="WADAResultsTableCell" style="width:150px;"><?php echo($row_WADAmusicuploads['ItemDescription']); ?></td>
<td class="WADAResultsTableCell" style="width:150px;"><?php echo($row_WADAmusicuploads['ItemType']); ?></td>
<td class="WADAResultsEditButtons" nowrap="nowrap"><table class="WADAEditButton_Table">
<tr>
<td><a href="musicuploads_Detail.php?ItemID=<?php echo(rawurlencode($row_WADAmusicuploads['ItemID'])); ?>" title="View"><img border="0" name="View<?php echo(rawurlencode($row_WADAmusicuploads['ItemID'])); ?>" id="View<?php echo(rawurlencode($row_WADAmusicuploads['ItemID'])); ?>" alt="View" src="../../WA_DataAssist/images/Slate/Traditional_zoom.gif" /></a></td>
<td><a href="musicuploads_Update.php?ItemID=<?php echo(rawurlencode($row_WADAmusicuploads['ItemID'])); ?>" title="Update"><img border="0" name="Update<?php echo(rawurlencode($row_WADAmusicuploads['ItemID'])); ?>" id="Update<?php echo(rawurlencode($row_WADAmusicuploads['ItemID'])); ?>" alt="Update" src="../../WA_DataAssist/images/Slate/Traditional_edit.gif" /></a></td>
<td><a href="musicuploads_Delete.php?ItemID=<?php echo(rawurlencode($row_WADAmusicuploads['ItemID'])); ?>" title="Delete"><img border="0" name="Delete<?php echo(rawurlencode($row_WADAmusicuploads['ItemID'])); ?>" id="Delete<?php echo(rawurlencode($row_WADAmusicuploads['ItemID'])); ?>" alt="Delete" src="../../WA_DataAssist/images/Slate/Traditional_trash.gif" /></a></td>
</tr>
</table></td>
</tr>
<?php } while ($row_WADAmusicuploads = mysql_fetch_assoc($WADAmusicuploads)); ?>
</table>
Thanks for any help!