Jump to content

Somebody HELP !!!!!!

carefree

By carefree
in PHP Coding Help

Recommended Posts

carefree Member

carefree

Posted
Posted

 

Im fairly new to php and ive recently encountered a problem. I dont know the exact term but parts of my site look like this:

 

" class="biglink" >Flash

( 0 resources)

" class="biglink" >CGI and Perl

( 0 resources)

 

" class="biglink" >ASP

( 0 resources)

" class="biglink" >Hosting

( 0 resources)

 

" class="biglink" >JavaScript

( 0 resources)

" class="biglink" >PHP

( 0 resources)

 

" class="biglink" >Linux

( 0 resources)

" class="biglink" >Mac

( 0 resources)

 

" class="biglink" >XML

( 0 resources)

" class="biglink" >Windows

( 0 resources)

 

 

I have an idea this might be a table.sql issue, but if any of you php gurus know where i could start looking i would be forever in your debt!!

 

Let me know what you think

 

Thanks Darryl

Link to comment
https://forums.phpfreaks.com/topic/58241-somebody-help/
Share on other sites
carefree Member

carefree

Posted
  • Author
Posted

The relevent code would help.

 

That was a users view of my site heres the index code view:

 

<?

include_once "config.php";

include_once "left_index.php";

include_once "right_index.php";

function main()

{

?>

<table width="420" border="0" align="center" cellpadding="0" cellspacing="0" dwcopytype="CopyTableCell">

  <tr>

    <td valign="top"> <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">

        <tr>

          <td>

            <?

if ( isset($_REQUEST["msg"])&&$_REQUEST['msg']<>"")

{

?>

            <br> <table align="center" bgcolor="#FEFCFC"  border="0" cellpadding="5" >

              <tr>

                <td><b><font face="verdana, arial" size="1" color="#666666">

                  <?

print($_REQUEST['msg']);

 

?>

                  </font></b></td>

              </tr>

            </table>

            <?

}//end if

?>

          </td>

        </tr>

        <tr>

          <td> </td>

        </tr>

        <tr>

          <td><form name="form2" method="post" action="showcategory.php">

              <table width="100%" border="0" cellspacing="0" cellpadding="2">

                <tr>

                  <td width="17%"><FONT color=#000000><strong><font color="#000000" size="2" >SEARCH</font></strong></FONT></td>

                  <td width="31%"><input type="text" name="keyword"></td>

                  <td width="24%"><select name="cid">

                      <?

  $cats=mysql_query("select * from sbwmd_categories where pid=0");

  while($rst=mysql_fetch_array($cats))

  {

    ?>

                      <option value="<? echo $rst["id"]; ?>"><? echo $rst["cat_name"]; ?></option>

                      <?

}//end while

?>

                    </select></td>

                  <td width="28%"><input type="submit" name="Submit2" value="Go" class="input"></td>

                </tr>

              </table>

            </form></td>

        </tr>

        <tr>

          <td> </td>

        </tr>

        <tr>

          <td><table width="100%" border="0" cellpadding="0" cellspacing="0" bordercolor="#000000">

              <tr>

                <td height="25" background="images/bargb.gif"> <div align="left"><FONT color=#000000><strong> <font color="#FFFFFF" face="Tahoma, Verdana, Arial, Helvetica, sans-serif">    <font color="#000000">Software

                    Categories </font></font></strong></FONT></div></td>

              </tr>

              <tr>

                <td bgcolor="#F3F3F3"><table width="100%" border="0" cellspacing="2" cellpadding="1">

                    <?

  $cats1=mysql_query("select * from sbwmd_categories where pid=0 ");

  $cnt=1;

  while($rst=mysql_fetch_array($cats1))

  {

  if(($cnt%2)==1)

  {

   

  ?>

                    <tr>

                      <? } //end if?>

                      <td width="50%" bgcolor="#FFFFFF" > <table width="100%">

                          <tr>

                            <td width="55"> <img src="images/folder.gif" width="50" height="45"></td>

                            <td> <div align="justify"><font color="#FF0000" size="3">

                                <strong> <a href="showcategory.php?cid=<? echo $rst["id"]?>" class="biglink"?>"  class="biglink" ><? echo $rst["cat_name"]; ?></a>

                                </strong> <font color="#666666" size="1"><br>

                                (

                                <?php

///////////////////////////////////////////////

///////////////////////////////////////////////

/// GENERATE CLIST ////////////////////////////////////////////  

$rst1_query=mysql_query("Select * from sbwmd_categories where pid=" . $rst["id"]);

$clist=$rst["id"];

while ( $rst1=mysql_fetch_array($rst1_query) )

{

$clist.="," . $rst1["id"];

while ( $rst1=mysql_fetch_array($rst1_query) )

{

$clist.="," . $rst1["id"];

}

   

$rst1_query=mysql_query("Select * from sbwmd_categories where pid IN (" . $clist . ") and id not in ( ". $clist . ")") ;

}

/// CLIST GENERATED /////////////////////////////////////////

 

//echo "[" .  $clist . "]";

 

 

$rst1_query=mysql_query("Select count(*)  from sbwmd_softwares where approved='yes' and cid in (" . $clist . ")"  );

$rst1=mysql_fetch_array($rst1_query);

 

$items=$rst1[0]  ;

echo  $items ;  

////////////////////////////////////////////

////////////////////////////////////////////

////////////////////////////////////////////

?>

                                resources)</font></font> </div></td>

                          </tr>

                        </table></td>

                      <? if(($cnt%2)==0)

  {  

  ?>

                    </tr>

                    <? } //end if?>

                    <?

$cnt++;

}//end while

?>

                  </table> </td>

              </tr>

            </table></td>

        </tr>

      </table>

      <p> </p>

      <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" dwcopytype="CopyTableRow">

        <tr>

          <td height="25" background="images/bargb.gif"> <div align="left"><FONT color=#000000><strong><font color="#000000" face="Tahoma, Verdana, Arial, Helvetica, sans-serif">  

               Featured Resources</font></strong></FONT></div></td>

        </tr>

        <tr>

          <td bgcolor="#f3f3f3" ><table width="100%" border="0" cellspacing="2" cellpadding="1">

              <?

  $featured_sites=mysql_query("select * from sbwmd_featuredads ");

  $cnt=0;$num=0;

  while($rst=mysql_fetch_array($featured_sites))

  {

  if(($cnt%2)==1)

  {

  $num++;  

  ?>

              <tr>

                <? } //end if?>

                <td width="100%" bgcolor="#ffffff"> <div align="justify">

                    <a  class="insidelink" href="<? echo $rst["url"]; ?>" target="_blank" ?>" target="_blank"><? echo $rst["name_url"]; ?></a><br>

                    <font color="#666666"> <? echo str_replace("\n","<br>",$rst["fd_desc"]); ?></font></div><BR></td>

                <? if(($cnt%2)==0)

  {  

  ?>

              </tr>

              <? } //end if?>

              <?

$cnt++;

}//end while

?>

            </table></td>

        </tr>

      </table>

      <br>

    </td>

  </tr>

</table>

<?

}// end main

