PHP - Help With Pulling/displaying Data From Table?

I have a field in my table that gets populated with a custom value from a subscription form, but when the data gets inserted into the table, it adds some text I do not want to output. The field is for the user's name, but when the form saves it, it saves the name, plus the text #2# (this is from a Wordpress plugin and I can't figure out how to remove the #2# when I insert the value there either). Is there a way to remove this #2# text when I display the field's value in MySQL and PHP?

hi,
I am displaying mysql data in a table form using php. The first attached pic shows how is it looking with the current code. As you can see there are heading on the left and top of the table. So user can make booking on a specific day (heading is on the top for days) and for specific duration of time(headings are on the left). As in first pic, there has been a booking on Wed at 10 o clock, but the problem is, it is displaying duration just for half an hour. As this duration is from 10 o clock to 11 o clock. So what I want to do is in the second pic. Please view the second pic. In the second pic I want to display the highlighted area in blie because all this time is booked or reserved.

Here is my current code.
Code: [Select]
<?php
require("dbconnect/dbconnect.php");
$building = $_POST['building'];
$block = $_POST['block'];
$d_m = $_POST['d_m'];
$choose_one = $_POST['choose_one'];
function get_data($table, $choose_one) {
    $bool = 1;
    $get_days = mysql_query("SELECT * FROM days");
    $get_times = mysql_query("SELECT * FROM time");
    $days = mysql_num_rows($get_days);
    //$row_day_id = mysql_fetch_assoc($get_days);
    //$day_id_db = $row['dayid'];

    echo "<table cellspacing='0' border='0' cellpadding='5'>
            <tr>
                <th scope='col' width='100'></th>";
    while($row_time = mysql_fetch_assoc($get_times)) {
        while($bool <= $days) {
            $row_days = mysql_fetch_assoc($get_days);
            $dayname = $row_days['days'];
            echo "
                 <th scope='col' width='100'>$dayname</th>   
                 ";
            $bool++;
        }
        $day_id = 1;
        $timeid = $row_time['timeid'];
        $time = $row_time['time'];
        echo "
             <tr>
                <th scope='row' width='100' height='50'>$time</th>";
        while($day_id <= $days) {
            $get = mysql_query("
                            SELECT * FROM $table 
                            WHERE 
                            dayid='$day_id' 
                            AND 
                            timeid_from='$timeid' 
                            AND
                            d_m='$choose_one'
                            ") or die(mysql_error());
            if(mysql_numrows($get) > 0) {
                $row = mysql_fetch_assoc($get);
                $block = $row['block'];
                $apt = $row['apartment_no'];
                $room = $row['room_no'];
                $d_m = $row['d_m'];
                $timeid_to = $row['timeid_to'];
                echo "
                     <td width='110' height='50' bgcolor='lightblue'>
                        <b>Block:</b> $block<br />
                        <b>Apartment:</b> $apt<br />
                        <b>Room:</b> $room
                     </td>
                     ";
                //echo "</tr>";
            } else {
                echo "
                     <td width='110' height='50' bgcolor='green'></td>
                     ";
            }
            $day_id++;
        } //end of second inner while loop
        echo "</tr>";
    } //end of outer while loop
    echo "</table>"; 
}

if($building) {
    if($block) {
        if($d_m) {
            if($choose_one) {
                if($building == 'mik') {
                    if($block == 'Block A' || $block == 'Block B') {
                        get_data('reserve_mik_ab', $choose_one);
                    } else if ($block == 'Block C' || $block == 'Block D') {
                        get_data('reserve_mik_cd', $choose_one);
                    }
                }
                if($building == 'p') {
                    get_data('reserve_p',$choose_one);
                }
            } else {
                echo "Choose one!";
            }
        } 
    }
}
?>
Please help!

Hello, I have a simple feedback form which asks for name, location and a simple comment about the business. I have inserted data into the database successfully but I'm not sure on the best way to display the data from the table on the same page as the form (after redirection).

Here is my code:

FORM:
Code: [Select]
<form id="feedback" name="feedback" action="php/phpcustom.php" method="POST">
<fieldset>
     <legend>Gardenable.com Feedback</legend>
     <p><label for="fname">Name:</label><input type="text" size="30" maxlength="40" id="fname" name="fname" /></p>

     <p><label for="loc">Location:</label><input type="text" size="30" maxlength="40" id="loc" name="loc" /></p>

     <p><label for="com">Comments:</label><textarea cols="40" rows="6" maxlength="300" id="com" name="com"></textarea></p>

<p><input type="submit" name="send" id="submitbutton" value="Submit" /><input type="reset" name="reset" value="Reset" /></p>
</fieldset>
</form>

ACTION SCRIPT on submit:
Code: [Select]
<?php
session_start();


$dbhandle = mysql_connect('localhost', 'root', '')
     or die("Unable to connect to MySQL");
 
$selected = mysql_select_db("commentdatabase",$dbhandle)
     or die("Could not select the database");

$name = $_POST['fname'];  
$loc = $_POST['loc'];  
$com = $_POST['com'];  

$sql = "INSERT INTO userinfo (name, location, comment) VALUES ('{$name}','{$loc}','{$com}')";

if(!mysql_query($sql, $dbhandle)) {
 die('Error: ' . mysql_error());
}

$dbselect = "SELECT * FROM userinfo";

if(!mysql_query($dbselect, $dbhandle)) {
 die('Error: ' . mysql_error());
}

header('Location: ../contact.htm');

mysql_close();

?>

//This is underneath the FORM CODE:
Code: [Select]
<div id="feedbackDiv">
<?php
 $dbhandle = mysql_connect('localhost', 'root', '')
         or die("Unable to connect to MySQL");
 
     $selected = mysql_select_db("commentdatabase",$dbhandle)
         or die("Could not select the database");
 
 $result = mysql_query("SELECT * FROM userinfo");
 
 while ($row = mysql_fetch_array($result)) {
         echo "ID:".$row{'name'}." Name:".$row{'location'}."Year: ". $row{'comment'}."<br />";
     }
 
 ?>
</div>

It is displaying a tiny part of php code rather than the returned data. This is what i being displayed: "; } ?>

The data is inserting correctly but i'm unsure as to whether or not I need to pass the values in the url string in the header function?

Thank you for any information you can provide me.

Regards,

BuNgLe

I am working on a project that involves providing details for county government, and if applicable, cities independent of county oversight.  Virginia is a state with a lot of independent cities, so I wanted to echo them in a separate list underneath the county governments.   This code works fine when displaying Virginia information.  However, I would like to hide the Independent Cities heading in every other state.  For some reason, this code still echoes the Independent Cities heading in states without independant cities in the database.   Any thoughts or wisdom?   (sorry for pasting the whole bulky code)

$query = "SELECT * FROM state WHERE st_id=$statecode";
            $result = mysql_query($query) or die("Query $query failed : " . mysql_error());
            $row = mysql_fetch_assoc($result);
            $state_name=$row["st_name"];
            $state_note=$row["state_notes"];

            echo "<h2>Counties of " . $state_name; "</h2>\n";
            
            $query = "SELECT * FROM counties WHERE st_id=$statecode AND visible=1 ORDER BY county_name ASC";
            $result = mysql_query($query) or die("Query $query failed : " . mysql_error());
        
            echo "<table width=100%><tr><td valign=top width=33%>\n";

            $count = 1;
            $col = 0;
            $rowcount = (int)(mysql_num_rows($result) / 3) + 1;
            $remainder = mysql_num_rows($result) - ($rowcount - 1) * 3;
            /* ********************************************************* */
            while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
                echo "<a href=\"services.php?county=".$row["county_id"]."\">".$row["county_name"] . "</style></a><br />\n";
                $count = $count + 1;
                if ((($remainder > 0) && ($count == ($rowcount + 1))) || (($remainder <= 0) && ($count == $rowcount))) {
                    $col = $col + 1;
                    if ($col!=3) {
                        echo "</td><td valign=top width=33%>\n";
                        $count = 1;
                        if ($remainder > 0)
                            $remainder = $remainder - 1;
                    }
                }
            }
            /* ********************************************************* */
            echo "</td></tr></table><br>\n";
            mysql_free_result($result);
            /* ********************************************************* */
            
            $query2 = "SELECT * FROM cities WHERE st_id=$statecode AND visible=1 ORDER BY city_name ASC";
            $result2= mysql_query($query2) or die("Query $query failed : " . mysql_error());
            $city_id = $row['city_id'];
            $city_name = $row['city_name'];
            
            if ($city_id!="") {
                echo "<h3>Independent cities of " . $state_name; "</h3>\n";
                echo "<table width=100%><tr><td valign=top width=33%>\n";
                $count2 = 1;
                $col2 = 0;
                $rowcount2 = (int)(mysql_num_rows($result2) / 3) + 1;
                $remainder2 = mysql_num_rows($result2) - ($rowcount2 - 1) * 3;
                /* ********************************************************* */
                while ($row = mysql_fetch_array($result2, MYSQL_ASSOC)) {
                    echo "<a href=\"services.php?county=".$row["city_id"]."\">".$row["city_name"] . "</style></a><br />\n";
                    $count2 = $count2 + 1;
                    if ((($remainder2 > 0) && ($count2 == ($rowcount2 + 1))) || (($remainder2 <= 0) && ($count2 == $rowcount2))) {
                        $col2 = $col2 + 1;
                            if ($col2!=3) {
                            echo "</td><td valign=top width=33%>\n";
                            $count2 = 1;
                            if ($remainder2 > 0)
                                $remainder2 = $remainder2 - 1;
                    }
                }
            
                
            }
            /* ********************************************************* */
            echo "</td></tr></table><br>\n";
            mysql_free_result($result2);
            /* ********************************************************* */
            
            
            
            }
            
        ?>

