snubbr.com

How can I embed a wav file into an https (Verisign SSL) Yahoo-hosted web page?

Get a Verisign SSL certificate for 30 days FREE. Click here to use coupon...

Get a free trial of Verisign SSL certificates. Click here for this special deal...
First of all How can I embed a wav file into an https (Verisign SSL) Yahoo-hosted web page? Looking forward for any response. 2nd question I got is.. Hi.

At present the customer detail on order.php is Name, Address Telephone and Email address ... I would like to add/display the data that we capture in the Fax field. (We capture the customers Mobile Number in this field).

I added the following to the page.

<tr>.

<td class="main"><b>Mobile Number:</b></td>.

<td class="main"><?php echo $order->customer['fax']; ?></td>.

</tr>.

However all I get is a blank space where the number I want should be.

Can anyone help me solve what I thought would be a simple amendment.

Many Thanks.

John K.

This post has been edited by.

Pynchon.

: 19 January 2009, 12:47..

Comments (93)

Hmm... I need to find out myself. I don't know what is the right answer to your question. I'll do some research in Google and get back to you if I bump into an anything. You should email the people at Verisign as they probably could help you..

Comment #1

Many thanks for the reply..

Where do I put the code you have quoted ?

Comment #2

I guess you are trying to get the fax no. displayed in the admin/order.php file right??.

If so go to admin/orders.php.

You will place that code right above include(DIR_WS_CLASSES'order.php');.

And call it like this in.

<tr>.

<td class="main"><b><?php echo 'Mobile #:'; ?></b></td>.

<td class="main"><?php echo $the_customers_fax; ?></td>.

</tr>..

Comment #3

Yep ... we have a lot of customers that give both their home numbers and a day-time mobile number ... it makes contacting the customer easier if the mobile number is displayed on the orders.php page when the order is opened for editing/processing. It saves having to look in the customer details record..

I'll try it just now and see what happens..

Thanks again..

Comment #4

Alas it doesn't appear to work.

This is the code as it appears in my orders.php ... at least the last few lines.

If (!tep_db_num_rows($orders_query)) {.

$order_exists = false;.

$messageStack->add(sprintf(ERROR_ORDER_DOES_NOT_EXIST, $oID), 'error');.

}.

}.

$the_extra_query= tep_db_query("select * from "TABLE_CUSTOMERS" where customers_id = '"$the_customers_id"'");.

$the_extra= tep_db_fetch_array($the_extra_query);.

$the_customers_fax= $the_extra['customers_fax'];.

Include(DIR_WS_CLASSES'order.php');.

?>.

The orders page still works so the presence of the code isn't breaking anything that I can see ... just that the number still doesn't show.

Hmmmm.

John K..

Comment #5

Did you put this <td class="main"><?php echo $the_customers_fax; ?></td>..

Comment #6

Yes ... that snippet was placed in the table cell I want the number to appear in..

Comment #7

Is it still showing blank? does the customer who you are testing for, does he have a fax number in the field.

Is there any error..

Comment #8

I've checked it against a number of records .. all of which have a fax/mobile number .... and all are displayed without the number.

There is no error .... all orders display as they should..

Comment #9

In your database in the customer table, the fax field is called customers_fax.

Just check to make sure..

Comment #10

Thanks for your help with this 'juniorprg'..

The table is called customers, and the field is called customers_fax..

Comment #11

I feel such a stupid now,,,right above the query I gave you put this aswell.

$the_extra_query= tep_db_query("select * from "TABLE_ORDERS" where orders_id = '"(int)$oID"'");.

$the_extra= tep_db_fetch_array($the_extra_query);.

$the_customers_id= $the_extra['customers_id'];.

So it should look like this.

$the_extra_query= tep_db_query("select * from "TABLE_ORDERS" where orders_id = '"(int)$oID"'");.

$the_extra= tep_db_fetch_array($the_extra_query);.

$the_customers_id= $the_extra['customers_id'];.

// Look up things in customers.

$the_extra_query= tep_db_query("select * from "TABLE_CUSTOMERS" where customers_id = '"$the_customers_id"'");.

$the_extra= tep_db_fetch_array($the_extra_query);.

$the_customers_fax= $the_extra['customers_fax'];.

