Somebody HELP !!!!!!

carefree · July 3, 2007

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

trq · July 3, 2007

The relevent code would help.

carefree · July 4, 2007

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()

{

?>

<tr>

<tr>

<td>

<?

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

{

?>

<tr>

<?

print($_REQUEST['msg']);

?>

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

</tr>

</table>

<?

}//end if

?>

</td>

</tr>

<tr>

</tr>

<tr>

<tr>

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

<?

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

while($rst=mysql_fetch_array($cats))

{

?>

<?

}//end while

?>

</select></td>

</tr>

</table>

</form></td>

</tr>

<tr>

</tr>

<tr>

<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>

<?

$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?>

<tr>

<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>

<tr>

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

</tr>

<tr>

<?

$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?>

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

<? 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

btherl · July 4, 2007

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";
?>

carefree · July 4, 2007

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

sasa · July 4, 2007

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]

carefree · July 4, 2007

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

Sign In

Somebody HELP !!!!!!

Recommended Posts

carefree

Link to comment

Share on other sites

trq

Link to comment

Share on other sites

carefree

Link to comment

Share on other sites

btherl

Link to comment

Share on other sites

carefree

Link to comment

Share on other sites

sasa

Link to comment

Share on other sites

carefree

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information