Hi Praba,

Magento is a large system to fully comprehend, I would recommend studying their tutorials, you need to be looking into your theme templates for product display:


Have a look at the fields already displaying there and look into the Class documentation for the specific fields you want.

I have found working with Magento to be quite time consuming (my lack of experience there), especially when looking for fields and changing the default layouts.

You will have to dive in here


Unfortunatelly there is no descriptive texts to help, but you will be able to see the structures.

Looking at your code you will need to fix up your output to represent something like below, you are missing "p" tags. So just add them and you should be fine.

 <li data-source="list=PL5F394CB9AB8A3519" data-playlist-name="MY YOUTUBE PALYLIST" data-thumbnail-path="content/thumbnails/large2.jpg">
        <p class="minimalDarkCategoriesTitle"><span class="minimialDarkBold">Title: </span>My playlist 2</p>
        <p class="minimalDarkCategoriesType"><span class="minimialDarkBold">Type: </span>YOUTUBE</p>
        <p class="minimalDarkCategoriesDescription"><span class="minimialDarkBold">Description: </span>Created by loading a Youtube playlist, videos are loaded and played from Youtube.</p>

Here is the link to the documentation:


I would modify these lines here, you have a couple of options, set a request param on the anchor of TAB 2, or a hidden input to indicate which tab was clicked, you would need some PHP code to set which tab is active, so you need an "active" style for that as well. I would not recommend this method for long term maintenance but for your code snippet this should be fairly simple. I have not tested the code, but you should get the concept

              $tab1Active = "";
              $tab2Active = "";
              if (empty($_REQUEST["whichTab"])) $_REQUEST["whichTab"] = 1;
              if (!empty($_REQUEST["whichTab"]) && $_REQUEST["whichTAB"] == 2) {
                  $tab2Active = 'class="active"';
                else {
                  $tab2Active = 'class="active"';
                <input type="hidden" name="whichTab" id="whichTab" value="{$_REQUEST["whichTab"]}">
                <li><a {$tab1Active} href="#tabs-1" onclick="document.getElementById('whichTab').value = 1;" >Quarter 1</a></li>
                <li><a {$tab2Active} href="#tabs-2" onclick="document.getElementById('whichTab').value = 2;">Quarter 2</a></li>


Generally you do this in your domain registration panel with the company that you registered your domain with.
If your DNS is self hosted, you will have to update the DNS on your own server (I don't think this is you).

Godaddy, MyDomain etc all have panels to update DNS records.

Could you specify where you registered your domain ?

Hi Emma,
The resulting code looks fine, which browser are you using?

I would also caution against relative name paths for your images, you may not get the results you want.

Hi Sergio

Max length for fields will depend purely on what you plan to store in them and whether we are talking about, after creating many different forms over time you get to a feeling for these things. Here are the sizes that I use:

First Name & Last Name - 100chars - Some people have long names!
Password - 100 chars - I store a hash for the password so has to be long
Email - 254 chars - That is the max length for an email
Username - 20 chars,
Telephone numbers - 30 chars - should cover all international area codes & extensions

I may be a bit exessive in the lengths but have found that I hate to redo database design for silly reasons like someone's double barrel first name or last name being way to long.

Hope this helps, good luck with the programming!

This may be late, but it is relevant to anyone loading extra extensions into your PHP, Always check which version of PHP you have first. You will also need to know if you have a thread safe or non-thread safe version. After this you should download the extension you need which matches the exact version of PHP. You may have to install a newer or older version of PHP to match the extension if your build is not supported. Perhaps obvious, make sure you know whether you have a 32bit version or 64bit version.

The default Sent needs to say default 'Sent', easy way to remember is that text stuff needs single quotes in SQL.

Lets just start off with line 11, did you mean to not put an opening bracket on your if statement ?

Hi Malatamil

Please can you provide us with your operating system , it will also help to know if you are running any anti-virus software and Skype, sometimes Skype can mess with the webserver.

The more information you provide the better, also if would also be useful to know if you have installed the database engine before, you may have clashing versions ?


Galaxy S4 is able to pick up 5GHz networks, I have found this situation also where laptops will not pick up a network but my mobile devices will. The thing you need to find out is what mode the wifi is broadcasting on, there are a couple, perhaps this needs to be indicated to your home pc via the wireless settings and then there is the channel. Make sure that the channel is not different on your pc from the broadcasting wireless router. Download a wireless network tool for your adapter and see if you can't discover the network. Another cool trick that I've learnt is that an Ubuntu live CD is great for troubleshooting, most cases it picks up the hardware and configures everything then I am able to see if there is really a hardware issue. Believe it or not, things work in Linux which don't work in Windows (I am assuming of course you are on a Microsoft operating system). If you are on a Mac computer there are some other things you can try. I will wait for your response.

I'm not sure the file input can accomodate that, you should use a label around the input and put the file name in there.

echo "<td><label>{$row["PicURL"]} <input type=\"file\" name=\"usefile\"> </label></td>";

Alternatively display the file as an img tag to show the user what has already been chosen?

Check out the link below, I hope it helps
Click Here

Just test if (isset ($_FILES["userfile"]) ). Only run your code if that is true. You can replace this code with that of line 12.

Just a question, why not filter the results when you do your query with a where statement "select date, ads, visible from table where visible = 1".

Secondly, how are you fetching the data to your PHP ?, most common way to get your results out would be :

$result = $mysqli->query($query)

//start a table here

$icount  = 0;
while ($record = $result->fetch_object()) {
     //make the table row

     if ($record->visible == 1 && $record->ads != 0) {
       echo " $icount {$record->DATE} {$record->ads} {$record->visible} ";   
     //close the table row


//end table here

Hi, are you still interested in an answer to this question ?

The first issue on connecting to a MSSQL database probably pertains to whether you are using and express version or not. The other problem will relate to which PHP drivers you have decided to use, there is a native Microsoft driver and the default PHP driver. I have discovered that it isquite a mission to get the PHP configuration correct.

Below a code snippet for native drivers.

$connectionInfo["UID"] = $username;
$connectionInfo["PWD"] = $password;
$connectionInfo["Database"] = "TESTDB";

$this->dbh = @sqlsrv_connect(  "\SQLEXPRESS", $connectionInfo );

And you can download the drivers here

Click Here

Hi your Count () function may not result in a field name called id which you are trying to order by so you probably need to alias it.select count(id) as id...

Hi, I have already solved this scenario using Cross Database Engine. It has an encode_image function which can make thumbnails and it does a checksum on the image from the database to see whether it should output the file again.
Here is an example:

  //before starting, please have sqlite3, gd and exif extensions enabled otherwise this won't work!

  require_once "cdesimple.php";

   //get the image of a duck
   $imagedata = file_get_contents ("http://upload.wikimedia.org/wikipedia/commons/5/51/Mandarin.duck.arp.jpg");

  //make a table with CDE and store it

  $CDE = new CDESimple ("images.db", "", "", "sqlite3", false, "YYYY-mm-dd");

  $CDE->exec ("create table if not exists tblmyimages (
                 id integer primary key autoincrement,
                 description varchar (200) default '',
                 imagedata blob       

   //make an insert, notice the use of params which sqlite doesn't support natively 

   $sqlinsert = "insert into tblmyimages (description, imagedata) 
                                  values (?          , ?)";  

   $CDE->exec ($sqlinsert, "A Duck", $imagedata);

   //now to display all the ducks - CDE automatically knows how to fetch blobs from the different database engines!!!

   $sql = "select * from tblmyimages";

   //get_row( $sql = "", $rowtype = 0, $fetchblob = true, $calculatedfields = array( ) ) {
   //rowtype can be one of the following
   //define( "CDE_OBJECT", 0 );
   //define( "CDE_ARRAY", 1 );
   //define( "CDE_ASSOC", 2 );

   $myimages = $CDE->get_row ($sql);

   //it may seem strange but CDE makes all fieldnames uppercase and by default returns an object, you can tell it to return an array if you want 

   //make a folder to store the outputtted images
   mkdir ("myimagestore");  

   //variable for outputting things  
   $html = "";   
   foreach ($myimages as ...

And, please don't forget to correct the spelling on "First Name"

I think it is easier than you think, remember you have the gender coming from the database already, your thinking is that the genders are static, my suggestion to solve this is as follows, excuse the code if it does not parse first time, I write it without testing it, it is the principal that is important.

$gender = array ("Male", "Female");

echo "<select name=\"selGender"\>";

foreach ($gender as $gid => $gendervalue) {
  $selected = "";
  if ($_REQUEST["selGender"] == $gendervalue) {
    $selected = "selected";
  echo "<option {$selected} value=\"{$gendervalue}\"> {$gendervalue} </option>";  


echo "</select>";

That should do it for you!

The first thing to determine is will your hosting provider allow you to run services and do you plan to setup the server yourself? The best operating system for running services for PHP is Linux, which you already seem to be running. It does not help I give you a solution and you are unable to implement it.

On testing, use your current code with the table statement suggested by pritaeas, you should be able to get the results you were aiming for. Don't include the auto increment field in your insert statement, it is better to have some primary key in your table because you will find that deleting records or updating them may become impossible if you leave that out!

My five cents are that the general rule of thumb with auto increment fields is that you leave them out of your insert statement, otherwise you are actually saying you want that primary key to be null, which it can't be as per your create statement.

In Firefox web browser one can copy a raw image into the CKEditor. You will have to copy and past the images individually after you have copied the text. Make sure you use the paste from word icon to remove formatting which may "hurt" the content.

I will see what I can do, the scenarios I have done this for are more complicated, I should be able to create a scenario for your situation. Will you be able to implement the phpDaemon service ? Running services in general requires some type of admin on the server.

Hi Jay

I've implemented both native and open source drivers in mssql in Cross Database Engine, you should give it a spin, save you hours of time figuring out what to do. All the connection strings are the same.


I would have a look at your SQL, no need to use the escape tags for your table names, you are missing concatenation also.

$sql = "select * from userinfo where badgenumber = '{$user_ssn}'";
$stmt = sqlsrv_query( $conn, $sql);
$arr = sqlsrv_fetch_array ( $stmt);

//inside the $arr are your values you need 

Cross database engine is simpler to use and you don't need to remember whether the connection param comes first or last.

$sql = "select * from userinfo where badgenumber = '{$user_ssn}'";
$obj = $CDE->get_value (0,  $sql); //object
$arr = $CDE->get_value (0,  $sql, 1); //array

Hope that helps your problem

Hi Muslim_1

I would look into phpDaemon, it should help solve your problem, rather stay away from Cron to do this type of thing.


I have had much success using daemons written with PHP. My thoughts are you could simply send all those messages simultaneously using something like phpDaemon.

Hi Wfray

It may be that your button tag is performing a form post / submit on firefox and not on IE ? It is the only thing I can think of. Try adding onsubmit="return false" inside your form tag to test my theory.

If that's not it then I am out of ideas.

Hi Daniel

My logic would suggest to create a PDF from the document file then apply your current process.

Have a look at this article


And alternatively