html linking quesion/problem

cyronuts

Hello!

All I get when I run this script is the GET variable echoed back to me, do I have something wrong with syntax in my $query statement?

here is my html link:

here is my php to parse the value, and output html code from mysql if they match:

<? 

require_once("sc_fns.php"); 

echo $HTTP_GET_VARS['value']; 

db_connct(); 

mysql_select_db("book_sc"); 
$query = ("SELECT * FROM html_pages WHERE html_page_name = '$value'"); 
$result = mysql_query($query); 
$num_results = mysql_num_rows($result); 

//echo "<BR>Number of html pages found:".$num_results."<BR><BR>"; 

for ($i=0; $i <$num_results; $i++) 
{ 
$row = mysql_fetch_array($result); 

echo unhtmlentities($row["html_page_code"]); 
echo "<BR><BR>"; 

} 

?>

bitwise

Try this:

<a href="html_parse.php?value=<php echo($store_policies); ?>"> <IMG SRC="images/site/site_img5.gif" WIDTH="160" HEIGHT="35" BORDER="0"></A>

cyronuts

That returns:

http://localhost/phphsk/html_parse.php?value=<?%20echo($store_policies);%20?>

in the browser and a blank page....?

thanks for the effort though, any other ideas? I am new to this, but the idea is to have an html link when clicked on passes a variable to be compared against a page_name in the db, and if it matches, send back the output from the db.

I am having the hardest time figuring this out.

stuartc1

What about trying this:

notice this part: <?=$store_policies?>

cyronuts

Here is the script to process the results:

require_once("sc_fns.php");

site_header();

db_connct();

mysql_select_db("book_sc");
$query = "SELECT * FROM html_pages WHERE html_page_name = '$value'";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);

for ($i=0; $i <$num_results; $i++)
{
$row = mysql_fetch_array($result);

echo unhtmlentities($row["html_page_code"]);
echo "<BR><BR>";

}

Here is the page with the link:

Basically,

I hardcoded the $splash page in and the rest of the links use the format above. It works like a charm - all output comes from the database and presents totally clean on the site side.

THANKS FOR THE INPUT, this forum/site really rocks.

Cyronuts

prasit

Originally posted by cyronuts

db_connct();

see anything here?

😃