Page 1 of 1

a-z list

Posted: Sat Dec 25, 2010 2:07 pm
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

Re: a-z list

Posted: Sat Dec 25, 2010 4:18 pm
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>'; ?>

Re: a-z list

Posted: Sun Dec 26, 2010 9:47 pm
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

Re: a-z list

Posted: Sun Dec 26, 2010 10:49 pm
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)){
?>