Link to home
Create AccountLog in
Avatar of larrybird1030
larrybird1030

asked on

PHP variable = recordset record

i have a dynamic data list with a repeat that repeats the first 5 rows in the dataset.

what i need is to carry the value of a dataset record to the next page.  the record is the primary key.  

i am doing it this way :

<div id="list_more_div">

<a href="sixmanmagazine/html/article_1.php?articleidp=??"><img src="sixmanmagazine/images/more.jpg" width="50" height="17" border="0" /></a>

</div>

i am stuck at ".php?articleidp=??"

?? needs to be the value of the repeated primary key.  the dataset is called sixman_articles and the record is called order.

i am using dreamweaver.

Thanks in advance.

Larry
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

what you are showing is only the html code for the output. but you don't show the relevant php code which builds it...

in short, it would be something like:
<a href="sixmanmagazine/html/article_1.php?articleidp=' + $record_var["field_name"] .'"><img 

Open in new window


presuming that your db query recordset variable is indeed $record_var and the field with the "id" is named "field_name".
just fill in the correct names, and it might work.
otherwise, you need to show more of the relevant code, and the error / ...
Avatar of larrybird1030
larrybird1030

ASKER

thanks for the help!!!

i'm rather new to all this.  so please be patient with me.

i added this to my code :

<div id="list_more_div">

<a href="sixmanmagazine/html/article_1.php?articleidp=' + $articleidp["order"].'"><img src="sixmanmagazine/images/more.jpg" width="50" height="17" border="0" /></a>

</div>

and i get this error :

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 '$articleidp['' at line 1

i'm not sure of what you need when you say "relevant code".

this might help.  if i use this code :

.php?articleidp=8><img

it works great.  it displays the record that has the primary key of 8.

this might help also :

$colname_article_data = "-1";
if (isset($_GET['articleidp'])) {
  $colname_article_data = $_GET['articleidp'];
}
mysql_select_db($database_Sixman_Data, $Sixman_Data);
$query_article_data = sprintf("SELECT * FROM sixman_articles WHERE `order` = '".$_GET[articleidp]."'", GetSQLValueString($colname_article_data, "int"));
$article_data = mysql_query($query_article_data, $Sixman_Data) or die(mysql_error());
$row_article_data = mysql_fetch_assoc($article_data);
$totalRows_article_data = mysql_num_rows($article_data);
?>

this comes from the article_1.php page.  i am linking to this page.

again thank  you for your time

larry
if i use this code :
.php?articleidp=8><img
it works great


so, where does that "8" come from? I mean, how exactly should it be populated?
from a query?
This does not make sense ... You are getting a SQL error in response to HTML output - somewhere we are missing something.

i added this to my code :

<div id="list_more_div">

<a href="sixmanmagazine/html/article_1.php?articleidp=' + $articleidp["order"].'"><img src="sixmanmagazine/images/more.jpg" width="50" height="17" border="0" /></a>

</div>

and i get this error :

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 '$articleidp['' at line 1

Open in new window

You will need to post all the code around this for us to see what is going on.

Also - can you dump your SQL query before you execute it i.e.

$sql = "Select " ... // rest of query here
echo $sql;
mysql_query ... // or however you execute your query
Please step back from this problem and give yourself a chance to learn the basics.  Dreamweaver is a terrible place to try to learn PHP.  Just don't do that.  You will be handicapped for years if you adopt their methods.

Instead get this very readable book and give yourself a month to study.  At the end of the month you will be two years ahead of where you'll be if you keep on the current path.
http://www.sitepoint.com/books/phpmysql5/

Now in its fifth printing, it's been a permanent part of my professional library since Edition One.  It is a good investment of your time and money, I promise!
Larry,

Open the Bindings Panel and switch your document to code view.

In the Bindings Panel, you should see your recordset name with a plus sign to expand it.  Click it.

You should now see a column list.  Drag the desired column that contains the ID number into code view and drop it where you currently list ?? in the original post.

That will create the appropriate PHP echo command to get that value.  

--------------

