issues url and ID. SELECT * FROM ... WHERE id='$id'

urbandog

Okay-- I finally got this to work, but i'm having issues with the id from the href on the first page, being the same as the id used in the table:

<?php
$query="SELECT * FROM portweb WHERE id='$id'";
$result=mysql_query($query);
if ($result) {
while ($data = mysql_fetch_assoc($result)){
?>
<div class="flash" align="center"><?php echo $data[image] ?></div>

But--- the information that is being pulled, is not from the id selected. There are two pages. One, with the information set up as a list of links....

The links are indexid.php?k=$id then loads all the content from that id, into a table on another page. BUT--- the table in the other page is only pulling content from $id6. No matter what links I'm hitting....Id4, 5, 3.. etc...

Can someone help me troubleshoot?

nemonoman

Post a larger amount of code...your problem could come from any number of sources.

urbandog

*1st page*
<?
if(isset($k)){
$k=$k;
}else{
$k=0;
}
//change the $limit to number of records to b displayed
$limit=4;

mysql_connect("***","", "");
mysql_select_db("***");
?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>URBANdog +Online Portfolio of Marie Prezner</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<LINK href="css.css" rel=stylesheet>
</head>

<?
$query=mysql_query("select from portweb order by id desc limit $k, $limit");
$resultcount=mysql_result(mysql_query("select count() as count from portweb"),0,'count');
while($data=mysql_fetch_array($query)):
echo "<table class=\"subfpo\">
<tr>
<td class=\"subfpo\" align=\"center\">
<div class=\"subtpixs\" align=\"center\"><a href=\"indexid.php?k=$data[id]\"><img src=\"portfolio/$data[image]\" alt=\"print\" border=\"0\"></a></div>
</td>
<td class=\"subfpocopy\">
<div class=\"tpixs\">
<div class=\"subprojtitle\"><img src=\"grfx/t_web.gif\" alt=\"web\"></div>
<div class=\"subprojtitle\">$data[title]</div>
<div class=\"subprojdate\">$data[date]</div>
<div class=\"subprojcontent\">$data[description]</div>
<div class=\"subprojtitle\" align=\"right\"><a href=\"indexid.php?k=$data[id]\">+Full Project</a></div>
</div>
</td>
</tr>";
endwhile;
if($resultcount>0){
if(isset($k) && ($k>0)){
$prev=max($k-$limit,0);
$nav.= "<a href=\"?k=$prev\">«Previous</a> |";
}
$end=(($k+$limit)>$resultcount)?$resultcount🙁$k+$limit);
$nav.="<b>Total :".$resultcount."   Showing: ".($k+1)."-".($end)."</b>";
if (isset($k) && (($k+$limit) < $resultcount)){
$next=$k+$limit;
$nav.= "|<a href=\"?k=$next\">Next»</a>";
}
echo "<tr><td class=\"subprojtitle\"><br><br>$nav</td></tr>";
}
?>

</table>

** 2nd page*******

<?
mysql_connect("***","", "");
mysql_select_db("***");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>URBANdog +Online Portfolio of Marie Prezner</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<LINK href="css.css" rel=stylesheet>
</head>

  <table>
  <tr>
      <td class="personal"><img src="grfx/map_personal.gif" alt="personal" border="0" usemap="#Map"></td>
  <td>

<!---->
<table class="prevnext"><tr>
	<td width="15">back</td>
	<td width="100%" align="center">1234</td>
	<td width="15">next</td>
</tr></table>

<table class="projtitle"><tr>
	<td width="50%"><img src="grfx/heading_featured.gif" alt="featured"></td>
	<td width="50%" class="lftborder"><img src="grfx/heading_details.gif" alt="details"></td>
</tr></table>

<table class="projid"><tr>
	<td width="50%"><?php echo $data[date] ?></td>
	<td width="50%" class="lftborder"><?php echo $data[description] ?></td>
</tr></table>

<table class="copyright"><tr><td align="center"><img src="grfx/copyright.gif" alt="copyright"></td></tr></table>

<?php
} // close while loop
} // close if statement
?>

**** there is the code....
Thank you!

nemonoman

here's a likely suspect:

putting named array indexes in quotes can cause problems;

check the html code being generated and I'll bet the output for this part is slightly mangled. Try:

urbandog

Thank you- I tried it.. and now it seems to be doing this... if you look at the url- it states.
indexid.php?k=7, but the information that it pulls is always static. Which is the info from id=0.

