10,940 Topics
 | |
| | Hey guys I am trying to write this application to display members who are celebrating the birthday in a particular week, month. I want the app also to be able to display those who will be celebrating their birthdays in abt 2months. I want to do something like how Facebooks …  |
| | Hi all. I am working on a small credit/debt management tool. I have a table that contains the main record for the debt: id, amount, client info, interest, paid back, etc Then I also have a "history" table where all operations on a debt are stored: when it was first … |
| | I have a rather embarrassing problem. While debugging a web app, I suddenly found I was not retrieving items from the database. I went to the command line to log into MySQL and got back "Error 1040: Too many connections." This was when I realized I'd forgotten to include a … |
| | I need to expand on the first query by counting the number of flights from the citys in my airline database and so far have come up with the second query; The tables in the database are flight, and city. flight columns:number, origincityid,destinationcityid,departure,duration and stops city columns:id and name SELECT … |
| | Hi, I am new to php and have to do a project that consists of a joke page, a jokelist page and the front page or index page. My problem is this: I have used the text below in my .htaccess page and the only thing I get when I … |
| | How to use Select Case in reading rows in a table in mySQL? by not using the username of the user. some codes please? thank you!...  |
| | Hi all, I am using Java Servlets with XML and XSLt, I am getting the values from text area in XSL , the value is using Escape method in Javascript. The code is Like [code] src = frm.txtFeedBackDsc.value; src=rtrim(src,' '); src=ltrim(src,''); dest= escape(src); frm.hsFeedbackDsc.value=dest;[/code] And the Value is stored in … |
| | hi. i want to check expire date with mysql query between start date and enddate. if the end date is bigger then today's date then its good else it didnt display records. can any one please help me out. Thanks in advance. :) |
| | I'm having a hard time understanding where is the problem... I have a class which is responsible connecting to DB and passing queries. (basically Data Access Layer) and it looks like this: [code=php] class DB { private $connection; public function __construct(){ $this->connection = mysql_connect('localhost', 'user', 'pass'); mysql_select_db( 'dbname', $this->connection ); …  |
| | I have this error.. Can help me to solve this matter? You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '296''' at line 1 1 <?php include("db.php"); ?> 11 <?php 12 $Kod=$_REQUEST['kodpro']; 13 echo … |
| | [code] $sql_table_get=mysql_query("select orderline.quantity, menu.item_name, menu.price from orderline, menu, orders where orderline.item_id = menu.item_id and orders.order_id = orderline.order_id and orders.table_num =table".'"$count"'." // problem line and orders.order_status = 0; "); [/code] tried many combo and couldn't make it work yet. basically i just need to know how to combine a $variable and … |
 | hello... i am doing one concept.but i have no idea to do that concept. plz nybody give an idea for that.... actually there is a site which have the registered restaurents on that site at the same another side user registration is there. now user login then automatically display distinct … |
| | Hi, what i'm really trying to find out is how to run 2 queries and get the result of them in a single file. The code goes Below, the problem is that the printed result comes only from the first query the second query result is displayed as 1st query … |
| | I have below out using print_r(); how can i display individual like i want to display [currency] => USD [rate] => 1.3000 how to use foreach Thanks [CODE]$xml = simplexml_load_file("http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml"); echo $xml->getName() . "<br />"; foreach($xml->children() as $child) { echo $child->getName()->currency . ": " . $child . "<br />"; echo … |
| | Hello, I have a database where content (song lyrics) is stored in multiple languages. But now that i'm testing it some characters do not appear correctly. For example, when i'm retrieving information (searching anything), the letter ë appears as � (a special character square - in case it doesn't appear). … |
| | How to read per row in a table in mySQL as the database? i want each username when they login, they will go to their respective forms. Like for example, there are 3 users and each user have their different forms. can someone help me with this... thank you! This … |
| | Basically I have a database and a form set up that enters information into the mysql database using php code. This works perfectly. The problem I'm having is writing a php sequence to send an email that confirms the user wanted to post the information. I would also like the …  |
| | Here's the situation: I have a dictionary database. I use special characters in the pronunciation (like this: 'hÉ™.lÉ™.ba.lu). However, when I use a PHP script to output this data, the special characters get replaced with question marks. Like this: 'h?.l?.ba.lu I've read a lot on this topic, but I'm not … |
 | This is my two tables: [CODE] CREATE TABLE `subject` ( `id` int(11) NOT NULL auto_increment, `subjectName` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `subject` -- INSERT INTO `subject` (`id`, `subjectName`) VALUES (1, 'Maths'), (2, 'Science'), (3, 'English'), (4, 'Chemistry'); … |
| | Hello, I am getting a syntax error in the following code, any suggestions what I need to modify? Thanks "Script line: 7 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line … |
| | am showing a report in a table, after fetching data from mysql. my client wishes to have this html report into an excel file too.. Suggestions required.. Either * button click call another php page and save to a predefined location * create xls file everytime i generate report. plz … |
 | How to store password in MYSQL ? i created the new page, [B]index.html[/B] [CODE]<form action="calc.php" method="POST"> Username: <input type="text" name="username"> Password: <input type="password" name="password"> <input type="submit" name="submit" value="Submit"> </form> [/CODE] and clac.php, [CODE]<?php $username = $_POST['username']; $pass = $_POST['password']; if ($username == "a" && $pass =="abc") /* here i set … |
| | Hi All I am trying to create script which will update the database every 24 hours to reset a row back to 0. My web host cron job panel does not work so that is why i am asking you for help. I will be very grateful for any help. … |
| | consider form . id,username,age,etc if i enter id all other field should get filled automatically. can anyone tell php code . as i dont know asp.net. suggest some sites please |
| | Hi, I have A DB look like this : events(type,event_from,event_to,description,owner,perm,repetition) and repetition(repetitionid,description) repetitionid = repetition and repetition look like that : 0;"None" 1;"Every day" 2;"Every week" 3;"Every month" 4;"Every Year" my question is by giving owner how can i found all hes events ? |
| | Hi there, I have built a simple CMS that is generally working well, the issue I'm having is with building dynamic navigation. On the site the content for the individual pages is fine but getting the menu data and creating the menus is causing problems. I have 2 possible structures … |
| | I added a user to my database ijdb for a project i am doing and have tried repeatedly to delete them with no luck. The user is jess; mysql>GRANT SELECT ON ijdb.* ->TO [email]jess@"%.host.net[/email]" ->IDENTIFIED BY "jessrules"; mysql>GRANT UPDATE (name, email) ON ijdb.author ->TO [email]jess@"%.host.net[/email]"; I have tryed DELETE, and …  |
| | I'm new to using Temporary Tables in PHP/MySQL. I wrote a very simple test script just to see if it would work, but the SELECT query is giving me a [B]mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given[/B] error on the last line, and I'm not sure why. $dbc … |
| | whats the difference between a table created in innodb and one created in myisam?'Advantages/disadvantage of innodb over myisam and which will you recommend on a web based application specifically meant for dating? thanx u all. |
| | Hello, I put together a small tutorial that I wanted to share. I found only scattered information on this and put a more complete tutorial together with code and comments. [URL="http://blog.ajwilhelm.net/archives/7"]Parsing Excel files with Python[/URL] |
The End.