Edited by myotch, 06 September 2014 - 09:19 PM.

Hi, I'm trying to make a dynamic html table to contain the mysql data that is generated via php. I'm trying to display a user's friends in a table of two columns and however many rows, but can't seem to figure out what is needed to make this work.

Here's my code as it stands:
Code: [Select]
<?php
//Begin mysql query
$sql = "SELECT * FROM friends WHERE username = '{$_GET['username']}' AND status = 'Active' ORDER BY friends_with ASC";
$result = mysql_query($sql);
$count = mysql_num_rows($result);

$sql_2 = "SELECT * FROM friends WHERE friends_with = '{$_GET['username']}' AND status = 'Active' ORDER BY username ASC";
$result_2 = mysql_query($sql_2);
$count_2 = mysql_num_rows($result_2);

while ($row = mysql_fetch_array($result)) {
                                                          echo $row["friendswith"] . "<br>";
                                                }
while ($row_2 = mysql_fetch_array($result_2)) {
                                                          echo $row_2["username"] . "<br>";
                                                }
?>

The above simply outputs all records of a user's friends (their usernames) in alphabetical order. The question of how I'd generate a new row each time a certain amount of columns have been met, however, is beyond me. Anyone know of any helpful resources that may solve my problem? Thanks in advance =)

Hi...

I tried to use foreach in displaying my table header, but I encountered problem when I tried to display data on the first row , my query only display the last Sum for the last Comp.

here is my code:

<html>
<head>
<title>Half Shell</title>
<link rel="stylesheet" type="text/css" href="kanban.css" />
<?php
  error_reporting(E_ALL ^ E_NOTICE);
  date_default_timezone_set("Asia/Singapore"); //set the time zone  
$con = mysql_connect('localhost', 'root','');

if (!$con) {
    echo 'failed';
    die();
}

mysql_select_db("mes", $con);


?>

<body>
<form name="param" action="" method="post" onSubmit="return false">

<div id="fieldset_PS">
<?php
   echo "<table>";
   
   $sql = "SELECT DISTINCT s.Comp FROM sales_order s, param_settings p WHERE s.Comp = p.Compounds ORDER BY s.Comp";
   $res_comp = mysql_query($sql, $con); 
   while($row_comp = mysql_fetch_assoc($res_comp)){
        $Comp[] = $row_comp['Comp'];
   }
   echo "<th>&nbsp;</th>";
   foreach($Comp AS $Comp){
    echo "<th>$Comp</th>";
  }   

   echo "<tr>
   <td>Total Kg/Compound</td>";
      $sql_sec = "SELECT SUM(TotalKg) AS TotalKg FROM sales_order  WHERE Comp = '$Comp' ORDER BY Comp";
   $res_sec = mysql_query($sql_sec, $con);
   
   while($row_sec = mysql_fetch_assoc($res_sec)){
       $TotalKg[] = $row_sec['TotalKg'];

   }
   foreach($TotalKg AS $TotalKg){
    echo "<td>$TotalKg</td>
    </tr>";
  }   

   ?>


I also attach the correct output that should be and the result from my code.

Thank you

