Search results for query: *

Hi guys, I am using PHP/PosgtreSQL.... I have a written a php script that displays a list of vehicles from a database..... my problem is I would like to display record details of a vehicle on a seperate screen when the user clicks on a required reg no. from a list? CAN SOMEONE PLEASE HELP! THANKS

Hi all, I have written a script to update specific records in a psql database.......my problem is that every time i update a record, the updated records is shown at the bottom of the list on the web broswer. How can keep the list in its original order after i update records?.........your help...

Hi all, Can someone please give examples of how i can update or delete a specifed record using psql and php?? Cheers.

Hi all, I am trying to display records from a psql database to the web browser, unfortunatly, it displays the following error message:- Parse error: parse error in /home/httpd/business/customerlist.php on line 18 Here is my code:- $db = pg_connect("host=larry port=4132...

Hi rycamor, This is the table structure i'm using: create table orders ( o_id int4 default nextval('orders_o_id_seq'::text) not null, omodel character varying (20), ocolour character varying (20), oforder character varying (5), oodate date...

hi all, i'm new(ish) to postgres.......i am trying to insert a record in a database but it keeps returning the following error message: ERROR: parser: parse error at or near "SELECT" to insert i have used the following command at psql prompt: INSERT INTO orders VALUES...

Is it possible to insert records in a PSQL Database using Perl?? Please give examples. Thanks

Hi all, Using the code below, can someone please tell how i can sort the contents in reg. no order? I have been given this code by a friend and i'm confused! sub missinglist () { my $msg=''; foreach my $comp (sort keys %dealers) { $msg.="\nmissing photographs for...

Hi all, i'm new to php/postgres I have some records in csv format. My question is how can i populate my PostgreSQL Database by taking info from csv (spreadsheet) files? your help is greatly appreciated.

Hi all, i'm new to PostgreSQL. I would like to know how you can populate a postgres Database from records taken from a csv file?? Thank you

Is it possible to have fixed length text fields on website forms??? Your help is greatly appreciated...

Hi all, I have a text file containing records of vehicles, i would like to display these records on the web browser. My problem is the first line of the file contains the system date, how can i display the details without including the date line?? e.g. text file:- 09.46 02 2002 April FORD...

There is no strange file in the 'results' directory, they all are text files in the date format i.e. 10022002. The blank line contains a checkbox followed by blank spaces! here is the sample html output:- <table border=0 cellpadding=3 > <tr> <th valign=top align=left> <left><form method=POST...

Its my friend 'Anikin' again..........your help has been greatly appreciated!! However.........I have changed the condition from '||' to '&&' it sort of worked, except it now displays one blank line instead of two!....any ideas?? Also, the files the 'include' points to are already within...

Hi there, I am trying to sort the contents of an array in date order...it sort of works! ....but the problem is when i include a new file it does not display it on top of list, also it displays 2 empty rows! (the list is within a form using checkbox)...the text files are saved as the date...

Hi Anikin, tried the above method but it displayed php code on web browser!: = $date) { print (&quot; &quot;); include(&quot;results/$array[]&quot;); print (&quot; &quot;); } } arsort($array,SORT_STRING); //for today to earlier dates closedir($handle); ?> here's my code: $date =...

Thanks for the advice 'Anikin'.....sorry i forgot to include one more point, the files are already saved in date format '020220' so i won't need to get system date to sort it. The problem is it seems to display the files in random order, and i would like to sort it from todays date and...

Hi all, Can someone please tell me how i can display contents of a directory in date order? (ie. earliest dates & onwards). Here's my code: $handle=opendir('results'); while (($file = readdir($handle))!==false) { if ( $file >= $date) {...

Thanks for the advice 'anakin'.....still can't find any problems with my script..........here's my code on file 'ref.htm': <?php include ('top.htm'); $matchdate = '$Match_year$Match_month$Match_day'; $date2 = date(&quot;Ymd&quot;); $fp=fopen(&quot;results/$matchdate&quot;, &quot;w&quot;)...

Hi there, For some reason i keep getting the following error message on my web browser, whenever i try to call a php file by submitting a standerd web form......Any idea what it means, its driving me nuts!!! Fatal error: input in flex scanner failed in /home/httpd/html/sandalrugby/results on...