[PHP-DB] PHP Home 2.2.8

2003-03-31 Thread Steve Dodkins
Hi All Has anyone upgraded from PHP Home Edition 2.2.3 (from sourceforge.net) to version 2.2.8 ? and if so were there any issues? Steve Dodkins _ IMPORTANT NOTICE This email (including any attachments) is meant only for the intended recipient. It may also contain

[PHP-DB] posting variables

2003-03-28 Thread Steve Dodkins
m1 + 20); echo $lim1; } Regards Steve Dodkins _ IMPORTANT NOTICE This email (including any attachments) is meant only for the intended recipient. It may also contain confidential and privileged information. If you are not the intended recipient, any reliance on, use, disclosure, distributio

[PHP-DB] Next/Prev 10 lines

2002-12-20 Thread Steve Dodkins
Has anyone got some code that will correctly display the next 10 line of a table with prev and next working? Or point me in the right direction for help? Regards Steve Dodkins IMPORTANT NOTICE The information in this e-mail is confidential and should only be read by those persons to whom it is

[PHP-DB] right join

2002-11-21 Thread Steve Dodkins
rd_no ORDER BY labor_qty",$link); Regards Steve Dodkins IMPORTANT NOTICE The information in this e-mail is confidential and should only be read by those persons to whom it is addressed and is not intended to be relied upon by any person without subsequent written confirmation of its contents.

RE: [PHP-DB] using php4 to connect to mysql (newbie question)

2002-11-20 Thread Steve Dodkins
Hi The latest PHP bible is now updated to 4.2 www.troutworks.com -Original Message- From: Snijders, Mark [mailto:[EMAIL PROTECTED]] Sent: 20 November 2002 12:18 To: 'mike karthauser'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] using php4 to connect to mysql (newbie question) read this

[PHP-DB] Pull Word Docs

2002-11-13 Thread Steve Dodkins
ay to represent the document path? Regards Steve Dodkins IMPORTANT NOTICE The information in this e-mail is confidential and should only be read by those persons to whom it is addressed and is not intended to be relied upon by any person without subsequent written confirmation of its contents

RE: [PHP-DB] sql select

2002-11-12 Thread Steve Dodkins
won't let you do it..try and (labor_qty*parts_time+parts_setup)>labor_time -Original Message- From: Steve Dodkins [mailto:Steve.Dodkins@;ebm-ziehl.co.uk] Sent: Tuesday, November 12, 2002 10:16 AM To: Php-Db (E-mail) Subject: [PHP-DB] sql select if i have a statement $result

[PHP-DB] sql select

2002-11-12 Thread Steve Dodkins
o AND works_orders_part_no=parts_no AND time2 = labor_wkyr ORDER BY labor_wkyr,works_orders_ord_no",$link); This works fine but if i add AND timea > labor_time it fails Regards Steve Dodkins IMPORTANT NOTICE The information in this e-mail is confidential and should only be read by those persons

[PHP-DB] Variables

2002-11-08 Thread Steve Dodkins
works_orders_part_no"]."".$myrow["works _orders_qty"]."".$myrow["labor_qty"]."".$myrow["labor_time"] ."".$myrow["timea"]; Regards Steve Dodkins IMPORTANT NOTICE The information in this e-mail is confidential and shou

[PHP-DB] select statement

2002-10-25 Thread Steve Dodkins
ult = mysql_query("SELECT * FROM labor, works_orders, parts where labor_ord_no = works_orders_ord_no AND works_order_part_no = parts_parts_no",$link); echo ""; echo"Works OrderPart NumberOrder QtyMade QtyOptions"; while($myrow = mysql_fetch_array($result)) Regards St

[PHP-DB] MS Access

2002-10-18 Thread Steve Dodkins
Hi Has anyone got a sample script that updates/adds and deletes records on an ms access database or can point me to a resource that will have one? Regards Steve Dodkins IMPORTANT NOTICE The information in this e-mail is confidential and should only be read by those persons to whom it is

[PHP-DB] echo printing a cookie

2002-10-15 Thread Steve Dodkins
Hi I'm trying to print the contents of a cookie (php 4.2.3) the syntax below is wrong but what should it be? if ($_cookie["cookiename"]== TRUE) { echo"your cookie is" $_COOKIE["cookiename"]""; } Regards Steve Dodkins IMPORTANT NOTICE The informat

[PHP-DB] Set Cookies

2002-10-15 Thread Steve Dodkins
isting19.1.php on line 4 3 6 7 8 Listing 19.1 9 10 11 hello again your chosen veg is $vegetable"; 14 15 else print "hello your 1st visit ?"; 16 17 ?> 18 19 20 Regards Steve Dodkins IMPORTA

[PHP-DB] MS Access Connectivity

2002-10-09 Thread Steve Dodkins
d path sql state S1009 in sqlConnect ... If i copy the db to the local drive and amend the system dsn to map to the local drive it works, MS Excel can also connect to the db over the network. Any ideas? Regards Steve Dodkins IMPORTANT NOTICE The information in this e-mail is confidential and