Web Design & Web Development Forum: HTML, CSS, JavaScript, PHP

www/nonwww

marianajones — Wed, 16 May 2012 10:22:03 GMT

Which is better practicing www or non www for a site?

Discount Coupon Codes

What is Database noramalizaion?

JackITo — Wed, 16 May 2012 04:01:26 GMT

Database normalization is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency. Normalization usually involves dividing large tables into smaller (and less redundant) tables and defining relationships between them. The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database via the defined relationships.

Problem in syntax from mysql to php syntax

newphpbees — Wed, 16 May 2012 03:11:31 GMT

Hi..

I create mysql syntax for query testing before i input to my php code

here is my mysql code:

Code:

set @t = 0;

set @rqty=31968; 

SELECT LOT_CODE as code,  DATE_ENTRY,   

CASE WHEN @t+OUTPUT_QTY > @rqty 

THEN @rqty  -@t  

ELSE OUTPUT_QTY 

END as qty,

@t := @t + d.OUTPUT_QTY as cumulative   

FROM dipping d  WHERE SUBSTR(LOT_CODE, 9,4) = 'P28' AND (@t < @rqty);

Now that query test is work i will input that code to my php codes.

PHP Code:


     $sql = "SELECT SKUCode, Materials, Comp, Qty 

     FROM bom  WHERE SKUCode = '$SKUCode'";

     $res = mysql_query($sql, $con);



    ($row = mysql_fetch_assoc($res));

     $Materials = $row['Materials'];

     $Qty = $row['Qty'];

     $Comp = $row['Comp']; //P28

//-----Compute Req Qty and Save to table---//     



     $ReqQty = $Qty * $POReq; // 31968





     

$sql = "UPDATE bom SET ReqQty = '$ReqQty' WHERE SKUCode = '$SKUCode' AND Materials = '$Materials'";

$resReqQty = mysql_query($sql, $con);



$t = 0;



$sql = "SELECT LOT_CODE as code,  DATE_ENTRY,   

CASE WHEN $t+OUTPUT_QTY > $ReqQty 

THEN $ReqQty  -$t  

ELSE OUTPUT_QTY 

END as qty,

$t := $t + d.OUTPUT_QTY as cumulative   

FROM dipping d  WHERE SUBSTR(LOT_CODE, 9,4) = '$Comp' AND ($t < $ReqQty)";

when I echo the query:

I got this:

SELECT LOT_CODE as code, DATE_ENTRY, CASE WHEN 0+OUTPUT_QTY > 31968 THEN 31968 -0 ELSE OUTPUT_QTY END as qty, 0 := 0 + d.OUTPUT_QTY as cumulative FROM dipping d WHERE SUBSTR(LOT_CODE, 9,4) = 'P28' AND (0 < 31968)

then I run it to the sql

and I got an error:

Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':= 0 + d.OUTPUT_QTY as cumulative FROM dipping d WHERE SUBSTR(LOT_CODE, 9,4) = '' at line 1
(0 ms taken)

Any help is highly appreciated

Thank you so much

Top Movie Converter for Apple TV 3 - Stream Blu-ray/DVD/1080p HD videos to Apple TV 3

kelly456 — Wed, 16 May 2012 00:57:21 GMT

Top Movie Converter for Apple TV 3 - Stream Blu-ray/DVD/1080p HD videos to Apple TV 3

Apple TV 3 is a hot device for you to watch videos on your TV, released on march this year, the Apple TV 3 has attracted great attention the same as the new iPad. The Apple TV 3 is great for us to watch high-definition movies on HDTV. May be you have collected many Blu-ray or DVD discs, or have download many HD movies in different video formats from websites, now you can watch these movies easily on TV through Apple TV 3, just need a Apple TV 3 video converter, below is a brief guide for you to better play Blu-ray, DVD and HD videos on Apple TV 3 without the limitation of the video formats, just follow it.

1.Download Pavtube Blu-ray Video Converter Ultimate, a top Movie Converter for Apple TV 3, if you need to run the software on Mac OS, please download iMedia Converter for Mac. With this excellent software, you can rip Blu-ray, DVD and HD files to Apple TV 3 supported formats.

2.Install and launch this Blu-ray/DVD/HD to Apple TV 3 converter.

3. Click format bar to choose the output format, please click and choose Apple TV -> Apple TV H.264 1280*720 (*.mp4), this format is perfectly supported by Apple TV 3. Besides, you can choose other formats for output as you want.

4. You can click settings button in the main interface to adjust the output parameters, you can change the resolution, bitrate and audio channels as you want.

5. Click convert button to start.

With Pavtube Blu-ray Video Converter Ultimate for Apple TV 3, you can convert Blu-ray to Apple TV 3, convert DVD to Apple TV 3, or convert MKV to Apple TV 3, etc. you can play any videos in Apple TV 3 without limitations. What’s more, you can go to Apple TV 3 column to find detail solutions.

If you just want to convert mkv/avi/tivo/m2ts to atv 3 on mac, you can try mac video converter for atv 3, it's an excellent apple tv 3 converter for mac.

Check out Pavtube's Apple TV 3 column to get more movie-enjoyment tips about Apple TV 3 and more special offers during Pavtube's Big Sale Season.

Creating a tableless image grid with CSS

jpf566 — Tue, 15 May 2012 18:57:53 GMT

Hey guys, as always I�m trying to do something seemingly simple and am having some bizarre issues. I�m just trying to make a simple image grid without using tables.

