coldfusion translation?
Posted: Fri May 02, 2008 9:33 am
I'm in the process of changing our site from coldfusion using access to php with mysql and I'm having some trouble, go figure!
What I'm trying to accomplish is a query to the db that returns a field that contains a ulr while displaying the text from another field, all inside a menu table.
To start, my db has 4 fields:
MenuID, MenuCategory, MenuItem, URL
6 1 Make an inquery /inquiries/
6 2 Schedule a Tour /inquiries/schedule/
6 4 Apply Now /inquiries/apply/
6 3 Send to a Friend /inquiries/friend/
this is some of my coldfusion code:
This is what the links look like on the page:

I haven't had any other problems with php, I can connect to the db and perform queries and have figured out a lot so far, but this has been a bit of a hurdle and I'm not even sure if it can be done.
Thanks!
What I'm trying to accomplish is a query to the db that returns a field that contains a ulr while displaying the text from another field, all inside a menu table.
To start, my db has 4 fields:
MenuID, MenuCategory, MenuItem, URL
6 1 Make an inquery /inquiries/
6 2 Schedule a Tour /inquiries/schedule/
6 4 Apply Now /inquiries/apply/
6 3 Send to a Friend /inquiries/friend/
this is some of my coldfusion code:
Code: Select all
<td align="left" valign="top"><cfoutput query="menu">
<table width="100%" border="0" cellpadding="0" cellspacing="0" class="menutable">
<tr>
<td><a href="#menu.URL#" class="menu">#menu.MenuItem#</a></td>
</tr>
</table>
</cfoutput></td>

I haven't had any other problems with php, I can connect to the db and perform queries and have figured out a lot so far, but this has been a bit of a hurdle and I'm not even sure if it can be done.
Thanks!