PHP - Echo Syntax Problem. Please Help.

I can't figure out how to write the a href part to make it blend in with the existing img syntax.  How do I alter this?

Code: [Select]
<?php

echo '<a href=\"{$r['feedusername']\"><img src="', getUserAvatar($r['feedusername']), "\" class=\"avatar mediumsmall newspadding f_left  mrl\" title=\"${r['associate_name']}\" alt=\"${r['associate_name']}\" /></a>";

?>

Hi..

I create mysql syntax for query testing before i input to my php code

here is my mysql code:

Code: [Select]
set @t = 0;
set @rqty=31968;
SELECT LOT_CODE as code,  DATE_ENTRY,   
CASE WHEN @t+OUTPUT_QTY > @rqty
THEN @rqty  -@t 
ELSE OUTPUT_QTY
END as qty,
@t := @t + d.OUTPUT_QTY as cumulative   
FROM dipping d  WHERE SUBSTR(LOT_CODE, 9,4) = 'P28' AND (@t < @rqty);

and i attach the sample output of the above query.

Now that query test is work i  will input that code to my php codes.


     $sql = "SELECT SKUCode, Materials, Comp, Qty 
     FROM bom  WHERE SKUCode = '$SKUCode'";
     $res = mysql_query($sql, $con);

    ($row = mysql_fetch_assoc($res));
     $Materials = $row['Materials'];
     $Qty = $row['Qty'];
     $Comp = $row['Comp']; //P28
//-----Compute Req Qty and Save to table---//     

     $ReqQty = $Qty * $POReq; // 31968


     
$sql = "UPDATE bom SET ReqQty = '$ReqQty' WHERE SKUCode = '$SKUCode' AND Materials = '$Materials'";
$resReqQty = mysql_query($sql, $con);

$t = 0;

$sql = "SELECT LOT_CODE as code,  DATE_ENTRY,   
CASE WHEN $t+OUTPUT_QTY > $ReqQty 
THEN $ReqQty  -$t  
ELSE OUTPUT_QTY 
END as qty,
$t := $t + d.OUTPUT_QTY as cumulative   
FROM dipping d  WHERE SUBSTR(LOT_CODE, 9,4) = '$Comp' AND ($t < $ReqQty)";



when I echo the query:

I got this:

 SELECT LOT_CODE as code, DATE_ENTRY, CASE WHEN 0+OUTPUT_QTY > 31968 THEN 31968 -0 ELSE OUTPUT_QTY END as qty, 0 := 0 + d.OUTPUT_QTY as cumulative FROM dipping d WHERE SUBSTR(LOT_CODE, 9,4) = 'P28' AND (0 < 31968)

then I run it to the sql

and I got an error:

Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':= 0 + d.OUTPUT_QTY as cumulative FROM dipping d WHERE SUBSTR(LOT_CODE, 9,4) = '' at line 1
(0 ms taken)


Any help is highly appreciated

Thank you so much

Hi all,

I have this problem with an echo I have this code, what is working only not all of it, it request a database (ID) TID which is a catorgy. Now I need to TID to be in a place but can't to seem to get it. Here is the code:
Code: [Select]
<?php defined('_JEXEC') or die('Restricted access'); // no direct access ?>
<script type="text/javascript"
    src="http://maps.google.com/maps/api/js?sensor=false">
</script>
<script type="text/javascript">
/*
function changeActiveCategory(id,show)
{
var a_categoryname = "a_category"+id;
if(show){
document.getElementById(a_categoryname).className = "active"+id;
}else{
document.getElementById(a_categoryname).className = "";
}
}
*/

function changeActiveType(id,show)
{
var a_typename = "a_type"+id;
if(show){
document.getElementById(a_typename).className = "active"+id;
}else{
document.getElementById(a_typename).className = "";
}
}




var markerGroups = { "1": [], "2": [], "3": [], "4": [], "5": []};
 
function toggleGroup(type) {
      for (var i = 0; i < markerGroups[type].length; i++) {
        var marker = markerGroups[type][i];
        if (marker.getVisible()) {
          marker.setVisible(false);
  changeActiveType(type,false);  
        } else {
          marker.setVisible(true);
  changeActiveType(type,true);  
        }

      }
    }

function changeActiveButton(id)
{
document.getElementById("idmap").className = "map";
document.getElementById("idsatellite").className = "satellite";
document.getElementById("idterrain").className = "terrain";
var dividname = "id"+id;
document.getElementById(dividname).className = id+" "+id+"active";
}

var map;
var goHome = new google.maps.LatLng(<?php echo $DefaultLat;?>, <?php echo $DefaultLng;?>);
 
