Simple Array Help

Anon

Ok...For starters I am a web designer, not a true developer, so respond accordingly. 🙂

I have a scenario where a simple array should do the job, but I can't seem to find any good examples of what I need. I have a listing of events, dates, seminars, etc.

In the database I have a $seminar_type. I want that info to be able to display the $seminar_name without it having to be another field in the db. I'm sure there are several ways of doing this but I figured an array on the pages (2) where I am displaying this info would be the easiest.

Here is what I have found, but I am sure it's all screwy as I have piecemealed it together from different tutorials (or guessed!)

$s_type is the field in the db indicating which seminar it is.

$seminar = array (
array ( "type" => "type1",
"name" => "name1" ),
array ( "type" => "type2",
"name" => "name3" ),
array ( "type" => "type3",
"name" => "name3" ),
);

function getname ($s_type, $seminar) {
$name = array();
if ($seminar($type) === $s_type) {
$s_name = $seminar($name);
}
return($name);
}

getname(?whatgoeshere?);

Ok...don't laugh. I know it doesn't work. Just wanted to show how pitiful I am. Help! 🙂

Jim

rrijnders

function getname ($s_type, $seminar)
{
  return $seminar[$s_type];
}

$seminar['type1']='Type One';
$seminar['type2']='Type Two';
$seminar['type3']='Type Three';
$seminar['type4']='Type Four';

$s_name = getname($s_type, $seminar);

-- Rich

Anon

Rich,
Thanks. That is much simpler. I am having a little bit of a problem integrating it with the rest of the page though. Not quite sure were the function should go. I have tried it in a couple of places. In the position below it will return the first result but then stops (with errors).

Here the PHP section of the page:

<?php

$connection = mysql_connect ("localhost", "user", "pass");
if ($connection == false){
echo mysql_errno().": ".mysql_error()."<BR>";
exit;
}

$query = "SELECT event_id,event_name,date_format(start_date, '%M %d') AS Readable_Date,date_format(end_date, '%M %d, %Y') AS Readable_Date_2,seminar_type,seminar_name from events ORDER BY start_date";
$result = mysql_db_query ("thinktpc", $query);

if ($result){
echo "<table class=body width=100% border=0>";
echo "<tr><td bgcolor=#CCCC33><font class=bodysmall> <b>Event Location</b></font></td><td bgcolor=#6666CC><font class=smallwhite> <b>Seminar Type</b></font></td></tr>\n"
."<tr><td> </td><td> </td></tr>";

$numOfRows = mysql_num_rows ($result);
for ($i = 0; $i < $numOfRows; $i++){
$name = mysql_result ($result, $i, "event_name");
$start_date = mysql_result ($result, $i, "Readable_Date");
$end_date = mysql_result ($result, $i, "Readable_Date_2");
$s_type = mysql_result ($result, $i, "seminar_type");
$e_id = mysql_result ($result, $i, "event_id");

function getname ($s_type, $seminar) 
{ 
  return $seminar[$s_type]; 
} 

$seminar['power']='The Power of Language'; 
$seminar['buddha']='From Buddha to Batman'; 
$seminar['unshakeable']='Unshakeable Strength in Adversity'; 
$seminar['tracking']='Tracking the Wounded Bear';
$seminar['omega']='The Omega Leader'; 
$seminar['keeping']='Keeping the Coal Out of Your Stocking'; 

$s_name = getname($s_type, $seminar); 

echo "<tr><td><a href=\"index.php?page=moreinfo&event=$e_id\"><b>$name</b></a></td><td><a href=\"$s_type.htm\">$s_name</a></td></tr>\n"
	."<tr colspan=2><td><font class=bodysmall>$start_date thru $end_date</font><br><br></td><td>&nbsp;</td></tr>";

}

echo "</table>";
}
else{
echo mysql_errno().": ".mysql_error()."<BR>";
}

mysql_close ();

END

Thanks for helping with this.

Jim S.

rrijnders

The error you are getting is probably something along the lines of "can not re-declare function getname". This is because you have the function definition inside of your <b>for</b> loop; essentially re-declaring the function with every record you read.

Since the definition of the lookup array never changes, you can safely put that up at the top of your page so it happens only once. This is also where you should define the function.

Take a look at the corrected code below and I think things will start to make more sense to you.

=============================
<?php

function getname ($s_type, $seminar)
{
nbsp;return $seminar[$s_type];
}

$seminar['power']='The Power of Language';
$seminar['buddha']='From Buddha to Batman';
$seminar['unshakeable']='Unshakeable Strength in Adversity';
$seminar['tracking']='Tracking the Wounded Bear';
$seminar['omega']='The Omega Leader';
$seminar['keeping']='Keeping the Coal Out of Your Stocking';

$connection = mysql_connect ("localhost", "user", "pass");

if ($connection == false){
nbsp; echo mysql_errno().": ".mysql_error()."<BR>";
nbsp; exit;
}

if ($result){
nbsp; echo "<table class=body width=100% border=0>";
nbsp; echo "<tr><td bgcolor=#CCCC33> Event Location</td><td bgcolor=#6666CC> Seminar Type</td></tr>\n<tr><td> </td><td> </td></tr>";

nbsp; $numOfRows = mysql_num_rows ($result);

nbsp; for ($i = 0; $i < $numOfRows; $i++){

nbsp;nbsp; $name = mysql_result ($result, $i, "event_name");
nbsp;nbsp; $start_date = mysql_result ($result, $i, "Readable_Date");
nbsp;nbsp; $end_date = mysql_result ($result, $i, "Readable_Date_2");
nbsp;nbsp; $s_type = mysql_result ($result, $i, "seminar_type");
nbsp;nbsp; $e_id = mysql_result ($result, $i, "event_id");

nbsp;nbsp; $s_name = getname($s_type, $seminar);

nbsp;nbsp; echo "<tr><td><a href=\"index.php?page=moreinfo&event=$e_id\">$name</a></td><td><a href=\"$s_type.htm\">$s_name</a></td></tr>\n
<tr colspan=2><td>$start_date thru $end_date<br><br></td><td> </td></tr>";
nbsp; }

echo "</table>";

}
else{
nbsp; echo mysql_errno().": ".mysql_error()."<BR>";
}

mysql_close ();

?>

HTH
-- Rich Rijnders
-- Irvine, CA US

rrijnders

forget the "nbsp;" thingies, They were supposed to be blanks for indenting...

-- Rich

Anon

Rich,
Thanks that did it. Appriciate your help. Now on to finish the Edit/Update script. 🙂

Thanks again,
Jim