?id=1 ??

[dv6cougar]

alright... i have a page that uses the ".$row["1"]." as a folder name to get pictures...

now in the script i have sample that shows like this

"SELECT * FROM users WHERE id=1";

now if I take away the WHERE id=1 and load the page as

show.php?id=1

the pics dont' show up?????

why would it work one way and not the other.

thanks

[ir4z0r]

insert
$id = $_GET['id'];
at the beginning of the script

[dv6cougar]

Originally posted by ir4z0r
insert
$id = $_GET['id'];
at the beginning of the script

most definitely will try taht

i forget to mention that....

i' using ".$row["2"]." through ["34"]

which displays a profile and that shows up either way 🙁

my servers down 🙁, shoudl be back up soon, as soon as it is up, I will be trying the $_GET

thanks

[dv6cougar]

ok i tried that

and i still got nothing 🙁

anyone have any ideas?

  <?
		 include("db.php");

	  $query2 = "SELECT * FROM users WHERE id=$id";
	  $result = mysql_query($query2);

	 $row = mysql_fetch_array($result);

	  $id=$_GET["1"];
   echo "<tr>";
      echo "<td width=\"100%\"><b><font face=\"Verdana\" size=\"2\">".$row["1"]."  :: ".$row["10"]." Mercury Cougar</font></b></td>";
   echo "</tr>";
   ?>
  </table>
  <p>&nbsp;</p>
  <table border="0" cellpadding="2" cellspacing="0" style="border-collapse: collapse" width="100%" id="AutoNumber3" height="200">
    <tr>
      <td width="50%" valign="top"><b><font size="2" face="Verdana">Mods</font></b><ul>


	  <? 

		if ($row["12"] == "") {
		}
		else 
		{

        echo "<li><font face=\"Verdana\" size=\"1\">".$row["12"];
		echo "</font></li>";
		}
		?>
        <? 
		if ($row["25"] == "") {
		}
		else 
		{

        echo "<li><font face=\"Verdana\" size=\"1\">".$row["25"];
		echo "</font></li>";
		}
		?><? 
		if ($row["13"] == "") {
		}
		else 
		{

        echo "<li><font face=\"Verdana\" size=\"1\">".$row["13"];
		echo "</font></li>";
		}
		?><? 
		if ($row["26"] == "") {
		}
		else 
		{

        echo "<li><font face=\"Verdana\" size=\"1\">".$row["26"];
		echo "</font></li>";
		}
		?>

that's my general script and all the rows above display perfectly... it's great.. on show.php?id=1... BUT... this portion does not work! but it does work if i do WHERE id=1"; in my query.....

here's the part that won't work, any one that can help me 🙁

<?

$incldir="db/memberpics/".$row["1"]."/";
$pagenum=$QUERY_STRING;

if ( $pagenum == NULL ) {  

  $pagenum=1;
}


$realpage=$pagenum - 1;
$linecount=0;

$d2 = dir($incldir);

while($entry=$d2->read()) {
    if ( $entry != "." && $entry != ".." && $entry != ".total" ) {
       $linecount++;
    }
}
$pagecount=$realpage * 5 + 1;
$endcount=$pagecount + 5;

$totalpages=floor($linecount / 5);
$rtotalpages=$linecount % 5;

if ( $rtotalpages >= 1 ) {
   $totalpages++;
}
//line 30
$currcount=1;

$d2 = dir($incldir);

while($entry=$d2->read()) {
    if ( $entry != "." && $entry != ".." ) {
      if ( $currcount < $endcount && $currcount >= $pagecount )






{
    echo "<a href=\"db/memberpics/".$row["1"]."/${entry}\"><img src=\"db/memberpics/".$row["1"]."/${entry}\" border=0></a>&nbsp;&nbsp;";
    }
    $currcount++;

}
}
echo "<br><Br>";
$back=$pagenum - 1;
$next=$pagenum + 1;

if ( $back < "1" ) {
  echo "&nbsp;&nbsp;";
} else {
  echo "<A href=\"show.php?$back\">&lt;&lt;</a>";
  echo "&nbsp;";
}

$totalpagecount=1;

while ( $totalpagecount <= $totalpages ) {
   if ( $totalpagecount == $pagenum ) {
      echo "<b>$totalpagecount</b>&nbsp;";
   } else {
      echo "<a href=\"show.php?$totalpagecount\">$totalpagecount</a>&nbsp;";
   }
   $totalpagecount++;
}


if ( $next > $totalpages ) { 
  echo "&nbsp;&nbsp;";
} else {
  echo "<A href=\"show.php?$next\">&gt;&gt;</a>";
}

?>

thanks 😃

[ir4z0r]

Originally posted by ir4z0r
insert
$id = $_GET['id'];
at the beginning of the script

i don't know where YOU think the beginning of the script is, I would think right after the <? 😉
and why did you use ["1"] ? use ['id']

[dv6cougar]

Originally posted by ir4z0r
i don't know where YOU think the beginning of the script is, I would think right after the <? 😉
and why did you use ["1"] ? use ['id']

yeah it is after the <? 🙂

i'll try that, and using 1 or id wouldn't matter? both meaing id essentially 😃

thanks again, i'll let you know if it works

[dv6cougar]

DOH!!

still no luck

here's the page....

http://www.tunercarz.com/midwest/show.php?id=1

http://www.tunercarz.com/midwest/sample.php

now try both and tell me what you think 🙁

BOTH SCRIPTS ARE IDENTICAL except show.php has the "WHERE id=$id";

and sample has "WHERE id=1";

it's poop 🙁

any more ideas? why are the pics not being pulled but the other stuff is?