3 replies to this topic

[Philcey]

I am trying to code a theme shop module, I cant find out how to make my second function (themeview) find out what ID is in the title and collect all the columbs data for that row, please help me..

<?php
global $modulefile;
if ((eregi("index.php", $_SERVER['SCRIPT_NAME'])) || (!eregi("".$modulefile.".php", $_SERVER['SCRIPT_NAME']))) { header("location:../../index.php"); }
includelang($modulename, "module"); // includes module language if exists

############ 
## Global ##
############



function index(){
global $modulefile, $modulename, $db, $prefix, $dblinkscat;
Head();
modulelogo($modulename);

$db->sql_query("SELECT * FROM tscat");
$result = mysql_query("SELECT * FROM tscat");
while($r=mysql_fetch_array($result))
{
$title=$r["title"];
$description=$r["description"];
$id=$r["ID"];

OpenTable();

echo"<table width=\"70%\">"
  . "               <td class=\"tabletop\" width=\"20%\">Theme Name </a></b></td>"
  . "                <td class=\"tabletop\" width=\"50%\">Description</a></b></td>"
  . " 	 </tr>"
  . "  <tr>"
  . " 	 <td class=\"row1\" width=\"20%\"><a href=\"".$modulefile.".php?load=$modulename&function=themeview&id=" . $id . "\">$title"
  . " 	 <td class=\"row1\" width=\"50%\">$description</td>"
  . "       </table></td>"
 ."";



CloseTable();
}
Foot();
}


function themeview(){
global $modulefile, $modulename, $db, $prefix, $dblinkscat;
Head();
modulelogo($modulename);

*** CODE MISSING ****




OpenTable();

echo "

<table width=100% border=0 cellspacing=3 cellpadding=0>
<tr>
<td>$tuts3[message]</td>
</tr>
</table>


";


CloseTable();

}
Foot();
}





###########
## Cases ##
###########
switch($function) {

    default:
    index();
    break;
	
	case "themeview":
	themeview();
	break;
	
	case "addlink":
	addlink($title, $url, $catid, $info);
	break;
	
}
?>

[rc69]

First off, what title?
Second, if you didn't write that, you should probably ask the creator's of the script how to do what you're asking. If you did write it, then you should also know the answer to your question, or think about a new hobby

[Philcey]

i ment url, so it finds out the id in the url and then does a query on all data the columbs in the ids row

[rc69]

Then just use $_GET['id'] run a mysql_query similar to:
mysql_query("SELECT * FROM table_name WHERE col_name = ".$_GET['id']);