Querying mysql with php

[Anon]

I have a database that i am trying to Query, but I only want results of rows who have a column number the same as a variable in my page. Something like SELECT * FROM tablename WHERE $variable = $Row[Columnname]. Right now when I pass the variable and it matches the the value in the column it brings up all of the records. What I want is it to bring up only the records that have the column value I stated before. here is what I have coded so far. It pulls up all of the records.

$Query = "SELECT * FROM $TableName";
$Result = mysql_db_query ($DBName, $Query, $Link);
$Row = mysql_fetch_array($Result);
print ($region);
print ($Row[Region]);

					$Query2 = "SELECT * FROM $TableName WHERE $region = $Row[Region]";
					$Result2 = mysql_db_query ($DBName, $Query2, $Link);


					//Create the tables

					print ("<Table Border=0 Width=\"100%\" Cellspacing=2 Cellpadding=2 Align=CENTER>\n");
					print ("<TR Align=CENTER Valign=TOP>\n");
					print ("<TD Align=CENTER Valign=TOP><b><u>Session ID</u></b>\n");
					print ("<TD Align=CENTER Valign=TOP><b><u>Session Name</u></b>\n");
					print ("<TD Align=CENTER Valign=TOP><b><u>Region</u></b>\n");
					print ("<TD Align=CENTER Valign=TOP><b><u>Location</u></b>\n");
					print ("<TD Align=CENTER Valign=TOP><b><u>Instructor</u></b>\n");
					print ("<TD Align=CENTER Valign=TOP><b><u>Time</u></b>\n");
					print ("<TD Align=CENTER Valign=TOP><b><u>Date</u></b>\n");
					print ("</TR>\n");

					//Get Results

					while ($Row2 = mysql_fetch_array($Result2)) {
						print ("<TR ALIGN=CENTER VALIGN=TOP>\n");
						print ("<TD ALIGN=CENTER VALIGN=TOP>$Row2[Session_ID]</TD>\n");
						print ("<TD ALIGN=CENTER VALIGN=TOP>$Row2[Session_Name]</TD>\n");
						print ("<TD ALIGN=CENTER VALIGN=TOP>$Row2[Region]</TD>\n");
						print ("<TD ALIGN=CENTER VALIGN=TOP>$Row2[Location]</TD>\n");
						print ("<TD ALIGN=CENTER VALIGN=TOP>$Row2[Instructor]</TD>\n");
						print ("<TD ALIGN=CENTER VALIGN=TOP>$Row2[Time]</TD>\n");
						print ("<TD ALIGN=CENTER VALIGN=TOP>$Row2[Date]</TD>\n");
						print ("</TR>\n");
					}
			mysql_close ($Link);
			print ("</Table>\n");

[zalath]

$Query2 = "SELECT * FROM $TableName WHERE $region = $Row[Region]";

Consider a) using $Row["Region"] instead, b) storing the $Row["Region"] in another variable and c) forming the query like so: $Query2 = "SELECT * FROM $TableName WHERE $region = '$some_other_variable' ";

Also consider reading the manual 😉

-L-