Desperate need of hep!

hockmasm

My website is having a weird problem.

When a person registers on my page, they can list 1 item for free. But, when that person posts the item, it does not show up in the search engine, or under the catetory listed. (check out www.n2ads.com to see what i mean.) It does, however show up under their Manage Listings page.

Now, what is werid, is if I create a username and password for a member under my site admin, and they go to www.n2ads.com to post an item, everything is fine. It shows up in the search engine and under the category.

I was hoping someone could look at my site to figure out what is wrong with it. I can provide php codes for any page that is necessary. Please tell me what to do to help you all help me. thanks.

halojoy

find out which 1-2-3 pages that does the job
when this thing happen

then post some parts of code you think does the job
of allow 1 list

sounds not impossible we can figure it rather soon
but we not like surfing around the web to check out websites
we need php code here (phpbuilder.com)
from web we can not see anything in PHP (only HTML from the web)

regards
halojoy august 2005
sweden

hockmasm

Here are my php codes for my webpages there are a few. I will start with the registration page, then the RegistrationTemplate that it refers to. Then the Mangage Listings page, then the ManageTemplate it refers to. Then the Add offer page. Then the Search page, and the SearchTemplate page.

    <?
    require_once("conn.php");
    require_once("includes.php");

if(isset($_POST[s1]))
{
    $MyExp = mktime(0,0,0,date(m) + 1, date(d), date(Y));

    $q1 = "insert into re2_agents set
                        username = '$_POST[NewUsername]',
                        AccountType = '$_POST[AccountType]',
                        password = '$_POST[p1]',
                        FirstName = '$_POST[FirstName]',
                        LastName = '$_POST[LastName]',
                        resume = '$_POST[resume]',
                        phone = '$_POST[phone]',
                        cellular = '$_POST[cellular]',
                        pager = '$_POST[pager]',
                        ResumeImages = '$ImageStr',
                        email = '$_POST[email]',
                        RegDate = '$t',
                        ExpDate = '$MyExp',
                        AccountStatus = 'active',
                        offers = '1' ";

    mysql_query($q1);

    if(ereg("key 2", mysql_error()))
    {
        $error = "<font face=verdana size=2 color=red><b>The username <font color=black>$_POST[NewUsername]</font> is already in use!<br>Select another one, please!</b></font>";

        unset($_POST[NewUsername]);
    }
    elseif(ereg("key 3", mysql_error()))
    {
        $error = "<font face=verdana size=2 color=red><b>You are already registered!<br>Update your account, please!</b></font>";

        unset($_POST);
    }
    else
    {
        $last = mysql_insert_id();
        $_SESSION[NewAgent] = $last;

        //send an email
        $to = $_POST[email];
        $subject = "Your registration at $_SERVER[HTTP_HOST]";
        $message = "Hello $_POST[FirstName] $_POST[LastName],\nhere is your login information for $_SERVER[HTTP_HOST]\n\nUsername: $_POST[NewUsername]\nPassword: $_POST[p1]\n\nYou are able to post a free listing. To login, follow this link:\n$site_url/login.php\n\nThank you for your registration!";

        $headers = "MIME-Version: 1.0\n"; 
        $headers .= "Content-type: text/plain; charset=iso-8859-1\n";
        $headers .= "Content-Transfer-Encoding: 8bit\n"; 
        $headers .= "From: $_SERVER[HTTP_POST] <$aset[ContactEmail]>\n"; 
        $headers .= "X-Priority: 1\n"; 
        $headers .= "X-MSMail-Priority: High\n"; 
        $headers .= "X-Mailer: PHP/" . phpversion()."\n"; 

        mail($to, $subject, $message, $headers);

        header("location:login.php");
        exit();
    }

}

if(!empty($_GET[AccountType]))
{
    $AccountType = $_GET[AccountType];
}
else
{
    $AccountType = $_POST[AccountType];
}

//get the templates
require_once("templates/HeaderTemplate.php");
require_once("templates/RegistrationTemplate.php");
require_once("templates/FooterTemplate.php");

?>

hockmasm

RegistrationTemplate:

    <form method=post action="register.php" enctype="multipart/form-data" name=RegForm onsubmit="return CheckRegister();">
    <table align=center width=300>
    <caption align=center>
        <font face=verdana size=2><b>Registration Form</b></font><br>
        <?=$error?></caption>
    <tr>
        <td align=right>Username:</td>
        <td><input type=text name=NewUsername value="<?=$_POST[NewUsername]?>"></td>
    </tr>

<tr>
    <td align=right>Password:</td>
    <td><input type=password name=p1></td>
</tr>

