displaying data from a href link?

[JCary]

Hi,

I'm pretty new to php and have a grasp on most of the basics but can't seem to figure out what should be simple...! Let's say I have a database with Name, Gender, Location. How do I create links like "View All Males | View All Females"? I know part of the code is:

$result = mysql_query("SELECT * FROM mytable WHERE gender='Male'",$db); 

But I'd like links to pull them up.

Thanks.

[mark_W]

Something like this:

Linking page:

<a href="getsex.php?sex=male">Males</a>
<a href="getsex.php?sex=female">Females</a> 

Getsex.php

$sex = $_GET['sex'];

if(isset($sex)) {
     if($sex == 'male'){
           // DB query to get male
     }
     if($sex == 'female'){
           // DB query to get females
     }
} else {
      echo 'Error: sex not set';
} 

Obviously this might not be the best way, just a quick way to show you

Mark

[altecex]

mark's method is definately the most reasonable way to do this. but, if you wanted to have the option to view both sexes at the same time, you could do this:

// HTML links
<a href="getsex.php?sex=male">Males</a>
<a href="getsex.php?sex=female">Females</a>
<a href="getsex.php?sex=both">Both</a>


//getsex.php

$sex = $_GET['sex'];


switch ($sex) {

     case 'male':
          //query lookup for males
     break;

     case 'female':
          //query lookup for females
     break;

     case 'both':
          //query lookup for both sexes
     break;

     default:
          //query lookup for whatever you want the default sex or sexes to be (only for if a sex is not specified in the link)

} 

just building off of mark's idea.

[JCary]

You guys are awesome, thanks a lot. This really helped explain things.


Thanks.

[mark_W]

mark's method is definately the most reasonable way to do this. but, if you wanted to have the option to view both sexes at the same time, you could do this:

// HTML links
<a href="getsex.php?sex=male">Males</a>
<a href="getsex.php?sex=female">Females</a>
<a href="getsex.php?sex=both">Both</a>
 
 
//getsex.php
 
$sex = $_GET['sex'];
 
 
switch ($sex) {
 
case 'male':
//query lookup for males
break;
 
case 'female':
//query lookup for females
break;
 
case 'both':
//query lookup for both sexes
break;
 
default:
//query lookup for whatever you want the default sex or sexes to be (only for if a sex is not specified in the link)
 
} 

just building off of mark's idea.

Nice one Altecex!

You should probably check that $sex is actually set first and if not terminate the script rather than not checking and letting it run anyway.

Mark

[St.]

[offtopic]
.oO( <a href="getsex.php?sex=other">Other</a> ) 8)
[/offtopic]

[gregor002]

[offtopic]
.oO( <a href="getsex.php?sex=other">Other</a> ) 8)
[/offtopic]

HAHA ...