Help with small get if statment

[winracer]

That is helpful thanks.

I hope is work for you.  also some more of the code in php

$user5 = $row['submitter'];   
   $smarty->assign('user5', $user5)
echo "
";

[winracer]

here is a nice peace of code if you care how long it takes a page to load

<?php
// Get Current Time
$mtime = microtime();
// Split Seconds and Microseconds
$mtime = explode (" ", $mtime);
// Create a single value for start time
$mtime = $mtime[1] + $mtime[0];
// Write Start Time Into A Variable
$tstart = $mtime;

// Get current time (Like above) to get end time
$mtime = microtime();
$mtime = explode (" ", $mtime);
$mtime = $mtime[1] + $mtime[0];
// Store end time in a variable
$tend = $mtime;
// Calculate Difference
$totaltime = ($tend - $tstart);
// Output the result
printf ("This page was generated in %f seconds.", $totaltime);
?>

[winracer]

did it work for you?

[FireDart]

Going to bed, I will try it next morning.

[winracer]

later.........

[FireDart]

Got the individual pages working, example:
index.php?id=media&m=1 or index.php?id=media&m=2 etc..

Just need to get it so on the index.php?id=media it shows the most recent media.

Demo:
Index: http://www.firedartonline.com/phpdirector/
Media: http://www.firedartonline.com/phpdirector/index.php?id=media
Media Page 1: http://www.firedartonline.com/phpdirector/index.php?id=media&m=1
Media Page 2: http://www.firedartonline.com/phpdirector/index.php?id=media&m=2

View attachments.

[winracer]

I like it. thumb's up from me! if you want to e-mail me the code I will help

[FireDart]

Let me get the files together and I will E-Mail you.

--Later--

I E-mail what am trying to do, our you good with contacting MySql DB's and displaying the info? Am trying to make the global.php file dynamically update depending on current DB info, so if you can get that working that would be great.

Also I plan on using the php function() feature for most of the script, to help stream line the code into easy to use snippets, which would be located in the "global.php".

[winracer]

you good with contacting MySql DB's and displaying the info?

yes, i will see what i can do.

[winracer]

Firedart I sent you a e-mail

[FireDart]

Thanks for the E-Mail, add more array options and styled the results:
http://www.firedartonline.com/phpdirector/index.php?id=media

media.php

Code: [Select]

<?php
/*
********************
PHPDirector - Media
********************
*/
/* Grab Media ID */
if(isset($_GET['m'])) {
/* Find URL Value */
$urlmediaid = $_GET['m'];

/* Grab Results from DB */
$query = "Select * FROM phpdir_media WHERE ID = $urlmediaid";
$result = mysql_query($query);

/* Display Results */
$media = mysql_fetch_array($result);

/* Assign Values to Smarty */
$smarty->assign('media_mediaid', $media['id']);
$smarty->assign('media_name', $media['name']);
$smarty->assign('media_creator', $media['creator']);
$smarty->assign('media_description', $media['description']);
$smarty->assign('media_date', $media['date']);
$smarty->assign('media_views', $media['views']);
$smarty->assign('media_mediatype', $media['video_type']);
$smarty->assign('media_approved', $media['approved']);
$smarty->assign('media_featured', $media['featured']);
$smarty->assign('media_rejected', $media['rejected']);
$smarty->assign('media_category', $media['category']);
$smarty->assign('media_pictures', $media['pictures']);
$smarty->assign('media_file', $media['file']);
$smarty->assign('media_ip', $media['ip']);

} else {
/* If no media value selected Display newest media */
/* Grab Results from DB */  
$newestmediaresult = mysql_query("SELECT * FROM phpdir_media");
  
   /* Display via Array */
$userresult = array();
do {
while ($newestmediarow = mysql_fetch_array($newestmediaresult , MYSQL_ASSOC)) {
$userresult[] = array(
"id" => $newestmediarow['id'],
"name" => $newestmediarow['name'],
"creator" => $newestmediarow['creator'],
"description" => $newestmediarow['description'],
"date" => $newestmediarow['date'],
"views" => $newestmediarow['views'],
"video_type" => $newestmediarow['video_type'],
"pictures" => $newestmediarow['pictures'],
"category" => $newestmediarow['category'],
);

}
}
while (! EOF);
$smarty->assign('userresult', $userresult);
}


/* Display Template */
$smarty->display('media.tpl');
?>

media.tpl

Code: [Select]

{{include file="header.tpl" title=Media}}

<div id="mediawrapper">
{{if $media_approved eq "1"}}
<h1>{{$media_name}}</h1>
<div id="media">
{{include file="players.tpl"}}
</div>
<div id="info">
<img class="media_picture" alt="" src="{{$media_pictures}}" />
<b>ID:</b> {{$media_mediaid}}
<br />
<b>Name:</b> {{$media_name}}
<br />
<b>Creator:</b> {{$media_creator}}
<br />
<div class="clearer"> </div>
<b>Description:</b>
<pre style="white-space: pre-wrap; word-wrap: break-word; height: 250px; overflow: auto;">
{{$media_description}}
</pre>
<br />
<b>Released:</b> {{$media_date}}
<br />
<b>Views:</b> {{$media_views}}
<br />
<b>Source:</b> {{$media_mediatype}}
<br />
<b>Approved:</b> {{$media_approved}}
<br />
<b>Featured:</b> {{$media_featured}}
<br />
<b>Rejected:</b> {{$media_rejected}}
<br />
<b>Category:</b> {{$media_category}}
<br />
<b>File ID:</b> {{$media_file}}
<br />
<b>CreatorIP:</b> {{$media_ip}}
</div>
{{else}}
<h1>Newest Media</h1>
{{foreach from=$userresult key=myid item=newmedia}}
<div class="new_media">
<a href="index.php?id=media&amp;m={{$newmedia.id}}"><img class="new_media_img" alt="{{$newmedia.name}}" src="{{$newmedia.pictures}}" /></a>
<a href="index.php?id=media&amp;m={{$newmedia.id}}">{{$newmedia.name}}</a>
<br />
<b>By:</b> {{$newmedia.creator}}
<br />
<b>Added:</b> {{$newmedia.date}}
<br />
<b>Description:</b>
<br />
{{$newmedia.description|truncate:200:'...'}}
</div>
{{/foreach}}
{{/if}}
</div>
{{include file="footer.tpl"}}

Now on too SmartyPaginate

[winracer]

cool works