as I go through the links (indexid.php?k=7, or 6 or 5... it still pulls from id 0...

Suggestions?

www.urbandog.net/web.php you can see from the page.

<?
$query=mysql_query("select from portweb order by id desc limit $k, $limit");
$resultcount=mysql_result(mysql_query("select count() as count from portweb"),0,'count');
while($data=mysql_fetch_array($query)):
echo "<table class=\"subfpo\">
<tr>
<td class=\"subfpo\" align=\"center\">
<div class=\"subtpixs\" align=\"center\"><a href=\"indexid.php?k=".$data[id]."\"><img src=\"portfolio/$data[image]\" alt=\"print\" border=\"0\"></a></div>
</td>
<td class=\"subfpocopy\">
<div class=\"tpixs\">
<div class=\"subprojtitle\"><img src=\"grfx/t_web.gif\" alt=\"web\"></div>
<div class=\"subprojtitle\">$data[title]</div>
<div class=\"subprojdate\">$data[date]</div>
<div class=\"subprojcontent\">$data[description]</div>
<div class=\"subprojtitle\" align=\"right\"><a href=\"indexid.php?k=".$data[id]."\">+Full Project</a></div>
</div>
</td>
</tr>";
endwhile;
if($resultcount>0){
if(isset($k) && ($k>0)){
$prev=max($k-$limit,0);
$nav.= "<a href=\"?k=$prev\">«Previous</a> |";
}
$end=(($k+$limit)>$resultcount)?$resultcount🙁$k+$limit);
$nav.="<b>Total :".$resultcount."   Showing: ".($k+1)."-".($end)."</b>";
if (isset($k) && (($k+$limit) < $resultcount)){
$next=$k+$limit;
$nav.= "|<a href=\"?k=$next\">Next»</a>";
}
echo "<tr><td class=\"subprojtitle\"><br><br>$nav</td></tr>";
}
?>

</table>

nemonoman

have you set register globals on? What is the value of $k being retrieved. What happens if you say:

$k=$_REQUEST['k'];

urbandog

Okay I take that back... I placed this in the code... and it states that the value of k is 9... which is correct... yet, all the other information being pulled is from id0....

<?
foreach($REQUEST as $key => $value) {
echo '$REQUEST['.$key.'] = '.$value.'
';};
?>

<!---->
<table class="prevnext"><tr>
	<td width="15">back</td>
	<td width="100%" align="center">1234</td>
	<td width="15">next</td>
</tr></table>

<table class="projtitle"><tr>
	<td width="50%"><img src="grfx/heading_featured.gif" alt="featured"></td>
	<td width="50%" class="lftborder"><img src="grfx/heading_details.gif" alt="details"></td>
</tr></table>

<table class="projid"><tr>
	<td width="50%"><?php echo $data[date]?>
     <?
     foreach($_REQUEST as $key => $value) {
 echo '$_REQUEST['.$key.'] = '.$value.'

';};
?>
</td>
<td width="50%" class="lftborder"><?php echo $data[description] ?></td>
</tr></table>

<table class="copyright"><tr><td align="center"><img src="grfx/copyright.gif" alt="copyright"></td></tr></table>

<?php
} // close while loop
} // close if statement
?>

nemonoman

your code:

if(isset($k)){
$k=$k;
}else{
$k=0;
}

suggests that you have not yet set
$k=$_REQUEST['k'] ;

and the above if statement sets it to 0 for you.

urbandog

I'm not really sure where to put the request K.... if I remove/or replace the $k=0, there's an error with line 63 where I set my limit... (see below)

The pages are currently set as thus:
page1*
<?
if(isset($k)){
$k=$_REQUEST['k'];
}else{
$k=0;
}

//change the $limit to number of records to b displayed
$limit=4;

*page2*
<?
if(isset($k)){
$k=$k;
}else{
$k=$_REQUEST['k'];
}

*****begin of line 63.

<?
$query=mysql_query("select from portweb order by id desc limit $k, $limit");
$resultcount=mysql_result(mysql_query("select count(*) as count from portweb"),0,'count');
while($data=mysql_fetch_array($query)):
echo "<table class=\"subfpo\">
<tr>
<td class=\"subfpo\" align=\"center\">
<div class=\"subtpixs\" align=\"center\"><a href=\"indexid.php?k=".$data[id]."\"><img src=\"portfolio/$data[image]\" alt=\"print\" border=\"0\"></a></div>
</td>
<td class=\"subfpocopy\">
<div class=\"tpixs\">
<div class=\"subprojtitle\"><img src=\"grfx/t_web.gif\" alt=\"web\"></div>
<div class=\"subprojtitle\">$data[title]</div>
<div class=\"subprojdate\">$data[date]</div>
<div class=\"subprojcontent\">$data[description]</div>
<div class=\"subprojtitle\" align=\"right\"><a href=\"indexid.php?k=".$data[id]."\">+Full Project</a></div>
</div>
</td>
</tr>";
endwhile;
if($resultcount>0){
if(isset($k) && ($k>0)){
$prev=max($k-$limit,0);
$nav.= "<a href=\"?k=$prev\">«Previous</a> |";
}
$end=(($k+$limit)>$resultcount)?$resultcount🙁$k+$limit);
$nav.="<b>Total :".$resultcount."   Showing: ".($k+1)."-".($end)."</b>";
if (isset($k) && (($k+$limit) < $resultcount)){
$next=$k+$limit;
$nav.= "|<a href=\"?k=$next\">Next»</a>";
}
echo "<tr><td class=\"subprojtitle\"><br><br>$nav</td></tr>";
}
?>

</table>

I'm sorry--- i'm all over the place here.
Marie

nemonoman

may I please suggest that you call passed id variable something other than k? Like $passedid??

urbandog

Hello--- I actually got quite frustrated with the k... and changed the link to:

a href="indexid.php?id=$data[id]..... on the first page and when taken to the second page, everything works correctly. I thank all of you for your help.

nemonoman

All of me replies "You're welcome".

urbandog

wow-- all of you did apply!

thanxs for your help... do you know a good tutorial about the k variable?

Marie