39,316 Topics
 | |
| | I would like to query regulation which it's date reminder is >= today and it's date ended is >=today. So I came with this query: [code] $query="select * from t_regulation where dt_reminder >= '$today' and dt_ended ='$today'" [/code] It works on postgerSQL but not on mysql :( I dont why … |
| | Hi, I am looking for some pointers on how to password protect a part of my website. I need that password to change every 24 hours and to be sent to several e-mail addresses. Can this be done with PHP? Any help is appreciated! |
| | Ok I am making a website and I have apache 2, php, mysql. I want users to be able to create a website(i got that part, it is easy) but I want user.example.com to redirect to example.com/user with a .htaccess file and sorry this is in the wrong section can … |
| | Hello, I'm getting an error [B]"Column count doesn't match value count at row 1"[/B] [CODE] <? include("db.php"); $ClientsName=$_POST['client']; $PrgNo=$_POST['prgno']; $PrgName=$_POST['prgname']; $TrainerName=$_POST['trainer']; $Dates=$_POST['dates']; $Days=$_POST['days']; $ProfFee=$_POST['fee']; $TrainerFee=$_POST['trainerfee']; $ReimbExp=$_POST['rexp']; $HandoutChg=$_POST['handchg']; $InvoiceNo=$_POST['invno']; $TotalInvAmt=$_POST['invamt']; $FeeRecd=$_POST['feerec']; mysql_connect($host,$username,$password); @mysql_select_db($database) or die("Unable to connect to db"); $query = "INSERT INTO tcg VALUES('$ClientsName','$PrgNo','$PrgName','$TrainerName','$Dates','$Days','$ProfFee','$TrainerFee','$ReimbExp','$HandoutChg','$InvoiceNo','$TotalInvAmt','$FeeRecd')"; mysql_query($query) or die(mysql_error()); mysql_close(); echo "Data …  |
| | I am building a side by php. I want to put username and password in my side. How will I be write the codes for that? Can you help me, Please.  |
| | Hello, I was wondering if it would be possible for someone to point me in the rgth direction of how to read emails using PHP? What I am wanting to do is have people send me an email. In the email will be an image and some text. I want … |
| | Is someone who can help me; I'm trying to get an image from a folder and show it: Here is my code, logos is the directory; the problem is that I'm getting only the name of the image! $handle=opendir('../logos/'); while (false!==($file = readdir($handle))) { if ($file != "." && $file … |
 | Do arrays not store inverted commas and apostrophes? This seems to be the case with a project I'm working on and it's very annoying. I'm pulling small strings from a DB, some of which contain inverted commas or apostrophes, and when I try echo them the ones with the apostrophes … |
| | Hey Guys, I need a little help. I have a calendar script that I want to write a query for and pull out the day of the week, then have it send an email showing all the entries for that day. Unfortunately i'm querying a day, month, year as seperate … |
| | Hi, Let's say i have a very busy web site and runing this code. Would it produce results of someone else's selection rather than my selection($name)? For example: my code send "john" to function return results. What happens if x person sends "Dean" at same time as mine. Do i … |
| | I'm transferring my css gallery site to a wordpress platform, and it has gone fine. Except I'm having difficulty with showing 12 posts on the index.php page - it shows 10 posts and leaves the two spaces at the bottom empty. Is there a way to configure how many posts … |
| | [code=php] if(!$sqlStr==$sqlStr1){ echo $sqlStr; }else{ echo $sqlStr; echo "<br>"; echo $sqlStr1; echo "<br>"; echo "No changes were made!<br>"; } [/code] This statement produces the same results whether or not the "!" statement is included. e.g. [icode]if(!$sqlStr==$sqlStr1)[/icode] produces the same results as [icode]if($sqlStr==$sqlStr1)[/icode] Why? |
| | Hi frnds... here what i am doing is, i need to develope website like stock market news..so, here i have a software for converting mysql to excel formate..i want to update automatically every 10 secs... where can i install my software.and how can i connect to my website....tell me something … |
| | This is the sample table : [CODE] CREATE TABLE contacts ( id character varying NOT NULL, CONSTRAINT pkey_id PRIMARY KEY (id) ) [/CODE] I use PHP with PostgreSQL database..if i will run my PHP code: Example: ADD ID NUMBER <-- If i will click this, the message below will appear: … |
| | Hi, I wish to do PHP Cerification.I dont have any idea.How to do PHP certification?What are the procedures to do?Is there any PHP Certification Material.........Please tell me with regards, santhanalakshmi. |
 | :icon_cry: Help pls! The following code is meant to upload images to a folder on a my server, but it does not work, Could any one pls helpme solve this problem :icon_cry: Heres the code ==================================== [code=php]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta … |
| | Hi Im hoping some fresh eyes will show me the issue here, been stuck on this for a while now... [code] $c = 0; for($i = 86400; $i < 604900; $i + 86400) { $start = $mktime - $i; $end = $mktime - ($c * 86400); echo $start . '<br … |
| | hi frnds.. i dont any thing abt excel formate... i need to do excel sheet update.. eg: i entered some text in textbox.then submit the form, then excel sheet should be update... also plz tell me how to do excel sheet first time uploading... i am good on mysql and … |
 | I was wondering if it was possible to upload say a picture file and a text file and in the script put them into a zip file programatically. if this is possible could you offer some tips or links please? regards! Thank you it looks like ill be reading for … |
| | Hello guys.. i need your help to convert this sql statement to php array.. [code] $string = "SELECT TOP 15 e.id, e.title, e.timestamp FROM serendipity_entries AS e LEFT JOIN serendipity_authors a ON e.authorid = a.authorid LEFT JOIN serendipity_entrycat ec ON e.id = ec.entryid LEFT JOIN serendipity_access AS acl_acc ON ( … |
| | If this is my code how would I loop to the next dog of the current owner after the dog has been fed 3 times. [CODE]Foreach ($owners as $owner) { For($x=1;$x<=$NumOfDogs;$x++) { $dog = $dogs[$x]; shuffle($dogFoods); Foreach ($dogFoods as $dogFood) { For($y=1;$y<3;$y++) { Feed($dog, $dogFood); } } } }[/CODE]  |
 | i made a script to create a directory and file within the directory for someone who is registering at my site also knows as [url]www.socialemo.com/theirusername/index.php[/url] but im stuck on the index.php file I DONT KNOW HOW TO WRITE HTML AND PHP TO THE FILE how am i supposed to write … |
| | Hi, I want to add 1 hour with current time,i done this using following method date('h:i:s',strtotime('+10 minutes') but i want to take the current time in a variable and add that time with 1 hour,but that value could not change as the time changes. help me out to solve this … |
| | Hi, I want to create a form that a user can fill in his information and send the form to his friends via email. Anybody have ideas or examples they know of. |
| | What's wrong with this code that it updates the collection name but not the description? [code=php]<?php require_once('../Connections/CSadmin.php'); ?> <?php // Load the common classes require_once('../includes/common/KT_common.php'); // Load the tNG classes require_once('../includes/tng/tNG.inc.php'); // Make a transaction dispatcher instance $tNGs = new tNG_dispatcher("../"); // Make unified connection variable $conn_CSadmin = new KT_connection($CSadmin, … |
| | I use phpDesigner but I have no idea how i could use debugger when there's a (submit)button in the code and would like to test what happens when the button is clicked. In this example, the debugger stops when it steps on the "Register" button. How should i set it … |
| | hello all, i need help with php/mysql syntax that will search a mysql dbase using 3 user-provided (from web form) options. All options are contained in drop-down menus. the mysql database has an auto column which is the primary key allowing for duplicate entries which are neccesary the table has … |
| | Thank you for taking the time to read this. I already have code to download as *.csv/*.xls file from my MySQL database (in place) I need to add a "flag" into the DB as for when the last download was made, and then upon next download, only $fetch_newRecords and reset … |
| | |
 | Hello all... Can i write all my site pages such as index.htm, support.htm,contact.htm .. etc to [url]www.mysite.com[/url] with URL Rewriting.. Please help on this.. Thanks in Advance.. |
The End.