StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
12817363
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2012-10-10T10:37:02.250
FavoriteCount
0
LastActivityDate
2012-10-10T10:37:02.250
LastEditDate
LastEditorUserId
0
OwnerUserId
2046356
ParentId
12813597
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
The first step is to do a find/replace for 'catagories' to change to 'categories' to make sure that your code is speaking the same language as your database tables and -- a happy bonus -- that it is in English! If I understand the question: you have a list of the distinct titles of categories but no IDs for these. You have no guarantee that each title corresponds to exactly one ID; indeed, if using 'DISTINCT' in your query is to have any effect on the rows returned, then there are at last two IDs corresponding to a single title. This is quite unusual so you may want to review why (i) you have several eponymous (same-named) categories and (ii) this being the case, why they should not be returned for selection in your form. If it turns out that you do need to provide a list of distinct category titles and for the form submission to do something with these, there must be IDs, then the choice of which ID to use per title is ambiguous. Assuming that it does not matter which ID is used, so long as it matches the appropriate title, you can do the following: <pre><code><?php foreach ($rows as $row) { $query = "SELECT id FROM #__categories WHERE title = " . $row->title . " AND published = '1' LIMIT 1 "; $db->setQuery($query); $row->id = $db->loadResult(); ?> <option <?php if ($row->id == $catagories) { echo " selected=\"selected\""; } ?>value="<?php echo $row->id;?>" > <?php echo $row->title;?> </option> <?php }?> </code></pre> For a more efficient solution, you could look into using <a href="http://www.tizag.com/sqlTutorial/sqlunion.php" rel="nofollow">UNION</a> in your original query to provide an ID for each of the rows returned.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POFetch category and article list joomla
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USJoseph Cape
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COthanks joe for your time i tried it it's working fine with small errorcorrect code is
 singulars
 PostPostId
 PO
 UserUserId
 USRakesh Sharma

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.