sheffieldfurniture.com/imagegrid/furniture.html
First issue is, why is there a space between the images here? It seems like it�s adding a margin although Chrome developer tools is not saying that the images have any margin applied to them. I do want to have the images spaced out but I can�t do the math necessary for doing that if some browsers are going to be randomly adding a margin.

sheffieldfurniture.com/imagegrid/furniturefloat.html
I was able to fix this by floating everything left. Is this the proper fix? It still bugs me that I couldn�t figure out why the images had space in-between

Let me know if I�m going about this wrong, is this how you guys would do a simple images grid? Also, I suck at math, how would you go about determining how large to make the images and how much margin? The parent container will be 960 Pixels and I�d like rows of 5 across to be centered

what is Difference Between White hat, Black hat n Gray hat SEO??

RobetsJulia — Tue, 15 May 2012 18:51:12 GMT

HI friends,

I need ur views regarding dese terms Difference Between White hat, Black hat n Gray hat SEO??

Thnx 4 Advance
:)

What is meant by spamming?

Ndot India — Tue, 15 May 2012 13:57:43 GMT

I just want to ask web masters here What is meant by spamming?

Whether it is doing link building activities more quickly to promote keyword : For example using the same content for all article and blogs (or) having duplicate contents in your website.

Marketing In SEO

akash001 — Tue, 15 May 2012 13:14:21 GMT

Please Tell me Marketing In SEO possible or not?And How

Help on Rich Snippets

SSLMatrix — Tue, 15 May 2012 10:03:46 GMT

Lots of Information and post i have found but non of them enough to understand how enable review and rating code for my website.

wellcome all expert to help me out.

Thanks in Advance.

Convert MOD to Galaxy S II to Play

peterluo518 — Tue, 15 May 2012 06:30:51 GMT

How to Convert MOD to Samsung Galaxy S II on Mac

"I get some HD videos at format MOD, now I want to play them on my Samsung Galaxy S II, but the Galaxy S II would not accept them, what shall I do to play such MOD files on Galaxy SII? Thanks for your help."

Samsung Galaxy S II is an excellent smart phone. It comes with a 4.3-inch screen with resolution of 480*800, which is very good at play video, but just like most smart phones, it can only play DivX, H.263, H.264, MPEG-4, WMV, XviD video files, such as MOD,TOD,MTS,AVCHD and the like HD formats are not supported, so, if you want to play MOD videos on Galaxy SII, you need to convert them to the formats it supports, for example,MP4. To convert MOD to Samsung Galaxy SII MP4, what you need is only a Video Converter. I highly recommend iOrgsoft MOD to Samsung Galaxy Converter, which can easily convert all MOD video files to MP4 fast.

iOrgsoft MOD Converter for Mac is a powerful software to convert Panasonic SDR, JVC Evirio, Canon FS MOD files to MP4 for playback on Galaxy S II as well as other devices such as Kindle Fire, Samsung Galaxy Tab 10.1, iPhone 4S and so on. Besides, it can provide full video editing functions such as clip mod, crop mod, adjust video effect and so on to help you make your personalized movies. This article will show you how to convert MOD to Galaxy S II on Mac step by step.

Guide on How to Convert MOD to Galaxy S II on Mac

Step 1: Free Download and install mod Converter Mac and run it

Step 2: Click Add File button to import MOD file and click the pull-up list of Profile to set output format as MP4 ,select a path to save the converted file below the Output.

Tips: With .mod Converter Mac,you can clip and edit the MOD video:split video into several segments, crop the video(remove unwanted part, zoom as full screen, 16:9,4:3), and set effect(brightness, contrast, saturation and special effect such as Old Film,Gray,Emboss for the video).

Step 3: Setting

Make settings below before convert, especially Resolution

Hit Start button, the .mod Converter for Mac will show you the converting status on a progressing bar.

After finish converting, you can transfer the converted video to your Galaxy SII to play whenever and wherever.

Support MiniGal Nano

JackITo — Tue, 15 May 2012 02:52:46 GMT

If you like MiniGal Nano there are several ways you can support the project:

Donate money
Click the donate button in the main website footer

Rate the script
Please visit the sites below and give Nano a good rating - it's quick and easy :)
OpensourceCMS
Hotscripts
Gscripts

CS Cart Customization | Zen Cart Customization | Magento Customization

2 containers within each other

mowen10 — Mon, 14 May 2012 21:25:25 GMT

Hi,i am looking to find out if it is possible to have a container within each other. For example I am looking to have a container of 900px that then has 2 divs of 450px next to each and within the first div (450px) i would like to split this by 225px but not sure how i can go about writing this.

If somebody could please help would really appreciate it.

Thanks in advance

Function is displaying javascript code instead of processing it

mitch123 — Mon, 14 May 2012 18:31:18 GMT

Hi guys,
As you can probably see below, by clicking the submit button it is reloading the browser and displaying my sender.js file's script, as opposed to processing it. I guess I'm using the wrong "command" (correct terminology?) and should not be using action(I guess?), but another command. What should it be?

Many thanks,

M.

Code:

function submitFunction(i) {

   if (i==1) document.forms['form1'].action='sender.js';

   if (i==2) document.forms['form2'].action='test.js';

   }

Selecting Colours

AJ Hypnotherapy — Mon, 14 May 2012 13:14:33 GMT

Hi, Found this a few days ago and I thought it was great so I have decided to share it. It was originally from a fourm so sorry if it was your post or have seen it here before I thought it was worth the risk! :)Attachment 760

Attached Images

colour theory.jpg‎ (34.7 KB)

How do i create links to sections on the same page in HTML?

hirewebsitedesi — Mon, 14 May 2012 13:14:06 GMT

How do i create links to sections on the same page in HTML?