mdemetri2

Ok thanks Psycho, I was kinda coming to that conclusion myself about the schema being wrong....so I will take a look at amending it I think. Thank you so much for the tips!

Hi. I have a table that I been to summarise, but use its column / files as rows, in otherwords transpose the table. Structure example is: id | month | CatA | CatB | CatC | CatD 1 jan 23 34 33 78 2 feb 21 38 67 78 2 mar 18 42 76 80 and would like to display: Jan Feb Mar CatA 23 21 18 CatB 34 38 67 CatC 33 67 76 CatD 78 78 80 Is this possible? Really appreciate any pointers.

I have tried the implement that unsuccessfully. I needed it as part of a post - when the form gets submitted. I will keep trying, thanks.

thanks for the reply Barand. I was trying to avoid replacing what I have with a new type of date picker. Anyone have any ideas on whether what I'm asking is possible? Thanks in advance.

Hi I have a javascript calendar that populates a form field (survey) in the format of dd/mm/yyyy. I don't know of a method to change the format in the calendar. So, I would like the format to be changed at the point the form is submitted and the date is used to update a record. I have tried to amend the portion of the update script for the survey field to change the format as part of it submitting the change. I used this line: GetSQLValueString(date("Y-m-d, strtotime("$_POST['survey']), "text") but I'm not getting the expected results, essentially from the text field entry format of dd/mm/yyyy I want Y-m-d Is this possible? Thanks in advance.

Ok so in the end I managed to figure this out myself. Thanks for the replies from those who made suggestions.

jazzman1 - I don't see why I need to.

jazzman1 - I'm not sure you understand. When I say table, I mean html table populated with query results.....

jazzman1 - One user can only be associated with one type....so type 1 sees table 1, type 2 sees table 2 etc.

Well, the variable would be $usertype = $row_user['type'] , essentially the result of a query based on '$_SESSION[MM_Username]'. Result would be numeric so user type 1,2 or 3 Example code for one table in my first post. The other two would be the same, but use different recordset / queries to populate. Hope this makes sense.

Thanks for the replies. The idea is, depending on the type of user logged in (identified by a variable brought back once the user is logged in) then a different table is displayed - as the query to populate the table is different for each table.

Ok, so it is possible as I was thinking. I'm just not clear on how to achieve it at the moment. Easy bit is setting a variable based on a return from the user logged in. Its then doing an if else scenario on the table to display the corresponding result set or having the three tables visibility altered depending on the variable returned.....the latter requiring java script I believe.

Hi I expect this is possible. If I have three recordsets but one table. Is it possible to alter the results displayed in the table dependent on a variable e.g. returned from the person logged in. Or maybe its case of have the three tables but only displaying them when the variable is to x, y or z? So currently, I have one table that displays content, code extract. <table width="593" border="0" class="TableContent"> <?php do { ?> <tr> <td width="575" class="TableContent2"><a href="R/zzedit.php?id=<?php echo $row_retail['id'];?>&ref=<?php echo $row_retail['property'];?>"><?php echo $row_retail['id']; ?></a><?php echo $row_retail['item']; ?><?php echo $row_retait['route']; ?><?php echo $row_retail['class']; ?></td> </tr> <?php } while ($row_retail = mysql_fetch_assoc($retail)); ?> </table> Would be great for anyone to point me in the right direction on this or provide some assistance. Appreciated. mdemetri2

Barand - thank you, that worked perfectly for what I required. Appreciated as always. thanks!

Barand, as usual quick response, I will certainly give that a try,.....will let you know how things go. thanks!