11,093 Topics
 | |
| | Suppose fields: id, uname, ufullname, upass, uemail I would like to add an option for users to update there profile. Users will update profile which make changes without reloading page. Every field will show once user clicked on Update profile. My needs little different than others tutorials i have searched … |
| | 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 … |
| | On days when my site gets a lot of traffic, I get this error message... Warning: mysql_connect() [function.mysql-connect]: User OH_admin already has more than 'max_user_connections' active connections in D:\Inetpub\vhosts\ourhometown.ca\httpdocs\includes\all.oh.front.inc.php on line 3 User OH_admin already has more than 'max_user_connections' active connections Can someone point me in the direction in how …  |
| | 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 this error appearing Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /websites/123reg/LinuxPackage21/th/er/ag/theragereport.co.uk/public_html/feed/feed_view.php on line 148 from this code [CODE]$sql3="SELECT view FROM $tbl_name2 WHERE id='40'"; $result3=mysql_query($sql3); $rows=mysql_fetch_array($sql3); $view=$rows['view']; // if have no counter value set counter = 1 if(empty($view)){ $view=1; $sql4="INSERT INTO $tbl_name(view) VALUES('$view') WHERE … |
| | 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 really dunno wats wrong here. the firts query works but the second does not . please help... There a these connected files: save.php [CODE]<?php include_once("classes/jewelry/item.class.php"); $inum = $_POST['ItemNo']; $i=new item(); $i->ItemNo = $inum; $i->ItemName= $_POST['ItemName']; $i->CapitalPrice=$_POST['CapitalPrice']; $i->SalePrice=$_POST['SalePrice']; $i->Category=$_POST['Category']; $i->Description=$_POST['Description']; $i->save(); include_once("classes/jewelry/stock.class.php"); $j=new stock(); $j->ItemNo = $inum; $j->NumStored= $_POST['Nload']; $j->NumSold= …  |
| | 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', … |
| | I have an options table setup like so: [CODE]option_id option_name option_value 1 sitetitle SimpleCollab 2 siteurl http://example.com/ 3 sitepath /home/user/MAMP/htdocs/pm 4 enable_registration 1 5 enable_query 1[/CODE] Then my php code is as follows: [CODE]function get_pm_option( $option ) { global $pmdb; $result = $pmdb->query( "SELECT * FROM " . DB . … |
| | 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 everybody! :) I have 4 tables in my mysql database as user car_description techniqual_description saled_serial_numbers In user table user_name is the primary key. In car_description there is car_id as primary key and serial_number as foreign key which is primary key in table saled_serial number and user_name as foreign key … |
| | 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 … |
| | I'm trying to create a delete button that lets a user "delete" an entry from mysql database. I have a demo.php page, where my php connects to my database and inserts data into it. And I have a demo-form.php which is to display the form and when "submit" button is …  |
| | I am just beginning to get the idea on how to put together the above four source codes to produce, in this case, a Contact Database/Display program. On a 0-10 learning scale I feel like a 3. My current problem is: ContactRevise3.html calls revise.php with the following script: [CODE] <script … |
| | Hello, about 3 months ago I made simple chat using MySQL++ which is working fine, login function: [url]http://pastebin.com/Mdup4zi6[/url] but today I'm creating Control Panel, I've copied and changed this function a little bit, but i'm getting 0 results (if I copy syntax to navicat I'll get password so...) login function: … |
| | I cant configure the site in ubuntu where my application will be runing ,and I find it difficult to know where to find MySQL sever.Can any one help me out?  |
| | 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 … |
| | In php group by then min group row show fist, please help, |
| | 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 … |
| | m geting an unexpected error in my code plz tel me where am i wrng my code because i have wriiten mysql_num_rows many time [CODE]<?php session_start(); print_r($_POST); $con=mysql_connect("localhost","root",""); mysql_select_db("pras2",$con); $slip_no=$_POST['slip_id']; $query="SELECT * FROM `slip` WHERE slip_id='$slip_no'"; $result=mysql_query($query); if ($result) { $query1= "UPDATE `slip` SET status='accepted' WHERE slip_id='$slip_no'"; $result1= mysql_query($query1); if($result1) … |
| | 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.. |
| | Hi all, Having problems with null dates in a mysql table. Have eventually found out that I can store a 'null' date in mysql as "0000-00-00" and I can run the 'insert' command to add a record to the mysql table. When I check on mysql workbench I can see … |
| | So i've come over a problem, i need to use something similar like this [CODE] set @num = 0; select * from ( select * , @num := @num + 1 as row_number from my_users as info order by Score desc ) as ii [/CODE] any ideas how i can … |
 | 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 … |
| | I have this code [CODE] sqlcon.Close() sqlcon.Open() cmd.CommandText = "SELECT item_category FROM tbl_item_code where item_category = '" & lbl_category.Text & "'" cmd.Connection = sqlcon dr = cmd.ExecuteReader dr.Read() If dr.HasRows() Then sqlcon.Close() sqlcon.Open() Dim cmd2 As New MySqlCommand Dim dr2 As MySqlDataReader cmd2.CommandText = "SELECT * FROM tbl_item_code WHERE item_code='" … |
| | 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 … |
| | I have this code which saves the dump file in a static path or destination [CODE] Process.Start("C:\xampp\mysql\bin\mysqldump.exe", "-u root ipoint -r C:\Backup\ipoint.sql") MsgBox("Backup Database Created")[/CODE] I want to choose the path by using the folder browser dialog which will put the path on a textbox but this code below doesn't … |
 | Alright, for some odd reason, the below syntax is incorrect. I have successfully connected to the database on previous lines, now i'm trying to create a table. The error I get is: [QUOTE]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version … |
| | Hi I am having a bad day! I am running an INSERT INTO and SELECT query which is working. One of the SELECT parts is: [CODE](SELECT title FROM exp_forum_topics WHERE topic_id = p.topic_id) AS post_subject,[/CODE] which brings back a title. What I want to do is prefix this title with … |
| | hi all, i need to display time table for students and staff my table design looks like --------------| timtable --------------| classid hour subjectcode day --------------| --------------| Working hours --------------| hour starttime endtime --------------| --------------| timtable --------------| classid hour subject code day --------------| --------------| subjectmaster --------------| subjectcode subjectname subjecttype . . … |
| | Hello, First let me start of by saying that I am new to javascript and ajax, but I thing I need them to accomplish what I am trying to do and here it is. I have there search forms, 1 search owner, 2 search contractor, 3 search properity. Then I … |
| | Hi I am having a problem with my syntax for the following code: What I am trying to do is: 1. Check if sticky = 'y' then give a value of 1 2. If not then check whether announcement is 'y' then give a value of 2 3. If not … |
| | I have the code shown below that nicely fills a Combobox but I have no idea how to have it on a form so that the user can select an item and the resulting $_POST would be availabe to another page the same way it would be if the Combobox … |
| | Hi I am working on web for some group, but i have problem my code is [ICODE]<?php session_start(); $username = $_POST['username']; $password = $_POST['password']; if ($username&&$password) { $connect = mysql_connect("http://mysql.ic.cz/phpmyadmin/","USERNAME","PASSWORD") or die("Nemůžu se připojit"); mysql_select_db("vy_promm") or die("Nemůžu najít databázi"); $query = mysql_query("SELECT * FROM uživatelé WHERE username='$username'"); $numrows = mysql_num_rows($query); … |
| | Hi! I need to know if theres a function that is simmilar to mysql_insert_id function where it gets the last inserted id but the thing is my id is not auto increment i tried doing the select statement but not working my scenario is: i am updating a record from … |
| | [CODE=php] <?php include('variables/variables.php'); ?> <div id="header"> <?php include ('includes/db-zelf.php'); // define your database connection credentials mysql_connect( $db_host, $db_user, $db_password ) or die(mysql_error()); mysql_select_db( $db_database ) or die(mysql_error()); /* KUBAGES */ $Luchtvr = mysql_query("SELECT * FROM Luchtvrachtpalletten WHERE ID='1'") or die(mysql_error()); while($Luchtvra = mysql_fetch_array( $Luchtvr )) { $kuubid = $Luchtvra['ID']; $kuubvol … |
The End.