Output from Database

Anon

I am converting from ColdFusion. I am trying to output a list of events that would then link by eventid to a single output page. All my output is above the fields.

<?php

$resultid = odbc_connect ( "HMOInfo", "", "" );
if ( $resultid )
{
$id = odbc_exec ( $resultid, "SELECT Eventid,EventDate,EventTitle FROM tblEvents;" );
odbc_result_all ( $id );
odbc_free_result ( $id );
}
odbc_close ( $resultid );

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<head>
<title>Test Events</title>
</head>

<body>
<table width="90%" bgcolor="COCOCO">
<tr>
<td width="50%"><font face="arial" size=-1><b>Date</b></font></td>
<td width="50%"><font face="arial" size=-1><b>Title</b></font></td>
</tr>
</table>

<table width="90%" >
<tr>
<td width="50%"><font face="arial" size=-1> <b><?php echo "$EventTitle";?></b></font></td>
<td width="50%"><a href="Event_Output.php?eventid=<?php echo "$eventid";?>><font face="arial" size=-1><b><?php echo "$EventDate";?></b></font></a></td>
</tr>
</table>

</body>

frymaster

----- start your code -----
<td width="50%"> <?php echo "$EventTitle";?></td>
<td width="50%"><a href="Event_Output.php?eventid=<?php echo "$eventid";?>><?php echo
"$EventDate";?></a></td>
------ end your code ------

hm. assuming that yer getting more than one row off your query, what i would do would be loop it (forgive my total lack of odbc knowledge here...)

----- start my code -----
for($i=0;$i<pg_numrows($id);$i++)
{
$this_listgin = pg_fetch_array($id, $i);

while(list($key, $val) = each($this_listing)
    $$key = $val

print <<<HTML
    <a href="Event_Output.php?eventid=$eventid"> $EventDate</a>
    <table stuff here>

HTML;
}
------ end your code ------

i've used the postgresql calls here since my odbc knowledge is zero, but you get the idea.

if the query pulls x rows, we loop x times with $i. we pull row $i and then loop through each key/value pair in that row and for each pair dump the value into a variable with the name of the key. ie, if you have a column called "eventid" that has value of 12, after this loop you have a variable called $eventid with a value of 12. with that done, you can just cook up your link using the column names as variables.

i think that's what your asking for... if it isn't, please clarify.

-frymaster

Anon

Thanks very much for your feedback. I think my query to the database has some code I don't yet understand.

Every Record prints to the page in eventid sequence above the HTML.

I am trying to print out the list below my title bar and nothing prints at all.

I am comfortable with Access and there does not seem to be much in the way of using that DB over MySql.

Just trying to start PHP without having to learn another DB at the same time.
terry