Echo $the_customers_fax;..

Comment #12

Wa' Hae.

It works !!!!.

Minor point though .... the number also displays above the logo top left of the page..

Thats brilliant .... though it would be good to get rid of the extra number ... lol.

:thumbs up:.

Thanks you..

Comment #13

$the_extra_query= tep_db_query("select * from "TABLE_ORDERS" where orders_id = '"(int)$oID"'");.

$the_extra= tep_db_fetch_array($the_extra_query);.

$the_customers_id= $the_extra['customers_id'];.

// Look up things in customers.

$the_extra_query= tep_db_query("select * from "TABLE_CUSTOMERS" where customers_id = '"$the_customers_id"'");.

$the_extra= tep_db_fetch_array($the_extra_query);.

$the_customers_fax= $the_extra['customers_fax'];.

Echo $the_customers_fax;.

Could the extra number be because of the highlighted code ??.

This post has been edited by.

Pynchon.

: 19 January 2009, 17:55..

Comment #14

Oh just remove the line.

Echo $the_customers_fax;.

$the_extra_query= tep_db_query("select * from "TABLE_CUSTOMERS" where customers_id = '"$the_customers_id"'");.

$the_extra= tep_db_fetch_array($the_extra_query);.

$the_customers_fax= $the_extra['customers_fax'];.

Echo $the_customers_fax;.

Replace to.

$the_extra_query= tep_db_query("select * from "TABLE_CUSTOMERS" where customers_id = '"$the_customers_id"'");.

$the_extra= tep_db_fetch_array($the_extra_query);.

$the_customers_fax= $the_extra['customers_fax'];..

Comment #15

Sweet !.

It works perfectly..

Many many thanks ... I've been pulling my hair out over this (whats left of it that is).

You're a star..

Comment #16

Thanks enjoy your weather in scotland...which is the same as in toronto..

Comment #17

Its a balmy -2 degrees here just now..

Your night-time temperatures look terrifying though .... -13 to -18 ... and without wind-chill..

Comment #18

Hi.

At present the customer detail on order.php is Name, Address Telephone and Email address ... I would like to add/display the data that we capture in the Fax field. (We capture the customers Mobile Number in this field).

I added the following to the page.

<tr>.

<td class="main"><b>Mobile Number:</b></td>.

<td class="main"><?php echo $order->customer['fax']; ?></td>.

</tr>.

However all I get is a blank space where the number I want should be.

Can anyone help me solve what I thought would be a simple amendment.

Many Thanks.

John K.

This post has been edited by.

Pynchon.

: 19 January 2009, 12:47..

Comment #19

I am not quiet sure if I understand you right, but I think it should be something like this.

I found this set of lines in admin/orders.php..

Comment #20


This question was taken from a support group/message board and re-posted here so others can learn from it.

 

Categories: Home | Diet & Weight Management | Vitamins & Supplements | Herbs & Cleansing |

Sexual Health | Medifast Support | Nutrisystem Support | Medifast Questions |

Web Hosting | Web Hosts | Website Hosting | Hosting |

Web Hosting | GoDaddy | Digital Cameras | Best WebHosts |

Web Hosting FAQ | Web Hosts FAQ | Hosting FAQ | Hosting Group |

Hosting Questions | Camera Tips | Best Cameras To Buy | Best Cameras This Year |

Camera Q-A | Digital Cameras Q-A | Camera Forum | Nov 2010 - Cameras |

Oct 2010 - Cameras | Oct 2010 - DSLRs | Oct 2010 - Camera Tips | Sep 2010 - Cameras |

Sep 2010 - DSLRS | Sep 2010 - Camera Tips | Aug 2010 - Cameras | Aug 2010 - DSLR Tips |

Aug 2010 - Camera Tips | July 2010 - Cameras | July 2010 - Nikon Cameras | July 2010 - Canon Cameras |

July 2010 - Pentax Cameras | Medifast Recipes | Medifast Recipes Tips | Medifast Recipes Strategies |

Medifast Recipes Experiences | Medifast Recipes Group | Medifast Recipes Forum | Medifast Support Strategies |

Medifast Support Experiences |

 

(C) Copyright 2010 All rights reserved.