Alphabetical

[redrock]

I have a form built to do prayers pages..What i want to do is take the receipents name an send it to the page that goes with their name..For example someone sends Ally a prayer i want it to go the A's page an then someone sends John a prayer i want it to go to the J's page is there a way to do this without creating 26 different pages an 26 different forms.I have the form linked to a MySql db

[Bootsman123]

I'm still not getting exactly what you want. You could take the first letter of their name and then have something like this:
page.php?first_letter=A or something like that.

[redrock]

i may have not explained well enuff ... i am wanting to pull form the database an put all the postings with the receipents name on a corresponding page with their first letter of name ie.. a

[Weedpacket]

So you want to be able to get from the database all the prayers for people with names starting with 'A'?

The SQL for thsi would be

SELECT prayer FROM thetable WHERE name LIKE 'A%'

Of course, you'd want to use a variable instead of A, something like

$query = "SELECT prayer FROM thetable WHERE name LIKE '".$first_letter."%'";

$first_letter would be got from $GET['first_letter'] as per Bootsman123's suggestion, thought for safety, it would have to be more than just $first_letter=$GET['first_letter'];. Something like

$first_letter = strtoupper(substr($_GET['first_letter'],0,1));
if(strpos('ABCDEFGHIJKLMNOPQRSTUVWXYZ', $first_letter)===false) $first_letter='A';

Would be fairly reasonable defence.

[redrock]

ok this is what i have

<?
//page is test.php

//inlcude the db connection page
require("dbconn.php");


$sql=("SELECT em_prayers.em_sender,em_prayers.em_receiver,em_prayers.em_message FROM em_prayers;");

$result=mysql_query($sql, $conn) or die ("Can't connect because ".mysql_error()); 

$first_letter = ("strtoupper(substr($_GET['$first_letter'],0,1));
if(strpos('ABCDEFGHIJKLMNOPQRSTUVWXYZ', $first_letter)===false)$first_letter='A'");
echo '<table border="4" cellspacing="0" width="50%" bordercolor="#800080" cellpadding="5"><tr>';

$i = 0;
while ($rows=mysql_fetch_array($result)){
    echo '<td>'.$rows['em_sender'].'</td>';
    echo '<td>'.$rows['em_receiver'].'</td>';
    echo '<td>'.$rows['em_message'].'</td>';
    if ($i++%3 == 0) {
        echo '</tr><tr>';

} 
}
echo '</tr></table>';
?>

an this is the error im getting
Warning: strpos() [function.strpos]: Empty delimiter. in /home/xxx/public_html/prayers/prayers.php on line 13

[CaptianChaos]

You said:
if(strpos('ABCDEFGHIJKLMNOPQRSTUVWXYZ', $first_letter)===false)$first_letter='A'");

You have a ") at the end of the line that should not be there. Try this:

if( strpos('ABCDEFGHIJKLMNOPQRSTUVWXYZ', $first_letter) === false) $first_letter='A';

[CaptianChaos]

Whoah, didn't see this syntax error at first:
$first_letter = ("strtoupper(substr($_GET['$first_letter'],0,1));

should be:
$first_letter = strtoupper(substr($_GET['$first_letter'],0,1));

[Weedpacket]

Originally posted by CaptianChaos
Whoah, didn't see this syntax error at first:
$first_letter = ("strtoupper(substr($_GET['$first_letter'],0,1));

should be:
$first_letter = strtoupper(substr($_GET['$first_letter'],0,1));

Not only that, but

$first_letter = strtoupper(substr($_GET['first_letter'],0,1));

And it helps to do that before the query, so that you can use $first_letter in the query.

[redrock]

i have tryed changing everything this where i am now

<?
//page is test.php

//inlcude the db connection page
require("dbconn.php");
require("prayers1.php");

$sql=("SELECT em_prayers.em_sender,em_prayers.em_receiver,em_prayers.em_message FROM em_prayers");

$result=mysql_query($sql, $conn) or die ("Can't connect because ".mysql_error()); 
$first_letter = strtoupper(substr($_GET['first_letter'],0,1)); 
if(strpos('ABCDEFGHIJKLMNOPQRSTUVWXYZ', $first_letter)===false)$first_letter='A';
echo '<table border="4" cellspacing="0" width="50%" bordercolor="#800080" cellpadding="5"><tr>';

$i = 0;
while ($rows=mysql_fetch_array($result)){
    echo '<td>'.$rows['em_sender'].'</td>';
    echo '<td>'.$rows['em_receiver'].'</td>';
    echo '<td>'.$rows['em_message'].'</td>';
    if ($i++%3 == 0) {
        echo '</tr><tr>';

} 
}
echo '</tr></table>';
?>

an still getting
Warning: strpos() [function.strpos]: Empty delimiter. in /home/kimntim/public_html/prayers/prayers.php on line 12

[CaptianChaos]

You are probably getting the error because $_GET['first_letter'] is not set, therefore $first_letter equals nothing.

Try changing this line:

if(strpos('ABCDEFGHIJKLMNOPQRSTUVWXYZ', $first_letter)===false)$first_letter='A';

to this:

if( !$first_letter || strpos('ABCDEFGHIJKLMNOPQRSTUVWXYZ', $first_letter)===false)$first_letter='A';

[Weedpacket]

Oh yeah, didn't check that :embarrassed:

if(!empty($_GET['first_letter']))
    $first_letter = strtoupper(substr($_GET['first_letter'],0,1))
else
    $first_letter = 'A';

[CaptianChaos]

weedpacket, what have you been yyyyyy? That's not like you to miss something like that... he, he

[redrock]

im sure im missing just one little thing here so can someone help

<?
//page is test.php

//inlcude the db connection page
require("dbconn.php");
require("prayers.php");

$first_letter = trim($_GET['first_letter']);
$first_letter = strtoupper( substr( $first_letter,0,1)); 
if(strpos('ABCDEFGHIJKLMNOPQRSTUVWXYZ', $first_letter)===false)$first_letter='A';

$sql=("SELECT em_prayers.em_sender, em_prayers.em_receiver, em_prayers.em_message FROM em_prayers where em_receiver like '". $first_letter . "%'");

echo '<table border="4" cellspacing="0" width="50%" bordercolor="#800080" cellpadding="5"><tr>';

$i = 0;
while ($rows=mysql_fetch_array($result)){
echo '<td>'.$rows['em_sender'].'</td>';
echo '<td>'.$rows['em_receiver'].'</td>';
echo '<td>'.$rows['em_message'].'</td>';
if ($i++%1 == 0) {
echo '</tr><tr>';

} 
}
echo '</tr></table>';
?>

this is the errors im getting
Warning: strpos() [function.strpos]: Empty delimiter. in /home/xxx/xxx/prayers/prayer.php on line 10

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xxx/xxx/prayers/prayer.php on line 17

[Weedpacket]

Originally posted by redrock
im sure im missing just one little thing here so can someone help

Yes, just one little thing: the mysql_query() line fell out somewhere along the way... it would go immediately after the $sql="SELECT ..."; line.

this is the errors im getting
Warning: strpos() [function.strpos]: Empty delimiter. in /home/xxx/xxx/prayers/prayer.php on line 10

This one is a bit more curious. Why is $first_letter so determined to be empty? If you're using a URL that ends with a "?first_letter=G" then the only reason I can see it not working (once that check I accidentally left out is put in) is if your version of PHP is earlier than 4.1; in that case, use $HTTP_GET_VARS instead of $_GET.

If you're not using a URL that ends with "?first_letter=G" to get the letter into the script, the question becomes how are you supplying it?

[redrock]

<<<<<<<<<< is a dummy i finally figured out my goof....