if i put an exit(); inbetween the two }} at the end it seems to insert the firstline of the array into the table orders_complete. I think what its doing is everytime the while loop cycles its...

hi again

unfortunitly using the mysql_fetch_assoc didnt resolve the issue. when viewing the row changed by the update query only inserted the last row of the select item,cost from orders_total...

thanks for that,

I will impliment that as soon as I can and let you know how I get on. As Im a new PHP programmer im not too sure what the difference is between the mysql_fetch_array and the...

each row entry for total_orders needs to be added to 1 field entry in table orders_complete colum ord_descr

oh right ok. well i am in the middle of designing a web based internal ordering system for a local pizza delivery company. basically the orders_complete table holds all processed information about...

Sure as requested

ORDER_TOTAL Table layout
create table order_total (
ord_id int not null auto_increment,
PRIMARY KEY(ord_id),
item varchar(255),
cost float(6,2));

ORDERS_COMPLETE TABLE

all what happens is that the last piece of information is entering into the orders_complete table i.e. half pound burger £3.40 and not the full information from the select * from total_orders table

i have changed the above code to the following:


include("config.php");

$result7 = mysql_query("SELECT * from order_total");
while($row = mysql_fetch_array($result7))
{
$test =...

Hi All

I was wondering if somebody could help me as this is driving me crazy.

I am trying to send an array from a mysql_fetch_array result to a seporate table. I have the following code:


...

cut a long story short I have 2 tables, one called orders_total and another called orders_complete.

the total_oders table contains rows of what the customer has ordered to eat i.e.

colum called...

if i remember re calling this. I believe if you do not specify a file location for the file to be uploaded i believe it uses a default temporary location within the php.ini file.

take a look at...

try the case statement, this would make things alot easier to code and to read.

Regards

Hi
Does anybody know if there is away for php to open a port i.e. com1 which is connected to the modem and pole for a incoming call? idealy I would like php to display CID (caller ID) from incoming...

hi all

having spent a large amount of time studing the ways to print using php I have finaly figured out the best solution. I have decided NOT to use the text file, but to print directly from a...

you can print directly to a printer held on the clients machine. the php_printer.dll is needed which can be found in the PECL downloads.

once you have downloaded and copyed the php_printer.dll...

changing the print function to RAW data seems to slow the printing speed
setting the printer function to TEXT seems to increase the speed

sorry i forgot to mension that in my last comment any lines displaying : are not shown in the output to screen

Thank you very much for your help so far :o)

ok i have completed the other test too.

It looks like that the printer_write($handle, "Text \n\rTo print"); did write 2 seporate lines. without...

Hi
I have tryed

printer_write($handle, "Line 1");
printer_write($handle, "Line 2");

This seems to print 2 seperate pages
line 1 is one page
line 2 is the other page

i am using:
$file = 'receipt.txt';
$handle = printer_open('HP LaserJet 4000 Series PCL6');
printer_set_option($handle, PRINTER_SCALE, 75);
printer_start_doc($handle, "My Document");...

Hi there, was wondering if somebody could help me.
I currently have a project to create a php/mysql system for a local pizza company, a touch screen system. Cut a long story short, I need to be...