11,093 Topics
 | |
| | Hello, I have this code till now: [CODE]<?php include '../include/db_viewer.php'; ?> <?php $c=$_GET["c"]; $sql="SELECT * FROM regulations AS b LEFT JOIN global AS ab ON b.id=ab.id WHERE checked = '".$c."' "; $result = mysql_query($sql); echo "<table class='maxWidth' cellspacing='0'> <tr><td> <table cellspacing='0' class='advanced'> <tr > <td>Broker</td> </tr>"; while($row = mysql_fetch_array($result)) { … |
| | i have 3 tables student table roll no name sub table roll no subid subname markstable roll no subid marks 1)select name,subname,marks whose having marks less than 40 2)select sub name,marks whose having avg above 60% 3)select rank of each student can any one tell me the query for that |
| | |
| | I am storing the images in a folder on my webserver and adding the location/details of the image to the database. But I have problems retrieving them, please help! Is this the code I should be using? [code=php]<?php echo "<img src='/images/". $filename ."'>" ?>[/code] then $filename is supposed to be … |
| | Is there any way to search with a variable that is an array. ie) [code=php] mysql_query("Select * FROM table_name WHERE `id` = '$var'"); [/code] where $var is an array. Is this possible? |
| | Hello! I have this funtion to delete a record from a MySQL table: [CODE]def delUser(): #Delete user #Ask for user to delete Username = raw_input('Which user would you like to delete? ') #Delete user delUser = '''DELETE FROM Users WHERE Username = %s''' cursor.execute(delUser,(Username)) db.commit()[/CODE] The problem is that it … |
| | Hey all. First post ;) and since i've used this site a lot for help i think its about time i registered and joined up. Im not new to programming but i am new with php + database manipulation. [CODE] $app = mysql_query("SELECT * FROM applicant_classinfo WHERE appid='".$_GET['id']."' AND '".$_GET['cname']."'"); … |
| | Hi, I am Installing XAMPP in Windows XP but when I start my computer it gives the dialog box with "mysqld.exe not found" and when i start the localhost/phpmyadmin the following errpr is occured "#2003 - The server is not responding " pls some one give me some solution of … |
| | Hello Does anyone know how to effectively search for a string in a Mysql table? Here's the problem: Let's say I have a table(id,song) and I want to search for a specific song (ex: One Love) Using the following query returns the exact song when the user enters it exactly … |
| | Hello everybody, firstly I am new in PHP, and I use the WAMP5 tools which has the following features: i) Apache 2.2.4 (SERVER) ii) PHP 5.2.3 + PECL iii) SQLitemanager iv) MySQL 5.0.41 v) Phpmyadmin I have a table named 'tblStudent' with four fields as follow properties: 1. stID int … |
| | 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. … |
| | |
| | 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] |
| | Hi All. I am currently designing a photo sharing website. I need to make a script that deletes the image from the folder it is stored in and also from the database. I have done the database bit but i cannot work out the deleting from the folder bit. Any … |
| | [CODE]<?PHP $results = mysql_query("SELECT * FROM messages, comments WHERE messages.user_on='$user2' AND comments.msg_id_fk = messages.msg_id ORDER BY messages.msg_id, comments.com_id DESC") or die(mysql_error()); ?>[/CODE]  |
| | I have data.sql file and there is 151262 insert statement in SQL file. but while i try to IMPORT it in MYSQL database this give me following error. Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampp\phpmyadmin\libraries\import\sql.php on line 111 Pls give some solution for this Problem. -keval |
| | All, I've recently installed Apache version 2.2, MySql version 5.1, and PHP version 5.2.13 and am using Windows as my OS. I've gotten PHP to work on the Apache server, and MySql is working properly on its own. However, when I try to connect to a mysql database, I get … |
| | Hi everyone I am making a system where i have to refresh the database after updating it. I am using a JTable and a mysql database, but i have to close down the application so that the updates can be implemented.Is there a way of refreshing the connection session, or … |
| | Hi everyone. Could someone assist me with a problem I have. I want to display images in a folder.(image/). I have my MySQL table with my images location.(images/test.jpg) etc. I also have a legend_id where I specified id's (id_1, id_2, id_3) This is linked to cars. If I search according … |
| | basically i have a table which has different branch names recorded in the same column as other data. I cannot change how the data comes in so i have to find a way of extracting and matching data from this column. eg +---------+---------------------+------+------------+--------+ | Company | Branch | Tml | … |
| | [CODE]#include <iostream> #include <string> using namespace std; class w { public: void InsertRow(String* myConnection) { // If the connection string is null, use a default. if (myConnection->Equals(S"")) { myConnection = S"DRIVER= {SQL Server};SERVER=MyServer;Trusted_connection=yes;DATABASE=idb;"; } OdbcConnection* myConn = new OdbcConnection(myConnection); String* myInsertQuery = S"INSERT INTO test (id)"; OdbcCommand* myOdbcCommand = new … |
| | Hello, I have two tables product table and accessory table. also i have a order table. order table have either product id or an accessory id. those are two nullable fields. now i want to choose from product or from accessory table, either product name or accessory name. can i … |
| | Hi I have a html page with a div and i'm loading data into it every 10 seconds (using jQuery load().) from a php page which is querying a mysql db. This is great but what i want to do is if a value in the table i'm loading into … |
The End.