For the record, Ray is right about Dreamweaver being a horrible place to learn PHP. But suggesting that someone drop everything for a month to do it "better" is simply not realistic (at best) or pollyannaish (at worst).  Not everyone is trying to learn PHP.  Sometimes people just need a fire and forget solution for a web site and Dreamweaver can still fill that knowledge gap for a right-now issue or while someone is taking the time to learn a better way.
Jason1178,

that worked but it is only pulling over the first record in the recordset.

let me tell you what i'm doing, i have a sports website that i want to have people add stories to it.

so i made a page that submits stories and adds them to a table.  

after the story is added, you can go back to the default page and it will be the feature story.  the previous story is second on list and so on.

here is an example of the new default page.

http://sixmanmagazine.com/default_list_added_stories.php

which links you to this page :

http://sixmanmagazine.com/sixmanmagazine/html/article_1.php?articleidp=10

i noticed that this part doesnt change :

.php?articleidp=10

the 10 should change with what ever story i want to display.

when you click on the "more" botton on the stories #3-#6 i want that story to appear on the linked page.

i made the story list with a dataset that sorts in desending order with a limit of 5.  that is the list that appears on the default page.  i added a repeat so the dataset would list.

when you bring up the example page, the menu's on top wont get you where you need to get.  use the back button to get you back to the new default page.

thanks for your help.

larry
the 10 should change with what ever story i want to display.

Short answer: in order for the link to change, you need to add the command within the repeat region.

Can you post your entire page code (use the code button) here?  I have a feeling that there is more than one thing wrong with your code.

Also, now that I see the layout of your site I have to ask: Why are you building this by hand with Dreamweaver?  You could have installed WordPress (another tool that makes Ray twitch) and been done by now :)
yes i am using dreamweaver, it just seemed easy to use.

here is the code, it looks pretty messy.  lol.  i'm just trying to get it to work before i clean it up.  

here is the code for http://sixmanmagazine.com/default_list_added_stories.php

