MySQL Error Please Help Me !

HansonHQ

hi everyone i am trying to get my website to show just data from my MySQL database that contain a sirtain string....

i.e.
if put in my url

page.php?abrv=php

php being the data in my abrv field of the database, so i only want to show fields in my database that have got php in the abrv field someone in a support chat room told me to put

if(!stristr($info, $abrv)))
continue;

but it just gave me,

Parse error: parse error in /home/user01/public_html/members/showscripts.php on line 20

now the error has gone i changed

if(!stristr($info, $abrv))) continue;

if(!stristr($info, $abrv)))
continue;

and now i dont have any errors at all but i just dont get ANYTHING whatsoever.

here is the code i have got it currently just searches the database and shows the information in the database with ALL of the categorys from the abrv field.
this can be seen @ http://project.icthost.com (in the members section theres a demo account already setup.)

<?php
//INCLUDE THE CONFIGURATION SCRIPT
$abrv = $_GET["abrv"];
include "config.php";
include("adminconfig.php");
$db = mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db ($db_name) or die ("Cannot connect to database");
$query = "SELECT * FROM php_scripts";
$result = mysql_query($query);
while($r=mysql_fetch_array($result))
{
$id=$r["id"];
$title=$r["title"];
$info=$r["info"];
$abrv=$r["abrv"];
$homepg=$r["homepg"];
$filename=$r["filename"];
$date=$r["date"];
$author=$r["author"];

echo "<table border='1' width='100%' cellspacing='0' cellpadding='0'>
<tr>
<td width='20%' valign='top'><font size='1' face='Verdana'>&nbsp;»Script
Category:<b> $abrv<br>
&nbsp;</b>»Author: <b>$author<br>
&nbsp;</b>»Date Added: <b>$date</b></font></td>
<td width='80%'>
<table border='0' width='100%' cellspacing='0' cellpadding='0'>
<tr>
<td width='100%'>
<table border='0' width='101%' background='/images/titlefill.jpg' cellspacing='0' cellpadding='0'>
<tr>
<td width='3%'><img border='0' src='/images/titleleft.jpg' width='19' height='31'></td>
<td width='82%'>
<p align='center'><font size='2' face='Verdana' color='#FFFFFF'><b> $title</b></font></td>
<td width='17%'>&nbsp;</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width='100%'><font size='2'><b>Description:<br>
</b>$info</font></td>
</tr>
</table>
<table border='0' width='100%' cellspacing='0' cellpadding='0'>
<tr>
<td width='50%'><b><font face='Verdana' size='2'>Homepage: <a href='$homepg'>$homepg</a></font></b></td>
<td width='50%'><font face='Verdana' size='2'><b>Download File: </b><a href='http://www.scriptu.com/scripts/$filename'>$filename</a></font></td>
</tr>
</table>
</td>
</tr>
</table><br>";
}
mysql_close($db);

?>

Anyone who can help it will be MOST appreciated.

WHOEVER HELPS ME OUT GETTING THIS HUGE PROBLEM SORTED I WILL GIVE A FREE HOSTING/RESELLER ACCOUNT AT WWW.ICTHOST.COM,

Thank You,
Gavin Hanson

ICThost Communications LTD
http://www.icthost.com

drew010

you could try a query like this:

$query = "SELECT * FROM php_scripts WHERE abrv = '$abrv'";

i see you have a table called abrv because it is returned in the array from the query.

that query will only return data where the data in abrv field is the same as whats in the url query string.

the problem with
if(!stristr($info, $abrv)))
continue;
is 1. you have three ) but only two (
and 2. continue is used with loop structures like for, while, do, and switch, and has no effect on if statements. (unless that if statement is in a loop, that i just dont see. then it would work)

HansonHQ

hi i kinda understand what you have posted but can you or someone else put it into my code for me please as i aint very good at going through my code and editing it, Thank You anyone who does this for me will get ANY HOSTING SERVICES FROM www.ICThost.com FREE OF CHARGE FOR 1 YEAR

drew010

<?php
//INCLUDE THE CONFIGURATION SCRIPT
$abrv = $_GET["abrv"];
include "config.php";
include("adminconfig.php");
$db = mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db ($db_name) or die ("Cannot connect to database");
$query = "SELECT * FROM php_scripts WHERE abrv = '$abrv'";
$result = mysql_query($query);

the rest should be fine how it is

HansonHQ

nahh it isnt working still....

all i get is a blank page

here is a url to the page...
http://project.icthost.com/members/showscripts.php

this is what i want to be able to do...
http://project.icthost.com/members/showscripts.php?abrv=php

but at the moment all it gives me is a blank page,
here is the code i have currently got...

<?php
//INCLUDE THE CONFIGURATION SCRIPT
$abrv = $_GET["abrv"];
include "config.php";
include("adminconfig.php");
$db = mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db ($db_name) or die ("Cannot connect to database");
$query = "SELECT * FROM php_scripts WHERE abrv = '$abrv'";
$result = mysql_query($query);
while($r=mysql_fetch_array($result))
{
$id=$r["id"];
$title=$r["title"];
$info=$r["info"];
$abrv=$r["abrv"];
$homepg=$r["homepg"];
$filename=$r["filename"];
$date=$r["date"];
$author=$r["author"];
if(!(stristr($info, $abrv_searched)))
continue;
echo "<table border='1' width='100%' cellspacing='0' cellpadding='0'>
  <tr>
    <td width='20%' valign='top'><font size='1' face='Verdana'>&nbsp;»Script
      Category:<b> $abrv<br>
      &nbsp;</b>»Author: <b>$author<br>
      &nbsp;</b>»Date Added: <b>$date</b></font></td>
    <td width='80%'>
      <table border='0' width='100%' cellspacing='0' cellpadding='0'>
        <tr>
          <td width='100%'>
            <table border='0' width='101%' background='/images/titlefill.jpg' cellspacing='0' cellpadding='0'>
              <tr>
                <td width='3%'><img border='0' src='/images/titleleft.jpg' width='19' height='31'></td>
                <td width='82%'>
                  <p align='center'><font size='2' face='Verdana' color='#FFFFFF'><b> $title</b></font></td>
                <td width='17%'>&nbsp;</td>
              </tr>
            </table>
          </td>
        </tr>
        <tr>
          <td width='100%'><font size='2'><b>Description:<br>
      </b>$info</font></td>
        </tr>
      </table>
      <table border='0' width='100%' cellspacing='0' cellpadding='0'>
        <tr>
          <td width='50%'><b><font face='Verdana' size='2'>Homepage: <a href='$homepg'>$homepg</a></font></b></td>
          <td width='50%'><font face='Verdana' size='2'><b>Download File: </b><a href='http://www.scriptu.com/scripts/$filename'>$filename</a></font></td>
        </tr>
      </table>
    </td>
  </tr>
</table><br>";
  }
mysql_close($db);

?>

the database is fine HOWEVER it goes....

id - int - 250 - auto increace - unique
title
abrv
etc are all text

does my abrv have to be a different type of field?

as i said before the purson that helps me sort this problem 100% gets free services @ www.icthost.com

drew010

im not sure if its crashing because of if(!(stristr($info, $abrv_searched)))
I dont see $abrv_searched anywhere. it might be a problem that the variable doesnt exist. I think the page is blank because there is some parse error somewhere in there. toward the top put
ini_set("display_errors", "on");
error_reporting(E_ERROR | E_PARSE);