Noob in need of help

[Luvz2drv]

Hi my name is Luvz2drv and I am a noob.

lol Great .. now what I am trying to do is this

A - B - C - D - E at the top of a page what I want to happen is when user selects ie a that this will goto a search page and will then sort out the displayed output by A or by B depending on what they have selected

I guess my question realy is can someone give me an example that I can build on to complete this task.

so that when a url of http://mydomain.com/search.php?A is clicked by the user that it runs the code assoiacted with the a..

thanks

[trandom]

just do something like:

<a href="search.php?query=a">Click here for A</a>
<a href="search.php?query=b">Click here for B</a>

if ($_GET['query'] == 'a') {
    // code for 'a' here.
} elseif ($_GET['query'] == 'b') {

} .... and so on....

[bradgrafelman]

Well, for the alphabet you could do...

for($i = 65; $i < 91; $i++) {
    echo '<a href="search.php?letter='.chr($i).'">'.chr($i).'</a>';
    if($i != 90 && $i != 77) echo ' || '; // This separates letters
    if($i == 77) echo "<br/>\n"; // This breaks it into 2 lines
}

For the search page, you'd simply do something like:

if(isset($_GET['letter'])) {
    $query = 'SELECT column1, column2 FROM myTable WHERE name LIKE \'' . mysql_real_escape_string($_GET['letter']{0}) . '%\' ORDER BY name';
} else {
    // what should the MySQL query be if there wasn't a letter
   // passed in the URL? do that here.
}

$exec = mysql_query($query);
// etc. .....

[Luvz2drv]

when I run the page now i get white

not sure where I have gone worng now

trying to pass the userif number to bring up the user and there awards..

if I take out the $iduser and make it a number it works... what im I doing wrng

if(isset($_GET['iduser'])) {
$iduser = mysql_real_escape_string($_GET[’iduser’]);
	$query = "SELECT userName, awdName, award_user_date, award_user_area, award_user_info, award_user_event, user.userID FROM award_user, award, user WHERE user.userID = award_user.userID AND award.awdID = award_user.awdID AND userID = '" . $iduser . " ' order by award_user_date DESC;";




$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
$chkname=temp;
$i=0;
while ($i < $num) {

$userID=mysql_result($result,$i,"userID");
$userName=mysql_result($result,$i,"userName");
$awdName=mysql_result($result,$i,"awdName");
$award_user_date=mysql_result($result,$i,"award_user_date");
$area=mysql_result($result,$i,"award_user_area");
$info=mysql_result($result,$i,"award_user_info");
$event=mysql_result($result,$i,"award_user_event");


if ($userName<>$chkname)
{print "<tr><td style='background-color:#aaaaaa;' colspan='3'>$userID <b>$userName</b></td></tr><tr style='background-color:#cccccc;width:150px;vertical-align:top;'><td>$awdName</td><td>$award_user_date</td><td>";} 

else 
{print "<tr style='vertical-align:top;background-color:#cccccc;'><td>$awdName</td><td>$award_user_date</td><td>";}

if ($area<> ''){
print "$area ";
}

if ($event<> ''){
print "$event";
}

if (($area == '' ) && ($event == '')){
print "$info";
}
else {
print "<br /> $info";
}

$chkname=mysql_result($result,$i,"userName");
$i++;
print "</td></tr><tr><td>ran query</td></tr>";
}


} else {
    // what should the MySQL query be if there wasn't a letter
   // passed in the URL? do that here.
	print "none";

}
?>

[Weedpacket]

$iduser = mysql_real_escape_string($_GET[’iduser’]); 

Check your quotes; PHP isn't recognising the characters you're using. Setting error reporting to E_ALL during development would catch things like this. Note that it will also complain about "$chkname=temp;", because it won't recognise "temp". null would be a better choice here.

A couple of stylistic notes. First

$i=0;
while($i < $num) {
...
$i++;
}

is equivalent to

for($i=0; $i<$num; $i++) {
...
}

It's just tidier.

Second, you'll find [man]mysql_fetch_array[/man] a more efficient way to extract data from a result set than repeated calls to mysql_result. (And, further down in the loop it would be simpler to just have $chkname = $userName; ).

And third, try and pick a better subject line next time - it took me ages to track this down again 🙂