reygcalantaol

Well, I can suggest [URL="http://www.heidisql.com/"]HeidiSQL[/URL] a fast and robust MySQL front-end software.

Hello nitos, What is really the problem and what you are trying to accomplish? As far as getting the current url is concern this code is correct, this is also correct: $current_url = "http://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]";

Hello UK-1991, I believe to properly structure your table you may change `vendor_v_name` to `v_id` as reference to vendor table, so: `prod_id` int(11) NOT NULL AUTO_INCREMENT, `product_name` varchar(255) NOT NULL, `product_price` int(20) NOT NULL, `prod_details` text NOT NULL, `v_id` int NOT NULL, PRIMARY KEY (`prod_id`) and your query to get …

Hello ribrahim, Kindly enable debugging mode by printing the error on your browser. The copy and paste the error here so that we have a hint to help you.

Hello Vishnu4, Please try: var oneDay = 24*60*60*1000; // hours*minutes*seconds*milliseconds var start_date = new Date(2015,01,20,1,0); //year, month, day, hours, minutes, seconds, milliseconds var end_date = new Date(2015,03,25,2,50); //year, month, day, hours, minutes, seconds, milliseconds var diffDays = Math.round(Math.abs((start_date.getTime() - end_date.getTime())/(oneDay)));

Hello admiralchip, Please try this $result = $wpdb->get_results("SELECT number FROM " . $table_name . " WHERE list_id=" . $list . " AND expiry_date > '".$scheduleddate."'"); The above query puts your date as string.

Hello pelusa, I am not sure what you are trying to accomplish but here is a simple way to redirect url to another using .htaccess Redirect 301 link1 link2 example: Redirect 301 http://www.domain.com/publication/?id=test http://www.domain.com/publication/?id=test&tkn=25MMI7

Hope somebody can help me regarding regular expression. I have a shortcode format "<!--myproductsku-->" in the string, I want to use regular expression to extract myproductsku. And if there is a match replace "<!--myproductsku-->" with "This is my myproductsku.". Rey

Please examine this code below. This is a working example I made on one of my clients. This may not what you need but you may use this code as a reference. <?php $arrDealer = getdealer($_POST['cmDealer'], $db); $filename = 'Lead-'.time().'.xml'; //Send email with attched adf xml $xmlDoc = new DOMDocument("1.0", …

<a href="javascript;" onClick="if(confirm('Are you sure?')) alert('You choose yes!'); else alert('You choose no!')">Click me</a> Try: http://jsfiddle.net/Je8pP/

I believed forum signature gives points to backlinks, specially, when you post to a forum that has the topic related to your targeted keyword.

Hello everyone. I do not know where to post this but I think is it php related topic. Currently I am working on WordPress plugin. The problem I have is that I have a url "http://www.widgetel.com/sales/affiliatecode where affiliatecode is unique for every affiliate member. What I want to acomplish is …

Try to clear your cache and refresh the page.

Hello guyz, I'm glad I finally back here. I need help using the preg_match function. I am scraping url and I need to get the specific value from the html tags. Here is the string [I]<p><b>1,664</b> Referring IP addresses</p>[/I], I need to get [I][B]1,664[/B][/I] How can I achieve it using …

Please review your code, you my have a typo on the second code, or george might have the same cash value with fred.

I am wondering if anyone notice this. When I search my site keywords on google using firefox mozilla it shows my site at nearly high place but when I use google chrome browser it show different result which put my site at low place. Anybody can explain this?

Hello guys, I just wonder if anyone knows if the number of website visits affect your search engine ranking?

Please show some code you work around.

Forum posting with dofollow link signature. :) But I realized it just last year when I buy my own domain.

Please show some code and specify what is the problem, so that we can decide if we can help you.

Your login script is incorrect, try this code: [CODE]<?php //initilaize the mysql user name and password //Database Config $dbHost='localhost'; //Database server $dbName='project'; // Name of the database $dbUser='root'; // Database username $dbPass=''; // Database password $source = mysql_connect($dbHost, $dbUser, $dbPass); if (!$source) { die('Not connected : ' . mysql_error()); } …

Yes, vibhadevit is right. addslashes only accepts string as an argument, so to make it safe, have a condition to check where the string you supplied to addslashes funtion is not null or something that is not a string.