Hey everyone. Currently I have a site set up where I manually edit the txt file and the site pulls it from the text file and displays via php. I wanted to automate it by creating one file which contains the sunset times for the whole year, and have php determine todays date and then display the corresponding sunset time.

Can someone please point me in the right direction?

maybe it can be set up in a way where each line in the txt file represents the day of the year. ex: Jan 1 would be line 0, Feb 1's sunset time would be on line 31 etc.

Thanks

Code: [Select]
id: 20 Reason: this is a test
id: 21 Reason: Tests
id: 22 Reason: Lolcatz
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: Reason:
id: 36 Reason: Test
As you can see on the 2nd code box there are id's 20,21,22 and 36 in the database the rest are not active in the database.

i am using using Code: [Select]
for to pull out the id that starts with the lowest value in the database, and only have it run until it gets to the maximum value.
Code: [Select]
for ($id=$set_min; $set_max<=7; $id++)
{
                // $id=$set_min is pulling the smallest value and $set_max is pulling the maximum value so it stops  after it gets to 36
$query=mysql_query("SELECT * FROM posted WHERE id = $id");
$query_row=mysql_fetch_array($query);

$reason = $query_row[reason];
$pulled_id = $query_row[id];
$pulled_pic22 = $query_row[picture];
$href_pull = "<a href=" . "search.php?id=" . "$id" .">";

echo "<td>" . $href_pull . "<img src=$pulled_pic22 height=200 width=150 />" . "</td>";
}

how would i make it so i do not pull the values 23-35 which are not in the active database.

Example: http://dev.hackmuch.com/of-the-day/search.php?id=36

FOr some reason i cant pull data from an XML file to insert into the database, it works without error just adds a blank value in the database?

i have this code at the moment, i guess arrayValue[71] is the value i need to pull and add to the "TABLE2" table, but when i run the script it just adds a blank value in the database?


<?php
include "connect.php";

//Price check Isle 9001! Query EVE-Central API. Example XML file is: http://api.eve-central.com/api/marketstat?typeid=35&regionlimit=10000002
$queryItemList = mysql_query("SELECT * FROM TABLE2;") or die(mysql_error());
$rowCount = mysql_num_rows($queryItemList);
$s=0;
$typeArray = array();
$region = "regionlimit=10000002";
while($s<$rowCount){

$typeID = mysql_result($queryItemList,$s,"typeID");

echo $typeID."<br />";

//echo "start<br />";

$reader = new XMLReader();

//echo "initialized XMLReader<br />";

$url = "http://api.eve-central.com/api/marketstat?typeid=".$typeID;

echo $url.$region."<br />";

$reader->open($url.'&'.$region);

$t=0;

$arrayName = array();

$arrayValue

 = array();

while ($reader->read()) {

//echo $reader->name;

$name = $reader->name;

$arrayName[$t] = $name;

if ($reader->hasValue) {

//echo ": " . $reader->value."<br />";

$value = $reader->value;

$arrayValue[$t] = $value;

}

$t++;

}

echo $arrayValue[71];

$import="UPDATE TABLE2 SET marketPrice='$arrayValue[71]' WHERE typeID='$typeID';";

mysql_query($import) or die(mysql_error());

$s++;;
}
print_r($typeArray);

/*print_r($arrayName);
echo "<br />";
echo "<br />";
echo "<br />";
print_r($arrayValue);*/

?>


an example XML file would be:
Code: [Select]
<!--
 Automatically generated data from EVE-Central.com
-->
<!-- This is the new API :-) -->
−
<evec_api version="2.0" method="marketstat_xml">
−
<marketstat>
−
<type id="24692">
−
<all>
<volume>4.00</volume>
<avg>152500000.00</avg>
<max>152500000.00</max>
<min>152500000.00</min>
<stddev>0.00</stddev>
<median>152500000.00</median>
<percentile>0.00</percentile>
</all>
−
<buy>
<volume>0.00</volume>
<avg>0.00</avg>
<max>0.00</max>
<min>0.00</min>
<stddev>0.00</stddev>
<median>0.00</median>
<percentile>0.00</percentile>
</buy>
−
<sell>
<volume>4.00</volume>
<avg>152500000.00</avg>
<max>152500000.00</max>
<min>152500000.00</min>
<stddev>0.00</stddev>
<median>152500000.00</median>
<percentile>152500000.00</percentile>
</sell>
</type>
</marketstat>
</evec_api>

