PHP HTML Issue and frame issue

[dmacman1962]

Hi All,

I am setting up a menu of items from a database. I have it working, with the exception of a "stray" quotation mark showing up before the items. Here is the code: ( I apologize if it is not the cleanest code)

<?
$hostname = "localhost";
$database = "xxx";
$username = "xxx";
$password = "xxx";
$connpt = mysql_pconnect($hostname, $username, $password) or trigger_error(mysql_error(),E_USER_ERROR);
mysql_select_db($database, $connpt);
$sql = "SELECT * FROM megaproducts";
$result = mysql_query($sql, $connpt) or die(mysql_error());

		if (mysql_num_rows($result) < 1) {
	print "There are no items to display.";
		} else {
	for ($i=0;$row = mysql_fetch_array($result, MYSQL_ASSOC);$i++) {
	$Name = $row['productsName'];
	$productsID = $row['productsID'];
	print "'<a href=http://www.x.com/dev/printtech/banners.php?productsID=$productsID>'$Name"."<br>";
}

}
?>

I just want to create a menu of items like this:

Apples <--- With a url to the frame referenced by the productsID
Oranges <--- With a url to the frame referenced by the productsID
Tomatos <--- With a url to the frame referenced by the productsID

The second issue is, I am using frames for this layout and need to pass the $productsID to the correct frame so it can display the items.

I hope this makes sense.

Thanks in advance,

Don

[sidney]

you have some stary single quotes in your link

and to target frame use the target attribute

print "<a href=\"http://www.ptideas.com/dev/printtech/banners.php?productsID=$productsID\" target=\"frame_name\">$Name</a><br>";  

[dmacman1962]

Thanks Sidney,

That helped with the extra quote.

I am still having frame issues, i know I am close though.

I have 3 pages.
mg_frameset.php
mg_frame2.php (Where it gets the list of items and displays them for you to choose)
mg_frame3.php (Which displays the chosen item from mg_frame2.php)

Here is the code for the frameset.php:

<?
$hostname = "localhost";
$database = "xxx";
$username = "xxx";
$password = "xxx";
$connpt = mysql_pconnect($hostname, $username, $password) or trigger_error(mysql_error(),E_USER_ERROR);
mysql_select_db($database, $connpt);
$sql = "SELECT * FROM megaproducts";
session_start();
$productsID= $GET['producstID'];
$SESSION['productsID'] = $productsID;
?>

Here is the code for mg_frame2.php (Where the dynamic menu is listed):

<?
$hostname = "localhost";
$database = "xxx";
$username = "xxx";
$password = "xxx";
$connpt = mysql_pconnect($hostname, $username, $password) or trigger_error(mysql_error(),E_USER_ERROR);
mysql_select_db($database, $connpt);
$sql = "SELECT * FROM megaproducts";
$result = mysql_query($sql, $connpt) or die(mysql_error());
if (mysql_num_rows($result) < 1) {
print "There are no items to display.";
} else {
for ($i=0;$row = mysql_fetch_array($result, MYSQL_ASSOC);$i++) {
$Name = $row['productsName'];
$productsID = $row['productsID'];
print "<a href=\"http://www.x.com/dev/printtech/mg_frame3.php?productsID=$productsID\" target=\"mainframe\">$Name</a><br>";
}
}
?>

Here is the code for the last frame mg_frame3.php (Which is where the infor is displayed once you choose it from mg_frame2.php):

<?
$hostname = "localhost";
$database = "xxx";
$username = "xxx";
$password = "xxx";
$connpt = mysql_pconnect($hostname, $username, $password) or trigger_error(mysql_error(),E_USER_ERROR);

$hold = $_REQUEST['productsID'];
$query = "SELECT * from megaproducts WHERE productsIDLIKE '$hold'";
$Name = mysql_query($query, $connpt) or die(mysql_error());
$row = mysql_fetch_array($Name, MYSQL_ASSOC);
$productsName = $row['productsName'];
print $productsName;

?>

I have 2 questions that someone will probably point out, if I don't

1) the mg_frame3.php page is displayed with the frameset and I will need to have the first item in the list from mg_frame2.php displayed as default on the page. Since when you first go to this section, you have not made a choice from mg_frame2.php yet.

2) and a session may be needed (which is what I attempted to do in mg_frameset.php) to have all 3 pages talking to each other correctly.

Am I on the correct track here?

I really appreciate everyones help.

Thanks,
Don

[sidney]

theres no frameset in frameset.php

you need to target the frame name of the frame you wish mg_frame3.php to show in

[dmacman1962]

Sorry Sidney,

I had the frameset code, i just posted the PHP code. Here is all of it:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN" "http://www.w3.org/TR/html4/frameset.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>

<frameset rows="80," cols="" frameborder="NO" border="0" framespacing="0">
<frame src="mg_frame.htm" name="topFrame" frameborder="no" scrolling="NO" marginwidth="0" marginheight="0" >
<frameset rows="" cols="144," framespacing="0" frameborder="NO" border="0">
<frame src="mg_frame2.php" name="leftFrame" scrolling="NO" noresize marginwidth="0">
<frame src="mg_frame3.php" name="mainFrame" frameborder="no" scrolling="NO" marginwidth="0" marginheight="0">
</frameset>
</frameset>
<noframes><body>
<?
$hostname = "localhost";
$database = "xxx";
$username = "xxx";
$password = "xxx";
$connpt = mysql_pconnect($hostname, $username, $password) or trigger_error(mysql_error(),E_USER_ERROR);
mysql_select_db($database, $connpt);
$sql = "SELECT * FROM megaproducts";
session_start();
$productsID= $GET['producstID'];
$SESSION['productsID'] = $productsID;
?>
</body></noframes>
</html>

[sidney]

productsID=$productsID\" target=\"mainframe\">$Name</a><br>";

but your frameset you use

mainFrame with a capital F

[dmacman1962]

Thanks Sidney,

I spotted that and went ot post the update and saw your post.

It works great!!!

Thanks for all your help.

Don