[RESOLVED] Using Array + Database Query

[obrienkev]

Hi all,

I have a number of links created...

<a href="index.php" id="home">Home</a>
<a href="index.php" id="about">About</a>
<a href="index.php" id="contact">Contact</a>

Variables are then set...

$home = $_GET['home']; // etc...

I then want to query the database based on which link is selected...

$query = "SELECT * FROM '$table'";
$result = mysql_query($query) or die(mysql_error());

Is an Array best to use for $table??
How do I put all link variables($home, $about, $contact) into the Array and then perform the query relevant to the SELECTED link?

Thanks.

Kevin

[leatherback]

Hey Kevin

The actual variable that s set is "ID": $id, not the value:

$id - $_GET['id'];

$table ALWAYS is a string, and holds the name of the table you ae querying.

Have a look at tutorials on database queries on http://www.bio-vision.nl/coding/PhP.php to get te basics pat down

[obrienkev]

Below works. Thanks guys.

Links...

			 <ul>
			 <li><a href="index.php?id=home" id="home" name="home">Home</a></li>
			 <li><a href="index.php?id=about" id="about" name="about">About</a></li>
			 <li><a href="index.php?id=contact" id="contact" name="contact">Contact</a></li>
			 </ul>

PHP:

			 // connect to db
			 include('db_connect.php');

		 // Set Vars
		 $id = $_GET['id'];

		 // Get Data
		 $query = "SELECT text ".
		 	        "FROM '$id'";
		 echo $query;
	 //$result = mysql_query($query) or die(mysql_error());