<tr>
    <td align=right>Confirm Password:</td>
    <td><input type=password name=p2></td>
</tr>

<tr>
    <td align=right>First Name:</td>
    <td><input type=text name=FirstName value="<?=$_POST[FirstName]?>"></td>
</tr>

<tr>
    <td align=right>Last Name:</td>
    <td><input type=text name=LastName value="<?=$_POST[LastName]?>"></td>
</tr>

<tr>
    <td align=right>Phone:</td>
    <td><input type=text name=phone value="<?=$_POST[phone]?>"></td>
</tr>

<tr>
    <td align=right>Email:</td>
    <td><input type=text name=email value="<?=$_POST[email]?>"></td>
</tr>

<tr>
    <td>&nbsp;</td>
    <td>
        <input type=hidden name=AccountType value="<?=$_GET[AccountType]?>">
        <input type=submit name=s1 value="Submit">
    </td>
</tr>

</table>
</form>

hockmasm

Manage listings:

    <?
    require_once("conn.php");
    require_once("access.php");
    require_once("includes.php");

if($_SESSION[AccountStatus] == "pending")
{
    header("location:inactive.php");
    exit();
}

//get the user offers
$q1 = "select * from re2_listings where AgentID = '$_SESSION[AgentID]' order by DateAdded desc ";
$r1 = mysql_query($q1) or die(mysql_error());
$rows = mysql_num_rows($r1);

if($rows > '0')
{
    $ListingTable .= "<table align=center width=470 border=1 bordercolor=black frame=hsides rules=rows cellspacing=0>\n";

    while($a1 = mysql_fetch_array($r1))
    {
        $ListingTable .= "<tr onMouseOver=\"this.style.background='#E2E2E2'; this.style.cursor='hand'\" onMouseOut=\"this.style.background='white'\" onClick=\"window.open('info.php?id=$a1[ListingID]', '_top')\">\n\t";

        if($a1[PriorityLevel] > '1')
        {
            //get the priority level name
            $qp = "select PriorityName from re2_priority where PriorityLevel = '$a1[PriorityLevel]' ";
            $rp = mysql_query($qp) or die(mysql_error());
            $ap = mysql_fetch_array($rp);

            $sub = "<span class=RedLink><sup>$ap[0]</sup></span>";
        }
        else
        {
            $sub = "";
        }

        $ListingTable .= "\n\t<td width=15>";

        if(!empty($a1[image]))
        {
            $ListingTable .= "<img src=\"myimages/camera.jpg\" width=15 height=15>";
        }

        $ListingTable .= "</td>\n\t";

        $ListingTable .= "<td width=200><B>$a1[address]</B>$sub</td>\n\t";
        $ListingTable .= "<td width=200>$a1[city], $a1[state], $sub</td>\n\t";

        $MyPrice = number_format($a1[Price], 2, ".", ",");

        $ListingTable .= "</td>\n\t<td align=center width=100><b>$$MyPrice</td>\n";
        $ListingTable .= "</tr>\n";

    }

    $ListingTable .= "</table>";
}

if($rows < $_SESSION[MaxOffers])
{
    $NewOffer = "<font face=verdana size=2>Click <a class=RedLink href=\"PostOffer.php\">here</a> to post a new offer.</font><BR>";
}
else
{
    $NewOffer = "<span class=RedLink>If you want to post more properties, you should update your account!<br>Click <a class=BlackLink href=\"prices.php\">here</a> to continue.</span><bR>";
}

require_once("templates/HeaderTemplate.php");
require_once("templates/ManageListingsTemplate.php");    
require_once("templates/FooterTemplate.php");

?>

hockmasm

Manage listings template:

    <?=$NewOffer?><BR>

<?=$ListingTable?>

hockmasm

AddOffer page:

    <?
    require_once("conn.php");

if(isset($_POST[s1]))
{
    if(!empty($_FILES[images][name][0]))
    {
        while(list($key,$value) = each($_FILES[images][name]))
        {
            if(!empty($value))
            {
                $NewImageName = $t."_offer_".$value;
                copy($_FILES[images][tmp_name][$key], "re_images/".$NewImageName);

                $MyImages[] = $NewImageName;
            }
        }

        if(!empty($MyImages))
        {
            $ImageStr = implode("|", $MyImages);
        }

    }

    $catInfo = explode("|", $_POST[SelectCategory]);
    $CategoryID = $catInfo[0];
    $SubcategoryID = $catInfo[1];

    $q1 = "insert into re2_listings set
                    AgentID = '$_SESSION[AgentID]',
                    CategoryID = '$CategoryID',
                    SubcategoryID = '$SubcategoryID',
                    address = '$_POST[address]',
                    city = '$_POST[city]',
                    state = '$_POST[state]',
                    country = '$_POST[country]',
                    ShortDesc = '$_POST[ShortDesc]',
                    DetailedDesc = '$_POST[DetailedDesc]',
                    Price = '$_POST[Price]',
                    PropertyType = '$_POST[PropertyType]',
                    image = '$ImageStr',
                    DateAdded = '$t' ";

    mysql_query($q1);

}

