Login";} // else { echo "Logout";} // // add entry to collection $solids_entry_add = $_GET["solids_entry"]; $solids_entry_remove = $_GET["solids_remove"]; if ($solids_entry_add){ $sql2 = "INSERT INTO collections (client_id, item_num) VALUES ($client_id ,$solids_entry_add)"; $new_add_result = @mysql_query($sql2) or die ("

Error accessing MySQL table!"); } if ($solids_entry_remove){ $sql2 = "DELETE FROM collections WHERE client_id = '$client_id' AND item_num ='$solids_entry_remove'"; $new_add_result = @mysql_query($sql2) or die ("

Error accessing MySQL table!"); } // End of New if ($solids_header_file != "" AND file_exists($solids_header_file)) { include($solids_header_file); include('laud_head.php'); ?> \n$solids_page_title\n"; if ($solids_styles_file != "" AND file_exists($solids_styles_file)) { include($solids_styles_file); ?> \n\n"; } echo "\n\n\n\n"; ?>


[ Add New Entry ] "; echo " [ Exit Edit Mode ]"; } ?>
Search by:   Results per page:    Change View
View My Collection
Error accessing MySQL table!"); $solids_total = @mysql_fetch_array($solids_count_result); if ($solids_total[0] > 0) { $solids_header_string = "$SCRIPT_NAME?solids_search=" . $solids_search . "&solids_search_type=" . $solids_search_type . "&solids_max_results=" . $solids_max_results . $solids_edit_string; echo "\n\n\n
\n\n"; $solids_pages = ceil($solids_total[0] / $solids_search_maximum); // Select page if ($solids_page != "" AND $solids_page >= 1 AND $solids_page <= $solids_pages) { $solids_search_results = ( ( $solids_total[0] - ( $solids_total[0] - ( $solids_page * $solids_search_maximum ) ) ) - $solids_search_maximum ); $solids_current_page = $solids_page; } elseif ($solids_page != "" AND $solids_page > $solids_pages) { $solids_search_results = ( ( $solids_total[0] - ( $solids_total[0] - ( $solids_pages * $solids_search_maximum ) ) ) - $solids_search_maximum ); $solids_current_page = $solids_pages; } elseif ($solids_page != "" AND $solids_page < 1) { $solids_search_results = ( ( $solids_total[0] - ( $solids_total[0] - ( 1 * $solids_search_maximum ) ) ) - $solids_search_maximum ); $solids_current_page = 1; } else { $solids_current_page = 1 + ( ( $solids_total[0] - ($solids_total[0] - $solids_search_results) ) / $solids_search_maximum ); } // Table Header ?>
$solids_count_string

"; // Debug Only // Grab result from db $solids_result = @mysql_db_query($solids_mysql_db, $solids_query_string) or die ("Invalid query (result)"); while ($solids_row = @mysql_fetch_array($solids_result)) { $solids_field_1 = $solids_row[ $solids_field[2][1] ]; $solids_field_2 = $solids_row[ $solids_field[2][2] ]; $solids_field_3 = $solids_row[ $solids_field[2][3] ]; $solids_field_4 = $solids_row[ $solids_field[2][4] ]; $solids_field_5 = $solids_row[ $solids_field[2][5] ]; $solids_field_6 = $solids_row[ $solids_field[2][6] ]; $solids_field_7 = " Click to see image "; //Set alternate row color if ($solids_color_ctr == 1) { $solids_row_color = $solids_row_color_1; $solids_color_ctr = 2; } else { $solids_row_color = $solids_row_color_2; $solids_color_ctr = 1; } if ($solids_edit == 1) { $solids_entry = urlencode($solids_field_1); } //Link titles to IMDb if ( strtolower(substr($solids_field_6, 0, 7)) == "http://" ) $solids_link = "" . $solids_field_1 . ""; elseif ($solids_imdb_links == 1) { if ($solids_field_6 != 0 AND $solids_field_6 != "") $solids_link = "" . $solids_field_1 . ""; //$solids_field_1 = ""; else $solids_link = $solids_field_1; } elseif ($solids_imdb_links == 2) $solids_link = "" . $solids_field_1 . ""; //$solids_field_1 = ""; else $solids_link = $solids_field_1; $solids_field_1 ="
" . $solids_link . "
"; echo "\n"; if ($solids_logged_in == 1) { $tmp_field_1 = substr ($solids_field_1, 43); $tmp_field_1 = substr ($tmp_field_1, 0,(strlen($tmp_field_1) -13)); // check if this item is owned $query = "SELECT * FROM collections WHERE client_id = '$client_id' AND item_num = '$tmp_field_1'"; $query_result_handle =@mysql_query ($query) or die ('The query failed! table_name must be a valid table name that exists in the database specified in mysql_select_db'); // make sure that we recieved some data from our query $num_of_rows = @mysql_num_rows ($query_result_handle); //or die ("The query: '$query' did not return any data"); if ($num_of_rows){ echo "\n"; } else{ // echo "\n"; } } if ($solids_edit == 1) { echo "\n"; } echo "\n\n\n"; $solids_ctr1++; } echo "\n
Edit
Own
[ Remove ]
[ Add ]
[ Edit ]
$solids_field_2$solids_field_3$solids_field_4$solids_field_5$solids_field_7
"; // Footer if ($solids_search_results > 0) { $solids_previous_page_results = $solids_search_results - $solids_search_maximum; $solids_previous_page = ""; } else { $solids_previous_page = "< Previous"; } if ($solids_search_results + $solids_search_maximum < $solids_total[0]) { $solids_next_page_results = $solids_search_results + $solids_search_maximum; $solids_next_page = ""; } else { $solids_next_page = "Next >"; } echo "\n\n\n\n\n\n\n\n
"; echo "$solids_previous_page"; echo ""; echo "\nPage "; echo " of $solids_pages"; echo "\n"; echo ""; echo "$solids_next_page"; echo "
\n"; echo "\n\n
\n\n"; $solids_ctr1 = $solids_ctr1 - 1; $solids_titles_displayed1 = $solids_search_results + 1; $solids_titles_displayed2 = $solids_titles_displayed1 + $solids_ctr1 - 1; echo "\n\n

\nSolids Displayed: $solids_titles_displayed1 - $solids_titles_displayed2."; echo "\n
Total Results: $solids_total[0].
\n"; } else { ?>
Sorry, no results were found.
phpSOLIDS v$phpsolids_version
Copyright © 2002-2009 by SolidPerfume.com

"; } // end of $db_error if statement... else { ?>
Error: Cannot connect to the database!
\n"; } ?>