[snakeob]

hello im having some trouble figureing out which method i should use,
basicly im trying to get this to have in the first menu the number you want to select(which works)
butthe tricky part is for the other two dropdown menus i want to be able to select the month and year, but they are both in one column, should i split the column into two, or should i use a substring? im lost please help

heres my code

PHP Code:

$result = mysql_query("SELECT DISTINCT callroutein FROM call_list");



echo "<h2>Please select the client and month that you  would like to generate a bill for<h2>";

echo "<form action='processform.php' method='POST'>";

echo "<select name='number'>\n";

while ( $row = mysql_fetch_array($result))

{

    echo "<option value='{$row['callroutein']}'>";

    echo $row['callroutein']."\n";

}



echo "</select>";

echo "\t";



$result2 = mysql_query("SELECT DISTINCT * FROM call_list WHERE calldate LIKE '' ");



echo "<form action='processform.php' method='POST'>";

echo "<select name='month'>\n";

while ( $row = mysql_fetch_array($result2))

{

        echo "<option value='{$row['calldate']}'>" . "</option>";

        echo $row['calldate']."\n";

}

echo "</select>";



$result3 = mysql_query("SELECT DISTINCT substring(calldate,8,4)AS calldate FROM call_list ORDER BY calldate ASC ");



echo "<form action='processform.php' method='POST'>";

echo "<select name='year'>\n";

while ( $row = mysql_fetch_array($result3))

{

        echo "<option value='{$row['calldate']}'>" . "</option>";

    echo $row['calldate']."\n";

}

echo "</select>";



echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp";

echo "\n<input type='submit' value= 'Submit'>";

echo "\n</form>\n"; 

[snakeob]

please help

iv gotten to where i can get the proper names to display in the drop downs but now once i try getting them into one query i get errors...

PHP Code:

<?php

$result = mysql_query("SELECT * FROM biller WHERE account,calldate,calldate LIKE" . $_POST['number'] . $_POST['year'] . $_POST['month']);

while ($row = mysql_fetch_array($result))
{
    $account=$row['account'];
    $calldend=$row['calldateend'];
    $calldstart=$row['calldatestart'];
    $calldate=$row['calldate'];
    $totalctime=$row['totalcalltime'];
    $totalccharge=$row['totalcallcharge'];
    $charge=$row['charge'];
    $origin=$row['origin'];
    $nava=$row['navagataid'];

print 
"<tr>
    <td>$account</td>
    <td>$calldend</td>
    <td>$calldstart</td>
    <td>$calldate</td>
    <td>$totalctime</td>
    <td>$totalccharge</td>
    <td>$charge</td>
    <td>$origin</td>
    <td>$navi</td>
</tr>";

}
?>

please help