 |
|
$database="protips";
$Client_ID=1;
$tiptype="Golf";
$file="golf.html";
>
if($viewTip_ID=="");
$query="Select DISTINCT pro.Pro_ID,pro.Client_ID,pro.Name,pro.Photo_URL,tips.Pro_ID from pro,tips where pro.Client_ID=$Client_ID and tips.tiptype='$tiptype' and tips.Pro_ID=pro.Pro_ID";
$select=msql($database,$query);
$row=0;
$rows=msql_numrows($select);
>
if($rows == 0)>
Sorry,
No echo $tiptype> Tips available at this time...
else>
while($row<$rows);
$Pro_ID=msql_Result($select,$row,"Pro_ID");
>
$row++;
endwhile;
endif;
endif;
if($viewTip_ID != "");
>
$query="Select * from pro where Pro_ID=$Pro_ID";
$select=msql($database,$query);
>
/* Use the tags below to define the qualities of the table */
$TableBorderColor="#000000";
$TableShadowColor="#808080";
$TableBodyColor="#FFFFFF";
$TableWidth=425;
$TableHeight=60;
$TableHeaderHeight=30;
$Blah=$TableHeaderHeight / 2;
$TableBodyHeight=($TableHeight - $TableHeaderHeight - 5);
$TableBodyWidth=$TableWidth - $TableShadowSize - 12;
$TableShadowSize = "5";
$LabelColor = "#FFFFFF";
>
 |
 |
$query="Select tiptitle,tiptext from tips where Tip_ID=$viewTip_ID";
$select2=msql($database,$query);
$tiptext = msql_result($select2,0,"tiptext");
>
echo msql_result($select2,0,"tiptitle");>
|
 |
 |
 |
 |
 |
echo $tiptype> Tip by $pro=msql_result($select,0,"Name"); echo $pro>
Click here
to learn more about echo $pro>
$photo=msql_Result($select,0,"Photo_URL");
if($photo != "");
echo " ";
endif;
>
$paragraph=ereg_replace("013"," ",$tiptext);
echo $paragraph;
>
|
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
$query="Select * from tips where Pro_ID=$Pro_ID and Client_ID=$Client_ID and tiptype='$tiptype' and Tip_ID <> $viewTip_ID";
$select2=msql($database,$query);
$tiprow=0;
$tiprows=msql_numrows($select2);
if($tiprows > 0);
>
endif> endif>
|
|