7,368 Topics
| |
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). … | |
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 … | |
| 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 … | |
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 | |
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 | … | |
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,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 … | |
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 … | |
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 … | |
I am trying to join two tables and havent been very successful, can anyone please help! The two tables are joke and author; I need to get the authors name and email address in the joke table! The database is ijdb; mysql> USE ijdb; Database changed mysql> SELECT LEFT(joketext, 20), … | |
Hi again! I have a db table named "users" . Within that table, a column named "havechildren". When a client registers on my site, they will choose whether they have children or not by a simple yes or no drop down. That information is stored in my table in the … | |
There are 2 questions that I have. After banging my head with mysql server for more than 4 hours, I've given up. The mysql server will start mysql service on windows 7, but will not start another service. (Is this somehow related to admin rights of 7. I am an … | |
Hi all, I have a cities table in MySQL with 3 rows in it. Table 'cities' row 1 'city' row 2 'statename' row 3 'stateabbreviation' With 52,593 cities in the DB. I would like to create an auto search form so that while typing a city in it will show … |
The End.