Can you fix this?

[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 and register 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.

Here are my php codes for my webpages.

register 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");

?>

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>

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

?>

Manage listings template:

    <?=$NewOffer?><BR>

<?=$ListingTable?>

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]

Here is the rest of the codes:

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

?>  

SearchTempalte page:

    <?=$ListingTable?>

[halojoy]

.

🙂
Thanks for your PM hockmasm

And with all that nice code ( Great you are using PHP Tags! ... Wish we all did so )
I estimate I will have solved this before friday this week.

It is monday in Sweden now, so will only be a few days waiting for you.

Reservation by halojoy:
- I will take no resposability or action in this case
- under the following circumstance:
- I should suddenly die and my life would be ended before friday comes.

😉
halojoy was run over by a car today
and is no longer a member of this board

[FONT=Arial Narrow]who cares
big deal
there are 67.000 members still
in phpbuilder community

do we miss rain
on a sunny day
like we miss sun shine
while water falls from sky[/FONT]
.

[halojoy]

[right]just a minute
hockmasm

I am downloading your php code and will take a closer look at it
while working offline

-- 🙂 🙂 🙂 🙂 --

.[/right]