header("location:manage.php");
exit();

?>

hockmasm

Search page:

    <?
    require_once("conn.php");
    require_once("includes.php");

$query = array();

if(!empty($_GET[c]))
{
    $query[] = "re2_listings.CategoryID = '$_GET[c]' ";
}

if(!empty($_GET[s]))
{
    $query[] = "re2_listings.SubcategoryID = '$_GET[s]' ";
}

if(!empty($_GET[AgentID]))
{
    $query[] = "re2_listings.AgentID = '$_GET[AgentID]' ";
}

if(!empty($_GET[search_country]))
{
    $query[] = "re2_listings.country = '$_GET[search_country]' ";
}

if(!empty($_GET[search_state]))
{
    $query[] = "re2_listings.state = '$_GET[search_state]' ";
}

if(!empty($_GET[search_city]))
{
    $query[] = "re2_listings.city = '$_GET[search_city]' ";
}

if(!empty($_GET[search_PropertyType]))
{
    $query[] = "re2_listings.PropertyType = '$_GET[search_PropertyType]' ";
}

if(!empty($_GET[MinPrice]))
{
    $query[] = "re2_listings.price >= '$_GET[MinPrice]' ";
}

if(!empty($_GET[MaxPrice]))
{
    $query[] = "re2_listings.price <= '$_GET[MaxPrice]' ";
}

if(!empty($_GET[rooms1]))
{
    $query[] = "re2_listings.rooms >= '$_GET[rooms1]' ";
}

if(!empty($_GET[rooms2]))
{
    $query[] = "re2_listings.rooms <= '$_GET[rooms2]' ";
}

if(!empty($_GET[bath1]))
{
    $query[] = "re2_listings.bathrooms >= '$_GET[bath1]' ";
}

if(!empty($_GET[bath2]))
{
    $query[] = "re2_listings.bathrooms <= '$_GET[bath2]' ";
}

if(!empty($_GET[before]))
{
    $MyDate = strtotime("-$_GET[before]");
    $query[] = "re2_listings.DateAdded >= '$MyDate' ";
}

if(!empty($_GET[school]))
{
    $query[] = "re2_listings.NearSchool = 'y' ";
}

if(!empty($_GET[transit]))
{
    $query[] = "re2_listings.NearTransit = 'y' ";
}

if(!empty($_GET[park]))
{
    $query[] = "re2_listings.NearPark = 'y' ";
}

if(!empty($_GET[ocean_view]))
{
    $query[] = "re2_listings.OceanView = 'y' ";
}

if(!empty($_GET[lake_view]))
{
    $query[] = "re2_listings.LakeView = 'y' ";
}

if(!empty($_GET[mountain_view]))
{
    $query[] = "re2_listings.MountainView = 'y' ";
}

if(!empty($_GET[ocean_waterfront]))
{
    $query[] = "re2_listings.OceanWaterfront = 'y' ";
}

if(!empty($_GET[lake_waterfront]))
{
    $query[] = "re2_listings.LakeWaterfront = 'y' ";
}

if(!empty($_GET[river_waterfront]))
{
    $query[] = "re2_listings.RiverWaterfront = 'y' ";
}

if(!empty($query))
{
    $MyQuery = implode(" and ", $query);

    $MyQuery = "and ".$MyQuery;
}


////////////////////////////////////////////////////////////
//////////        order by

$order = array();

if(!empty($_GET[orderby]))
{
    $MyOrder = explode("|", $_GET[orderby]);

    while(list(,$ov) = each($MyOrder))
    {
        if($ov == "DateAdded")
        {
            $order[] = " re2_listings.DateAdded desc ";
        }

        if($ov == "Price")
        {
            $order[] = " re2_listings.Price asc ";
        }

        if($ov == "address")
        {
            $order[] = " re2_listings.address asc ";
        }

    }
}
else
{
    if(!empty($_GET[p]))
    {
        $order[] = " re2_listings.Price asc ";
    }

    if(!empty($_GET[r]))
    {
        $order[] = " re2_listings.rooms asc, re2_listings.bathrooms asc, re2_listings.garage asc ";
    }

    if(!empty($_GET[city]))
    {
        $order[] = " re2_listings.city, re2_listings.address, re2_listings.state ";
    }

}