Change this to : if(isset($_POST["submit"]) && $_POST["submit"] == "Legg til medsøker"){

In your code, you are making as many forms are how many records are there in the database, but when you submitted the form, you are doing like "document.forms[0].submit();" which submitted the first form element in the document. You can try this code: <html> <body style="background-color:#E0FFFF;"> <script language="javascript" > <!-- …

Before going to your question, let me ask first. What DBMS you are using and what reporting tool you are using?

I am developing google search application using google search API. I am almost done with it but I have one problem which I am hardly find the solution over the net. My problem is to get the cache date (a date where google last crawled the site). I will be …

Good day everyone, I new this is not to hard but I forgot on how to do it. I have this form: [CODE]<form><table><tr> <td>Add Picture:</td> <td colspan="3"><input name="txtPics" type="file" /></td> <td> <input type="button" name="addFileField" onClick="Add_New_field('fieldName')" /> </td> </tr> <tr> </table></form>[/CODE] My problem is that I want to dynamically add new …

I agree, just close that block and that will be ok.

@jaseem, Are table1 and Table2 has relationship? If there is then you can join them. To make the query easier, you can use data environment to make queries.

Please explain what you are doing and what you want to accomplish. Your post doesn't make explain that well.

This code show how to retrieve rss feed into php array. First: Download-> magpierss from [url]http://magpierss.sourceforge.net/[/url] Second: Copy and paste the following code into php file. [CODE] require_once('magpierss/rss_fetch.inc'); $url = "http://reygcalantaol.com/feed/"; $rss = fetch_rss($url); // $rss = fetch_rss($url); $cnt = count($rss->items); //print_r($rss->items); //To access your array foreach ($rss->items as $key …

PHP is easy to learn as long as you are committed to learn into it.

Do not declare your function inside the loop. That will make your function declared as many as the loop iterate and php don't allow it.

You can make a fucntion and assign your result set into an array for further used. [CODE] function getResult() $query = "SELECT name, desc, city FROM table"; $result = mysql_query($query) or die('Could not find info'); while($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $result['name'] = $row['name']; $result['desc'] = $row['desc']; $result['city'] = $row['city']; } return …

Having a good and neat coding structure makes your code very useful.

You can view the source code and look for the CSS used and see also the html code. You will definitely come up with what you want. To view the source you can "[I]right click[/I]" this page and choose view source code.

Why looking for the ready made project. Why not plan for a project that is in need now a day and hired a team to materialize it. I am also a web developer with expertise in PHP and ASP. I can be one in a team. :)

"SELECT Field_Name FROM Table_Name WHERE substr(Field_Name,1,4) LIKE 'A%'" where; Field_Name is the name of fields to return Table_Name is the name of your table substr(Field_Name,1,4) only evaluates the first four characters

Insert into table_name (boolean_field) values (true); where table_name is the name of your table boolean_field is the name of the field with boolean type true/false are the possible values to be inserted in boolean type field.

Be sure that in the project properties the main() procedure was set in the startup object so that the connection object opens first before the other forms.

Are you using datareport and data environment in as your reporting tool? If so then, you can filter your query result by just selecting the last record. How? for example you have an autoincrement field (id) in your table then the last record would be the record with largest (id). …

Both of you are correct with your thoughts.

If your are using dataenvironment, you can re-open the source recordset with the new sql query. Note: close the recordset after the datareport.show command.

You may also use parameterize query to prevent SQL injection.

One other solution for that is to create a frame with invisible property, put a textbox on it with assign password characater, and when a user click a button just change the frame property to visible. Here is the example: [URL="http://reygcalantaol.com/projects/fake inputbox.zip"]http://reygcalantaol.com/projects/fake inputbox.zip[/URL]

Are you using blog framework e.g. wordpress?

Group the result by adding GROUP BY clause after the WHERE clause. [QUOTE]SELECT DISTINCT id.[Title],id.[Description],id.[LastModified], c1.[Cat1], c2.[Cat2] FROM IndexData id, Category c1, Subcat c2 WHERE c1.[FileID]=id.[FileID] AND c2.[FileID]=id.[FileID] AND c1.[Cat1] = '" & strcat1& "' AND id.[Title] LIKE '%" & strtxt &"%' GROUP BY id.Title,id.description,id.lastmodified,c1.cat1.c2.cat3"[/QUOTE]

(1) Input each product with unique product_code for each size. Like for example: T-001 for Large Shirt, T-002 for Medium Shirt, in that way you can easily keep track your inventory. (2) It is good idea if you will make three tables (a) items/products (b) bills (c) Item_bill , where …

To compare dates on SQL statement date should be enclose with # sign.

MySQL is the best option if you do not want to spend money.