Display full MySQL table

Hi, just starting out with DA so very possibly a simple question, please bare with me!

To start with I need a dynamic table that simply displays all records from my user table, this should have the option to update/add new record etc. Using DataAssist I don't seem to be able to create the primary display table, it creates pages for 'insert', 'update', 'details', 'search', 'results' but not the full table page, should it create this?

I have created a dynamic table within DW that does display the table but this leaves me with no options on each record to amend? Anyone have advice on how I can go about this?

Also I am using my own CSS for my site so don't need DA to provide the css, is this possible or should I just comment out the code it inserts on each page?

Kind regards

the results page will show a row for each record in the table if you do not enter anything on the search page.

you can elect not to create a search page, and just open the results page directly, this will show a row for search record with the option to update or view the details page.

Originally Said By: Jason Byrnes

  the results page will show a row for each record in the table if you do not enter anything on the search page.

you can elect not to create a search page, and just open the results page directly, this will show a row for search record with the option to update or view the details page.  

That's great Jason, will give it another try. Is there a reason why when I run the wizard and choose only 5 fields for results page it displays every single column [16]? I have tried this now 3 times ensuring on the results config I simply choose 5 columns to display?

I suppose I can manually remove just wondering why it would happen?

Thanks

Not sure, I'm not able to reproduce the issue.

Open the results page and go to the server behaviors panel, in the server behaviors list, double click the Repeat Region server behavior to edit it. set the records to show to 5.

Originally Said By: Jason Byrnes

  Not sure, I'm not able to reproduce the issue.

Open the results page and go to the server behaviors panel, in the server behaviors list, double click the Repeat Region server behavior to edit it. set the records to show to 5.  

Hi Jason, thanks again. All sorted now, I didn't realise I needed to remove all columns I didn't want in the wizard.

On another note, is there an easy way to format the date into UK format? I have been looking at the code created by DA, but not sure where exactly I need to try and change the format. MySQL table is yyyy-mm-dd but I need dd-mm-yyyy, am I able to change this in the queries created on each page in the header section?

I did find some code to achieve this but it fails when I add to the DA created insert pages? I added the below to the header section along with the DA created code & change 'column' to my column name which is ContactDOB.

<?php
function mysql2uk($date) {
return date('d-m-Y H:i:s',strtotime($date));
}
$sql ="select * from tblContacts";
$result = mysql_query($sql) or die();
$values = mysql_fetch_row($result);
echo mysql2uk($values['Column']);
?>

Thanks again Jason.

php file attached if it helps?

change line 151:

<td class="WADADataTableCell"><input type="text" name="ContactDOB" id="ContactDOB" value="<?php echo(str_replace('"', '&quot;', $row_WADAtblcontacts['ContactDOB'])) ?>" size="32" /></td>

to:

<td class="WADADataTableCell"><input type="text" name="ContactDOB" id="ContactDOB" value="<?php echo(date("d-m-Y", strtotime($row_WADAtblcontacts['ContactDOB']))) ?>" size="32" /></td>

Originally Said By: Jason Byrnes

  change line 151:

php:

<td class="WADADataTableCell"><input type="text" name="ContactDOB" id="ContactDOB" value="<?php echo(str_replace('"', '&quot;', $row_WADAtblcontacts['ContactDOB'])) ?>" size="32" /></td>

to:

php:

<td class="WADADataTableCell"><input type="text" name="ContactDOB" id="ContactDOB" value="<?php echo(date("d-m-Y", strtotime($row_WADAtblcontacts['ContactDOB']))) ?>" size="32" /></td>

  

Hi Jason, that does indeed allow me to add the date in UK format on the insert page but once 'update' is selected it writes it the the database as 0000-00-00, this then displays like that on the details page?

MySQL table format is 'Type = Date', 'Default=NULL'

Is it possible to store it in the DB as 31/01/12 so that displays on detail page?

Regards

Gary

add the following code at line 1:

<?php

if(isset($_POST['ContactDOB']) && $_POST['ContactDOB'] != "") {

    $_POST['ContactDOB'] = date("Y-m-d", strtotime($_POST['ContactDOB']));

}

?>

Originally Said By: Jason Byrnes

  add the following code at line 1:

php:

<?php
if(isset($_POST['ContactDOB']) && $_POST['ContactDOB'] != "") {
    $_POST['ContactDOB'] = date("Y-m-d", strtotime($_POST['ContactDOB']));
}
?>

  

Hi Jason, thanks for the update that hasn't changed anything I'm afraid, I even change the above code to d-m-Y to match the earlier code sent across. Have attached the revised php file, I have ensured the code is being sent back by inserting data into another field on same form, that updates perfectly.

An odd thing does happen, when I view any record on update page the ContactDOB field always displays 01-01-1970, if I change to 17-03-1968 and select 'update' the details page & MySQL table shows 0000-00-00? If I then choose 'update' again it displays 01-01-1970 on update page!

Sorry to be a pain, really cant work this out!

Gary