39,316 Topics
 | |
| | Hi, I have a problem in making a query.I have two tables patient and encounter. Patient has one to many relation with the encounter table. The encounter table has a field encounter_date. I want to make a search query in which I enter the date ranges and the query fetches … |
| | Can some one help my butt out that why I only get one check box out of the 4 to show up in my email to myself when a user hits submit? When ever I check box any email I only get the bottom check box to show up in … |
| | Hi, My phpmyadmin is inside the server. I want to connect my database from my remote PC to the database in the server using php. I would greatly appreciate if someone can suggest a way to connect the database remotely in windows platform. Thank you. |
| | Hi all, this is what I've built: A dynamically built form which selects the questions depending on the section of the form it's in. The problem: Each form input is called `answer[]` passing the selected value to an update query $updateSQL = sprintf("UPDATE tblsite SET sitetypeid=%s, pctid=%s, contactname=%s, address=%s, postcode=%s, … |
 | Hi all I have recently watched a tutorial series from PHPACADEMY called the advert rotation script series. I have found a small problem, the problem is that if any of the adverts have expired then the rest will not show. does anyone have any solutions for this issue, that if … |
| | i get erros here: Deprecated: Function ereg() is deprecated in C:\xampp\htdocs\a_upload\zoom.php on line 48 <?php $visitors = 0; $handle = opendir(session_save_path()); while(($file = readdir($handle)) != FALSE) { if($file != "."&&$file !="..") { if(ereg("^sess",$file)) $visitors++; } } echo "there are $visitors online"; ?> here is my full code if you need … |
| | Hi, I want to know how to select data from a database with two drop down menu. I can select a data from mysql database with one drop down menu. But I don't know how to combine two drop down menu to select data from database and show it in … |
| | i am only display 10 images on this page but it takes like 4sec to load. which is alot, i should take like 1 or 2 sec to load. any thoughts? i also tired joining sql <?php include("include/header.php"); //check, if user is loged in or not if(isset($_SESSION['username'])) /*** user is … |
| | Here is a tricky one that im having issues with... I have a page called events.php that has a include to query sql and pull events from the database after todays date and include the artist information from a include file. here is the code. The events page has a …  |
| | <?php mysql_pconnect("localhost","root",""); mysql_select_db("AppDevelopMenu") or die( '1'); $sql1=mysql_query("select Question from questions where QId ='1'"); if(!$sql1) echo '2'; else{ $question=mysql_fetch_assoc($sql1) ; $outputq[]=$question; $sql=mysql_query("select OptionId,OptionContent from options where QId ='1'"); if(!$sql) { echo '3'; } else { while($row=mysql_fetch_assoc($sql)) $outputq[]=$row; print(json_encode($outputq)); } } mysql_close(); ?> i have to modify this code to read json … |
| | so i have a table called image: ->image_id, user_id, img, name and i want to del one row where image_id = 3; $del = mysql_query("DELETE image WHERE image_id = '$image_id_g'"); i want to del whole row not just image_id. iam not sure if this will del whole row  |
 | Hi, I'm a beginner programmer and I'm developing this web app, nothing major; the hardest part was writting to text file (not really hard...) Anyways, my company policy doesn't allow us to install server softwares on computers. So now, I can't run the PHP code I wrote!! **I am wondering … |
| | Hi all. Maybe someone can help me here. I have a pagination document in php to paginate a large mysql table. This pagination document (by Jatinder Singh Thind, www.phpsense.com) "includes_once" another pagination document that has functions to handle the page links. The functions return a link. I'm trying to get … |
| | I have a comparison of 2 variables in a script, and am not getting the desired results, and wondered what the simplest comparison would be to obtain those results... $username='TestName'; $user='testname'; if ($username==$user){ print "This is the result I want." ; }else{ print "This isn't the result I want." ; … |
| | Hello, I am building a blog - just to shapen my skills. Since leaving college I feel like I have been loosing my programming edge. I work in IT and I primarily work on Oracle databases as a developer. Here is what I am building - a blog. I have … |
| | Hi, I'm at a conference that is using a form in a website that I developed, and for some reason the form is not accepting the value of the checkbox when it is selected. It used to work fine, and apparently I did something within the past few days that … |
| | Good evening I'm looking for yet more assistance, and hope someone is able to point me in the right direction. I'm trying to produce a format for our tipping competition, whereby people who fail to complete their entries are shown a) without a result in the profit column, and b) … |
 | Hello Everyone, I am using a Javascript Library called [Turn.js](http://www.turnjs.com/) and basically, I am building an ebook reader, now the problem is that I need to load external pages, these pages have their own animation and css layouts per page, plus the image is made for an iPad so vertically …  |
 | I was creating a database for my sister showing which Goalkeepers have the most clean sheets during the Soccer European Championships. I know that if I want to just display the Goalkeepers in order of amount of clean sheets then my SQL code would read: SELECT * FROM gk ORDER … |
| | 1st - this code here prints random image from database. but i need help print random images but no repeating images. 2nd queestion is that how can i use this code to print image name. too. $Q = "SELECT (SELECT image_short_name FROM user WHERE username = '$user') as `image_short_name`" .",`image_id`,`image`" … |
| | Okay, my head is swimming as I've been trying to figure out what I'm doing wrong here. I am certain it's something stupid and I've tried different ways of putting it all in, but still no luck. Basically, I am trying to make it so I can put in our … |
| | Hi, everybody i have problem in fileuplaod.apache error log display the following error mesg File does not exist: C:/wamp/www/uploads/planbooks/0f3d1d9a2ac7fbaf6ed4b4c266901eb579e2e658.jpg, but i creates folder in uploads/planbooks class PlanbookForm extends BasePlanbookForm { public function configure() { parent::configure(); $this->useFields(array('photo','title_name','country_id','zone_id','place','itinerary','occasion','date','description')); $this->widgetSchema['photo'] = new sfWidgetFormInputFileEditable(array('label' =>'photo','file_src' => '/'.sfConfig::get('sf_web_upload_dir').'/uploads/planbooks/' .$this->getObject()->getPhoto(), 'is_image' => true, 'edit_mode' => !$this->isNew(), … |
| | i want to get image_id. which is store in database long blob. iam send a image id from different page to this page. and i am using _GET to revice the image_id on this page. $image_id = $_GET['img']; but it say Undefined index: img is there a different way to … |
| | echo" //i need this echo; <form class='form' action='zoom.php?img=<?php echo intval($_GET['img']);?>' method='post'> //i dont need echo in here "; i also tired action='zoom.php?img= intval($_GET['img'])' action='zoom.php?img=$_GET['img'])' but no luck it give me syntar error every time |
 | Hello Everyone Iam Exporting All My Data From Mysql To Txt File With This Code <?php $sql2 = mysql_query("SELECT * FROM export INTO OUTFILE '/Zero.txt' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'"); ?> I Need To Edit The Code So It Export The New Data I Insert In MySql … |
| | Hi there guys, I seem to be having a silly issue and I cant figure out why, my code is working fine for uploading and storing the image name in the datebase, but my issue come about when the form gets sumitted with no file selected I do want this … |
| | Hi, Currently I am building a html page that has some fields to search items into database. For the moment I am using 2 files index.html and search.php, in the page index.html I can input the word that I want to search in the database and I send the inputs …  |
 | Hi, I want to know how to search the inputs provided by the user in the form of checkboxes in a mysql database. <form> <input type="checkbox" name="interests" value="Food"> <input type="checkbox" name="interests" value="Movie"> <input type="checkbox" name="interests" value="Music"> <input type="checkbox" name="interests" value="Sports"> <input type="checkbox" name="interests" value="Reading"> </form> I have other input elements … |
 | Hi, when a user login, i want yo use his session username to query a secific database. I am trying to use the code below but it is not working. $username=$_SESSION['username']; can someone help me. |
| | Hi, I have a checkbox in my form and want to see the changes to it in next page but the problem is if I un-check a checkbox then the $_POST variable will not include it in next page so I won't be able to the changes. Any idea for … |
The End.