function HomeControl(controlDiv, map) {
 
  controlDiv.style.padding = '0px 5px';
 
var controlUI = document.createElement('DIV'); 
  controlUI.style.cursor = 'pointer'; 
  controlUI.setAttribute("class","mapType");
  controlDiv.appendChild(controlUI);
 
var controlMap = document.createElement('DIV');
if(map.getMapTypeId()=='roadmap'){
controlMap.setAttribute("class","map mapactive");
}else{
controlMap.setAttribute("class","map");
}
controlMap.setAttribute("id","idmap");
controlUI.appendChild(controlMap);

 
var controlsatellite = document.createElement('DIV');
if(map.getMapTypeId()=='satellite'){
controlsatellite.setAttribute("class","satellite satelliteactive");
}else{
controlsatellite.setAttribute("class","satellite");
}
controlsatellite.setAttribute("id","idsatellite");
controlUI.appendChild(controlsatellite);

var controlterrain = document.createElement('DIV');
if(map.getMapTypeId()=='hybrid'){
controlterrain.setAttribute("class","terrain terrainactive");
}else{
controlterrain.setAttribute("class","terrain");
}
controlterrain.setAttribute("id","idterrain");
controlUI.appendChild(controlterrain);

 
  google.maps.event.addDomListener(controlUI, 'click', function() {
    /*map.setCenter(goHome);*/
  });
 
  google.maps.event.addDomListener(controlMap, 'click', function() {
   map.setMapTypeId(google.maps.MapTypeId.ROADMAP);
   changeActiveButton('map');
   
  });
 
  google.maps.event.addDomListener(controlsatellite, 'click', function() {   
map.setMapTypeId(google.maps.MapTypeId.SATELLITE);
changeActiveButton('satellite');

  });
 
  google.maps.event.addDomListener(controlterrain, 'click', function() {
   map.setMapTypeId(google.maps.MapTypeId.HYBRID);
   changeActiveButton('terrain');
/*map.setMapTypeId(google.maps.MapTypeId.TERRAIN);*/
  });
 
}
 
  function initialize() {   
    var latlng = new google.maps.LatLng(<?php echo $DefaultLat;?>, <?php echo $DefaultLng;?>);
    var myOptions = {
      zoom: <?php echo $MapDistance;?>,
      center: latlng,
  navigationControl:true,
  scaleControl:true,
  mapTypeControl: false,
      mapTypeId: google.maps.MapTypeId.HYBRID
    };
    var map = new google.maps.Map(document.getElementById("map_canvas"),
        myOptions);

var homeControlDiv = document.createElement('DIV');
var homeControl = new HomeControl(homeControlDiv, map);
homeControlDiv.index = 1;
map.controls[google.maps.ControlPosition.RIGHT].push(homeControlDiv);

var gmarkers = [];
var htmls = [];

<?php
echo 'var ptooltip=new Array();';
echo 'var showhtml=new Array();';
if($items)
{
$p=0;
foreach ($items as $item) 
{ 
$link = LinkHelper::getLink('properties','showproperty','',$item->CYslug,$item->Sslug,$item->Lslug,$item->Tslug,$item->Pslug);
$item->name=str_replace("'","\'",$item->name);
echo "\n"."ptooltip[".$p."]=new Array( '".$item->id."','".$item->ref."','".$item->tid."','".$item->name."','".$link."');"."\n";

/*property details*/
if($item->imagename!=NULL){ $img=$item->imagename;}else{$img='noimage.jpg';}
$myHtml='';
$myHtml.='<div id="propertydetail"><div class="title"><a href="'. $link.'" title="'.str_replace('"',' ',$item->name).'">'.$item->name.'</a></div><div class="image"><img src="images/properties/images/thumbs/'.$item->id.'/'.$img.'" alt="'.str_replace('"',' ',$item->name).'" width="100" height="75"></div><div class="text">';
 if ($item->name_type) { 
$myHtml.=JText::_($item->name_type).'<br />';
} 
if ($item->address) {
$myHtml.=JText::_($item->address).'<br />';
}
$myHtml.='</div>';
$myHtml.='<div class="property_button">';
$myHtml.='<a class="BottomlnkDetail" href="'.$link.'" title="'.$item->id.'">Lees meer...</a>';
$myHtml.='</div>';
$myHtml.='</div>';


echo "\n"."showhtml[".$p."]='".$myHtml."';"."\n";
$myHtml='';
/*end property details*/
$p++;
}
}
?>
var base_Icon=new Array();
base_Icon = '<?php echo JURI::base();?>modules/mod_prop_googlemap/img/beer.png';

<?php
if($items)
{
$x=0;
foreach ($items as $item) { 
?>

var myLatlng = new google.maps.LatLng(<?php echo $item->lat;?>,<?php echo $item->lng;?>);
var marker = new google.maps.Marker({
      position: myLatlng,
      map: map,
  icon: base_Icon  
  });
  /*alert (marker.number);*/
  marker.setTitle('Klik voor meer info.');
  attachSecretMessage(marker, <?php echo $x;?>);
  markerGroups[HIER MOET TID KOMEN].push(marker);
 
<?php
$x++;
}
}
?>
 
function attachSecretMessage(marker, number) {
 
  var infowindow = new google.maps.InfoWindow(
      { content: showhtml[number],
/* disableAutoPan: true,*/
        size: new google.maps.Size(50,50)
      });
  google.maps.event.addListener(marker, 'click', function() {
    infowindow.open(map,marker);
/*showInContentWindow(showhtml[number]);*/
  });
 
  google.maps.event.addListener(infowindow, 'closeclick', function() {
    /*infowindow.close(map,marker);
showInContentWindow('');
closeInContentWindow();*/
  });
 
  /*
  google.maps.event.addDomListener(controlterrain, 'click', function() {
   map.setMapTypeId(google.maps.MapTypeId.HYBRID);
   changeActiveButton('terrain');

  });
  */
 
   
}
 
function showInContentWindow(text) {
    var sidediv = document.getElementById('content_window');
sidediv.style.visibility = "visible";
    sidediv.innerHTML = text;
  }
function closeInContentWindow() {
var sidediv = document.getElementById('content_window');
sidediv.style.visibility = "hidden";
  }
  }
  </script>
