Search results for query: *

Thank you, I didn't even know that a list of reserved words existed. Now I have a link. Its quite satisfying when you get to the bottom of this sort of problem. Richard PS it does work

So that you can see the whole picture while ($x <= $mast_page) { if ($_SESSION['units'.$x] * $_SESSION['price'.$x] != 0) { $unit = $_SESSION['units'.$x]; $unitprice = $_SESSION['price'.$x]; $desc = $_SESSION['desc'.$x]; $query="INSERT INTO...

INSERT INTO `sledgerdet`(cno, invno, row, unit, desc, unitprice)VALUES (3, 25, 1, 10,' dffcffghhjjkkjuhkuu', 10)

Yes it is PHP a lot of people in the PHP forum have helped me. I am afraid to say that it doesn't work. If it doesn't work I have a die(mysql_error(mysql)); The error is:- You have an error in your SQL syntax near 'desc, unitprice)VALUES (3, 25, 1, 10,' gggggggggggggg', 10)' I have...

I was a foxpro AP for 12 years and you get very confident when writing the select or insert statements you have to be. I can't find any consistancy with mysql 3.23.58 Lets take an example INSERT INTO `sledgerdet`(cno, invno, row, unit, desc, unitprice)VALUES ($mast_cno, $invno, $invrow...

Thanks for your help. Another couple of years & I might get the hang of it Regards Richard

Hi I wasn't too far away, was I !! <?php if(session_id() == "") {session_start(); } session_destroy(); $redirecturl = "../index.php"; header("Location: $redirecturl"); ?>

I have two identical web areas The initial screen asks for username & password (on both) On the development area the computer has started to "remember" the password. This is my accounts & I often work on site then generate the invoice using any computer that has access to the web & a printer...

Now you are trying to baffle me Rich

I have cracked it thanks to you lot. I have used 3 submit buttons and the isset function tells me which one has been pressed. I think "($_POST['submit'])" this bit of code might also tell me which button has been pressed. (I will investigate) I didn't know you could have multiple submit...

unfortunatly I have no knowledge of javascript so I will go to plan b and set up 3 radio buttons with a submit button Thanks for your help Richard

Thanks for replying I have three buttons on the bottom of form New Line Recalculate Create Invoice (and print) I could put a radio button and a submit, but this is getting me annoyed & I want to no how to do it. I see something similar in PHPmyadmin but the code is not available to me Rich

If my button "Add line" is used to call a prog newline.php the $_POST variables are not visible in the newline.php. Rich

I am creating an invoice form in php I have a button on the bottom that can add a new line by calling itself with a parameter invscreen.php?lines=x I have no trouble working out the lines and creating a multi line invoice. As you enter the form the SESSION variables are created but what I...

Brilliant Thanks very much, I looked at that for days. It will be a long time before I forget that lesson Richard

I am getting this error message Notice: Undefined index: invno in /home/clients/rcldev/html/rlt/invoicecreate.php on line 97 From this chunk of code // get next invoice no $query = "select max(invno) from sledger where cno = $mast_cno"; $mysql = conectmysql(); $res =...

I have just cracked it, several faults. 1. it was in a loop 2. the variable $cOutput was not being reset after printing a page How difficult is it to do a pdf, I am not to keen on the footer saying the name of the file & the date rich

would a different tack be helpfull. I was thinking of creating a pdf file then printing it rich

no

I am putting this chunk of code at the start of a report $cOutput= '<input type="button" value="Print this page" onClick="window.print()">'; I print $cOutput to the screen afterwards At the mo it repeats itself on every screen, can I have it so it only prints once? Rich