PHP - Database Echo Error

<a href="entries.php?eid=<?php echo $row2->eid; ?>" class="n">Entry ID <?php echo $row2->eid; ?> by <?php echo $row2->username; ?></a>
My issue is that the second output of entry id works fine. The first output, being the more important, does not, even though they are identical. This will probably be something ridiculously stupid.

Hi,
I have a search results page that return the results based on "Make" & "Model" of vehicle.

The question is, can an image be echoed onto that results page based on which make and model has been searched for?

The image is stored in a field called "Image_Van"  so would need to display that depending on the row in that database that has been selected from Make & Model...

Hope this makes sense!


<?php

//info bars colour
$color_info="#D6D685"; // Almost Silver //FFFFCC
$color1="#E9E9E9";// Light Blue
$color2="#EAD5FF";// Light Blue


//include function library code

include_once("func_lib.php");

// use the user_connection include file's connectDB function

include_once("usr_conn.php");

if (!connectDB())

{


echo "<p>Unable To Connect To Database</p>";

return;
}

//test that make and model are passed in, if they are assign them
if (($_GET ['make'] == "MAKE") or ($_GET ['model'] == "MODEL"))

{
$errMessage =  "<br><br><b><font class=small>Your search hasn't returned any results, please re-enter your search again.</font></b><br><br><a href=van_accessories.php>Search again</a><br><br>";


}


else


{
// get search values for make and model, removing " and ' chars
$strMake = mysql_escape_string($_GET ['make']);















$strModel = mysql_escape_string($_GET ['model']);















}















// set the Prod_Type that is to be shown regardless of car make and model















$strDefaultProd = "XD";































//write query string that will pased in paging links















$strQuery = "make=".$strMake."&model=".$strModel."&";















//echo $strQuery;















//grab the page number that we're on















$page = mysql_escape_string($_GET ['page']);































//$strMake = "FIAT";















//$strModel = "Uno";































//create sql query















$sqlSelect = "SELECT Prod_ID, Prod_Type, Prod_Model, Prod_Make, Prod_REF, Product_Desc, Price_ExVat, image_name, Image_Van FROM products";

                                                                                        //change this back to 'FILL THIS IS IN' to switch accessories off!

$criteria = " WHERE (Car_Make = '".$strMake."' AND Car_Model = '".$strModel."' AND Default_Code = 'RS') OR (Car_Make = 'all' AND Default_Code = 'SA')";


//$criteria = " WHERE Car_Make = '".$strMake."' AND Car_Model = '".$strModel."'";







// assign the basic sqlquery



$sqlquery = $sqlSelect . $criteria;



//echo $sqlquery; #debug











//get the result set



$result = mysql_query($sqlquery);



$count = mysql_num_rows($result);



$full_count = $count;















//set max number of records per page



$records_per_page = 999;







//Next figure out how many pages you'll have.



$total_pages = ceil( $count / $records_per_page );







/*















This just sets up a page variable which will be past in a "next" and "prev"















link.  The first link to this page may not actually have $page so this just















sets it up.















*/































if ( $page == "" ) { $page = 1; }































//echo "<br>page number".$page; #debug















































# this will set up the "First | Prev | " part of our navigation.















if ( $page == 1 ) {















    # if we are on the first page then "First" and "Prev"















    # should not be links.















    $naviagation = "<font color=\"#666666\">First</font> | <font color=\"#666666\">Prev</font> | ";















} else {















    # we are not on page one so "First" and "Prev" can















    # be links















    $prev_page = $page - 1;















    $navigation = "<a href=\"van_steps_results.php?".$strQuery."page=1\">First</a> | <a href=\"van_steps_results.php?".$strQuery."page=".$prev_page."\">Prev</a> | ";















}































# this part will set up the rest of our navigation "Next | Last"















if ( $page == $total_pages ) {















    # we are on the last page so "Next" and "Last"















    # should not be links















   // $navigation .= "<font color=\"#666666\">Next</font> | <font color=\"#666666\">Last</font>";















} else {















    # we are not on the last page so "Next" and "Last"















    # can be links















    $next_page = $page + 1;















    $navigation .= "<a href=\"van_steps_results.php?".$strQuery."page=".$next_page."\">Next</a> | <a href=\"van_steps_results.php?".$strQuery."page=".$total_pages."\">Last</a>";















}































/*















The final thing to do is your actual query, but first we have to figure out















what the offset will be.















*/















$offset = ( $page - 1 ) * $records_per_page;















