dee19802000

hey i have a jump menu that when i select an option it filters a table. My problem is that i have a .htaccess file in place to rewrite the urls but when i select my option i get a 404 error. I know this is something to do with my htaccess file not knowing what is going on so i am here asking for some help. I have posted some code snipets below: My option code with a link to the url i want <option style="text-align:center;" value="<?php echo $row_config['website_url']; ?>content/<?php echo $_GET['id']; ?>/<?php echo $linkname ?>/filter/<?php echo $row_categories['cat_id']?>"><?php echo $row_categories['cat_name']?></option> my htaccess file Options +FollowSymLinks RewriteEngine on RewriteRule ^content/([^/\.]+)/([^/\.]+)/?$ index.php?id=$1 RewriteRule ^content/filter/([^/\.]+)/([^/\.]+)/?$ index.php?cat_id=$1 RewriteRule ^articles/([^/\.]+)/([^/\.]+)/?$ articles.php?articles_id=$1 RewriteRule ^home/ index.php [L] Dee

anybody?

sorry the link to the template is here http://2b.selfip.com/knights/newsletter/newsletter.html Damian

Hey folks, I wonder if anybody would be able to help me here. I have a html newsletter designed up for a client and they sent it to the developers to integrate with their email system. They have come back to me saying the folllowing: The newsletter code has a small problem in that it needs the doctype to be present in order to be rendered correctly layout wise. Most email clients will strip or ignore the doctype leading to the layout not to be displayed correctly in a lot of email clients. This can be replicated by viewing the newsletter.html page in IE (6 - without the doctype. Can the newsletter layout be modified to compensate for a lack of doctype? Is there a way around this issue? Damian

I have that done already, do i need to use a WHERE or LIKE statement to relate them?

see image attached. [attachment deleted by admin]

Ok, its like projects that are related to another, These should be related by client, category and type of project. So when a user clicks on a project they will see projects that are related by those elements above in a scrolling box. This is my prototype at the minute http://2b.selfip.com/2bv4/project-details.php?cp_id=2&p_id=2 Dee

How would i create an sql statement for related items in my database? I have tried this but it isnt dynamic enough because not all sections have education as a related topic SELECT * FROM projects WHERE p_id LIKE '%Education%' Any help would be appreciated. Dee

cheers!

hey, what am i doing wrong with this do while loop that i have looping info i want to email $message.= do { "<tr> <td align=\"left\" valign=\"top\">". $code ."</td> <td align=\"left\" valign=\"top\">". $desc ."</td> <td align=\"center\" valign=\"top\">". $colour ."</td> <td align=\"center\" valign=\"top\">". $size ."</td> <td align=\"center\" valign=\"top\">". $price ."</td> <td align=\"center\" valign=\"top\">". $unit ."</td> </tr>" } while ($row_quotes = mysql_fetch_assoc($quotes)); Dee

how would i them sums up the quotes based on the reference number? Dee

Hey I am having some difficulty trying to get an inner join to sum a column SELECT quotes.quote_id, quotes.m_id, quotes.author, quotes.date_now, quotes.valid_date, quotes.comment, quotes.m_comment, quotes.reference, quotes_det.id_q, quotes_det.q_id, quotes_det.item_code, quotes_det.quantity, quotes_det.quote, quotes_det.active, SUM(quotes_det.quote) FROM (quotes LEFT JOIN quotes_det ON quotes_det.q_id=quotes.quote_id) WHERE quotes. m_id=%s GROUP BY quotes.reference i keep getting 0 as my returned result. What do i need o do to get the correct result? Damain

I ended up doing as oni said, i declared the variable and added it to my message for($i = 0; $i<count($_POST["product_int"]); $i++) { $products = "<ul><li>". $_POST["product_int"][$i] . "</li></ul>"; } $to = '[email protected]' ; $subject = 'Sipfit Call Back Request ' . $_POST['name']; $headers = 'MIME-Version: 1.0' . "\r\n"; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; $headers .= 'From: Sipfit Call Back Request <[email protected]>' . "\r\n"; $headers .= "CC:".$_POST['email']."\r\n"; $message = "<table> <tr><td><b>Your Name</b></td><td align='left'>".$_POST['name']."</td></tr> <tr><td><b>Contact No</b></td><td align='left'>".$_POST['telephone']."</td></tr> <tr><td><b>E-Mail</b></td><td align='left'>".$_POST['email']."</td></tr> </table> <table> <tr><td><br><b>Which Sipfit Products are you interested in?:</b><br></td></tr> </td><td>$products</td></tr> </table>"; Thanks for your help guys. Dee

nope that didnt work. Parse error: syntax error, unexpected ',' Dee

Hey, can somebody tell me what I am doing wrong here. I get this error Parse error: syntax error, unexpected T_FOR from this code $to = '[email protected]' ; $subject = 'Sipfit Call Back Request ' . $_POST['name']; $headers = 'MIME-Version: 1.0' . "\r\n"; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; $headers .= 'From: Sipfit Call Back Request <[email protected]>' . "\r\n"; $headers .= "CC:".$_POST['email']."\r\n"; $message = "<table> <tr><td>Your Name</td><td align='left'>".$_POST['name']."</td></tr> <tr><td>Contact No</td><td align='left'>".$_POST['telephone']."</td></tr> <tr><td>E-Mail</td><td align='left'>".$_POST['email']."</td></tr> </table> <table> <tr><td><br><b>Which Sipfit Products are you interested in?:</b><br></td></tr> <tr><td>" . for($i = 0; $i<count($_POST["product_int"]); $i++){ echo "<ul><li>". $_POST["product_int"][$i] . "</li></ul>"} . "</td></tr> </table>";