im looking at pulling the following value from the <sell> section:
Code: [Select]
<median>152500000.00</median>
i am guessing the above should be arrayValue[71] but for some reason its not picking it up.

any help on this would be greatly appreciated as im lost in this script.

I am pulling records from a mysql db.   

Example Output:

Team A=  Our Team
Team b = An opponent team
Team A score = 7
Team B score = 8

Team A = Our Team
Team b = Another Opponent
Team A score = 3
Team B score = 1


What I need now is to add ONE more output, which is whether this is a "WIN" or a "LOSS".

Should I add a field into the table that calc's this?    If so, how?   Please be specific.

Or, should I use php to compare Team A score vs Team B score PER every record and then insert this new variable into the output.    If so, how do I create a new variable value for every single output in the table?


I know ultimately that this is a IF THEN type of calc, but can't quite figure out how specifically.   

Please be specific.

Thanks

Good evening,

This has been bugging me for 24 hours now. I have created 2 web applications. The first one is the dummy, and the second one is the final. Basically, this two web applications does the same, just a few modifications made on the final one. I have a process of pulling out of information from the database should the user would want to modify a field. I have a problem though, the dummy one works perfectly, but the new one don't. In fact, if I use the dummy php file together with the new files, the dummy won't be working. But if I use it together with the old files, it works perfectly fine.

This is the error I am getting:


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\invent-asia\edit_client.php on line 46

<?php
include("dbconnection.php");

if(isset($_POST["btnSubmit"]))
{
$id = $_POST["id"];
$territory = $_POST["territory"];
$job_title = $_POST["job_title"];
$area_of_work = $_POST["area_of_work"];
$employer = $_POST["employer"];
$location = $_POST["location"];
$job_title = $_POST["job_title"];
$date_posted = $_POST["date_posted"];
$closing_date = $_POST["closing_date"];
$department = $_POST["department"];
$gender = $_POST["gender"];
$first_name = $_POST["first_name"];
$last_name = $_POST["last_name"];
$title = $_POST["title"];
$telephone = $_POST["telephone"];
$address_1 = $_POST["address_1"];
$address_2 = $_POST["address_2"];
$address_3 = $_POST["address_3"];
$country = $_POST["country"];
$city = $_POST["city"];
$postal_code = $_POST["postal_code"];
$website = $_POST["website"];
$email_address = $_POST["email_address"];
$comment_by_cg = $_POST["comment_by_cg"];
$date_emailed = $_POST["date_emailed"];
$mailing_comments = $_POST["mailing_comments"];
$telesales_comments = $_POST["telesales_comments"];

$query = "UPDATE contacts SET territory= '".$territory."', job_title = '".$job_title."', area_of_work = '".$area_of_work."', employer = '".$employer."', location = '".$location."', job_title = '".$job_title."', employer = '".$employer."', date_posted = '".$date_posted."', department = '".$department."', closing_date = '".$closing_date."', gender = '".$gender."', first_name = '".$first_name."', last_name = '".$last_name."', title = '".$title."', telephone = '".$telephone."', address_1 = '".$address_1."', address_2 = '".$address_2."', address_3 = '".$address_3."', country = '".$country."', city = '".$city."', postal_code = '".$postal_code."', website = '".$website."', email_address = '".$email_address."', comment_by_cg = '".$comment_by_cg."', date_emailed = '".$date_emailed."', mailing_comments = '".$mailing_comments."', telesales_comments = '".$telesales_comments."' WHERE id = '".$id."'";
mysql_query($query) or die(mysql_error());

echo "<script>
alert('You have successfully updated a record');
window.location = 'view.php';
</script>";
}

$query = "SELECT * FROM contacts WHERE id = '".$_GET["id"]."'";
$result = mysql_query($query, $connection);

