[RESOLVED] A to Z pagination problem

[vinny199]

Hi, what Am I doing wrong?

i've been following a tutorial on how to make an A to Z pagination navigation bar

I get an empty record although my variable parse fine from page 1 to page 2.

I presume there is something wrong with my recordset but what?

so on page one, for instance for my letter D I have the link:

<a href="posctode_02.php?p=d">D</a>

and on my page postcode_02.php I have the following recordset:

mysql_select_db($database_to_octo, $to_octo);
$query_rs_postcode = "SELECT * FROM users WHERE postcode LIKE '".$_GET['p']."' ";
$rs_postcode = mysql_query($query_rs_postcode, $to_octo) or die(mysql_error());
$row_rs_postcode = mysql_fetch_assoc($rs_postcode);
$totalRows_rs_postcode = mysql_num_rows($rs_postcode);

Where do I go wrong please?

Thanks,

Vinny

[devinemke]

change your query to:

$query_rs_postcode = "SELECT * FROM users WHERE postcode LIKE '" . $_GET['p'] . "%'";

[vinny199]

Thank you!