Jump to content

jasonc

Members
 View Profile  See their activity

  • Posts

    860

  • Joined

  • Last visited

 Content Type 

Posts posted by jasonc

    find out if they use frames

    in PHP Coding Help

    Posted

    ok i have now done the following to test if someone was using frames to view one of my pages.

     

    these are the scripts i have and the script that may be on what site they may be trying to cheat the site voting.

     

    say this file is on my site which will be used to find out if they are cheating....

    called votepage.php

    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>vote page<br>
<?
$info = $_SERVER['HTTP_HOST'].'<br>'.$_SERVER['PHP_SELF'];
echo($info);
?>
</body>
</html>

     

    and these files are on the cheats site using a framed method to hide the frame that will cheat my site voting...

    say called 

    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN" "http://www.w3.org/TR/html4/frameset.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<frameset rows="*,150" frameborder="NO" border="0" framespacing="0">
  <frame src="their own page-top-frame.php" name="mainFrame">
  <frame src="http://www.mysite.com/test/votepage.php?s=123" name="bottomFrame" scrolling="NO" noresize>
</frameset>
<noframes><body>

</body></noframes>
</html>

     

    i have not added a page for their top page, but the frames and my page on my site are the files needed to hopefully help someone in solving this problem i have.

     

    now if this was done it will mean that when anyone visited their site with these cheat files using the framed method it will increase the counters on my site who ever looked at 'their' site as the ip will be different for they visitors it will fool my site into thinking it is someone else which it is, but they are not actually looking at my site to make the vote.

     

    also for some reason the file votepage.php on my site that should detect if they are cheating does not show the url of the file that requested the file on my site. it is showing the url of my site and not theirs!  which is what i need to help workout if the cheated.

     

     

    please help

    find out if they use frames

    in PHP Coding Help

    Posted

    thanks for the code you gave.

     

    not sure how it will help as this only gives my the sites url and the file the script was run in.

     

    unless i somehow check the php_self to see if it contains    <frame>    ?

     

     

     

    i have a social bookmarking site and want to have a competition.

     

    the most clicks wins a prize.

     

    some links are shown on other site and we get the click-backs.

     

    www.site.com?siteid=123

     

    this is what the links look like on our site.

     

    i have had problems in the past with frames messing up voting scripts i wrote so need to get something as fully proof as possible.

     

    so when a visitor click the link on our site or via another social bookmarking site the counter for that link goes up!

     

    problem.....

    member adds a link, if this link gets the most hits they win. i have an ip checker i added to counter scripts so only unique hits count, or until the ip drops off the list of recent visitors.

     

    but..... if this member adds a hidden frame on another bookmarking site which views this page the hits goes up as it seems like the page was visited properly, and also the ip is different each time another person views his non-related page, which of course it was not. as i have a cheat.

     

    how do i solve this....

     

    javascript is not an option as it can be turned off.

    cookies too as this can be disabled or removed to allow further visits and increased hits.

     

    i am at a loss as to how i do this.

    find out if they use frames

    in PHP Coding Help

    Posted

    i am starting a competition but have hit a snag

     

    any visitors (not members) click links and this increases the hits for that link on our site.

    but if say someone was to put this link to open in a hidden 'frame' on they site it would then seem like it was viewed by the person that view the other frame of that page.

    meaning that the hits would be false !

     

    what i would like to do is know if the page was viewed inside a frame?

     

    how can this be done please.

     

     

    thanks

    changing content of a div via another div that has menu items

    in HTML Help

    Posted

    i wish to have two divs a left and right and a top and bottom frame and when the menu items in the left menu is clicked it changes the content of the center div to display the contents related to the hyperlink clicked.

     

    how can i do this please without having the whole page reloaded.

     

    thanks

     

     

    <div id="Layer1" style="position: absolute; left: 12px; top: 14px; width: 639px; height: 21px; z-index: 1; vertical-align: middle"><div align="center">header</div></div>
<div id="Layer2" style="position: absolute; left: 12px; top: 37px; width: 105px; height: 21px; z-index: 2; vertical-align: middle">
  <div align="center">menu</div>
</div>
<div id="Layer3" style="position: absolute; left: 121px; top: 37px; width: 531px; height: 21px; z-index: 3; vertical-align: middle">
<div align="center">main page</div></div>

     

    please help convert tables to CSS

    in CSS Help

    Posted

    i have this last piece of code to convert, please can someone tell me the correct way to code this in CSS.

     

    thank you

     

     

    #index-container {