if(mysql_num_rows($result) > 0) - THIS IS THE 46th LINE IN THE CODE
{
$territory = mysql_result($result,0, "territory");
$job_title = mysql_result($result, 0, "job_title");
$area_of_work = mysql_result($result, 0, "area_of_work");
$employer = mysql_result($result, 0, "employer");
$status = mysql_result($result, 0, "status");
$location = mysql_result($result,0, "location");
$department = mysql_result($result,0, "department");
$date_posted = mysql_result($result,0, "date_posted");
$closing_date = mysql_result($result,0, "closing_date");
$gender = mysql_result($result,0, "gender");
$first_name = mysql_result($result,0, "first_name");
$last_name = mysql_result($result,0, "last_name");
$title = mysql_result($result,0, "title");
$telephone = mysql_result($result,0, "telephone");
$address_1 = mysql_result($result,0, "address_1");
$address_2 = mysql_result($result,0, "address_2");
$address_3 = mysql_result($result,0, "address_3");
$city = mysql_result($result,0, "city");
$country = mysql_result($result,0, "country");
$postal_code = mysql_result($result,0, "postal_code");
$website = mysql_result($result,0, "website");
$email_address = mysql_result($result,0, "email_address");
$comment_by_cg = mysql_result($result,0, "comment_by_cg");
$date_emailed = mysql_result($result,0, "date_emailed");
$mailing_comments = mysql_result($result,0, "mailing_comments");
$telesales_comments = mysql_result($result,0, "telesales_comments");
}
?>

Can anyone help me solve this issue? This is the only feature in my project that is left bugged

Your quick response is well appreciated. Thank you very much

I've got a table (tbl_items) that holds a number of items and the individual information for each. Within 'tbl_items' I also have a row labeled 'category_id' in which each item is given a number (ex: 2).

I've got a separate table (tbl_items_categories) that only has 2 rows: 'category_id' and 'category_name'.

I wasn't sure if a JOIN method would be best for this but what would be the best approach to list all items and within each item, also echo out the name of the category they belong to and not the category_id number?

Ok I have a fairly straight forward question. I am designing a baseball website and I am trying to add in a schedule, here is what I have:

Data Bases
1) Teams DB - Each team has a unique team ID, location, logo, and owner
2) Schedule DB - Each game has a unique game ID, and the schedule is set up like this: AWAY = Team ID, HOME = Team ID....

So I assume I am using the JOIN command to pull the schedule from both databases, any idea how the SQL command would look?

index.php?page=1 that link style but there is not hard files it is all to be stored in the DB

here is what i have got so far

Code: [Select]
<?

$result = mysql_query("SELECT * FROM page") or die(mysql_error());
$row = mysql_fetch_array( $result );

if(isset($_GET['page'])) {
echo $row['text'];
} else {
$result = mysql_query("SELECT * FROM page
 WHERE id='1'") or die(mysql_error());
$row = mysql_fetch_array( $result );
echo $row['text'];
}
?>
but always shows page ID 1 (home page) so i no i am missing something just not sure what hehe

DB structu
Code: [Select]
menu
----id (auto increase)
----name (home, about etc)
----id2 (page weight)
pages
----id (auto increase)
----name (page name home, about etc)
----text (page text)


link structure from the menu

Code: [Select]
<?

$result = mysql_query("SELECT * FROM menu ORDER BY id2") or die(mysql_error()); 


?>
<table>
<?
while($row = mysql_fetch_array( $result )) { ?>

<tr><td>
<a href="index.php?page=<? echo $row['id'];?>"><? echo $row['name']; ?></a>
</td></tr> <?
}
?>
</table>


dont think i have missed any info that i have on file but not sure why it will not link so thought of you guys hehe

Thanx in advance

OK, I've scoured the forms on here, searched and tutorial read and even pulled out an old PHP book. Alas, I'm stumped.

First off, my two tables that I'm trying to pull data from:

rubric
-------------------------------------
---- code ---- | ---- title --------
-------------------------------------
ABCD            | Category Name


schedule
----------------------------------------------------
------ name ------ | ------ short_title ------
----------------------------------------------------
ABCD-123-4569   | Title Is Here


Now, none of these share the same value, per say. rubric.code shares the first THREE letters from schedule.name, but that is all.
What I'm trying to do is something similar to the old:

A
apple
automobile

B
banana
basket
bench

C
car
child
crumb

... etc, etc, where the letter heading is actually the rubric.title value and then underneath it it lists all the matching short_title from
schedule where the first four letters of schedule.name match the value of rubric.code - if that even makes sense.

Unfortunately these are the tables I have to work with. If anyone out there has any ideas, I would be thrilled to hear them. Another
thing that is driving me crazy is that this server I'm working on doesn't have error reporting turned on so I've been stuck with just a
white screen to let me know something is amiss.

I'm running PHP Version 5.3.3-7+squeeze8 if that helps.

Thank you!