<?php require_once('Connections/Sixman_Data.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

mysql_select_db($database_Sixman_Data, $Sixman_Data);
$query_sixman_articles = "SELECT * FROM sixman_articles ORDER BY `order` DESC";
$sixman_articles = mysql_query($query_sixman_articles, $Sixman_Data) or die(mysql_error());
$row_sixman_articles = mysql_fetch_assoc($sixman_articles);
$totalRows_sixman_articles = mysql_num_rows($sixman_articles);

$maxRows_sixman_articles_2 = 5;
$pageNum_sixman_articles_2 = 0;
if (isset($_GET['pageNum_sixman_articles_2'])) {
  $pageNum_sixman_articles_2 = $_GET['pageNum_sixman_articles_2'];
}
$startRow_sixman_articles_2 = $pageNum_sixman_articles_2 * $maxRows_sixman_articles_2;

mysql_select_db($database_Sixman_Data, $Sixman_Data);
$query_sixman_articles_2 = "SELECT * FROM sixman_articles ORDER BY `order` DESC LIMIT 5";
$query_limit_sixman_articles_2 = sprintf($query_sixman_articles_2, $startRow_sixman_articles_2, $maxRows_sixman_articles_2);
$sixman_articles_2 = mysql_query($query_limit_sixman_articles_2, $Sixman_Data) or die(mysql_error());
$row_sixman_articles_2 = mysql_fetch_assoc($sixman_articles_2);

if (isset($_GET['totalRows_sixman_articles_2'])) {
  $totalRows_sixman_articles_2 = $_GET['totalRows_sixman_articles_2'];
} else {
  $all_sixman_articles_2 = mysql_query($query_sixman_articles_2);
  $totalRows_sixman_articles_2 = mysql_num_rows($all_sixman_articles_2);
}
$totalPages_sixman_articles_2 = ceil($totalRows_sixman_articles_2/$maxRows_sixman_articles_2)-1;
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Sixman Magazine</title>
<style type="text/css">
<!--
#magazine_list_div {
	margin-top: 10px;
	font-family: Arial, Helvetica, sans-serif;
	font-size: 12px;
	margin-left: 10px;
	margin-right: 10px;
}
#google_ad_div {
	margin-top: 5px;
	background-color: #FFF;
	height: 80px;
	border: thin solid #000;
	margin-bottom: 5px;
}
body {
	font: 100% Verdana, Arial, Helvetica, sans-serif;
	margin: 0; /* it's good practice to zero the margin and padding of the body element to account for differing browser defaults */
	padding: 0;
	text-align: center; /* this centers the container in IE 5* browsers. The text is then set to the left aligned default in the #container selector */
	color: #000000;
	background-color: #000;
}
.oneColElsCtr #container2 {
	width: 953px; /* the auto margins (in conjunction with a width) center the page */
	border: 1px solid #000000;
	text-align: left; /* this overrides the text-align: center on the body element. */
	margin-top: 20px;
	margin-right: auto;
	margin-bottom: 50px;
	margin-left: auto;
	padding: 10px;
	background-color: #CCC49F;
	height: 1500px;
}
#middle_main_div {
	margin-top: 10px;
	background-color: #FFF;
	border: 1px solid #000;
	height: 217px;
	padding: 5px;
}
#poll_vote_div {
	height: 217px;
	float: right;
	width: 295px;
	border: thin solid #000;
}
#main_text_div {
	margin-top: 7px;
	height: 139px;
	margin-bottom: 10px;
}
#article_list_div {
	float: left;
	width: 450px;
	background-color: #FFF;
	padding: 5px;
	border: 1px solid #000;
	height: 500px;
}
#list_title_div {
	font-family: Arial, Helvetica, sans-serif;
	font-size: 14px;
	font-weight: bold;
}
#list_content_div {
	font-family: Arial, Helvetica, sans-serif;
	font-size: 12px;
}
#list_author_div {
	font-family: Arial, Helvetica, sans-serif;
	font-size: 10px;
}
#list_more_div {
	font-family: Arial, Helvetica, sans-serif;
	font-size: 12px;
	font-style: italic;
	font-weight: bold;
	text-align: right;
	padding-right: 10px;
}
#main_div {
	background-color: #ccc49f;
	height: 423px;
}
#bottom_main_div {
	margin-top: 10px;
	background-color: #FFF;
	border: 1px solid #000;
	height: 400px;
}
#spacer {
	background-color: #FFF;
	height: 10px;
}
.oneColElsCtr #mainContent {
	padding: 0 20px;
}
#top_image {
	background-color: #FFF;
}
#donate_div {
	float: right;
	background-color: #FFC;
	width: 245px;
	height: 170px;
	border: 1px solid #000;
}
#donate_text_div {
	margin-top: 10px;
	margin-bottom: 10px;
	padding-right: 10px;
	padding-left: 10px;
	font-family: Arial, Helvetica, sans-serif;
	font-size: 10px;
}
#main_img_video_div {
	width: 590px;
	float: left;
	margin-top: 10px;
	height: 400px;
	background-color: #FFF;
	border: 1px solid #000;
	padding: 5px;
}
#main_image_div {
}
#main_img_text {
	font-family: Arial, Helvetica, sans-serif;
	font-size: small;
	margin-top: 5px;
	height: 60px;
	border-top-width: 1px;
	border-right-width: 1px;
	border-bottom-width: 1px;
	border-left-width: 1px;
	border-top-style: solid;
	border-top-color: #000;
	border-right-color: #000;
	border-bottom-color: #000;
	border-left-color: #000;
	padding-top: 10px;
}
#right_sml_video {
	float: right;
	width: 330px;
	margin-top: 10px;
	height: 290px;
	background-color: #FFF;
	border: 1px solid #000;
	padding: 5px;
}
#headlines_div {
	float: left;
	width: 295px;
	padding: 5px;
	height: 378px;
	background-color: #FFF;
	font-family: Arial, Helvetica, sans-serif;
	font-size: 13px;
	border: 1px solid #000;
	margin: 5px;
	color: #000;
}
#headline_img_div {
	height: 15px;
	margin-bottom: 10px;
	width: 295px;
	background-color: #000;
	font-size: x-small;
	color: #FFF;
	font-weight: bold;
}
#main_bottom_div {
	padding: 10px;
	width: 933px;
	float: none;
}
#small_vid_text {
	float: none;
}
#video_div {
}
#video_txt {
	margin-top: 10px;
	height: 25px;
	font-family: Arial, Helvetica, sans-serif;
	font-size: small;
}
#advertisement_div {
	float: right;
	margin-top: 10px;
	width: 330px;
	padding: 5px;
	border: 1px solid #000;
	height: 155px;
	background-color: #FFF;
	font-family: Arial, Helvetica, sans-serif;
	font-size: 11px;
}
#blog_1_div {
	height: 58px;
	margin-bottom: 7px;
	margin-top: 5px;
	border: 1px solid #000;
	margin-right: 10px;
	margin-left: 10px;
}
#blog_2_div {
	height: 58px;
	border: 1px solid #000;
	margin: 10px;
}
#advertise_img_div {
	height: 15px;
	margin-bottom: 10px;
	width: 330px;
}
#bottom_middle_div {
	margin-right: 322px;
	margin-left: 322px;
	background-color: #FFF;
	margin-top: 5px;
	border: 1px solid #000;
	height: 378px;
	padding: 5px;
	font-family: Arial, Helvetica, sans-serif;
	font-size: 11px;
}
#left_top20_div {
	float: left;
	width: 130px;
	margin-left: 10px;
	font-family: Arial, Helvetica, sans-serif;
	font-size: 11px;
}
#right_top20_div {
	float: right;
	width: 130px;
	margin-right: 10px;
	font-family: Arial, Helvetica, sans-serif;
	font-size: 11px;
}
#botton_right_div {
	float: right;
	width: 295px;
	padding: 5px;
	height: 378px;
	background-color: #FFF;
	font-family: Arial, Helvetica, sans-serif;
	font-size: 11px;
	border: 1px solid #000;
	margin: 5px;
	overflow: auto;
}
#blog_div {
	float: right;
	margin-top: 10px;
	width: 330px;
	padding: 5px;
	border: 1px solid #000;
	height: 88px;
	background-color: #FFF;
	font-family: Arial, Helvetica, sans-serif;
	font-size: 11px;
}
#sixmanmagazine_title_div {
	margin-top: 10px;
	font-family: Arial, Helvetica, sans-serif;
	font-size: 10.5px;
}
#issue_title_div {
	font-family: "Arial Black", Gadget, sans-serif;
	font-size: 14px;
	font-weight: bold;
	text-align: center;
	margin-bottom: 5px;
}
#headline_link_div {
}
#game_week_div {
	margin-top: 5px;
	height: 35px;
	width: 590px;
	font-family: Arial, Helvetica, sans-serif;
	font-size: 14px;
	font-weight: bold;
}
#middle_main_left_div {
	float: left;
	height: 217px;
	width: 310px;
	font-family: Arial, Helvetica, sans-serif;
	font-size: 12px;
	border: 1px solid #000;
}
#middle_main_middle_div {
	float: left;
	width: 290px;
	margin-left: 10px;
	height: 207px;
	border: 1px solid #000;
	font-size: 12px;
	padding-right: 10px;
	padding-bottom: 10px;
	padding-left: 10px;
	overflow: auto;
}
#main_middle_title_div {
	font-family: Arial, Helvetica, sans-serif;
	font-size: 12px;
	font-weight: bold;
	color: #FFF;
	background-color: #000;
	margin-bottom: 10px;
}
#main_middle_left_title_div {
	font-family: Arial, Helvetica, sans-serif;
	font-size: 12px;
	font-weight: bold;
	color: #FFF;
	background-color: #000;
}
#ad_txt {
	height: 25px;
	font-family: Arial, Helvetica, sans-serif;
	font-size: 9px;
}
#main_img_video2_div {
	width: 450px;
	float: left;
	margin-top: 10px;
	height: 468px;
	background-color: #FFF;
	border: 1px solid #000;
	padding: 5px;
}
#main2_div {
	background-color: #ccc49f;
	height: 492px;
}
#main3_div {
	margin-top: 15px;
	height: 600px;
}
#middle_main_left2_div {
	margin-top: 10px;
	background-color: #FFF;
	border: 1px solid #000;
	height: 600px;
	padding: 5px;
	float: left;
	width: 450px;
	margin-right: 10px;
}
#main_image2_div {
	height: 308px;
	border: 1px solid #000;
}
#main_article_title_div {
	font-family: Arial, Helvetica, sans-serif;
	font-size: 18px;
	font-weight: bold;
	padding-right: 10px;
	padding-left: 10px;
	padding-top: 3px;
	padding-bottom: 3px;
}
#main_article_author_div {
	font-family: Arial, Helvetica, sans-serif;
	font-size: 9px;
	margin-right: 10px;
	margin-left: 10px;
	margin-top: 3px;
}
#main_article_text_div {
	font-family: Arial, Helvetica, sans-serif;
	font-size: 12px;
	height: 60px;
	margin-top: 10px;
	margin-right: 10px;
	margin-bottom: 5px;
	margin-left: 10px;
}
-->
</style>




