10,940 Topics
 | |
| | 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); … |
The End.