Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

~285 People Reached
Favorite Forums
Favorite Tags
Member Avatar for daniel7912

Hi, At the moment I am pulling a record from the database which is in datetime format. Could someone please tell me how I can modify this to just display the time and exclude the date? Many thanks for any help. [CODE]<?php $time = mysql_query("SELECT * FROM gps WHERE imei …

Member Avatar for lyrico
0
239
Member Avatar for daniel7912

Hi, For my assignment work I have to make 3 queries, and one of my queries includes a part that needs me to work out with orders have a total price above £70. Here's the code I have so far: [code=sql]SELECT SUM(Quantity*Price) As Total_Order_Cost FROM Orders JOIN [Product_orders] ON [Orders].Order_ID …

0
46