-
Posts
812 -
Joined
-
Last visited
Everything posted by techker
-
Hey guys i just want to know if i set this up good.. 59 1 * * * /httpdocs/updateDB_QTY.php so i want it to start every 1h59 minutes..
-
ok this is what i got for the query $query2 = "SELECT TbItemInventory.Name, xcart_products.productcode FROM TbItemInventory, xcart_products WHERE ( TbItemInventory.Name = xcart_products.productcode ) LIMIT 0 , 50"; <? while($row1 = mysql_fetch_array($result6)){ echo $row1['Name']. " - ". $row1["productcode"]. " - ".$row1["QuantatyOnHand"]; echo "<br />"; } ?> no this works.now how can i insert a update? tryed this with nosuccess.. $sql4 = "UPDATE xcart_products SET avail='$QTY' WHERE productcode='$Name' "; $result4 = mysql_query($sql4)or die(mysql_connect());
-
with a obdc connector. its fast and free http://www.bullzip.com/download.php so i dump it in all the info.but i need to update the xcart product table
-
Hey guys i need to check a databse and update another Db? can i do this in one script? i have a databse(tblinventory) that i sync(OBDC) with specific fields(price-QTY-SalesPrice..) and i have a cart(Xcart)that i want to update the inventory QTY and price. so bacsicly i want to check my tbl inventory and sync it with my xcart procuct tbl.
-
cold be.copy of the plesk page Plesk ships with several test pages, showing script version, testing database connections, sending mail, etc. Click on icon to see test pages for different scripts: ASP -SSI- PHP -ColdFusion- Perl Python -FastCGI -Miva
-
Hey guys i have a vps from 1and1 and im going tru it and notice there is a module asp? does that meen i can use asp and php on it? this is what i seen when creating a new domain plesk default page then there was a asp button test HTTP_ACCEPT application/x-ms-application, image/jpeg, application/xaml+xml, image/gif, image/pjpeg, application/x-ms-xbap, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, application/x-shockwave-flash, */* HTTP_ACCEPT_ENCODING gzip, deflate HTTP_ACCEPT_LANGUAGE en-US HTTP_CONNECTION Keep-Alive HTTP_COOKIE locale=en-US HTTP_HOST store.lfnc-shop.com HTTP_REFERER http://store......com/ HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C) REQUEST_METHOD GET REQUEST_URI /test/apacheasp/test.asp
-
Hey guys i want to do for my members a creat your own email but with my domain name at the end.. like a gmail our yahoo.. is it possible to do this?i have a vps server
-
ok but i have now clue..i know it can be done cause i have hurd about it but dont know what to look for..
-
i think i just clicked..i have a file called img.php so basicly i inlude the echo image id in the link echo "<img src='getImage.php?id=$IDImage'>"; yap i got..thx!!
-
Hey guys im using in shop a access program for my inventory and prices.. i want to make an online catalogue for my clients.. i need to sync my access db file to my mysql server?is this possible?cause i know it can be done but doing it is another issue..lol
-
ok this is tblimages Field Type Collation Attributes Null Default Extra Action IDImage bigint(20) No auto_increment Image blob BINARY Yes NULL Nom varchar(50) latin1_swedish_ci No Taille float No Fichier tinyint(1) No commande details NoCommande mediumint(9) No IDProduit bigint(9) No Quantite int(11) No Rabais float No Prix float No tblProduits Field Type Collation Attributes Null Default Extra Action IDProduit bigint(20) No auto_increment IDProduit Access bigint(20) Yes 0 IDCatalogue smallint(6) No IDCategorie mediumint(9) No IDFabriquant mediumint(9) No SkuFabriquant varchar(25) latin1_swedish_ci No DescriptionCourte varchar(40) latin1_swedish_ci No Description text latin1_swedish_ci No Prix decimal(12,6) Yes NULL PrixCoutant double Yes NULL IDImage bigint(20) No QuantiteDisponible int(11) Yes NULL LinkExterne varchar(300) latin1_swedish_ci Yes NULL PrixRegulier float(12,6) Yes NULL
-
i need to show the image not the id.cause this query gets all the image id's
-
Ok so i have been messing arround and found this to show me the Imgae id $sql = 'SELECT c . NoCommande , c . UName , c . Etat , c . DateCommande , cd . Quantite , cd . Rabais , cd . Prix , p . description , p . DescriptionCourte , p . IDImage ' . ' FROM tblCommande AS c ' . ' INNER JOIN tblCommandeDetail AS cd ON cd . NoCommande = c . NoCommande ' . ' INNER JOIN tblProduits AS p ON p . IDProduit = cd . IDProduit ' . ' INNER JOIN tblImages AS t ON t . IDImage = p . IDImage ' . ' WHERE c . NoCommande = 30 LIMIT 0, 30 '; NoCommande UName Etat DateCommande Quantite Rabais Prix description DescriptionCourte IDImage i got the image id!but how do i now go in IDImages to get the location?
-
Hey guys i have a catalogue im working with and on my front page of my website i would like to put recent order.. So i need to grab info from 3 database's.. first is the order details tblorderDetails to grab the IDProduct then i need the tblProduct for the IDImage( product image) then last tblImage for the image file and name.. can anybody help me with this query?
-
Hey guys any body know where i can find a voice chat script?cause all i found was pc based now server only?i have a vps so i can add features if needed.. thx!!
-
cool afther i can do <? or {php}
-
its a shared hosting?is this in the php ini?
-
hey guys i need to modify my body's cms and it uses tpl pages. i need to add php to a page.i know there is setting pre made in smarty for {php} but that does not work for me? and other way to add php to tpl pages?
-
Hey guys in my databse the prices are written like this: 12,100 when i do the sum of it it only gives me the sum before the ,??
-
wow i need to read up more on object tag's..it can really simplify lots of work! <object classid="clsid:22D6F312-B0F6-11D0-94AB-0080C74C7E95"> <param name="FileName" value="3d.wmv" /> </object> need to read up on were does the class id come from..lol thx
-
hmm ok i get it.. so what if my link starts with <embed src="<? echo info['link'] ?>" />
-
hey guys i want to make a litle script for my boddy's web site to upload video .that part is good but i have a quick question on posting the vids.. with pictures you usally do echo img... if i store the path of the vid in my database and echo just the path will the video show? and when you upload on youtube does it convert it to flv?