[RESOLVED] Is it possible to create a ‘PHP switch’ for ‘WHERE’ - MySQL?

spiderfang

Hi,

Is it possible to create a ‘PHP switch’ for ‘WHERE’ command?

I would like to display results based on the link that is clicked from the main menu.

Is it possible to add this switch code or similar within the the MySQL code?

switch($_GET['SC'])   

{
case 'Posters.php': echo('Poster'); break;
case 'Things.php': echo('Things'); break;
}

If I click links Things.php from the main menu, I would like it to echo Things.
WHERE Category=’Things’ '")

Or If I select Posters.php
WHERE Category=’Posters’ '")

<?php
// Make a MySQL Connection
mysql_connect("localhost", "xxxxxx", "xxxxxx") or die(mysql_error());
mysql_select_db("dbname") or die(mysql_error());

// Get all the data from the "example" table
$result = mysql_query("SELECT * FROM example WHERE Category ='[COLOR=Blue]if I click links Things.php 
from main menu, I would like it to display Things. Or If I select Posters.php > Posters[/COLOR]'") 
or die(mysql_error());  

echo "<table border='1'>";
echo "<tr> <th>Name</th> <th>Age</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
	// Print out the contents of each row into a table
	echo "<tr><td>"; 
	echo $row['Banner'];
	echo "</td><td>"; 
	echo $row['Info'];
	echo "</td></tr>"; 
}

echo "</table>";
?>

void_function

Sure:


$something= $_GET['something'];
$where='';

switch ($something) {
  case 'a': $where= "something='a'"; break;
  case 'b': $where= "something='b'"; break;
  ...
}

$res= mysql_query("SELECT something_else FROM table WHERE $where");

spiderfang

Many thanks for the quick reply!

I’m not to sure if I’ve placed the coding correctly....we’ll obviously not because I only have half a clue what’s going on here!! I seem to be getting error!?

<?php
// Make a MySQL Connection
mysql_connect("localhost", "xxxxxx", "xxxxxx") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());

// Get all the data from the "example" table

$something= $_GET['SC'];
$where='';

switch ($something) {
  case ‘Posters.php’: $where= "something='Posters-UK.php'"; break;
  case 'Things.php': $where= "something='Things'"; break;
}

$res= mysql_query("SELECT something_else FROM example WHERE $where")
or die(mysql_error()); 

echo "<table border='1'>";
echo "<tr> <th>Banner</th> <th>Info</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
	// Print out the contents of each row into a table
	echo "<tr><td>"; 
	echo $row['Banner'];
	echo "</td><td>"; 
	echo $row['Info'];
	echo "</td></tr>"; 
}

echo "</table>";
?>

void_function

See this:

$res= mysql_query("SELECT something_else FROM example WHERE $where")
or die(mysql_error()); 

// ...


while($row = mysql_fetch_array( $result )) {

Both should be either $res or $result. mysql_fetch_array() takes as parameter what mysql_query() returns.

Also, if you expect fields Banner and Info in the row fetched, then these should be present in the query:

SELECT Banner, Info FROM tablename WHERE $where

I hope you did rewrite my example to reflect your table structure?

spiderfang

Many thanks void_function for your replies.

I’ll try to make it a bit more clear on what I’m trying to accomplish.

This is my MySQL database (localhost > test > testing):

Category | Banner | Info

This is my main menu:

<a href="?SC=Stuff.php-UK.php">Stuff</a>
<a href="?SC=Things.php">Stuff</a>

when I click stuff.php I what to output:

Banner | Info

Banner 2 | Text
Banner 2 | Text

when I click Things.php I what to output:

Banner | Info

Banner 1 | Text
Banner 1 | Text

This is my coding so far which doesn’t seem to be outputting anything:

<?php
// Make a MySQL Connection
mysql_connect("localhost", "xxxxxx", "xxxxxx") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());

// Get all the data from the "testing" table

$something= $_GET['SC'];
$where='';

switch ($something) {
  case 'Stuff.php': $where= "something='Stuff'"; break;
  case 'Things.php': $where= "something='Things'"; break;
}

$result= mysql_query("SELECT * FROM testing WHERE $where") 
or die(mysql_error());

echo "<table border='1'>";
echo "<tr> <th>Banner</th> <th>Info</th> </tr>";

// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {

// Print out the contents of each row into a table
	echo "<tr><td>"; 
	echo $row['Banner'];
	echo "</td><td>"; 
	echo $row['Info'];
	echo "</td></tr>"; 
}

echo "</table>";
?>

void_function

Perhaps you should replace "something" with "Category":

switch ($something) {
  case 'Stuff.php': $where= "Category='Stuff'"; break;
  case 'Things.php': $where= "Category='Things'"; break;
}

Plus, why do you have .php extension for SC? Is there any particular reason? And, did you close the doublequotes in the href, or is this just a typo here? Eventually, everything is case sensitive here, so make sure all your fields and variables are of proper case.

spiderfang

Double quotes were typos. I'm using .php extension as the pages will contain other php coding for processing. I don't believe this should be a problem though as the original coding without the switch processed fine.

I made the changes but still all I get is the table headers and no data from Mysql!

<?php
// Make a MySQL Connection
mysql_connect("localhost", "xxxxxx", "xxxxxx") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());



// Get all the data from the "testing" table

$something= $_GET['SC'];
$where='';

switch ($something) {
  case 'Stuff.php': $where= "Category='Stuff'"; break;
  case 'Things.php': $where= "Category='Things'"; break;
}

$result= mysql_query("SELECT * FROM testing WHERE Category $where");

echo "<table border='1'>";
echo "<tr> <th>Banner</th> <th>Info</th> </tr>";

// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {

// Print out the contents of each row into a table
	echo "<tr><td>"; 
	echo $row['Banner'];
	echo "</td><td>"; 
	echo $row['Info'];
	echo "</td></tr>"; 
}

echo "</table>";
?>

void_function

spiderfang wrote:
Double quotes were typos. I'm using .php extension as the pages will contain other php coding for processing. I don't believe this should be a problem though as the original coding without the switch processed fine.

My point is that you don't need the .php extension for the values you're passing through SC variable.

Try this query:

$result= mysql_query("SELECT * FROM testing WHERE $where");

spiderfang

$result= mysql_query("SELECT * FROM testing WHERE $where");

YEEEEEEEEEEEEEEE it worked! it worked! 🙂

Many Thanks void_function