<link rel="stylesheet" href="sixmanmagazine/cssmenutools/scripts/MTHM.css" type="text/css" />
<script type="text/javascript">
var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-33464357-1']);
  _gaq.push(['_trackPageview']);

  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();
</script>

<link rel="stylesheet" type="text/css" href="sixmanmagazine/html/player_files/audio-player.css" />
<script type="text/javascript" src="sixmanmagazine/html/player_files/jquery.jplayer.min.js"></script>
<script type="text/javascript" src="sixmanmagazine/html/player_files/jquery.audio-player.demo.js"></script>
</head>

<body class="oneColElsCtr">

<div id="container2">
  <div id="top_image">  <div id="donate_div">
  
    <div id="donate_text_div">
      <div align="left">If you would like to donate to the website, it would be appreciated. Click on button below.<br />
        <br />
Thank You. <br />
        Sixman Magazine<br />
        <br />
        If you don't have PayPal, look for "Dont' have a PayPal account?" on left side of screen.</div>
    </div>
  
  
  
  <form action="https://www.paypal.com/cgi-bin/webscr" method="post">
    <div align="center">
  <input type="hidden" name="cmd" value="_s-xclick">
  <input type="hidden" name="encrypted" value="-----BEGIN PKCS7-----MIIHTwYJKoZIhvcNAQcEoIIHQDCCBzwCAQExggEwMIIBLAIBADCBlDCBjjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAkNBMRYwFAYDVQQHEw1Nb3VudGFpbiBWaWV3MRQwEgYDVQQKEwtQYXlQYWwgSW5jLjETMBEGA1UECxQKbGl2ZV9jZXJ0czERMA8GA1UEAxQIbGl2ZV9hcGkxHDAaBgkqhkiG9w0BCQEWDXJlQHBheXBhbC5jb20CAQAwDQYJKoZIhvcNAQEBBQAEgYAW6eA9GiQKSvnlcoDhKWDpuY3eE4rqa2YGksgf4Y8dNKzSgiKP8uqwCRQAx1TPiwT5QndBJuebZm/vhQuLe3ZsOIRSMc3NWZG5iBdm6n5M+DuXjfbFXTWTBOwy9jhGPEuKw2btXgSwlcy+tJgbsyJmukfNEQuqRybqBFT3iRmiGTELMAkGBSsOAwIaBQAwgcwGCSqGSIb3DQEHATAUBggqhkiG9w0DBwQIHqvg3EJHrbyAgagXKw68mvWu7viwVOWvKoazsfDbCm5yMWIP1SbuGueTtifwe927GucOGOt+H8uyoYPIBXdJfm2k07qgHbctEWdyS8i2mE/p7hkEMPtUXlK9mKhG53Kpqeh0VJemtxwYNd+M82KCZTq11K49T6LE85EL8YyMLYcw/TyQIvSGryR8tr2VFDrv3sBmilojMGLnT3VwfN6fTan9u4pN9dnEDqVRtuZx4KhkJwugggOHMIIDgzCCAuygAwIBAgIBADANBgkqhkiG9w0BAQUFADCBjjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAkNBMRYwFAYDVQQHEw1Nb3VudGFpbiBWaWV3MRQwEgYDVQQKEwtQYXlQYWwgSW5jLjETMBEGA1UECxQKbGl2ZV9jZXJ0czERMA8GA1UEAxQIbGl2ZV9hcGkxHDAaBgkqhkiG9w0BCQEWDXJlQHBheXBhbC5jb20wHhcNMDQwMjEzMTAxMzE1WhcNMzUwMjEzMTAxMzE1WjCBjjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAkNBMRYwFAYDVQQHEw1Nb3VudGFpbiBWaWV3MRQwEgYDVQQKEwtQYXlQYWwgSW5jLjETMBEGA1UECxQKbGl2ZV9jZXJ0czERMA8GA1UEAxQIbGl2ZV9hcGkxHDAaBgkqhkiG9w0BCQEWDXJlQHBheXBhbC5jb20wgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAMFHTt38RMxLXJyO2SmS+Ndl72T7oKJ4u4uw+6awntALWh03PewmIJuzbALScsTS4sZoS1fKciBGoh11gIfHzylvkdNe/hJl66/RGqrj5rFb08sAABNTzDTiqqNpJeBsYs/c2aiGozptX2RlnBktH+SUNpAajW724Nv2Wvhif6sFAgMBAAGjge4wgeswHQYDVR0OBBYEFJaffLvGbxe9WT9S1wob7BDWZJRrMIG7BgNVHSMEgbMwgbCAFJaffLvGbxe9WT9S1wob7BDWZJRroYGUpIGRMIGOMQswCQYDVQQGEwJVUzELMAkGA1UECBMCQ0ExFjAUBgNVBAcTDU1vdW50YWluIFZpZXcxFDASBgNVBAoTC1BheVBhbCBJbmMuMRMwEQYDVQQLFApsaXZlX2NlcnRzMREwDwYDVQQDFAhsaXZlX2FwaTEcMBoGCSqGSIb3DQEJARYNcmVAcGF5cGFsLmNvbYIBADAMBgNVHRMEBTADAQH/MA0GCSqGSIb3DQEBBQUAA4GBAIFfOlaagFrl71+jq6OKidbWFSE+Q4FqROvdgIONth+8kSK//Y/4ihuE4Ymvzn5ceE3S/iBSQQMjyvb+s2TWbQYDwcp129OPIbD9epdr4tJOUNiSojw7BHwYRiPh58S1xGlFgHFXwrEBb3dgNbMUa+u4qectsMAXpVHnD9wIyfmHMYIBmjCCAZYCAQEwgZQwgY4xCzAJBgNVBAYTAlVTMQswCQYDVQQIEwJDQTEWMBQGA1UEBxMNTW91bnRhaW4gVmlldzEUMBIGA1UEChMLUGF5UGFsIEluYy4xEzARBgNVBAsUCmxpdmVfY2VydHMxETAPBgNVBAMUCGxpdmVfYXBpMRwwGgYJKoZIhvcNAQkBFg1yZUBwYXlwYWwuY29tAgEAMAkGBSsOAwIaBQCgXTAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0xMjEyMDkxODAxMjdaMCMGCSqGSIb3DQEJBDEWBBTnq6EcD82EcHe4A5fcDiaD4cfNajANBgkqhkiG9w0BAQEFAASBgD5P/RKfFiOSMTbexbGE7VLK65F3IgHF9aJWB4tU3O2RVwIgHfGNtmHTTBlK3wHiZIZwTykrl3azWMntdn//EI8fGXywoKV4XBHdaaGE0HtVwbFWZ2qEye7h6kXNNZOtKZZWvf/Rw7IT6RfzJiiDeVdnIYXpxqWSkVVO15Wu/BiM-----END PKCS7-----
