User Profile
Collapse
-
checkbox- if statement
Yo Yo Yo, hey guys
lol a tricky question for my limited php skills, lol but i bet you will be laughin your head of when i ask about it.
i have a form that asks users to fil out information about stock, its got loads of checkbox's with YES or No options.
so they fil in the form, e.g do you have blue walls YES or No, say no is checked, then no is displayed,
so my code says this
... -
the calculation part, i dont know how to do calculations using php.
dont know i if could do $textbox1 + $textbox2 + $textbox 3 = $total and were to start doing calculations within dat code i showed....Leave a comment:
-
opz sorry, that lost me.
currenty its a php form, that selects so far just the firstname and the surname, but also on the form, there are a few more colum headings as you can see in the code above na,med BOOTS,DOHC,HOSI ,BR,PPP,OTHER, they have just got text boxes, ready for the regional manager to enter some hours in.
so they enter the hours for each person in the relavent textboxs, then i want for them to press...Leave a comment:
-
[php]
<?php
/*
create table users (id int, staffid int, region varchar(20), firstname varchar(20), surname varchar(20));
insert into users values(1,1,'reg ion1','John', 'Doe'),(2,2,'re gion1','Pete', 'Mackay');
create table stores (name varchar(10));
insert into stores values('Name1') ,('Name2'),('Na me3'),('Name4') ,('Na me5'),('Name6') ;
*/
$con = mysql_connect(" localhost","roo t","password ");...Leave a comment:
-
-
nice reply thanks, but do u not think that if i hadnt tried already i would be back on here....Leave a comment:
-
-
-
how to go about doing it in PHP, if i understood it, i wouldnt not be on here asking for help....Leave a comment:
-
how to insert this into database n display
[php]
<form action="do.php" method="post">
<?php
/*
create table users (id int, staffid int, region varchar(20), firstname varchar(20), surname varchar(20));
insert into users values(1,1,'reg ion1','John', 'Doe'),(2,2,'re gion1','Pete', 'Mackay');
create table stores (name varchar(10));
insert into stores values('Name1') ,('Name2'),('Na me3'),('Name4') ,('Na... -
-
-
calculate in PHP
hey guys, i was just wondering how to do calculations in php.
i have a table, currently in the table are firstname,surna me, then there are lists of stores eg. Boots,woolworth s,hospital etc
so the page loads with just the first name, then say 0.8 is entered into boots, 0.7 entered into woolworths, the user then submits the data, i would like the data to be entered into my database, but then also caqlculated into a total... -
subtmiting the dropdown option selected to the database
Hey guys
i have a list of stores listen in a drop down, the user pics the store, but then i would like that option to be entered into the database.
there are 25 drop down boxs in the table, so 25 enteries will be made in the dtabase for the fowllowing days sat,mon,tues,we ds,thurs,fri,
i have the table already setup in the database, just need to know how to take the data from the form.
i... -
-
couldnt i just have a save button and when the checkbox is checked and saved pushed, then it submits and saves the page??? to those settings??...Leave a comment:
-
-
month will not change
Code:SELECT DISTINCTROW Format(PERIOD.START_DT,"mmmm yyyy") AS MonthYear, SALES.PERIOD_ID, Sum(SALES.SALES) AS SumOfSALES, Sum(SALES.SALES_UNITS) AS SumOfSALES_UNITS, Sum(SALES.SALES_VALUE) AS SumOfSALES_VALUE, Sum(SALES.PHILIPS) AS SumOfPHILIPS, Sum(SALES.FITTED) AS SumOfFITTED, Sum(SALES.FITTED_UNITS) AS SumOfFITTED_UNITS, Sum(SALES.FITTED_VALUE) AS SumOfFITTED_VALUE, Sum(SALES.DONE) AS SumOfDONE, Sum(SALES.BOOKED) AS SumOfBOOKED,
-
No activity results to display
Show More
Leave a comment: