pritaeas

I think it's good to start with pen/paper. When starting a new application I always do this, so I can collect my thoughts on how to handle things. Sometimes it's a flow diagram, sometimes data, often just random thoughts. If it turns out to be useless, I cross it out, …

In my case I get my assignments from my supervisor. It's either a change in an existing program, or e.g. creating a new interface from scratch. In the first instance, you can change a lot of small things in a day. The latter will require more in depth study and …

It's all here: [url]http://nl2.php.net/mysql_fetch_assoc[/url] [code] $sql = "SELECT DISTINCT year(date) AS 'year' FROM news "; $result = mysql_query($sql); while ($row = mysql_fetch_assoc($result)) { echo '<p>' . $row['year'] . '</p>'; } [/code]

From the mysql help: DATEDIFF() returns expr1 – expr2 expressed as [b]a value in days[/b] from one date to the other. expr1 and expr2 are date or date-and-time expressions. Only the date parts of the values are used in the calculation.

Is the SQL db the same, e.g. both mysql ? Can you use the same user, with the same password ? Is the PHP version the same, as of version 5, mysql extension is not automatically activated. Are you using other specific extension that are not yet installed ?

[code] (\[[0-9]{4}\] name [0-9];)$ [/code]

[url]http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html[/url] This may be a good start.

You could use double, but that may give rounding troubles. Instead you could use two bigints. One for the amount without decimal sign, and one to use as divider (1, 10, 100 ...).

Yes. You can do this with a .htaccess Unfortunately, I do not have the example with me, but I'm sure somebody here will also know.

[url]http://www.gnu.org/copyleft/gpl.html[/url]

In the OnClick event there's Sender. That refers to the clicked button, so you can use [code] TButton(Self).Color := clYellow; [/code]

Best start here: [url]http://www.smarty.net/[/url]

This is quite a server. If you haven't built any ftp server yet, I'd recommend starting with the basic functionality, instead of trying to create such an enterprise level application. What language did you have in mind ?

Your $file variable will not be parsed inside single quotes. Either remove the single quotes, or replace them with double quotes. Wrong: $_FILES['$file']['name'] Correct: $_FILES["$file"]['name'] Correct: $_FILES[$file]['name']

If you can't change the limit, change the table or split the data.

Personally, I love the Jargon File's description best: [url]http://www.catb.org/jargon/html/introduction.html[/url]

[url]http://www.automatedqa.com/[/url]

Should you have use the mysql type DATETIME or TIMESTAMP instead of the ones you are using now, then you could have easily used these functions: [url]http://dev.mysql.com/doc/refman/6.0/en/date-and-time-functions.html[/url] More on the datatypes: [url]http://dev.mysql.com/doc/refman/5.0/en/datetime.html[/url]

Your first define seems to be incorrect. [code] define('TEXT_MAIN', 'WELCOME TO M M TECH. <b>Our aim to provide cheap products at the best prices.</b>.' . ' <br><br><table border="0" width="100%" cellspacing="5" cellpadding="2"><tr><td class="main" valign="top">' . tep_image(DIR_WS_IMAGES . 'default/1.gif') . '</td><td class="main" valign="top"><b>About MMtech.com.au</b><br><br>We are an australian based company.' . 'Our office …

Is your smtp.va.com server a different server ? If so, are you sure it supports open relay smtp. Normally you would need to authenticate to able to send email. If it is the same server try localhost instead.

You can use mysqli or pdo, both are documented on php.net. If you have PEAR installed you can use MDB or MDB2. More info on pear.php.net

Can you give an example ? That may clarify what you want to achieve.

See: Example #4 Sending HTML email Here: [url]http://nl2.php.net/function.mail[/url]

It is possible that no from address is set. That may be the cause of the server rejecting your message. You can check the message details for any headers.

AFAIK there is no ISO table for nationalities.

You can also use the mcrypt extension, but I'm not sure whether it supports your requested method of encryption.

[code] $link = "<a href='reset-password.php?ui={$row['user_id']}&ak=$upassword'>Reset the Password </a>"; $update_password = mysql_query("update tbl_auth_user set user_password ='$upassword' where user_id = '{$row['user_id']}'") or die("Password reset failed"); [/code]

This should be your code. [code] $result = mysql_query($sql); if ( $result ) { echo "Contact successfully added."; } else { echo mysql_error(); } [/code] If this does not work, their may be something wrong in your sql statement.

type: php defensive programming in Google and look for the two links from php-classes.org. They'll show you some things about how to address these problems.

[code] SELECT * FROM products WHERE product_id NOT IN (SELECT DISTINCT product_id FROM junction_table) [/code]

On line 341 : [code] <?php echo ?> [/code] This statement is incomplete. Remove it, or put something after the echo.

Do you want a single query where the values in your array are in the where ? Like this: [code] $values = implode(",", $your_array); $query = "SELECT * FROM table WHERE column IN ($values)" [/code]

You want data replication from mySql to Oracle ?

[url]http://nl3.php.net/manual/en/function.mysql-connect.php[/url] [url]http://nl3.php.net/manual/en/mysqli-stmt.execute.php[/url] [url]http://nl3.php.net/manual/en/pdo.connections.php[/url] And if PEAR is installed you could use the MDB2 package as well.

Hi. I don't think a switch statement will make your code better or easier to read. In my (humble) opoinion you're better off creating a lookup table containing: plant, modelyearfrom, modelyearto, description.

5.2.5 is not specifically mentioned. Search within the 5.1 manual. Are you looking for something in particular ?

when loading a page, the $_POST fields may be empty, so the code is not executed. Do you use: [code] if (! session_id()) session_start(); [/code] at the top of every page ? Or something else perhaps ?

Do you mean you want to turn your PC into a server ? Then check out Wampserver or Xampp. This will install the necessary tools on your machine.

Check out the new browser Kirix Strata. It is designed to gather and store information from the internet. It's quite useful. ([url]http://www.kirix.com/[/url]) You could write a bot, but I think you can better put your energy in adjusting the scripts and let the browser do the work for you.

In case you don't read all comments on that page, you need to have the GD extension installed.

You need to ask this question in a javascript group, they'll know.

You can add it to the file. Then you can use ini_get() to retrieve the value. Changing it is normally not possible, because it would require write access to your php.ini file. This comes with a lot of security issues. What exactly are you trying to accomplish, maybe there is …

Check out the documentation of your php.ini file. There you can enter the mail host, user, pass etc. which mail() should use. It should be possible e.g. to connect to gmail or another smtp host.

Do you have to design your own templating system ? Otherwise, have a look at Smarty. It will cover all your templating needs. If you need to create your own, then you would have to define a begin and end marker in your template, and program the parser to copy …

You can specify parent='_top' with a link, that will open the page, replacing the current frames.

I'd go to Playa Bonita near Santa Lucia, Cuba with three friends, playing cards, drinking rum and smoking cigars.

You could load a different page within a frame or iframe.

Sorry, Not possible. The monitor is output only, it's not a bidirectional system.

Maybe you can output a javascript function that can redirect, and put the call in html when necessary.

my guess is that the dataSet function should contain: $db_link = mysql_connect($host, $user, $pass); It looks incomplete.