duttydea

Hi all, I have an array: [CODE]<?php $product_id = $_GET[id]; //the product id from the URL $action = $_GET[action]; //the action from the URL //if there is an product_id and that product_id doesn't exist display an error message if($product_id && !productExists($product_id)) { die("Error. Product Doesn't Exist"); } switch($action) { //decide …

I have just written this code o update my MYSQL Server with data from an Arduino Micro controller using Ethernet. Basically I want to pass the variables collected by the Arduino to the Server. Whenever I try to use this script the Values [I]$_POST['Name'][/I] [I]& $_POST['Value'][/I] do not get passed …

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 and a Link to RomanCart. When the user clicks the “Add to Cart” info is added to …

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 then deduct an hour from the Total. Can anyone help? Thanks in …

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 their sub category: [CODE]SELECT `Product_ID`, `Product_picurl`, `Product_Name`, `Product_Description`, `Product_price`, `Product_Category`, `Product_Pdf`, `Product_Cart`, `Product_Features`, `Product_subcat`, `Key` …

I want to add an image to my php script: [QUOTE]<?php $sql = "select * from Prod_listing"; $result = mysql_query ($sql); while ($row = mysql_fetch_array($result)) { $field1= $row["Product_Name"]; $field2= $row["Product_Id"]; $field3= $row["Product_Description"]; $field4= $row["Product_picurl"]; echo "<h1> <strong> $field1 <br> </strong> </h1>"; // Header Tag, bold.tag echo "$field2<br>"; echo "$field3<br>"; echo …

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. [CODE]<table width="65%" height="404" border="1" align="left" cellpadding="0" cellspacing="0"> <tr> <td height="16" …

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: [CODE] SELECT `Product_Name` , `Product_Description` , `Product_Features` , `Product_picurl` , `Product_price` , `Product_Category` , `Product_subcat` FROM `prod_listing`[/CODE] Like this: Acoustic Treatment Acoustic panels …

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" everytime i edit it i get a syntax Error!! please can you help? Thanks in advance [CODE]<?php …

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. [B]I have tried to use this:[/B] [CODE]<?php @ include ("index_random.php");?>[/CODE] to display random products from the product listing But it has no …

How can i Load images in to each cell of a table based on its product id? The picture url is stored in field:[I] Product_picurl[/I] [CODE]SELECT `Product_id`,`Product_Name` , `Product_picurl` FROM `prod_listing` where `Product_id` ="$ID" [/CODE] I have looked around for a photogallery script but cant find one!! Thanks in advance