">
  <input type="image" src="https://www.paypalobjects.com/en_US/i/btn/btn_donateCC_LG.gif" border="0" name="submit" alt="PayPal - The safer, easier way to pay online!">
  <img alt="" border="0" src="https://www.paypalobjects.com/en_US/i/scr/pixel.gif" width="1" height="1">
    </div>
  </form>

  
  </div>
    <div align="center"><img src="sixmanmagazine/images/bg_top_2.jpg" width="700" height="174" /></div>
    <div id="MTHMQDVFbODDiv" class="MTHMQDVFbODwrapper">
      <div id="MTHMQDVFbODTop" class="MTHMQDVFbODtop">
        <ul>
          <li class="MTHMQDVFbODitem1"><a href="default.php"><span>Main</span></a></li>
          <li class="MTHMQDVFbODitem2"><a href="#"><span>Division I</span></a></li>
          <li class="MTHMQDVFbODitem2"><a href="#"><span>Division II</span></a></li>
          <li class="MTHMQDVFbODitem2"><a href="#"><span>Nebraska</span></a></li>
          <li class="MTHMQDVFbODitem2"><a href="#"><span>Wyoming</span></a></li>
          <li class="MTHMQDVFbODitem2"><a href="#"><span>Videos</span></a></li>
          <li class="MTHMQDVFbODitem1"><a href="sixmanmagazine/html/coach_data_entry.html"><span>Data Entry</span></a></li>
          <li class="MTHMQDVFbODitem1"><a href="sixmanmagazine/html/contact_us.html"><span>Contact Us</span></a></li>
        </ul>
      </div>
      <script type="text/javascript" src="sixmanmagazine/cssmenutools/scripts/MTHM.js">/* MTHMMenu script ID:MTHMQDVFbOD */</script>
      <br style="clear:both" />
    </div>
  </div>
  <div id="main2_div">
    

    <div id="main_img_video2_div">
    <div id="main_image2_div">Image goes here</div>
    <div id="main_text_div">

  <div id="main_article_title_div"><?php echo $row_sixman_articles['title']; ?></div>