border: 1px solid #fff;
background: #507bcd;
}

#index-content {
margin: 8px;
}

<table width="319" align="center" style="border-collapse:collapse;">
  <tr>
    <td width="311" height="126" valign="top" bgcolor="#000000">
      <table width="100%" cellpadding="8" style="border-collapse:collapse;">
        <tr>
          <td valign="top">
              <div align="center" id="index-container">
                    <div>a</div>
              </div>
           </td>
          <td rowspan="3" valign="top" nowrap>b</td>
        </tr>
      </table>
    </td>
  </tr>
</table>

    alternatives to mail() ?

    in PHP Coding Help

    Posted

    I have been using the mail() command for some time but recently my host is turning this feature off so the 'nobody@...' does not send emails out from server!

     

    I have a members section on my community site and need to have their details sent out when they join the forums, but due to the feature being turned off they do not get it.

     

    Is there another method to send emails out via the server that does not require the mail() or nobody@.. feature?

     

    thanks

    emails not getting to members when using mail()

    in PHP Coding Help

    Posted

    some of our members are able to get email when i uses the email address in the from_email variable using outlook express but not when it is sent via the server/website.

     

    the email text variable contains full html, <html>blah<head>blah</head><body>blah</body></html>

     

    the email address being sent to has been checked in the databases and even removed and typed manually to be sure no strange characters are there and still it does not work.

     

    is the following code the correct way to send it?

     

    thanks in advance for your help.

     

    $email_headers = "Content-Type: text/html; charset=ISO-8859-1\r\nFrom: ".$from_email."\r\n";

mail("$email","Thank you for signing up to ".$sitename, $emailtext, $email_headers);

    placing image using CSS

    in CSS Help

    Posted

    this is the html code, but for some reason the css has to be in a separate file i tried to add it but the page did not show correctly. so i have included both files here..

     

    what i am trying to get is the image to be above all the text (not overlapping) and in the same place, top right of the box.

     

    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" type="text/css" href="csscode.css">
</head>
<body bgcolor="#000000">
<table width="100%">
  <tr> 
    <td> <div class="containercolour2"> <b class="rtopcolour2"><b class="r1"></b><b class="r2"></b><b class="r3"></b><b class="r4"></b></b><font size="2" color="#000000" face="Tahoma"> 
        <div class="right"> <a href="?i=1" target="_top"><font color="#FFFFFF" size="2" face="Tahoma">comments</font></a> 
          <font size="2">(</font> 1 <font size="2">)</font>        
          (27 clicks)</div>
        </font> <a class="two" href="?i=1" target="_blank">  
        <h1>play the drums</h1><img src="images/noimage.gif" width="100" class="floatRight">
        </a> <font size="2" color="#FFFFFF" face="Tahoma">16-01-2008</font> <font size="2" color="#FFFFFF" face="Tahoma"> 
        By blahblah(10)</font> <b class="rbottomcolour2"><b class="r4"></b><b class="r3"></b><b class="r2"></b><b align="right"></b></b></div></td>
  </tr>