?>

<?

 

include_once "template.php";

?>

 

 

Let me know if you need anything else:)

 

Thanks Darryl

Link to comment
https://forums.phpfreaks.com/topic/58241-somebody-help/#findComment-289308
Share on other sites
btherl Member

btherl

Posted
Posted

Now with highlighting!  (I haven't modified the code, apart from de-shortifying the opening php tags)

 

<?php
include_once "config.php";
include_once "left_index.php";
include_once "right_index.php";
function main()
{
?>
<table width="420" border="0" align="center" cellpadding="0" cellspacing="0" dwcopytype="CopyTableCell">
  <tr>
    <td valign="top"> <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>
          <td>
            <?php
if ( isset($_REQUEST["msg"])&&$_REQUEST['msg']<>"")
{
?>
           
<table align="center" bgcolor="#FEFCFC"   border="0" cellpadding="5" >
              <tr>
                <td><font face="verdana, arial" size="1" color="#666666">
                  <?php
print($_REQUEST['msg']);

?>
                  </font></td>
              </tr>
            </table>
            <?php
}//end if
?>
          </td>
        </tr>
        <tr>
          <td> </td>
        </tr>
        <tr>
          <td><form name="form2" method="post" action="showcategory.php">
              <table width="100%" border="0" cellspacing="0" cellpadding="2">
                <tr>
                  <td width="17%"><FONT color=#000000><strong><font color="#000000" size="2" >SEARCH</font></strong></FONT></td>
                  <td width="31%"><input type="text" name="keyword"></td>
                  <td width="24%"><select name="cid">
                      <?php
           $cats=mysql_query("select * from sbwmd_categories where pid=0");
           while($rst=mysql_fetch_array($cats))
           {
                   ?>
                      <option value="<? echo $rst["id"]; ?>"><? echo $rst["cat_name"]; ?></option>
                      <?php
               }//end while
                ?>
                    </select></td>
                  <td width="28%"><input type="submit" name="Submit2" value="Go" class="input"></td>
                </tr>
              </table>
            </form></td>
        </tr>
        <tr>
          <td> </td>
        </tr>
        <tr>
          <td><table width="100%" border="0" cellpadding="0" cellspacing="0" bordercolor="#000000">
              <tr>
                <td height="25" background="images/bargb.gif"> <div align="left"><FONT color=#000000><strong> <font color="#FFFFFF" face="Tahoma, Verdana, Arial, Helvetica, sans-serif">    <font color="#000000">Software
                    Categories </font></font></strong></FONT></div></td>
              </tr>
              <tr>
                <td bgcolor="#F3F3F3"><table width="100%" border="0" cellspacing="2" cellpadding="1">
                    <?php
           $cats1=mysql_query("select * from sbwmd_categories where pid=0 ");
           $cnt=1;
           while($rst=mysql_fetch_array($cats1))
           {
           if(($cnt%2)==1)
           {   
                  
           ?>
                    <tr>
                      <?php } //end if?>
                      <td width="50%" bgcolor="#FFFFFF" > <table width="100%">
                          <tr>
                            <td width="55"> <img src="images/folder.gif" width="50" height="45"></td>
                            <td> <div align="justify"><font color="#FF0000" size="3">
                                <strong> <a href="showcategory.php?cid=<?php echo $rst["id"]?>" class="biglink"?>"  class="biglink" ><? echo $rst["cat_name"]; ?>[/url]
                                </strong> <font color="#666666" size="1">

                                (
                                <?php
///////////////////////////////////////////////
///////////////////////////////////////////////
/// GENERATE CLIST ////////////////////////////////////////////          
   $rst1_query=mysql_query("Select * from sbwmd_categories where pid=" . $rst["id"]);
   $clist=$rst["id"];
   while ( $rst1=mysql_fetch_array($rst1_query) )
   {
    $clist.="," . $rst1["id"];
   while ( $rst1=mysql_fetch_array($rst1_query) )
   {
   $clist.="," . $rst1["id"];
   }
   
   $rst1_query=mysql_query("Select * from sbwmd_categories where pid IN (" . $clist . ") and id not in ( ". $clist . ")") ;
}
/// CLIST GENERATED /////////////////////////////////////////

//echo "[" .  $clist . "]";


$rst1_query=mysql_query("Select count(*)  from sbwmd_softwares where approved='yes' and cid in (" . $clist . ")"   );
$rst1=mysql_fetch_array($rst1_query);

$items=$rst1[0]  ;
echo  $items ;       
////////////////////////////////////////////
////////////////////////////////////////////
////////////////////////////////////////////
?>
                                resources)</font></font> </div></td>
                          </tr>
                        </table></td>
                      <?php if(($cnt%2)==0)
           {          
           ?>
                    </tr>
                    <?php } //end if?>
                    <?php
            $cnt++;
            }//end while
            ?>
                  </table> </td>
              </tr>
            </table></td>
        </tr>
      </table>
      <p> </p>
      <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" dwcopytype="CopyTableRow">
        <tr>
          <td height="25" background="images/bargb.gif"> <div align="left"><FONT color=#000000><strong><font color="#000000" face="Tahoma, Verdana, Arial, Helvetica, sans-serif">  
               Featured Resources</font></strong></FONT></div></td>
        </tr>
        <tr>
          <td bgcolor="#f3f3f3" ><table width="100%" border="0" cellspacing="2" cellpadding="1">
              <?php
           $featured_sites=mysql_query("select * from sbwmd_featuredads ");
           $cnt=0;$num=0;
           while($rst=mysql_fetch_array($featured_sites))
           {
           if(($cnt%2)==1)
           {   
           $num++;       
           ?>
              <tr>
                <?php } //end if?>
                <td width="100%" bgcolor="#ffffff"> <div align="justify">
                    <a   class="insidelink" href="<?php echo $rst["url"]; ?>" target="_blank" ?>" target="_blank"><? echo $rst["name_url"]; ?>[/url]

                    <font color="#666666"> <?php echo str_replace("\n","
",$rst["fd_desc"]); ?></font></div><BR></td>
                <?php if(($cnt%2)==0)
           {          
           ?>
              </tr>
              <?php } //end if?>
              <?php
            $cnt++;
            }//end while
            ?>
            </table></td>
        </tr>
      </table>
     

    </td>
  </tr>
</table>
<?php
}// end main
?>
<?php

include_once "template.php";
?>

Link to comment
https://forums.phpfreaks.com/topic/58241-somebody-help/#findComment-289319
Share on other sites
carefree Member

carefree

Posted
  • Author
Posted

The site is http://www.simple-scripts-online.com if you want a visual view of whats happening. 

 

In html when code isnt closed aka:

 

<form id ="simple"

 

It displays this as "visual" text not hidden code, would this be the andswer with php??

 

 

Any help would be greatly appreciated

 

Thanks Darryl

Link to comment
https://forums.phpfreaks.com/topic/58241-somebody-help/#findComment-289389
Share on other sites
carefree Member

carefree

Posted
  • Author
Posted 

change line[code]<strong> <a href="showcategory.php?cid=<? echo $rst["id"]?>" class="biglink"?>"  class="biglink" ><? echo $rst["cat_name"]; ?></a>

to<a href="showcategory.php?cid=<? echo $rst["id"]?>" class="biglink"><? echo $rst["cat_name"]; ?></a>[/code]

 

 

Thankyou sooooooooooooooooooo Much, you fixed it !!!! check it out now its all clean:) http://www.simple-scripts-online.com

 

 

You are a true Guru!!

 

Thanks Darryl

Link to comment
https://forums.phpfreaks.com/topic/58241-somebody-help/#findComment-289419
Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.