[RESOLVED] create links from table entries

[woolseyr]

Hi,
I am trying to create a table of contents of sorts where the links when clicked will display the contents from the data base the trouble i am having is with the variables (i believe) there is only one row of entries. i just want it to pull a specific field. here is the code that i have for it to display the field names with the link.

<?php

include('../db_connect.php'); ?>

<?


$query = "SELECT * FROM manual";

$result = mysql_query($query) or
print ("Can't select entries from table manual.<br />" . $query . "<br />" . mysql_error());
while($row = mysql_fetch_array($result))

{
	echo
		"<a href='manual2_en.php?=preamble" . "'>" . "Preamble" . "</a>" . "<p>" .
		"<a href='manual2_en.php?=scc" . "'>" . "School Community Code" . "</a>" . "<p>" ;
		}
?>  

The page that it is supposed to redirect to i dont have that completely worked out yet... that is where i am having the most troubles

This is the second page (where it should display the content.)

<?php

include('../db_connect.php'); ?>
<?
if (!$_GET['scc']) { 
      header("Location: manual_en.php"); 
      exit(); 
   } else { 
      $id  = $_GET['scc'];
   }

$query = "SELECT $id FROM manual'";

$result = mysql_query($query) or
print ("Can't select entries from table Parent Letters.<br />" . $query . "<br />" . mysql_error());
while($info = @mysql_fetch_array($result))
    {
		echo
    	    "$body {$info['scc']}" ;
    }

?>   

As you can see most of it will not work for sure cause it is only calling the one field. I just dont know what to actually put there.

Any help would be great.

Thanks.

[sid]

what is the structure of the manual table?

[woolseyr]

---

--

-- Table structure for table 'manual'

CREATE TABLE manual (
id int(2) NOT NULL auto_increment,
preamble longtext NOT NULL,
contents longtext NOT NULL,
mission longtext NOT NULL,
scc longtext NOT NULL,
curriculum longtext NOT NULL,
stu_progress longtext NOT NULL,
school_routines longtext NOT NULL,
extracurricular longtext NOT NULL,
appa longtext NOT NULL,
appb longtext NOT NULL,
appc longtext NOT NULL,
appd longtext NOT NULL,
appe longtext NOT NULL,
appf longtext NOT NULL,
appg longtext NOT NULL,
apph longtext NOT NULL,
appi longtext NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

[Weedpacket]

I think you've got your links back-to-front

<a href='manual2_en.php?=scc'>

This won't create $GET['scc'] nor put a value into it. From the other link in that code, and from your table, I'm going to guess that you meant scc to be the field name.

<a href='manual2_en.php?field=scc'>

and then

if(empty($_GET['field']))
{
      header("Location: manual_en.php"); 
      exit(); 
}
$field = $_GET['field'];
if(!in_array($field, 'preamble', 'scc', 'etc'))
{
      header("Location: manual_en.php"); 
      exit(); 
}
$query = "Select $field from manual";

Now, that probably won't do what you want, though. Unless you really do want to select all preambles from the manual table, or all sccs from the manual table, or....

Do you really want to select an entire column (a certain field from every record), or are you actually after a single record?

[woolseyr]

actually this is probably exactly what i am looking for. I know that this is probably a long way of doing this but i am only going to be putting one record in that table... and I will just be updating that record. I am using this for learning different ways of doing what i need my site to do..

Now it just gives.

Warning: Wrong parameter count for in_array() in /var/www/zenonpark/htdocs/en/manual2_en.php on line 99

Which is

if(!in_array($field, 'preamble', 'scc', '.........'))

[laserlight]

Read the PHP Manual on [man]in_array/man.

[woolseyr]

Doing that as we speak

[woolseyr]

Thanks all for you help. I did it a little different and got it to work..
Dont know if it is the best way to do it. but it does what i need it to ....

what i did was

<?
if(empty($_GET['field']))
     { 
          header("Location: manual_en.php"); 
          exit(); 
     } else {    

$field = $_GET['field'];
	  }
$query="SELECT * FROM manual";

$result = mysql_query($query) or
print ("Can't select entries from table manual.<br />" . $query . "<br />" . mysql_error());

while($info = @mysql_fetch_array($result))
    {
	echo $info["$field"];				
    }
?>  

Thanks again