</table>
</body>
</html>

     

    .containercolour1 {
position:relative;
background:#799BD9;
margin:0 5px;
top: 2432px;
left: 67px;

}
.rtopcolour1, .rbottomcolour1{ display:block; background:#507BCD; }
.rtopcolour1 *, .rbottomcolour1 *{ display: block; height: 1px; overflow: hidden; background:#799BD9; }

.containercolour2 {
position:relative;
background:#325EAF;
margin:0 5px;
left: 110px;
top: 187px;

}
.rtopcolour2, .rbottomcolour2{ display:block; background:#507BCD; }
.rtopcolour2 *, .rbottomcolour2 *{ display: block; height: 1px; overflow: hidden; background:#325EAF; }

.r1{ margin: 0 5px}
.r2{ margin: 0 3px}
.r3{ margin: 0 2px}
.r4{ margin: 0 1px; height: 1px }
a.one:link { color: #000; }
a.one:visited { color: #000; }
a.one:hover { color: #999999; }
a.one:active { color: #000; }
a.one { text-decoration: none; }
a.two:link { color: #000; }
a.two:visited { color: #000; }
a.two:hover { color: #fff; }
a.two:active { color: #000; }
a.two { text-decoration: none; }
h1 { text-align: left; font: small tahoma; font-size: 12px; font-weight: bold; margin: 0 0; padding: 5; }
h2 { text-align: left; font: small tahoma; font-size: 12px; font-weight: bold; margin: 0 5; padding: 5; }
img.floatLeft { float: left; margin-top: 0px; margin-right: 10px; margin-bottom: 10px; margin-left: 3px; }
img.floatRight { float: right; margin: 15px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 3px; }
.right {
position:absolute;
bottom:4;
right:6;
left: 5px;
top: 80px;

}
.floatright { float: right; margin: 0px 0px 0px 2px; }

    can upload but not delete files

    in PHP Coding Help

    Posted

    i am able to upload files but when it comes to deleting them it does not work.

     

    i look at the html source code before i submit or delete and all looks ok, but i echo the file name and it contains an  _  (underline) in place of the .  before the extention

     

    can anyone suggest what i could be doing wrong

     

    <?
$uploaddir = "/home/mysite/public_html/images/";
include("dbconfigfile.php");
if ($_POST['d'] == "1") {
foreach($_POST as $key => $val) {
if ($key != "*.*" && $key != "*" && $key != "d") {
// delete file name only from images-filename, but... if the imagelocation is empty then delete the whole entry line from DB.
//delete file from folder if exists !
unlink($uploaddir . $key);
echo($uploaddir . $key."<br><br><br><br>");
echo($key.' Deleted<br>');
mysql_query("DELETE FROM `images` WHERE `filename` ='" . $key . "' LIMIT 1;") or die(mysql_error());
}
}
echo("files are not really deleted yet, still working on it.");
} else {
?><p align="center">Please note that if you upload a file with the same name as another file you have uploaded, this new file will over write the old file.</p><p align="center">Your Existig Files...</p><p align="center">
<? $dh = opendir($uploaddir);
?><form name="form1" method="post" action=""><input name="d" type="hidden" value="1"><?
while (false !== ($filename = readdir($dh))) {
$ext = getFileExtension($filename);
if(in_array($ext, $allowed)) {
?><input type="submit" name="<?=$filename;?>" value="DELETE"> <?=$filename;?><br><?
}
}
?></form></p>
<form action="" method="POST" enctype="multipart/form-data">
<table width="444" height="218" border="1" align="center">
<tr align="center">
<td height="152" colspan="2">
<? if(isset($_REQUEST['submit']) && $_FILES['imgfile']['name'] != "") {
$file = $_FILES['imgfile']['name']; $tmp_file = $_FILES['imgfile']['tmp_name']; $size = $_FILES['imgfile']['size'];
$upload = $uploaddir . $file; $ext = getFileExtension($file);
if(!in_array($ext, $allowed)) { echo "ERROR: Invalid file extension.";
} elseif (move_uploaded_file($tmp_file, $upload)) {
// set info about image in mysql
$update = mysql_query("INSERT INTO `images` (`imagelocation` , `filename`, `uploadedby`) VALUES ('', '" . $file . "', '" . $_SESSION['adminusername'] . "')") or die(mysql_error());
echo $file."<br>Upload successfully!<br>";
} else { echo "Image upload failed.";
}
} else { echo("No file uploaded");
} ?>
</td>
</tr>
<tr><td height="28" colspan="2"><div align="right"><input type="file" name="imgfile"><input type="hidden" name="MAX_FILE_SIZE" value="20000"></div></td></tr>
<tr><td width="372" height="28"><p>.doc .gif .jpg .wma .mp3 .pdf .ppt .pub .rtf .txt .zip      only</p></td><td width="56"><input name="submit" type="submit" value="Upload"></td></tr>
</table>
</form>
<? }
} ?>

    How to stop contents of a form being re-submitted when user refreshes

    in PHP Coding Help

    Posted

    ok i have created from scratch a message board.

     

    first off.... when i click the only topic you have i get the following error...

     

    Parse error: syntax error, unexpected T_VARIABLE, expecting '(' in /home/fhlinux159/m/mannyroadend.co.uk/user/htdocs/viewthread.php on line 28

     

    if you fix this error then i'll be able to help a bit more later on.

     

    as for solving your issue with double postings, you will need to do a check for the post that has come in and then see if the username and the topic and any other info posted is the same as that already in the database before it is processed and added to the DB.

     

     

    in your message board.php, add a new IF statement after the variables are set with incoming data.

    to see if this info exists, if it does not then allow it to be added to the DB

     

    if data exisits then perform error message that the submit, refresh was done and do not add to DB.

     

    i have also added a new field to the user table in the DB so if members do this many time they get a double post 'hit' like a counter and when it reaches 10 they get a polite email telling them to change their ways, then counter resets and starts again!

     

    hope this helps

     

     

    ps.  i have been told this too recently, you should never trust user input in forms, you need to do some checks before it is added to the DB, someone may oneday perform a 'MySQL injection' google it to find out more.

     

     

    upload works but can not delete file due to spaces.. i think

    in PHP Coding Help

    Posted

    thanks

     

    i have taken a look at php.net/mysql_real_escape_string

     

    not real sure what i am doing in this case using mysql_real_escape_string

     

    i have data posted and just placed straight into the database seems this is not the way to do it?

     

    if i am right i have to use this to place the data in and again use it to verify that the data in the database is the same as what i am looking for?

     

     

    INSERT INTO `stuff` (`field1`, `field2`) VALUES ('mysql_real_escape_string($data1)', 'mysql_real_escape_string($data2));

     

    then

     

    SELECT * from `stuff` WHERE `field1` = 'mysql_real_escape_string($data1)');

     

     

    ?

    upload works but can not delete file due to spaces.. i think

    in PHP Coding Help

    Posted

    the following code for some reason puts a _ in place of the .

     

    the files in the directory are named ok, file1.jpg file2.jpg and so on.

     

    the source code prior to clicking the delete button shows all the files correctly formed.

     

    the uploaddir is also correct. just the . being changed to a _

     

    why would that be?

     

    this is my upload and delete file.

     

     

    <?

    $uploaddir = "/home/mysite/public_html/images";

    include("dbconfigfile.php");

    if ($_POST['d'] == "1") {

    foreach($_POST as $key => $val) {

    if ($key != "*.*" && $key != "*" && $key != "d") {

    // delete file name only from images-filename, but... if the imagelocation is empty then delete the whole entry line from DB.

    //delete file from folder if exists !

    unlink($uploaddir . $key);

    echo($uploaddir . $key."<br><br><br><br>");

    echo($key.' Deleted<br>');

    mysql_query("DELETE FROM `images` WHERE `filename` ='" . $key . "' LIMIT 1;") or die(mysql_error());

    }

    }

    echo("files are not really deleted yet, still working on it.");

    } else {

    ?><p align="center">Please note that if you upload a file with the same name as another file you have uploaded, this new file will over write the old file.</p><p align="center">Your Existig Files...</p><p align="center">

    <? $dh = opendir($uploaddir);

    ?><form name="form1" method="post" action=""><input name="d" type="hidden" value="1"><?

    while (false !== ($filename = readdir($dh))) {

    $ext = getFileExtension($filename);

    if(in_array($ext, $allowed)) {

    ?><input type="submit" name="<?=$filename;?>" value="DELETE"> <?=$filename;?><br><?

    }

    }

    ?></form></p>

    <form action="" method="POST" enctype="multipart/form-data">

    <table width="444" height="218" border="1" align="center">

    <tr align="center">

    <td height="152" colspan="2">

    <? if(isset($_REQUEST['submit']) && $_FILES['imgfile']['name'] != "") {

    $file = $_FILES['imgfile']['name']; $tmp_file = $_FILES['imgfile']['tmp_name']; $size = $_FILES['imgfile']['size'];

    $upload = $uploaddir . $file; $ext = getFileExtension($file);

    if(!in_array($ext, $allowed)) { echo "ERROR: Invalid file extension.";

    } elseif (move_uploaded_file($tmp_file, $upload)) {

    // set info about image in mysql

    $update = mysql_query("INSERT INTO `images` (`imagelocation` , `filename`, `uploadedby`) VALUES ('', '" . $file . "', '" . $_SESSION['adminusername'] . "')") or die(mysql_error());

    echo $file."<br>Upload successfully!<br>";

    } else { echo "Image upload failed.";

    }

    } else { echo("No file uploaded");

    } ?>

    </td>

    </tr>

    <tr><td height="28" colspan="2"><div align="right"><input type="file" name="imgfile"><input type="hidden" name="MAX_FILE_SIZE" value="20000"></div></td></tr>

    <tr><td width="372" height="28"><p>.doc .gif .jpg .wma .mp3 .pdf .ppt .pub .rtf .txt .zip      only</p></td><td width="56"><input name="submit" type="submit" value="Upload"></td></tr>

    </table>

    </form>

    <? }

    } ?>

    [SOLVED] trying to create a top ten members list who have posted the most.

    in MySQL Help

    Posted

    I have created my own forum but wish to have a top ten list of members who have posted the most on my home page.

     

    i have a field called 'username' which i want to count and then work out which member shows the most and then have it shown first then each in turn to the one who has posted the least till i have either all members shown if less then ten or just the first ten.

     

    can this be done using mysql coding or would i have to use the 'username' from the members signup database table and find each member in turn and count the number of posts made and then sort this list to get the list i need?

     

     

    thanks in advance for your help

    RSS - change the way links are shown.

    in Third Party Scripts

    Posted

    i have been told that RSS can not be changed that there is just one format of displaying the links and the info and only in that order.

     

    i am trying to get the link to show like a normal link would

     

    <a target="_blank" href="http://website.com">this is my site</a>

     

    at the moment it shows the link then the description two lines after it.

     

    which is a little confusing.

     

    is it possible to do this ?

     

    this is what code i currently have...

     

     

     

     

    <?

    echo("<?xml version=\"1.0\" encoding=\"ISO-8859-1\" ?>\n");

    ?>

    <rss version="2.0">

    <channel>

    <ttl>0</ttl>

    <title>Welcome to our RSS Feed</title>

    <link>http://website.com</link>

    <description>RSS Feed</description>

    <language>en-us</language>

    <pubDate><?=gmdate("D, d M Y H:i:s \G\M\T");?></pubDate>

    <lastBuildDate><?=gmdate("D, d M Y H:i:s \G\M\T");?></lastBuildDate>

    <generator>OnTheFly</generator>

    <image>

    <title><?=$sitename;?></title>

    <url>http://<?=$siteurl;?>/images/sitelogo.png</url>

    <link>http://<?=$siteurl;?>?s=rssimg</link>

    <width>88</width>

    <height>31</height>

    </image>

    <?php while ($result = mysql_fetch_assoc($resultset)) {

    echo(" <item>\n");

    echo(" <title><![CDATA[$result]]></title>\n");

    echo(" <link>http://$siteurl/?v=$result[id]&h=r</link>\n");

    //echo(" <pubDate>$result[submitgmtdatetime]</pubDate>\n");

    echo(" <description>$result[desc]</description>\n");

    echo(" </item>\n\n");

    } ?>

    </channel>

    </rss>

    on hover expand menu

    in CSS Help

    Posted

    I have copied the code from the following site

    www.fish4jobs.co.uk

     

    after you have done a search say 'admin' you get the results.

     

    near the top you have a RSS feed you can click.

     

    it is this code that i want to use.

     

    i have copied the code but i have not got the 'popup' class

     

    i have looked all around but can not seem to find it.

     

    please can someone take a look and see if they have better luck as i am still new to css.

     

    or has anyone got a css popup class that would work with the following code i have already got so far.

     

     

    thanks in advance for your help.

     

     

     

    <div style="float:right;">

     

     

     

    <div id="rss">

    <a href="/iad/rss?SearchId=SEARCH_ID_JOBS&Keyword=admin&Number_Of_Days=0&I1=0&I10=20&LoginId=-1&createdTime=1197625434383&chk=786db34786ea2085ad557beb3d55a3c0"><img src="http://assets.fish4.co.uk/live/images/rss/rss.gif" alt="RSS" id="rss" /></a>

    <div id="rssmenu" style="background:#ec5502 url(http://assets.fish4.co.uk/live/image...background.jpg) repeat-x;">

    <p><a href="/iad/rss?SearchId=SEARCH_ID_JOBS&Keyword=admin&Number_Of_Days=0&I1=0&I10=20&LoginId=-1&createdTime=1197625434383&chk=786db34786ea2085ad557beb3d55a3c0" style="background-image:url(http://assets.fish4.co.uk/live/image...nd-position:2% 50%;background-repeat:no-repeat;">Subscribe to results feed</a><p>

     

    <p><a href="/iad/info/rss" class="popup" style="background-image:url(http://assets.fish4.co.uk/live/image...nd-position:2% 50%;background-repeat:no-repeat;">What is RSS?</a></p>

    <ul>

    <li><a href="http://my.msn.com/addtomymsn.armx?m=1&id=rss&ut=http%3A%2F%2Fwww.fish4.co.uk%2Fiad%2Frss%3FSearchId%3DSEARCH_I D_JOBS%26Keyword%3Dadmin%26Number_Of_Days%3D0%26I1%3D0%26I10%3D20%26LoginId%3D-1%26createdTime%3D1197625434383%26chk%3D786db34786ea2085ad557beb3d55a3c0" class="add" style="background-image:url(http://assets.fish4.co.uk/live/image...nd-position:2% 50%;background-repeat:no-repeat;">Add to MSN</a></li>

    <li><a href="http://e.my.yahoo.com/config/cstore?.opt=content&.url=http%3A%2F%2Fwww.fish4.co.uk%2Fiad%2Frss%3FSearchId%3DSEARCH_ID_JOBS%26 Keyword%3Dadmin%26Number_Of_Days%3D0%26I1%3D0%26I10%3D20%26LoginId%3D-1%26createdTime%3D1197625434383%26chk%3D786db34786ea2085ad557beb3d55a3c0" class="add" style="background-image:url(http://assets.fish4.co.uk/live/image...nd-position:2% 50%;background-repeat:no-repeat;">Add to Yahoo!</a></li>

    <li><a href="http://www.bloglines.com/sub/http://www.fish4.co.uk/iad/rss?SearchId=SEARCH_ID_JOBS&Keyword=admin&Number_Of_Days=0&I1=0&I10=20&LoginId=-1&createdTime=1197625434383&chk=786db34786ea2085ad557beb3d55a3c0" class="add" style="background-image:url(http://assets.fish4.co.uk/live/image...nd-position:2% 50%;background-repeat:no-repeat;">Add to Bloglines</a></li>

    <li><a href="http://www.google.com/ig/add?feedurl=http%3A%2F%2Fwww.fish4.co.uk%2Fiad%2Frss%3FSearchId%3DSEARCH_ID_JOBS%26Keyword%3Dadmin%2 6Number_Of_Days%3D0%26I1%3D0%26I10%3D20%26LoginId%3D-1%26createdTime%3D1197625434383%26chk%3D786db34786ea2085ad557beb3d55a3c0" class="add" style="background-image:url(http://assets.fish4.co.uk/live/image...nd-position:2% 50%;background-repeat:no-repeat;">Add to Google</a></li>

    <li><a href="http://www.newsgator.com/ngs/subscriber/subext.aspx?url=http%3A%2F%2Fwww.fish4.co.uk%2Fiad%2Frss%3FSearchId%3DSEARCH_ID_JOBS%26Keyword%3Dadm in%26Number_Of_Days%3D0%26I1%3D0%26I10%3D20%26LoginId%3D-1%26createdTime%3D1197625434383%26chk%3D786db34786ea2085ad557beb3d55a3c0" class="add" style="background-image:url(http://assets.fish4.co.uk/live/image...nd-position:2% 50%;background-repeat:no-repeat;">Add to Newsgator</a></li>

     

    </ul>

    </div>

    </div>

    </div>

    [SOLVED] search results not what they should be

    in MySQL Help

    Posted

    Why the collation stuff?

     

    i thought i'd try something and use the code produced by phpmyadmin.

     

    i also copied the full code into my scripts leaving the word i was searching for in the code too, and not having what was put in the form added to the code.

     

    and still the same thing, the wrong results.

     

    so this rules out POST sending the wrong info to the database.

    [SOLVED] search results not what they should be

    in MySQL Help

    Posted

    all information is correct, apart from that, being that i forgot to change the sites to info but the script is still the same otherwise.

     

    i created copies of the scripts and have been using them to test the scripts out.

     

    i also created copies of the data too, and have been using the copies which is called 'info'

     

    sorry for any confusion.

     

     

    [SOLVED] search results not what they should be

    in MySQL Help

    Posted

    searching for 'and' returns of all these results...  (all results shown)

     

    Click Monkeys - Google's arch enemies I'm guessing

    Coathanger Bench

    Tapedeck.Org - Celebrating the gentle art of the cassette tape

    Offensive Drawings - NSFW, as an artist draws the rude thing but then changes into something safe

    Best Crappy Stuff

    Kinetic Energy - Energy saving household items

    National Lampoon Covers - I loved NatLamp and just sold my collection from 1984

     

     

     

     

     

    searching for 'but' returns of all these results...  (all results shown)

     

    Click Monkeys - Google's arch enemies I'm guessing

    Coathanger Bench

    Tapedeck.Org - Celebrating the gentle art of the cassette tape

     

     

     

     

     

    searching for 'rat' returns of all these results...  (all results shown)

     

    Click Monkeys - Google's arch enemies I'm guessing

     

     

     

     

     

    it has been suggested that the DB could be corrupt or something so i done an 'optimise' but do not know how i check for bugs that could be causing the results to be wrong.

     

    also if i search for words that are not in the DB at all i get no results as expected.

     

     

     

×
×
  • 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.