if(count($order) > '0')
{
    $MyOrder = implode(", ", $order);

}

if(empty($MyOrder))
{
    $MyOrder = " order by re2_agents.PriorityLevel desc, re2_listings.DateAdded desc";
}
else
{
    $MyOrder = " order by re2_agents.PriorityLevel desc, $MyOrder";
}


if(!empty($_GET[Start]))
{
    $Start = $_GET[Start];
}
else
{
    $Start = '0';
}

$ByPage = '20';

$q1 = "select * from re2_listings, re2_agents, re2_priority where re2_listings.AgentID = re2_agents.AgentID and re2_agents.PriorityLevel = re2_priority.PriorityLevel and re2_agents.AccountStatus = 'active' $MyQuery $MyOrder limit $Start, $ByPage ";

$qnav = "select * from re2_listings, re2_agents where re2_listings.AgentID = re2_agents.AgentID $MyQuery";

$r1 = mysql_query($q1) or die(mysql_error());
$lrows = mysql_num_rows($r1);

if($lrows > '0')
{
    $ListingTable .= "<table align=center width=470 border=1 bordercolor=E5E5E6 frame=hsides rules=rows cellspacing=0>\n";

    while($a1 = mysql_fetch_array($r1))
    {
        $ListingTable .= "<tr onMouseOver=\"this.style.background='#E2E2E2'; this.style.cursor='hand'\" onMouseOut=\"this.style.background='white'\" onClick=\"window.open('info.php?id=$a1[ListingID]', '_top')\">\n\t";

        if($a1[PriorityLevel] > '1')
        {
            $sub = "<span class=RedLink><sup>$a1[PriorityName]</sup></span>";
        }

        $ListingTable .= "\n\t<td width=15>";

        if(!empty($a1[image]))
        {
            $ListingTable .= "<img src=\"myimages/camera.jpg\" width=15 height=15>";
        }

        $ListingTable .= "</td>\n\t";

        $ListingTable .= "<td width=200><B>$a1[address]</B>$sub</td>\n\t";
        $ListingTable .= "<td width=200>$a1[city], $a1[state], $sub</td>\n\t";

        $MyPrice = number_format($a1[Price], 2, ".", ",");

        $ListingTable .= "</td>\n\t<td align=center width=100><b>$$MyPrice</td>\n";
        $ListingTable .= "</tr>\n";

    }

    $ListingTable .= "</table>";

        $rnav = mysql_query($qnav) or die(mysql_error());
        $rows = mysql_num_rows($rnav);

            if($rows > $ByPage)
            {
                $ListingTable .=  "<br><table align=center width=510>";
                $ListingTable .= "<td align=center><font face=verdana size=2> | ";

                $pages = ceil($rows/$ByPage);

                for($i = 0; $i <= ($pages); $i++)
                {
                    $PageStart = $ByPage*$i;

                    $i2 = $i + 1;

                    if($PageStart == $Start)
                    {
                        $links[] = " <span class=RedLink>$i2</span>\n\t ";
                    }
                    elseif($PageStart < $rows)
                    {
                        $links[] = " <a class=BlackLink href=\"search.php?Start=$PageStart&c=$_GET[c]&s=$_GET[s]&AgentID=$_GET[AgentID]&search_city=$_GET[search_city]&search_state=$_GET[search_state]&search_country=$_GET[search_country]&search_PropertyType=$_GET[search_PropertyType]&MinPrice=$_GET[MinPrice]&MaxPrice=$_GET[MaxPrice]&rooms1=$_GET[rooms1]&rooms2=$_GET[rooms2]&bath1=$_GET[bath1]&bath2=$_GET[bath2]&before=$_GET[before]&school=$_GET[school]&transit=$_GET[transit]&park=$_GET[park]&ocean_view=$_GET[ocean_view]&lake_view=$_GET[lake_view]&mountain_view=$_GET[mountain_view]&ocean_waterfront=$_GET[ocean_waterfront]&lake_waterfront=$_GET[lake_waterfront]&river_waterfront=$_GET[river_waterfront]&city=$_GET[city]&p=$_GET[p]&r=$_GET[r]\">$i2</a>\n\t ";    
                    }
                }

                $links2 = implode(" | ", $links);

                $ListingTable .= $links2;

                $ListingTable .= "| </td>";

                $ListingTable .= "</table><br>\n";

            }
}
else
{
    $ListingTable = "<br><br><center>No results were found!</center>";
}

require_once("templates/HeaderTemplate.php");
require_once("templates/SearchTemplate.php");    
require_once("templates/FooterTemplate.php");

?>

hockmasm

SearchTempalte page:

    <?=$ListingTable?>