Print array on new page

programming
1

Hi All,

I have been making a page to display records from a music database, I have a page that displays music by genre with a hyperlink to display all tracks from that genre with a checkbox, the artist name and the title. I need the user to be able to select multiple tracks and press a “add to playlist” button that stores the selection which can be emailed to the site owner. I have pasted the code below that displays all tracks from a genre with a checkbox for each. I guess I need to know what the best way to do it is.

[COLOR=#000000][COLOR=#0000bb]<?php [/COLOR][COLOR=#007700]require_once([/COLOR][COLOR=#dd0000]'Connections/dbconn.php'[/COLOR][COLOR=#007700]); [/COLOR][COLOR=#0000bb]?>[/COLOR][/COLOR]
[COLOR=#000000][COLOR=#0000bb]<?php
[/COLOR][COLOR=#007700]if (![/COLOR][COLOR=#0000bb]function_exists[/COLOR][COLOR=#007700]([/COLOR][COLOR=#dd0000]"GetSQLValueString"[/COLOR][COLOR=#007700])) {
function [/COLOR][COLOR=#0000bb]GetSQLValueString[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]$theValue[/COLOR][COLOR=#007700], [/COLOR][COLOR=#0000bb]$theType[/COLOR][COLOR=#007700], [/COLOR][COLOR=#0000bb]$theDefinedValue [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#dd0000]""[/COLOR][COLOR=#007700], [/COLOR][COLOR=#0000bb]$theNotDefinedValue [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#dd0000]""[/COLOR][COLOR=#007700]) 
{
  if ([/COLOR][COLOR=#0000bb]PHP_VERSION [/COLOR][COLOR=#007700]< [/COLOR][COLOR=#0000bb]6[/COLOR][COLOR=#007700]) {
    [/COLOR][COLOR=#0000bb]$theValue [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000bb]get_magic_quotes_gpc[/COLOR][COLOR=#007700]() ? [/COLOR][COLOR=#0000bb]stripslashes[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]$theValue[/COLOR][COLOR=#007700]) : [/COLOR][COLOR=#0000bb]$theValue[/COLOR][COLOR=#007700];
  }

  [/COLOR][COLOR=#0000bb]$theValue [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000bb]function_exists[/COLOR][COLOR=#007700]([/COLOR][COLOR=#dd0000]"mysql_real_escape_string"[/COLOR][COLOR=#007700]) ? [/COLOR][COLOR=#0000bb]mysql_real_escape_string[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]$theValue[/COLOR][COLOR=#007700]) : [/COLOR][COLOR=#0000bb]mysql_escape_string[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]$theValue[/COLOR][COLOR=#007700]);

  switch ([/COLOR][COLOR=#0000bb]$theType[/COLOR][COLOR=#007700]) {
    case [/COLOR][COLOR=#dd0000]"text"[/COLOR][COLOR=#007700]:
      [/COLOR][COLOR=#0000bb]$theValue [/COLOR][COLOR=#007700]= ([/COLOR][COLOR=#0000bb]$theValue [/COLOR][COLOR=#007700]!= [/COLOR][COLOR=#dd0000]""[/COLOR][COLOR=#007700]) ? [/COLOR][COLOR=#dd0000]"'" [/COLOR][COLOR=#007700]. [/COLOR][COLOR=#0000bb]$theValue [/COLOR][COLOR=#007700]. [/COLOR][COLOR=#dd0000]"'" [/COLOR][COLOR=#007700]: [/COLOR][COLOR=#dd0000]"NULL"[/COLOR][COLOR=#007700];
      break;    
    case [/COLOR][COLOR=#dd0000]"long"[/COLOR][COLOR=#007700]:
    case [/COLOR][COLOR=#dd0000]"int"[/COLOR][COLOR=#007700]:
      [/COLOR][COLOR=#0000bb]$theValue [/COLOR][COLOR=#007700]= ([/COLOR][COLOR=#0000bb]$theValue [/COLOR][COLOR=#007700]!= [/COLOR][COLOR=#dd0000]""[/COLOR][COLOR=#007700]) ? [/COLOR][COLOR=#0000bb]intval[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]$theValue[/COLOR][COLOR=#007700]) : [/COLOR][COLOR=#dd0000]"NULL"[/COLOR][COLOR=#007700];
      break;
    case [/COLOR][COLOR=#dd0000]"double"[/COLOR][COLOR=#007700]:
      [/COLOR][COLOR=#0000bb]$theValue [/COLOR][COLOR=#007700]= ([/COLOR][COLOR=#0000bb]$theValue [/COLOR][COLOR=#007700]!= [/COLOR][COLOR=#dd0000]""[/COLOR][COLOR=#007700]) ? [/COLOR][COLOR=#0000bb]doubleval[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]$theValue[/COLOR][COLOR=#007700]) : [/COLOR][COLOR=#dd0000]"NULL"[/COLOR][COLOR=#007700];
      break;
    case [/COLOR][COLOR=#dd0000]"date"[/COLOR][COLOR=#007700]:
      [/COLOR][COLOR=#0000bb]$theValue [/COLOR][COLOR=#007700]= ([/COLOR][COLOR=#0000bb]$theValue [/COLOR][COLOR=#007700]!= [/COLOR][COLOR=#dd0000]""[/COLOR][COLOR=#007700]) ? [/COLOR][COLOR=#dd0000]"'" [/COLOR][COLOR=#007700]. [/COLOR][COLOR=#0000bb]$theValue [/COLOR][COLOR=#007700]. [/COLOR][COLOR=#dd0000]"'" [/COLOR][COLOR=#007700]: [/COLOR][COLOR=#dd0000]"NULL"[/COLOR][COLOR=#007700];
      break;
    case [/COLOR][COLOR=#dd0000]"defined"[/COLOR][COLOR=#007700]:
      [/COLOR][COLOR=#0000bb]$theValue [/COLOR][COLOR=#007700]= ([/COLOR][COLOR=#0000bb]$theValue [/COLOR][COLOR=#007700]!= [/COLOR][COLOR=#dd0000]""[/COLOR][COLOR=#007700]) ? [/COLOR][COLOR=#0000bb]$theDefinedValue [/COLOR][COLOR=#007700]: [/COLOR][COLOR=#0000bb]$theNotDefinedValue[/COLOR][COLOR=#007700];
      break;
  }
  return [/COLOR][COLOR=#0000bb]$theValue[/COLOR][COLOR=#007700];
}
}

[/COLOR][COLOR=#0000bb]$colname_Recordset1 [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#dd0000]"-1"[/COLOR][COLOR=#007700];
if (isset([/COLOR][COLOR=#0000bb]$_GET[/COLOR][COLOR=#007700][[/COLOR][COLOR=#dd0000]'genre'[/COLOR][COLOR=#007700]])) {
  [/COLOR][COLOR=#0000bb]$colname_Recordset1 [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000bb]$_GET[/COLOR][COLOR=#007700][[/COLOR][COLOR=#dd0000]'genre'[/COLOR][COLOR=#007700]];
}
[/COLOR][COLOR=#0000bb]mysql_select_db[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]$database_dbconn[/COLOR][COLOR=#007700], [/COLOR][COLOR=#0000bb]$dbconn[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000bb]$query_Recordset1 [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000bb]sprintf[/COLOR][COLOR=#007700]([/COLOR][COLOR=#dd0000]"SELECT recordID, artist, title FROM tblrecord WHERE genre = %s ORDER BY artist ASC"[/COLOR][COLOR=#007700], [/COLOR][COLOR=#0000bb]GetSQLValueString[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]$colname_Recordset1[/COLOR][COLOR=#007700], [/COLOR][COLOR=#dd0000]"text"[/COLOR][COLOR=#007700]));
[/COLOR][COLOR=#0000bb]$Recordset1 [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000bb]mysql_query[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]$query_Recordset1[/COLOR][COLOR=#007700], [/COLOR][COLOR=#0000bb]$dbconn[/COLOR][COLOR=#007700]) or die([/COLOR][COLOR=#0000bb]mysql_error[/COLOR][COLOR=#007700]());
[/COLOR][COLOR=#0000bb]$row_Recordset1 [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000bb]mysql_fetch_assoc[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]$Recordset1[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000bb]$totalRows_Recordset1 [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000bb]mysql_num_rows[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]$Recordset1[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000bb]?>[/COLOR][/COLOR]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<form id="add_to_cart" name="add_to_cart" method="post" action="music-display.php">
<table width="68%" border="0" cellspacing="0" cellpadding="0">
  [COLOR=#000000][COLOR=#0000bb]<?php [/COLOR][COLOR=#007700]do { [/COLOR][COLOR=#0000bb]?>[/COLOR][/COLOR]
    <tr>
      <td width="3%"><label>
          <input type="checkbox" name="recordID[]" id="checkbox" />
        </label></td>
      <td width="29%">[COLOR=#000000][COLOR=#0000bb]<?php [/COLOR][COLOR=#007700]echo [/COLOR][COLOR=#0000bb]$row_Recordset1[/COLOR][COLOR=#007700][[/COLOR][COLOR=#dd0000]'artist'[/COLOR][COLOR=#007700]]; [/COLOR][COLOR=#0000bb]?>[/COLOR][/COLOR]</td>
      <td width="68%">[COLOR=#000000][COLOR=#0000bb]<?php [/COLOR][COLOR=#007700]echo [/COLOR][COLOR=#0000bb]$row_Recordset1[/COLOR][COLOR=#007700][[/COLOR][COLOR=#dd0000]'title'[/COLOR][COLOR=#007700]]; [/COLOR][COLOR=#0000bb]?>[/COLOR][/COLOR]</td>
      </tr>
    [COLOR=#000000][COLOR=#0000bb]<?php [/COLOR][COLOR=#007700]} while ([/COLOR][COLOR=#0000bb]$row_Recordset1 [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000bb]mysql_fetch_assoc[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]$Recordset1[/COLOR][COLOR=#007700])); [/COLOR][COLOR=#0000bb]?>[/COLOR][/COLOR]
</table><br />
<label>
  <input type="submit" name="addToCartbtn" id="addToCartbtn" value="Add to my playlist" />
</label>
</form>
</body>
</html>
[COLOR=#000000][COLOR=#0000bb]<?php
mysql_free_result[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]$Recordset1[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000bb]?>[/COLOR][/COLOR]