switch() help

[lalocp]

Hello...

Newbie needs help.

I've got a script that runs a query on a database and returns event information. The script will display the data in a table with three cells (Event, Date, Venue). I've recently added a split and switch() functions so that I may redisplay the date in a "Month Name, Day, Year" format (but in Spanish) from the YYYY-MM-DD format. I have to take the month number and redisplay it as a Month Name.

My problem is that when I add the function after a:

     while ($row = mysql_fetch_array($result))

The function works as expected and displays the new formatted date in its proper cell in the table. But with empty event and venue cells, even though there is valid data returned from the query.

If I place the two functions before the while function, I get proper event and venue information but no date information.

Following is the code snippet. Any help would be immensely appreciated.

---------code------------------
<?PHP

$db = mysql_connect("localhost", "me", "me");
if( !$db )
{
die("Error connecting to the Server");
exit;
}
$result = mysql_select_db("concerts", $db);
if( !$result )
{
die("Error selecting Database");
exit;
}

$query  = " SELECT
	concert_schedule.evento, concert_schedule.grupo, concert_schedule.fecha, concert_schedule.invitados, venues.ciudad, venues.pais,
	venues.local, venues.direccion, venues.estado, venues.zip, venues.phone, venues.direc2, venues.email, venues.URL

	FROM	concert_schedule, venues

	WHERE	concert_schedule.fecha=\"$mifecha\" and venues.local=concert_schedule.local

	ORDER	BY concert_schedule.grupo AND fecha ASC";

$result = mysql_query($query,$db);

 if( !$result )
 {
    die("Error executing query");
 }

 echo "<tr height=35>";
 echo "<td width=250 align=CENTER bgcolor='#000000'><font face='Arial' size='2' color='#FFFFFF'><b>Evento <br> Artista e Invitados</b></font></td>";
 echo "<td align=CENTER bgcolor='#000000'><font face='Arial' size='2' color='#FFFFFF'><b>Fecha</b></font></td>";
 echo "<td align=CENTER bgcolor='#000000'><font face='Arial' size='2' color='#FFFFFF'><b>Local</b></font></td>";
 echo "</tr>";

{

while ($row = mysql_fetch_array($result))

$rompe = split('-', $row[fecha]);

$dia = $rompe[2];
$anio = $rompe[0];

switch($rompe[1])
{
case "01":
$mes = "Enero";
break;

	case "02":
		$mes = "Febrero";
		break;

	case "03":
		$mes = "Marzo";
		break;

	case "04":
		$mes = "Abril";
		break;
	default:
		$espfecha=$row[fecha];
}

$espfecha = "$mes $dia, $anio";

printf("
<tr height=35>
<!---Artista e Invitados -->
<td width=250 align=left valign=top>
<table>
<tr>
<td width=250 valign=top><font face=verdana size=2><b><i>%s</i></b></font></td>
</tr>

		<tr>
			<td><font face=verdana size=1><b>%s</b><br>%s</font></td>
		</tr>
	</table>

</td>
<!--- Fecha -->
<td align=left valign=top><font face=verdana size=1>%s</font></td>

<!--- Local -->

<td align=left valign=top><font face=verdana size=1><b>%s</b><br> %s<br>%s<br>%s %s<br> %s %s<br>%s<br>

		Web: <a href=\"http://%s</a> <br>
		Email: <a href=\"mailto:%s\">%s</a> </center> </font></td></font></td>

	<!--- Pagina -->

</tr>\n",$row[evento],$row[grupo],$row[invitados],$espfecha,$row[local],$row[direccion],$row[direc2],$row[ciudad],$row[estado],$row[zip],$row[pais],$row[phon
e],$row[URL],$row[email],$row[email]);

$AffectedRows = mysql_affected_rows($db);

print("<font size=2 face='verdana, helvetica'><b> Encontramos <font size=+2> $AffectedRows </font> conciertos para $espfecha.</b></font><br><br>\n");

}
?>

[gardner1]

First off hand you might want to assign the array rompe[1] before you do work to it.

like so:

$dia = $rompe[2];
$mes = $rompe[1];
$anio = $rompe[0];

switch($rompe[1])
{
case "01":
$mes = "Enero";
break;
..............
default:

$espfecha=$rowfecha];

Not sure it would be the fix.

Another thing that I ran into in a similar situation, where I wanted to sort informatioin, query, sort it again, then display it, but I wanted the display of the items at the top of the page, I had to use encapsulation (classes) in order to do that.

You script is written as interpretive, so of course, the placement of the code makes a huge difference to where things can be displayed.

If you use classes, and call by reference, you can place the "objects" where you want on the page irrespective of order in the interpretive sense.

[lalocp]

Thanks Richard.

Actually, 4 lines above the switch funcion I have the function $rompe = split('-', $row[fecha]); creating the $rompe[] array and $rompe[1] is the index for the month.

The problem has since been solved. I was missing an initial { brace after the while().

Someone else pointed it out at another forum. I sure needed a fresh pair of eyes to check it out.

thanks again.

[gardner1]

Hehe, =) good to hear!

and yeah, I saw that above, but wasn't sure if it should be instantiated or not, was hoping that might help, but as with ur eyes, I also missed that =O

There's quite a few good free coding editor's out there (i use Textpad) and most of them have a "Match Brace" function that would have caught that... might look into that if ur using just notepad/vi

Peace! and grats