radar Posted September 4, 2006 Share Posted September 4, 2006 Okay so this time on this subject I've got a table called links.. and again this is in my administration console and im working on a part where I can go through and validate all links before they are posted on the site for public to view....In my table which is called links I have 5 colums...links_idlinks_statuslinks_urllinks_imagelinks_nameSo I figured I would use a foreach on this but not sure how I would with 5 different options that I need only 4... after the query that is... So here is my query..[code]<?php$queued = mysql_query("SELECT * FROM links WHERE links_status = 'queued'");$cnt = mysql_num_rows($queued);$queueds = mysql_fetch_assoc($queued);if ($cnt == "" || $cnt == "0") {$tpl->assign('queued_link_list', '<tr><td width="100%" bgcolor="#FFFFFF" class="style7">There are 0 links waiting in queue</td></tr>');} else {// here is where I need help...}?>[/code]So I need to come up with a script -- a loop to go through all links that are in queued status which has already been selected and turned into an assoc array via the string $queueds... Now the list should be in something like $queued_link_list which will contain all the HTML for the table codes etc that will display the proper information.. here is how i have the code set up right now..This is only HTML and Im not sure where to begin on this..[code]<tr> <td width="331" bgcolor="#FFFFFF" class="style7">queued_link_site</td> <td width="172" bgcolor="#FFFFFF" class="style7">queued_link_image</td> <td width="205" bgcolor="#FFFFFF" class="style7">queued_link_name</td> <td width="44" bgcolor="#FFFFFF"><img src="../templates/cesite/images/b_approve.gif" alt="approve" width="16" height="16" /> <img src="../templates/cesite/images/b_drop.gif" alt="deny" width="16" height="16" /></td> </tr>[/code]Okay so i just put in some basic info there... queued_link_site will be a link to the site address for the entry in the list..queued_link_image will be a link to the image (if any) which should open in a new browser window preferrably one sized to the image...queued_link_name is just the name of the site -- this will show in the link field if there is no image set.. then the b_approve.gif will change the status to approved or something like that... and b_drop.gif will delete the link from the database because it didnt meet the qualifications that are to be defined at a later date...So any help on this would be appreciated.. Thank you guys in advanced -- Im sure i'll be asking a lot of questions while i go through this site but by the time im done i should know all there is to know.. since i am making my whole site from scratch.. im even coding the forums.. or going to attempt to anyway..edit: fixed display problems in my post.. Quote Link to comment Share on other sites More sharing options...
Moon-Man.net Posted September 4, 2006 Share Posted September 4, 2006 If you want, you could talk to me on MSN, or email nathan.metcalf(AT)weatherbeeta.com.auBut i cant stay on the forums.Cheers,Nathan Quote Link to comment Share on other sites More sharing options...
radar Posted September 4, 2006 Author Share Posted September 4, 2006 I have msn and every other messenger client too -- my msn is justin (AT) morphicdesigns (dot) (com)if you can help -- that'd be awesome.. Quote Link to comment Share on other sites More sharing options...
Jenk Posted September 4, 2006 Share Posted September 4, 2006 Which template engine you using? (I'm guessing Smarty?)Anyway, to get you started..[code]<?php$queued = mysql_query("SELECT * FROM links WHERE links_status = 'queued'");if (!mysql_num_rows($queued)) { $quededs_link_html = array(); while ($row = mysql_fetch_assoc($queued)) { $quededs_link_html[] = array( 'href' => $row['links_url'], 'img' => $row['links_image'], ); } $tpl->assign('quededs_link_html', $quededs_link_html);}?>[/code]and if it is Smarty, your template can now use the following to display the above:[code]<table> {if isset($links)} {section name=link loop=$links} <tr><td><a href="{$links[link].href}"><img src="{$links[link].img}"></a></td></tr> {/section} {else} <tr><td width="100%" bgcolor="#FFFFFF" class="style7">There are 0 links waiting in queue</td></tr> {/if}</table>[/code]btw.. don't hardcode HTML into you app.. that's why you are using templates in the first place. Quote Link to comment Share on other sites More sharing options...
radar Posted September 4, 2006 Author Share Posted September 4, 2006 Actually I made my own template engine... It was tough but yeah... I ended up figuring it out and getting it done... The only HTML i'd hardcode is html thats never going to change.. such as on this..Right now i am working on my admin.php and that I've got set to always be on the default style... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.