showing results by field in dropdown

chucho 09 Mar, 2011

Sorry about my grammar my Name is Julio Rodriguez and I am testing chrono connectivity I have for my websit e I have 12 months in a drop down box on a form I want user too select the current month then I want chronocoonnectiovity to only show records from the current logged in user where the month chosen was a static mopnth march for example if the person put mach into the form it will show on the fronnt end I am tried readingthe tutorial wbut with no luck probablyu because of my language barrier (my field name is text_3 (month) and my id is select_7) I tried using where code

<?php
$user =& JFactory::getUser();
echo "WHERE `cf_user_id` = ".$user->id;
?>
WHERE `text_3` LIKE '%March%';

and boBody code created in a wysiwyg editor to make the results nice

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
  <meta content="text/html; charset=ISO-8859-1"
 http-equiv="content-type">
  <title></title>
</head>
<body>
<table style="text-align: left; height: 25px; width: 758px;"
 border="0" cellpadding="2" cellspacing="4">
  <tbody>
    <tr>
      <td
 style="font-family: Helvetica,Arial,sans-serif; text-align: left; color: rgb(99, 139, 198); font-weight: bold; background-color: rgb(237, 239, 244); width: 203px;"><span
 style="font-weight: normal;"> </span><big
 style="font-weight: normal;"> Date:</big>  <span
 style="color: black; font-weight: normal;">{text_3}

and I am using footer code

{pagination}

Thank's for any help I recieve,
Muchas Gracias Julio

Gr

GreyHead 09 Mar, 2011

Hi chucho,

This code

<?php
$user =& JFactory::getUser();
echo "WHERE `cf_user_id` = ".$user->id;
?>
WHERE `text_3` LIKE '%March%';

will give something like this in the MySQL query

WHERE `cf_user_id` = 99 WHERE `text_3` LIKE '%March%'

The repeated WHERE will break the query.

Please try this instead:

<?php
$user =& JFactory::getUser();
echo " WHERE `cf_user_id` = ".$user->id." AND `text_3` LIKE '%March%' ";
?>

Bob

ch

chucho 10 Mar, 2011

Grehead this worked great Thankyou I am still testing it and so far I have had a great experience I am verry satisified with the support form at chronoforms I think I will use chronoforms for my site but I have another problem when I click in any field on the form on my site my header jumps down maybe 5-10px I have a background image with a bar at the top tiled to make the header seams like it is stretched across the page so when the header moves down it show and doesn't line up with the background image I made. It doesn't do it in Firefox but it dopes in my main browser IE 8 is there special code I have to use with Internet Explorer?

Thanks for the help
Julio

Gr

GreyHead 10 Mar, 2011

Hi Julio,

Please post a link to the form so we can take a quick look at the styling question.

Bob

ch

chucho 29 Mar, 2011

Sorry for postin too late but the problem was with ie 8 I used the ie8 compatibility plugin on joomla extensions directory and it fixed I just set it to ie 7 mode

Thank You
Julio

This topic is locked and no more replies can be posted.