[SOLVED] Link with php data calling within echo

[osiris1603]

I wrote this code which works fine until I enter the else echo content of which is a link that contains more PHP coding:

 

<?
$buynow = "SELECT availability FROM productlist WHERE id = 60";
$buylink = mysql_query ($buynow);
while ($get_info = mysql_fetch_row($buylink)){ 
foreach ($get_info as $buynowlink) 
if ( $buynowlink == "SORRY, CURRENTLY NOT IN STOCK" ) {
echo "<DEL>Buy Now</DEL>";
}
else
              echo "<script type=\"text/javascript\">document.write('<a href=\"cart.php?action=add_item&cartid=<? echo $PHPSESSID; ?>&product=Excel Bells Large&price=<?
$cost = \"SELECT price FROM productlist WHERE id = 60\"; 
$price = mysql_query ($cost); 
while ($get_info = mysql_fetch_row($price)){
foreach ($get_info as $productprice) 
print \"$productprice\";
}
?>&qty=1\" rel=\"facebox[.thickstyle]\">Buy Now</a>');</script>
<noscript><a href=\"add_item_njs.php?cartid=<? echo $PHPSESSID; ?>&product=<?
$product = \"SELECT productname FROM productlist WHERE id = 60\"; 
$nameofproduct = mysql_query ($product); 
while ($get_info = mysql_fetch_row($nameofproduct)){
foreach ($get_info as $productname) 
print \"$productname\";
}
?>&price=<?
$cost = \"SELECT price FROM productlist WHERE id = 60\"; 
$price = mysql_query ($cost); 
while ($get_info = mysql_fetch_row($price)){
foreach ($get_info as $productprice) 
print \"$productprice\";
}
?>&qty=1\">Buy Now</a></noscript>";
}
?>

 

As you can see there is <? ?> within the links which call data from the database such as price etc. which is needed. However when I try this out it does not give any output as the <? ?> within the echo is not allowing it to (i think?).

 

Does anyone know how I can solve this?

 

Many thanks in advance!

[xtopolis]

Possibly a typo, but to start, you're missing a "{" after else it seems.  Also, try breaking it down so that you don't have so much after }else{ right away... then gradually add a bit until it breaks.

[conker87]

Why are you escaping variable start/end quotes and quotes outside of the tags?

 

Use <?php ?> too, real men use full tags.

 

Edit:

That's best I can do it, I'm too sure if its correct though.

 

<?php
$buynow = "SELECT availability FROM productlist WHERE id = 60";
$buylink = mysql_query ($buynow);
while ($get_info = mysql_fetch_row($buylink))
{ 
	foreach ($get_info as $buynowlink)
		{
			if ( $buynowlink == "SORRY, CURRENTLY NOT IN STOCK" )
				{
					echo "<DEL>Buy Now</DEL>";
				}
			else
				{
					echo "<script type=\"text/javascript\">document.write('<a href=\"cart.php?action=add_item&cartid={$PHPSESSID}&product=Excel Bells Large&price=";
					$cost = "SELECT price FROM productlist WHERE id = 60";
					$price = mysql_query ($cost);
					while ($get_info = mysql_fetch_row($price))
						{
							foreach ($get_info as $productprice) 
								{
									print "$productprice";
								}
							echo "&qty=1\" rel=\"facebox[.thickstyle]\">Buy Now</a>');</script><noscript><a href=\"add_item_njs.php?cartid={$PHPSESSID}&product=";
							$product = "SELECT productname FROM productlist WHERE id = 60";
							$nameofproduct = mysql_query ($product); 
							while ($get_info = mysql_fetch_row($nameofproduct))
								{
									foreach ($get_info as $productname)
										{
											print "$productname";
										}
									echo "&price=";
									$cost = "SELECT price FROM productlist WHERE id = 60";
									$price = mysql_query ($cost);
									while ($get_info = mysql_fetch_row($price))
										{
											foreach ($get_info as $productprice) 
												{
													print "$productprice";
												}
										}
									echo "&qty=1\">Buy Now</a></noscript>";
								}
						}
				}
		}
}
?>

[osiris1603]

conker87

 

Thank you very much for your code and help, it works the way I have been trying to achieve! If there is a reputation system on this forum I will give you some. Thank you very, very much!

[conker87]

That's alright, glad I could be of service.

 

Don't forget to hit the 'Topic Solved' button.