How can i use the time from mysql fields using this format: 00:00:00 ?

i am trying to calculate my working hours.

I have a start time, a finish time and a lunch flag.

What i am hoping to achieve is:

difference between start & End time.
If Lunch flag equals yes...

Hi all,

I have an array:

<?php

$product_id = $_GET[id]; //the product id from the URL
$action = $_GET[action]; //the action from the URL

//if there is an...

Cheers Guys!!!!!!!!!!

Here is what im using..



<?php
//--------------- Connection Script ----------------------------\\
$username = "*";
$password = "*";

I Im still not getting any joy!!!

when i change a database field to a name not present in the database i get the html table.

No PHP errors are shown, i dont even think the script is even...

how do i use the data stored in $field4.

I want to add an image to my php script:



The picture link is stored in $field4

thanks in advance

Just Tried the code:


No data is displayed

I have a script that displays data from Mysql server, what i hoping to do is display the data in a HTML Table.

I would like to create the table in deamweaver purley cause i am not great at HTML.
...

Thats exactly what i want but dont know how to do it!!

I have a database of over 900 products.

What i am hoping to create is a website that pulls the Product information from a database using its Product ID.

The products are displayed according to...

I have just added the code to my site.

the only problem, when i add to cart the cart page is displayed.

<a href="cart.php?action=add&id='.$row['Key'].'">Add to cart</a>

how can i stop the...

Hi all,
I need some help creating a cart system.

I’m currently using roman cart & MySQL which means I have to maintain two separate databases.

The MySQL database holds the Product information...

http://www.daniweb.com/forums/thread104411.html

Check out the post above.

I generated this script using maestro php
Generator.


It has a table that shows up in dw and
Calls fields in...

Hi everyone!!

I have a mysql table of products and i want to group them by the category then each sub category in a table:

SQL strng:
SELECT `Product_Name` , `Product_Description` ,...

How can i Load images in to each cell of a table based on its product id?

The picture url is stored in field: Product_picurl

SELECT `Product_id`,`Product_Name` , `Product_picurl`
FROM...

Thanks guys!!
I added the handler to the cpanel

It worked a treat!!

I have a created template in html..

in this template i have a scrolling DIV

What i want to do is display the myqsl data in this DIV.

I have tried to use this:
<?php @ include...

To my knowledge i need to change both queries as 1 is the record count & the other is the records!!

I am a Newbie To PHP!!

I used maestro php myqsl to crate the code below..

I am trying to change the query to include a where statment:

"where Product_Category = Acoustic treatment"
...