//echo "<br>offset".$offset; #debug


//create sql query


$sqlSelect = "SELECT Car_Make, Car_Model, Prod_ID, Prod_Type, Prod_Model, Prod_Make, Priority, Prod_Code, Prod_REF, Product_Desc, Price_ExVat, Link, image_name, Image_Van FROM products";


$criteria = " WHERE (Car_Make = '".$strMake."' AND Car_Model = '".$strModel."' AND Default_Code = 'RS') OR (Car_Make = 'all' AND Car_Model = 'all' AND Default_Code = 'SA')";


$limit = " ORDER BY Priority ASC, Prod_Code ASC, Prod_ID ASC LIMIT $offset, $records_per_page";

// assign the basic sqlquery
$sqlquery = $sqlSelect . $criteria . $limit ;

//echo $sqlquery;

//get the result set

$result = mysql_query($sqlquery);
// if no matches found from query
if (!$result || (mysql_num_rows($result) == 0)){
//echo ("<b><font class=small>No matches were found.</font></b>");
}
// display the results
else{
// use rowcount to display total results found

$count = mysql_num_rows($result);

//echo $count;

//echo("<p>Total Matches Found = " . $rowCount . "</p>"); //*debug

}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
<title>Results Page:</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<script src="js/jquery-1.3.2.min.js" type="text/javascript"></script>
<!--script src="js/jquery.lint.js" type="text/javascript" charset="utf-8"></script-->
<link rel="stylesheet" href="css/prettyPhoto.css" type="text/css" media="screen" title="prettyPhoto main stylesheet" charset="utf-8" />
<script src="js/jquery.prettyPhoto.js" type="text/javascript" charset="utf-8"></script>


<!--  start header graphic html -->

<style type="text/css">
<!--
.table {
border: 0px none;
border-collapse: separate;
}

BODY
{
}
A
{
    COLOR: #003366;
    TEXT-DECORATION: none;
}
A:hover
{
TEXT-DECORATION: underline;
color: #900;
}
.small
{
    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
}
.std
{
    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
COLOR: #000000;
}
.header
{
    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
    FONT-WEIGHT: BOLD;
COLOR:#000000;
}
.bigheader
{
    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
FONT-WEIGHT: BOLD;
    COLOR:#FFFFFF;
}
.error
{
    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
COLOR:#FF0000
}
.headertable
{
FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
FONT-WEIGHT: regular;
    COLOR:#FFFFFF;
    BACKGROUND-COLOR:#000066;
}
.stdtable
{
FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
FONT-WEIGHT: regular;
    COLOR:#000066;
}
.style16 {font-size: 11px}
.style7 { color: #CC0000;
font-style: italic;
}
.small1 {    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
}
.header1 {    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
    FONT-WEIGHT: BOLD;
COLOR:#000000;
}
a:link {
color: #900;
}
-->
</style>




<div align="center">
  <table border="0" cellpadding="0" cellspacing="0">
    <tr>
      <td background=""><table width="100%" border="0" align="center" cellpadding="2" cellspacing="0">
        <tr>
          <td bgcolor="#003366">&nbsp;</td>
        </tr>
      </table>

        <!--END header-->
        
        <table width="960" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td><table width="100%" border="0" cellspacing="0" cellpadding="2">
              <tr>
                <td><div align="center">
                  <table width="100%" border="0" cellspacing="0" cellpadding="0">
                    <tr>
                      <td class="arial11"><table width="100%" border="0" cellpadding="10" cellspacing="0">
                        <tr>
                          <td width="33%"><p><img src="2003/results.gif" alt="" width="238" height="43" /></p>
                            <p>&nbsp;</p>
                            <p>&nbsp;</p></td>
                          </tr>
                        </table></td>
                    </tr>
                  </table>
                </div></td>
              </tr>
            </table>
              <table width="950" border="0" align="center" cellpadding="2" cellspacing="2" bordercolor="#FFFFFF">
                <tr align="center" valign="top" class="std">
                  <td colspan="7"><hr width="500" size="1" />
                    <?php















if (isset($errMessage)){















echo $errMessage;















}















// if no matches found from query















if (!$result || (mysql_num_rows($result) == 0))















echo ("<b><font class=small>No matches were found.</font></b><br><br>");































// display the results















else{















// use rowcount to display total results found















echo("<br><p><em><font class=vehicle>Search Results for " . $strMake . "&nbsp;" . $strModel .".</em> Total Matches Found = " . $full_count . "</p>"); //*debug















echo $navigation;



}




/*



With your navigation built you can just echo that out any where you want it



to appear.



*/



//echo $navigation;



?></td>
                </tr>
                <?php



$title =  "<tr align=\"center\" class=\"headertable\" height=\"32\">";


$title .= "<td width=\"95\"><img src=\"images/transparent.gif\" width=\"95\" height=\"1\" /></td>";

    $title .= "<td width=\"60\">Make</td>";



    $title .= "<td width=\"60\">Ref No.</td>";



    $title .= "<td width=\"550\">Title/Description</td>";



    $title .= "<td width=\"73\">Price Ex VAT</td>";



    $title .= "<td width=\"73\">Price Inc VAT</td>";



    $title .= "<td width=\"60\"><img src=\"2003/basket.gif\" width=\"21\" height=\"14\"></td>";



    $title .= "</tr>";































//set the counters for the records results display screen















$cnt = 0;















$headercount1 = 0;















$headercount2 = 0;















$headercount3 = 0;















$headercount4 = 0;















$headercount5 = 0;















$headercount6 = 0;















$headercount7 = 0;



























while ($row = mysql_fetch_assoc($result))















{































//cut the prod_type variable















//get the length of the variable















$strLength = strlen ($row["Prod_Type"]);















//assign first 2 characters of variable















$strPrefix = substr($row["Prod_Type"], 0, 2);















//debug















//echo "\n prefix :" . $strPrefix;















//assign remaining characters of variable















$strSuffix = substr($row["Prod_Type"], 2, $strLength);















//debug















//echo "\n suffix :" . $strSuffix;































































//set product header image depending on the Prod_Type Code















//start the table row















echo "<tr align=center><td colspan=7 class=small>";










//set bg cell color diff for BH make
switch ($strPrefix)
{
case "BH":
$color=$color2;
break;

default:
$color=$color1;
break;
}//end switch


switch ($strPrefix)
{

   case "BH":

        if ($headercount1 == 0)

{

echo "<img border=0 src=2003/searchheaders/step.jpg></td></tr>";
echo $title;
}
$headercount1 ++;

//$headercount1


       break;

  // REMOVE ALL THIS COMMENTING IF NEEDED TO SHOW THE ROOF BARS!  case "RB":

     //  if ($headercount2 == 0)
// {
// echo "<img border=0 src=2003/searchheaders/NOTUSED.jpg alt=Roof-Bars></td></tr>";
// echo $title;
// }

// $headercount2 ++;

//$headercount1

       break;

case "BX":
        if ($headercount3 == 0)
{

echo "<img border=0 src=2003/searchheaders/bulkheads.jpg alt=Roof-Boxes></td></tr>";
echo $title;
}
$headercount3 ++;

//$headercount1

       break;
case "BR":


        if ($headercount4 == 0)

{

echo "<img border=0 src=2003/searchheaders/bulkheads.jpg alt=Bike-Racks></td></tr>";

echo $title;

}


$headercount4 ++;

//$headercount1

       break;
case "SR":
        if ($headercount5 == 0)

{
echo "<img border=0 src=2003/searchheaders/bulkheads.jpg alt=Ski-Rack></td></tr>";
echo $title;
}

$headercount5 ++;


//$headercount1


       break;
case "CR":

        if ($headercount6 == 0)

{
echo "<img border=0 src=2003/searchheaders/bulkheads.jpg alt=Canoe-Rack></td></tr>";



echo $title;
}


$headercount6 ++;

//$headercount1

       break;

case "XD":

 if ($headercount7 == 0)

{


echo "<img border=0 src=2003/searchheaders/towbar.jpg alt=General-Accessories></td></tr>";
echo $title;

}



$headercount7 ++;


}















//end header image selection and close the table row.















//echo "</td></tr>";































// if (($cnt++)%2)
// {
// $color="#E9E9E9"; // Almost Silver
// }
//     else
// {
// $color="#E9E9E9";// Light Blue
// }































//print a product row if the prodtype isn't set to INFO



$pop_link = "";







if ($strSuffix != "INFO"){







//test to see if an image exists for the product



if ($row["Link"] <> NULL){



$pop_link = "&nbsp;&nbsp;&nbsp;<a href=\"products/".$row["Link"]."?iframe=true&width=650&height=500\" rel=\"prettyPhoto\" >More information >>>></a>";



}







echo "<tr class=stdtable align=center height=25>";


//DISPLAY THUMB IMAGE IF ONE WAS LISTED IN THE image_name FIELD
$p_Image_Van = htmlspecialchars($row["Image_Van"]);
//echo "p_Image_Van:$p_image_name";
if ($p_Image_Van != "")
echo "<td bgcolor=$color width=\"95\"><img src=\"images/product_images/$p_Image_Van\" border=\"0\" /></td>";
else
echo "<td bgcolor=$color width=\"95\"><img src=\"images/transparent.gif\" width=\"95\" height=\"50\" border=\"0\" /></td>";


echo "<td bgcolor=$color width=\"60\">". htmlspecialchars($row["Prod_Make"]) .




"</td><td bgcolor=$color width=\"60\">" . htmlspecialchars($row["Prod_REF"]) .















"</td><td bgcolor=$color align=left class=\"infolink\" width=\"550\">" . htmlspecialchars($row["Product_Desc"]) .







$pop_link .







"</td><td bgcolor=$color width=\"73\">&pound;" . number_format(htmlspecialchars($row['Price_ExVat']), 2) .















"</td><td bgcolor=$color width=\"73\">&pound;" . number_format((calcVAT (htmlspecialchars($row['Price_ExVat']))), 2) .















"</td><td bgcolor=$color width=\"60\"><a href=basket.php?src=".urlencode($_SERVER['REQUEST_URI'])."&productID=" . $row["Prod_ID"] . "><img src=2003/buy.gif border=0></a></td></tr>";















}















// if the prod type is set to INFO then print out a new row for that information















else















{















echo "<tr class=stdtable align=center height=25 ><td colspan=7 bgcolor=$color_info><em><strong>" . htmlspecialchars($row["Product_Desc"]) . "</strong></em></td></tr>";















}















}















































