[my vps has asp?]

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

 

[members creat emails]

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

[sync Access DB to Mysql DB..]

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..

[Query for 3 DB's..]

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!!

[sync Access DB to Mysql DB..]

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

[Query for 3 DB's..]

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               

       

 

 

[Query for 3 DB's..]

i need to show the image not the id.cause this query gets all the image id's

[Query for 3 DB'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?

[Query for 3 DB's..]

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?

 

[voice chat only]

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!!

[php on tpl pages?]

cool afther i can do <? or {php}

[php on tpl pages?]

its a shared hosting?is this in the php ini?

[php on tpl pages?]

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?

[select sum help]

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 ,??

[post a video?]

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

[post a video?]

hmm ok i get it..

 

so what if my link starts with

 

<embed src="<? echo info['link'] ?>" />

[post a video?]

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?

[if statment..]

Hey guys i have a query i would like to pass but i cant seem to get the if workorking?

 

reg querry sellect all from Archives..(Row3)

 

and the $info come from my pagination script to list all products.

 

so there is basicly 2 querry's here.

 

cause i have 2  tables ,one products and the other Archives.so when i sell a product it inserts in archives the product id and sold price.

 

so basicly this page is listing all cars .when i sell the car i set the status to sold.

so i want to show if the car was already archived..

 

 

so i set up a

 

<? if ($row3['CARID'] == $info['ID']) { echo '<img src="icons/SyncCenter_1213_10_32x32x32.png" border="0" alt="" />');}?>[code=php:0]

[insert ID in query]

oh ok..i will try it.thx!

[insert ID in query]

funny cause now it says my fetch array is no good?

$sql = "SELECT * FROM $tbl_name WHERE Date = (SELECT MAX( date ) FROM $tbl_name) WHERE Dealer_ID='$_SESSION[user_id]' LIMIT $start, $limit";

$result = mysql_query($sql);

 

[/php

[insert ID in query]

thx true...lol

[insert ID in query]

Hey guys i have this pagination script that im using and i need to add a specific user to it.so it does not select every thing from the databse but only the user loggin.

 

SELECT COUNT(*) as num FROM $tbl_name WHERE Date = (SELECT MAX( date ) FROM $tbl_name

 

need to add `Dealer_ID`=$ID

 

thx!!

[left join error]

so i used

 

$query = "(SELECT * FROM cars )

UNION

(SELECT * FROM cars2 )

ORDER BY ID LIMIT 10;

  ";

 

The used SELECT statements have a different number of columns

[left join error]

hey guys i have 2 databases that are exacly the same.but one is cars the other is cars2 i need to echo all of the contents of both togetter.

 

inventory page.

 

so i tryed looking up left join

 

im struggeling with this ..

 

SELECT *  cars LEFT JOIN cars2

 

works but thable 1 cars only show the id's not the rest of the info and table 2 cars 2 show it all?

 

both have the same fields(copy paste)

[print and send]

Well, if you have a function for print and one for send, then why not just have a function that calls both?

That is the point of my topic exacly what I need.thx. For the help