a-z list

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
webdzine
Forum Newbie
Posts: 20
Joined: Wed Dec 08, 2010 12:40 am

a-z list

Post by webdzine »

hey i am trying to have a search by player last name.

Code: Select all

<table width="100%">
	<tr>
     <?php      
$query_AZList = "SELECT DISTINCT UPPER(LEFT(lastname,1)) as letters FROM players ORDER BY letters";
$AZList = mysql_query($query_AZList) or die(mysql_error());
	$row_AZList = mysql_fetch_assoc($AZList);
	$totalRows_AZList = mysql_num_rows($AZList);
	do { ?>
		<?php echo ‘<a href=”players.php?ltr=’.$row_AZList['letters'].’”>’.$row_AZList['letters'].’</a>’; ?>
	   <td width="150" align="left" style="border-bottom: 1px dashed #ACACAC; padding: 3px 0px 3px 10px;">
	   <?php } while ($row_AZList = mysql_fetch_assoc($AZList)); ?>
	   </td>
	 </tr> 
</table>
i have this but i keep getting an error:
Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in ************** on line ("<?php echo ‘<a href=”players.php?ltr=’.$row_AZList['letters'].’”>’.$row_AZList['letters'].’</a>’; ?>")

please help i cant figure it out
smertius
Forum Newbie
Posts: 1
Joined: Sat Dec 25, 2010 4:04 pm

Re: a-z list

Post by smertius »

You have been used two different kind of apostrophe. Below you can find, correct line:

Code: Select all

  <?php echo '<a href=”players.php?ltr='.$row_AZList['letters'].'”>'.$row_AZList['letters'].'</a>'; ?>
webdzine
Forum Newbie
Posts: 20
Joined: Wed Dec 08, 2010 12:40 am

Re: a-z list

Post by webdzine »

thanks. for helping with the list.

but now i am running into a problem pulling the data.

when you click on a letter it takes me to players.php?ltr=B
i am trying to find a query where it will pull all players where there lastname starts with the letter
the code i currently have is


$lnameletter = $_GET['ltr'];

Code: Select all

<?php
$query_players = "SELECT * FROM players WHERE lastname.firstcharacter = 'ltr'";
$rsplayer = mysql_query($query_players) or die('Error, query failed');
while($rowplayer=mysql_fetch_object($rsplayer)){
?>
im pretty sure my problem is in lastname.firstcharacter
webdzine
Forum Newbie
Posts: 20
Joined: Wed Dec 08, 2010 12:40 am

Re: a-z list

Post by webdzine »

nevermind. got it..

i used :

Code: Select all

<?php
$query_players = "SELECT * FROM players WHERE LEFT (lastname, 1) = '$lnameletter'";
$rsplayer = mysql_query($query_players) or die('Error, query failed');
while($rowplayer=mysql_fetch_object($rsplayer)){
?>
Post Reply