//******************************************************************************************************







/*







//get all porducts from the database that are marked with prod_type XD regardless of car make and model















$sqlSelectDefault = "SELECT Prod_ID, Prod_Type, Prod_Model, Prod_Make, Priority, Prod_Code, Prod_REF, Product_Desc, Price_ExVat FROM products";















$criteriaDefault = " WHERE Prod_Type LIKE '".$strDefaultProd."%'";















$limitDefault = "ORDER BY Priority ASC, Prod_Code ASC";































// assign the basic sqlquery















$sqlqueryDefault = $sqlSelectDefault . $criteriaDefault . $limitDefault ;















//echo $sqlquery;































//get the result set















$resultDefault = mysql_query($sqlqueryDefault);















































// if no matches found from query















if (!$resultDefault || (mysql_num_rows($resultDefault) == 0)){















//echo ("<b><font class=small>No matches were found.</font></b>");















}















// display the results















else{















// use rowcount to display total results found















$countDefault = mysql_num_rows($resultDefault);















//echo $count;















//echo("<p>Total Matches Found = " . $rowCount . "</p>"); //*debug















}































//set product header image depending on the Prod_Type Code















//start the table row















echo "<tr align=left><td colspan=6 class=small>";































echo "<img border=0 src=2003/searchheaders/general.jpg alt=General-Accessories>";































echo "</td></tr>";































while ($rowDefault = mysql_fetch_assoc($resultDefault))















{































//cut the prod_type variable















//get the length of the variable















$strLengthDefault = strlen ($rowDefault["Prod_Type"]);















//assign first 2 characters of variable















$strPrefixDefault = substr($rowDefault["Prod_Type"], 0, 2);















//debug















//echo htmlspecialchars($rowDefault["Prod_ID"]);















//echo "\n prefix :" . $strPrefixDefault;















//assign remaining characters of variable















$strSuffixDefault = substr($rowDefault["Prod_Type"], 2, $strLengthDefault);















//debug















//echo "\n suffix :" . $strSuffixDefault;















































if ($strSuffixDefault != "INFO"){















$color="#E9E9E9"; // Almost Silver















//print a product row if the prodtype isn't set to INFO















echo "<tr class=stdtable align=center height=25 ><td bgcolor=$color>". htmlspecialchars($rowDefault["Prod_Make"]) .















"</td><td bgcolor=$color>" . htmlspecialchars($rowDefault["Prod_REF"]) .















"</td><td bgcolor=$color align=left>" . htmlspecialchars($rowDefault["Product_Desc"]) .















"</td><td bgcolor=$color>?" . number_format(htmlspecialchars($rowDefault['Price_ExVat']), 2) .















"</td><td bgcolor=$color>?" . number_format((calcVAT (htmlspecialchars($rowDefault['Price_ExVat']))), 2) .















"</td><td bgcolor=$color><a href=basket.php?src=".urlencode($_SERVER['REQUEST_URI'])."&productID=" . $rowDefault["Prod_ID"] . "><img src=2003/buy.gif border=0></a></td></tr>";















}















// if the prod type is set to INFO then print out a new row for that information















else















{















echo "<tr class=stdtable align=center height=25 ><td colspan=6 bgcolor=$color><em>" . htmlspecialchars($rowDefault["Product_Desc"]) . "</em></td></tr>";















}















}











*/