<div id="main_article_author_div"><?php echo $row_sixman_articles['author']; ?></div>
<div id="main_article_text_div"><?php echo $row_sixman_articles['teaser']; ?></div>
<div id="list_more_div"><a href="sixmanmagazine/html/article_1.php?articleidp=<?php echo $row_sixman_articles['order']; ?>"><img src="sixmanmagazine/images/more.jpg" width="50" height="17" border="0" /></a></div>
<br />
      <br />
    </div>
    </div>
    
    <div id="right_sml_video">
    
    <div><a href="http://sixmanmagazine.com/sixmanmagazine/html/magazine_2013_january.html"><img src="sixmanmagazine/images/magazine_image.jpg" width="329" height="210" border="0" /></a></div>
    <div id="sixmanmagazine_title_div">
      <div id="issue_title_div"><strong>Sixman Magazine January 2013</strong></div>
    
      If you are interested in advertising in the magazine, please contact us for information.  If you have any news or pictures send them to us!!!!
      <br />
      <br />
      larry@sixmanmagazine.com
    </div>
    </div>
    
  </div>
  <div id="main3_div">
  <div id="article_list_div">
    <table width="448">
      <?php do { ?>
        <tr>
          <td width="371">
          <div id="list_title_div">
	  		    <?php echo $row_sixman_articles_2['title']; ?>
          </div>
          </td>
          </tr>
        <tr>
          <td><div id="list_author_div">
		  	  <?php echo $row_sixman_articles_2['author']; ?>
          </div>
          </td>
        </tr>
        <tr>
          <td><div id="list_content_div">
		  	  <?php echo $row_sixman_articles_2['teaser']; ?>
          </div>
          </td>
          </tr>
        <tr>
          <td>
          <div id="list_more_div"><a href="sixmanmagazine/html/article_1.php?articleidp=<?php echo $row_sixman_articles['order']; ?>"><img src="sixmanmagazine/images/more.jpg" width="50" height="17" border="0" /></a></div>
 </td>
        </tr>
        <tr>
          <td><hr /></td>
          </tr>
        <?php } while ($row_sixman_articles_2 = mysql_fetch_assoc($sixman_articles_2)); ?>
    </table>
    

  </div>
</div>
  
  
  
  <!-- end #container -->
</div>
</body>
</html>
<?php
mysql_free_result($sixman_articles);

mysql_free_result($sixman_articles_2);
?>

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Jason C. Levine
Jason C. Levine
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
was very helpfull and patient
well crap.  i should have seen that.  that fixed it right up.

anyways, thanks for the help.

is it ok to contact you with other questions?

i still need to add an upload image button to my article submit page.

i will try to figure it out myself before i ask.

again thanks for the help.
i still need to add an upload image button to my article submit page.

Now you're going to have some real fun.  There isn't a built-in behavior to upload an image in Dreamweaver so you are either going to have to learn to code it yourself or shell out a lot of money for an extension.  Good luck.

is it ok to contact you with other questions?

Feel free to open new questions on EE.

I also want to note for the record that I took points from both AngelEyes and Ray_Paseur.

<touchdown dance in the office>