Sandwich Selector
   

Most Recent  Add A Review

500)) {$maxcount=20;} if ($mincount<=0) {$mincount=1;} mysql_select_db($dbname,$dbh); if ($qsearch) { $query="select * from sandwich where sa_flags&1=1 && "; $qsearch=mysql_escape_string($qsearch); $qsearch=preg_replace('/[ ]and[ ]|[ ]or[ ]|[\|\(\)\&]/i',' ',$qsearch); $terms=split('[ ]+',$qsearch); $first=1; foreach($terms as $term) { if ($first) {$first--;} else {$query.=" && ";} $query.="(sa_contents like '%$term%' || sa_name like '%$term%' || sa_review like '%$term%')"; } $query.=" order by sa_timestamp desc"; $ptitle="Search Results ($qsearch) - "; } elseif (is_int($direct)&&($direct>0)) { $query="select * from sandwich where sa_id=$direct && sa_flags&1=1 "; $ptitle=" Sandwich review number $direct - "; } else { $query="select * from sandwich where sa_flags&1=1 order by sa_timestamp desc"; $ptitle="Sandwich Selector Reviews - "; } if ($result=mysql_query($query)) { $returned=mysql_num_rows($result); } else { $returned=0; } if (!($numpages=ceil($returned/$maxcount))) {$numpages=1;} $curpage=ceil(($mincount/$maxcount)); $ptitle.="Page $curpage of $numpages"; ?>
Search for the Supreme Sausage Sandwich

Editor required. If you understand the need for this site and have a few minutes a day to spare, let us know (submit a review and put your details in the body). Thanks sandwichiers.

About
Sandwich Selector: Add a review!

 
Reviews of sandwiches (pre-packaged, fresh or however you like it). Had a particularly good sandwich recently ? What about a minging sandwich that really sucked ? Send in your review! It's quick, simple and just needs a short description.
Links
0) { $count=0; print("
"); while(($row=mysql_fetch_array($result)) && ($count<($maxcount+$mincount))) { $count++; if ($count<$mincount) {continue;} // borderbox print("\n"); print("
\n"); print("\n"); $nicedate=strftime("%A, %B %d %Y %R",strtotime($row["sa_timestamp"])); $reviewer=$row["sa_reviewer"]; $review=$row["sa_review"]; $review=preg_replace("/\\\\/","",$review); $review=preg_replace("/&/","&",$review); $review=preg_replace("/\n/","
",$review); $contents=$row["sa_contents"]; $contents=preg_replace("/\\\\/","",$contents); $contents=preg_replace("/\n/","
",$contents); $title=$row["sa_name"]; $manufacturer=$row["sa_manufacturer"]; $vendor=$row["sa_vendor"]; $country=$row['sa_country']; $town=$row['sa_town']; print(""); print("\n"); print("
"); print("

$title ($manufacturer)


Vendor: $vendor
Location: "); if ($town) { echo "$town, "; } echo "$country
"; print("$nicedate

Containing: $contents

Review by $reviewer:
$review

"); if (($row["sa_flags"]&2)||(($row["sa_flags"]&4)==0)) { print("
    "); if ($row["sa_flags"]&2) { print("
  • Vegetarian
  • \n"); } if (($row["sa_flags"]&4)==0) { print("
  • No Mayo
  • \n"); } print("
\n"); } $boxw=$lw*10; printf("

Price: £%.2f

",$row["sa_price"]); if (($msgid)&&($direct)) { if (!showmsg($dbh,$dbname,$bd,$msgid)) { print("

Message Not Found

"); } echo("

\n"); if (!$backurl) {$backurl="?vm=".$row[sa_id];} echo("
[ Back ] | "); echo("[ Reply ]"); showthread($msgid,1,0,"&vm=".$row[sa_id]); } else { showthread((-1)*$row[sa_id],1,0,"&vm=".$row[sa_id]); print("

Comment or chat about this sandwich "); print("

\n"); } print(""); print("\n"); print("\n"); print("\n"); print("
Amount of Filling:"); if ($row["sa_filling"]>10) {$row["sa_filling"]=10;} $filling=$row["sa_filling"]*$lw; print("\"-\""); print("".$row["sa_filling"]."/10
Value:"); if ($row["sa_vfm"]>10) {$row["sa_vfm"]=10;} $vfm=$row["sa_vfm"]*$lw; print("\"-\""); print("".$row["sa_vfm"]."/10
Overall:"); if ($row["sa_overall"]>10) {$row["sa_overall"]=10;} $overall=$row["sa_overall"]*$lw; print("\"-\""); print("".$row["sa_overall"]."/10
"); print("
"); print("
"); } print("
"); } else { print("

Sorry, no sandwiches found.

"); } if ($qsearch || $direct) { print("

[ Most Recent Reviews ]

"); } ?>
1) { if (($mc=$mincount-$maxcount)<0) {$mc=1;} echo("[<< Next] "); } if ($returned-$mincount>=$maxcount) { echo("[Previous >>] "); } ?>

 

Most Recent   Add A Review   Back to Veghead   Atom feed   D-SOT 
 

Valid XHTML 1.0 Transitional [Valid Atom]