?>
                <tr align="center">
                  <td colspan="7" class="small1"></td>
                </tr>
                <tr>
                  <!-- <tr align="center" class="headertable" height="32">















          <td width="145">Product Name</td>















          <td width="178">Ref No.</td>















          <td width="280">Description</td>















          <td width="73">Price Ex VAT</td>















          <td width="73">Price Inc VAT</td>















          <td width="60"><img src="2003/basket.gif" width="21" height="14"> </td>















        </tr>-->
                  <td colspan="7" height="1" bgcolor="#003366"><img src="colour_spacer.gif" width="756" height="1" /></td>
                </tr>
            </table></td>
          </tr>
        </table>
        <p><br />
          </p>
        </p>
        <div align="center"><br />
        </div>
        <table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td>&nbsp;</td>
          </tr>
</table>
        <?php































//free up some memory















mysql_free_result($result);



// close the aatabase connection

mysql_close();

//include footer code


?>
        <br />
      </table>


</html>

Hi guys

I have created a profile page where users can update their profile.

what I need to do is to echo back the users details in the inout text

I have name and telephone number

any ideas how to do it? here is my code

<?php
session_start();
include ("global.php");


//username session
$_SESSION['username']=='$username';
$username=$_SESSION['username'];


//welcome messaage
echo "Welcome, " .$_SESSION['username']."!<p>";

  if ($_POST['register'])
    {
     //get form data
     $name = addslashes(strip_tags($_POST['name']));
     $telephonenumber = addslashes(strip_tags($_POST['telephonenumber']));



   
$query = "UPDATE  users   SET name = ' $name' WHERE username='$username'";
$result = mysql_query($query);

$query = "UPDATE  users   SET telephonenumber = ' $telephonenumber' WHERE username='$username'";
$result = mysql_query($query);



}


?>

    <form action='updateprofile.php' method='POST'>
    Company Name:<br />
    <input type='text' name='name'><p />
     <input type='text' name='telephonenumber'><p />
 
    <input type='submit' name='register' value='Register'>
    </form>


_______

the reason i want to do this is because when user is updating the name field the empty input text for telephone number ovverides the telephone number field in the database.

I would aprreciate your help guys,

I have peice of code which is designed enter a question into a database and the username of the person who asks the question.

However, the code enters <?php echo Array; ?>  into the database and  not 'Tom'.

I am using the same code which inserts the category of the question in the database which works.  But the username comes up as <?php echo Array; ?>.  Does anyone know why it shows "array"?


Code: [Select]
if($loggedIn) {
    echo "Welcome, ".$user['username'].". <a href=\"logout.php\">Logout</a>.
<table width='300' border='0' align='center' cellpadding='0' cellspacing='1'>
<tr>
<td><form name='form1' method='post' action='phpviewquestion.php'>
<table width='100%' border='0' cellspacing='1' cellpadding='3'>
<tr>
<td colspan='3'><strong>Your Question</strong></td>
</tr>
<tr>
<td width='71'>Question</td>
<td width='6'>:</td>
<td width='600' height='50'><input name='question' type='text' id='question'></td>
<td width='71'>Notes</td>
<td width='6'>:</td>
<td width='600' height='50'><input name='notes' type='text' id='notes'></td>
</tr>
<tr>
<td colspan='3' align='center'><input type='image' name='image' value='Submit' src='http://www.domain.co.uk/images/submitbutton.PNG' name='image' width='100' height='53'></td>
<input name='category' type='hidden' value='Furniture' id='category' >
<input name='questionmaker' type='hidden' value='<?php echo $username; ?>' id='questionmaker' >
</tr>
</table>
</form>
</td>
</tr>
</table>

</div>
"
;
} else {
    echo "Please <a href=\"login.php\">Login</a>.";
}

?>

i hav dis checkstatus.php page where the user enters a random number sms to him..but after tht he shud be able to see d reply given by admin ..d problem over here is d user only views half of the field called 'anything'
(my database is named "proj")
heres my code
jst cant understand why dis is happening...pls help