7,368 Topics
 | |
| | |
| | Well this is my register form, it all worked fine before but for some reason it isn't inserting anything into the table, all of my other scripts that insert items into a table. A quick reply would be nice :) thank you. Here is the Register Script: [CODE]<?php $title = … |
 | Hi everyone, I am wanting to know if there is such a thing like the mySQL SELECT WHERE but in array's. I have this array: [CODE]<?php $array = array( [1] = array( ['test'] = '1', ['test2'] = '2' ); [2] = array( ['test'] = '4', ['test2'] = '2' ); ); … |
| | Hello to all, before begin i must say that I'm sorry for my bud english and hope that it not be a problem for understanding whit you. I'm looking for a solution to create a simple background server application that running and live over infinite loop cicle, whit have the … |
| | I'm making a SAMP server, with all the info of bans and bought vehicles in a MySQL database to get easy acces to it and to change it easily. But setting it up wast that easy :/ Here is the MySQL info, can some1 please help me here? [CODE=php]-- phpMyAdmin … |
| | Hey there I try to find how many times a person did order and what is the day difference between it (second step): Table is called eshop_flat_sales_order customer_email created_at status a(at)a.com 12.1.10 complete b(at)a.com 14.2.10 cancelled c(at)a.com 16.1.10 complete a(at)a.com 18.1.10 complete c(at)a.com 18.1.10 complete b(at)a.com 20.1.10 complete Now I … |
| | Greetings to the Community, I need some assistance with a MySQL query that is running very slow. I must admit that I am not a MySQL expert and I wrote this query with hints from several postings on Daniweb, so I'm looking for some hints to speed it up. Here's … |
| | I have create in MySQdb a DB with a table named example,in this table i want to save a name, this name is in Greek language.My problem is thw follown when i try to save the name instantly without use textctrl, its ok but when i use textctrl i take … |
| | Hi, I want to only compare with a distinct value in a join across two tables. I am bulding a navigation, based on what gets returned (Based on how many "brand_id" is found in the join.) - I just only need to know if there is ONE brand_id of a … |
| | I'm trying to do an insert into my order_item table, but I'm getting this error. Can someone help with why this is happening. Thank you. My sql code to create the tables is below. [CODE] drop table IF EXISTS order_item, orders, customer, product; CREATE TABLE customer ( id INT(10) NOT … |
| | My final question. I have values which have been serialized into a table forum_polls as are in the following format as shown in the two examples below: [CODE]a:2:{i:0;a:2:{s:6:"answer";s:3:"Yes";s:5:"votes";s:1:"1";}i:1;a:2:{s:6:"answer";s:2:"NO";s:5:"votes";s:1:"2";}}[/CODE] [CODE]a:5:{i:0;a:2:{s:6:"answer";s:2:"CA";s:5:"votes";s:1:"1";}i:1;a:2:{s:6:"answer";s:4:"CIMA";s:5:"votes";s:1:"1";}i:2;a:2:{s:6:"answer";s:4:"ACCA";s:5:"votes";s:1:"0";}i:3;a:2:{s:6:"answer";s:5:"CIPFA";s:5:"votes";s:1:"1";}i:4;a:2:{s:6:"answer";s:24:"MBA(specify in comments)";s:5:"votes";s:1:"1";}}[/CODE] which unsererilized (I cheated and used an online unserializer) give: [CODE]array ( 0 => array ( 'answer' => 'Yes', … |
| | Hi all, I have Text in MySQL utf 8 and an iframe displaying this text, and the page content is utf8. Does anybody know why the iframe caret position doesn't match with MySQL position when there are line breaks, and how to fix it? Regards |
| | Hi all, I have a text file saved as utf8 without BOM. I loaded it into MysQL database. An iframe is loaded with this data from MySQL. I need the caret position in the iframe in order to perform operations in the database. Everytime there's a new line the positions … |
 | hi all, I need to join three tables my tables are ___________ markmaster ___________ stuid subid examcode mark ___________ _____________ subjectmaster _____________ subid subname subtype externalmark internalmark _____________ ___________ exammaster ___________ examcode examname duration description ____________ I need result like stuid,subname,subtype,examname,mark . Could any one guide to write query for … |
| | Hi- Probably pretty simple for experienced mysql-ers, but I'm at a loss... Say I have two tables: Movies & Reviews. Movies has a RecNum field, a Title field & other info Reviews has a MovieNum field (identifying which Movie RecNum it's for), a Rating field (1-5 if rated, 0 if … |
| | Hi All, I'm having difficulty in getting the data that I need from the DB.. and it is probably my lack of understanding in the query that I created... data looks like this in the table called RandPtrack rec_id type group_id open_date close_date orders shares order_date order_num 1 R 96 … |
| | Hi Apologies if this is not the correct forum for this question. I am running xampp. I have 100+ image files in a directory that I wish to rename. The old filename and the new filename are stored in an mysql database I want to write a routine that will … |
| | |
| | Hey, I am trying to create this EVENT via phpmyadmin, but I get a syntax error which I cant see: This is the code for the event: [CODE] DELIMITER | CREATE EVENT delete_cart ON SCHEDULE EVERY 5 MINUTES DO BEGIN DECLARE cartID INTEGER; DECLARE cartProductID INTEGER; DECLARE cartAntal INTEGER; DECLARE … |
| | Hi, How to discard stopwords for some queries? Thank you in advance,  |
| | Hi, i have a problem while preparing to MySQL Developer Exam. Exactly i don't understand the question and the answer :) So Test is here: You work as database adminstrator for company inc. You have written following statement: [CODE]SELECT 'Student Name'||stud_name FROM students WHERE stud_id=50;[/code] Which of the following will … |
| | I have been trying to create a search query. Following is my mysql query: SELECT id, title, SUBSTRING(description, 1, 80) AS description,price,picture,date FROM movie INNER JOIN movieLocation ON movie.id = movieLocation.movieid WHERE TRUE AND movieLocation.Location='NEW YORK'AND MATCH(movie.title, movie.description) AGAINST ('Catch me if you can'); There is an error on this … |
| | Hi All, I am hoping to finish this feature on a shopping cart soon - just one thing im not sure how to create. Basically: 1 hour after a user has put the very first item into the shopping cart - (items are stored in the database) I want to … |
| | This is how my license table look like.. i want to select only row that has atleast one "1". which means i don't want to select any row that has full of zeros.. |
 | Ok, i am so new to PHP and today, i wanted to create a very simple php code that submits username and country name into myqsl. So, I created databse and tables in phpMyAddmin, and i created two php files ( c below ) i.e. form.php & insert.php [B]This is … |
| | Hi there, I am relatively new to PHP and MySQL coding and I am currently using the Joomla CMS. What I am trying to do is get a game name based on a custom field value from my DB like so; [CODE] // fetch the value of field called Game … |
| | hi.. Im new to mysql..i want to know how to generate daily reports for all employees i created 3 tables with fields employee table:emp_id,name job table:job_id,job_name activity table:act_id,emp_name,job_name,date,activity done(assigned values as email,phonecall,visits) Daily Activity Report : (Employee ID, Emp Name,Jobs Name, Activity Done) Eg: 1.| Date | Rajeev | Income … |
| | I have set my table to InnoDB which has parent to child relation table 2(child) has FK Reference to table 1 (parent) PK table 2 has cascade on update and delete I am trying to insert a record in table 2 which PK doesnt exist yet in table 1 my … |
| | Hi I am now running this query [CODE] SELECT p.topic_id, p.topic_id, p.forum_id, p.author_id + @user_id_jump, p.ip_address, p.topic_date, (SELECT username FROM members WHERE member_id = p.author_id) AS post_username, p.title, p.body, CASE WHEN (SELECT post_id FROM forum_attachments WHERE post.id = p.post_id) != 0 THEN 1 ELSE 0 END AS post_attachment, FROM forum_topics … |
 | Hi all, I hav a code that takes my table rows and displays as checkboxes in a registration form, When the form submits user checked values will be saved separated by comma's(,) in one column . In future the user need to edit his details means how to show that … |
The End.