<div class="prop_googlemap" style="width:960px; height:510px">
<div class="first">
    <div class="second">
        <div class="third">
 
<div id="map_canvas" style="width: 950px; height: 500px"></div>
<div id="prop_googlemap_categories_all">
<div id="prop_googlemap_categories">     
    <ul class="categorys">
      <li><a id="a_type1" class="active1" href="javascript:void(0)" onclick="toggleGroup('1');">Kroeg</a></li>
      <li><a id="a_type2" class="active2" href="javascript:void(0)" onclick="toggleGroup('2');">Discotheek</a></li> 
      <li><a id="a_type3" class="active3" href="javascript:void(0)" onclick="toggleGroup('3');">Zaal</a></li>
      <li><a id="a_type4" class="active4" href="javascript:void(0)" onclick="toggleGroup('4');">test</a></li>
</ul>       
   
               
</div>
<div style="clear:both"></div> 
<div class="prop_googlemap_categories_bottom"></div>
</div>
<div id="content_window"></div>
<div id="side_bar"></div>
</div>
</div>
</div>
</div>
 <script type="text/javascript">  initialize(); </script>               
<div style="clear:both"></div>

As you can see he
Code: [Select]
markerGroups[THIS IS WHERE THE TID SHOULD COME].push(marker);where now it says: "THIS IS WHERE THE TID SHOULD COME" there needs to be a number ( 1 stands for a bar, 2 stands for a disco, 3 for something else.

Now this is where I ask for the TID:
Code: [Select]
echo "\n"."ptooltip[".$p."]=new Array( '".$item->id."','".$item->ref."','".$item->tid."','".$item->name."','".$link."');"."\n";
But it can be me, but can't seem to get it working.... Can't seem to get the right code for "THIS IS WHERE THE TID SHOULD COME" anyone that could help me? Thanks!

Hello,

I have this syntax on my header div
Code: [Select]
<p><a href="javascript:ajaxpage('shopcart.php', 'content');" class="difflink"><img src="../stock_photos/shopcart.png"><?php echo '<span class="text">'.writeShoppingCart().'</span>'; ?></a></p>
but whatever I try it always output my echo in the next line instead of next to my picture file.

How can I do it displayed at the same line?

Thank you

This php file cant echo in the 2nd php code, can anyone help me about this?
1st php code to connect into the 2nd php code
Code: [Select]
<?php
$Total = $Total + $Amount;
}
?>

</tr>
<tr>
    <td colspan="3" align="Right">Total</td>
    <td align ="Center"><?php echo number_format($Total,2);?></td>
</tr>
2nd php code
Code: [Select]
<?php
$db = mysql_connect("localhost", "root", "");
mysql_select_db("vinnex",$db);
$TransNo = $_POST['TransNo'];
$Username = $_POST['Username'];
$Date = $_POST['Date'];
$Total = $_GET['Total'];
echo $Total;
$sqltransaction = " INSERT INTO transaction (TransNo, Username, Date, Total)
VALUES ('$TransNo', '$Username', '$Date', '$Total')";
$resulttransaction = mysql_query($sqltransaction);
?>