10,946 Topics
 | |
| | 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] |
| | 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 … |
| | hi,im really new to MySQL,can some one help me in joining table pls...i hv 2 tables,customer table and record table customer table with CustomerID,Customer Name,CustomerAddress, record table with RecordID,CustomerID,Date, how to make the CustomerID in record as foreign key? how to join that two tables so that record will be … |
| | hi, i'm really new to programming in general, and i think i've figured out how to insert and select data from mysql databases, however, i can't seem to get values from a table and work on it here, i'm trying to 1) grab a number from my table 2) generate … |
| | I have a database with some tables from a restaurant and users can see if they are [I]free[/I] of [I]reserved[/I]. If [I]free[/I] they cand book that table. Now, my question is this: What can i do so that after (let's say 1 day (or any amount of time) after the … |
| | Hi all, I'm going crazy... I need make this simple function: I need to have 2 inputs checkboxes Bank wire and visa. How can i update them? Here is my VISA table (the bank_wire is almost equel to visa table) [CODE]CREATE TABLE IF NOT EXISTS `visa` ( `id` smallint(6) NOT … |
| | Hi, i was wondering how if it is possible to enter a large amount of information into mysql database easily. I have about 15,000 rows that i have to enter and i would like to know if there is a way anyone knows to enter it fast rather than entering … |
| | Hello, So here is the story: I'm trying to select from two diferend tables ( bank_wire and visa) [CODE]CREATE TABLE IF NOT EXISTS `bank_wire` ( `id` smallint(6) NOT NULL AUTO_INCREMENT, `method_name` char(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Bank wire', `checked` smallint(1) unsigned NOT NULL DEFAULT '1', `commision` char(255) COLLATE utf8_unicode_ci … |
| | Hey guys, Please tell me how to load data from an excel file to a mysql database using jsp. |
| | guys can i call this a database and how to use it this is the file mysql.php [CODE]<?php if(!defined("SQL_LAYER")) { define("SQL_LAYER","mysql"); class sql_db { var $db_connect_id; var $query_result; var $row = array(); var $rowset = array(); var $num_queries = 0; // // Constructor // function sql_db($sqlserver, $sqluser, $sqlpassword, $database, $persistency … |
| | Hi Everyone. I have MySQL db with images in(MEDIUMBLOB); I would to display the images in a gallery fashion with a MySQL select command. Any help would be appreciated. Regards |
| | It sais Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given on line74 and I tried a lot of things. here is code [$query="SELECT * FROM specificati,ofertant,suprafete,preturi,manopera WHERE ofertant.id_ofertant=preturi.id_ofertant AND preturi.id_manopera='Montaj parchet' AND preturi.id_manopera=manopera.id_manopera AND specificati.id_camera=suprafete.id_camera "; if (isset($query) && !empty($query)) { echo"<!--" . $query . "-->"; $result=mysql_query($query) or … |
| | Hello everybody, I have a problem with my mysql-server, at least, I think... This is the problem : I use aptana as my editor, in which I have installed QuantumDB as plugin. This allows me to quickly update or delete or insert data in my MySQL-database without having to leave …  |
| | Is it possible to edit the contents of fields after a select statemen? For example, I have a table Person (Id int, Username varchar(50)). Most of the rows in Username has the format of, say for example, aaa_01, bbb_02. I want to select this usernames with the underscores and the … |
| | Hi There Everyone. Could anyone assist me in the correct method of displaying images from my mysql db. I want to display multiple images on my page. This is the code I have. I got this from a post from DaniWeb. Hope I did the code tags correctly. [code=php] <?php … |
| | Hello, I am new to php code (month or so) and mysql, I am pretty much teaching myself, I am good with HTML, CSS, JS, etc... I am trying to create a DB for a client that is fairly simple; Add members (got that done); Verify member and post data … |
The End.