11,093 Topics
 | |
 | i have a table in Mysql's database, tblStudents, which has 1,000 stdents, from different departments, e.g 500 from IIT, 300 from IMS, 100 from Medical, 100 from Engineering. and on fornt end in, i have 2 dropdown boxes, one drpdwnDown box is filled with values, IMS, IIT, MEDICAL, ENGINEERING. now … |
| | i have 2 tables as follow sales (table1) sales_id, userid(buyerid), product id, productname, orderid, status users (table2) userid, username, pass Now, I need to display the top customer who makes regular purchase on my shopping site. How can I achieve this? I tried as SELECT A.(*), B.username FROM sales A, … |
| | Good day, I've created a webpage on localhost using php. I have a local network with 3 computers at home. I can access the webpage only from one computer (http://localhost/mywebpage/). What changes should I make in phpmyadmin to be able to access the webpage from all computers? Is it possible? …  |
 | DaniWeb will once again be sponsoring the Percona Live MySQL conference coming up next month. You can go to http://www.percona.com/live/nyc-2012/ to register and use promo code DANIWEB to save 15% on tickets. DaniWeb will also be hosting the official after party for the Percona conference, which you can find out … |
| | Hi Everyone! My question is on Pagination (as it is called). I have a php program that accesses a database and shows the result list with HTML. Well, if my result list is quite long how do i code so that only say 10 rows show per page. I know … |
| | i am making a booking system and i am thinking how am i suppose to know if there is a conflicting time.. i want to add an Error message if the time is conflicting in other event help me please Example: Date Time Start Time End DEBUT September 18 5:00 … |
| | Hi All, I want to generate time table reports. A form includes labels to enter grade, class and stream. After selecting data user should click on "Generate" button and relevant time table details. The data is submitted for the following page and there was an empty set of data shown … |
| | I am creating the Simple Blog from PHP for absolute beginners book. I have worked through the book and my only error now occurs when I am logged in as the admin and try to Post a Blog. The errors I get are: Warning: array_push() expects parameter 1 to be … |
| | Hi guys, i'm new here. First of all, i'm from Argentina... So maybe my english is a little crappy I'm developing a page with login. I uploaded it to a hosting with no poblem... But when i want to create a stored procedure an error appearse. I've searched on web … |
| | I just want to connect my mysql with vb.net code as below: But,for some reason I cant figure out the problem i have also added the mysqldata.dll in my reference. all the input in connection string is valid and there is no error in the code. it just shows cannot … |
| | Dear Respected Members, I have problem with LEFT JOIN that it brings the whole columns from tables even if I limit to specific column ids :( I am forced to use the LEFT JOIN because in table B - column "id" - is not always exists in table A. Please …  |
 | Hey, I've got a simple little table that has only 3 fields. ID (primary key, auto-increment), cat_name, and cat_num. I need to know how to get my php script to go into that table, and increase the value in cat_num by one on every row. So for instance, here is … |
| | Hi. does anyone know how to save the combobox selected Index like(0,1,2,3) in mysql database by combobox as INTEGER? Please help me..! |
| | i created database in mysql along with 3 tables but when i opened C:\ProgramData\MySQL\MySQL Server 5.5\data then i found on .frm files and a single .opt file so where is my originalo datbase and data ? my datbase name is kustkht |
| | Hi, I have this script, it attempts to place JSON data into a MySQL database. The problem is it duplicates records, this does not happen when the “news_added” field is not NULL. That’s the only thing I can see different. I would like the script to update a record, replacing … |
| | hi all. I have some problem. I want to make Delete multiple rows in mysql with check box. so I did it below. but delete doesn't work. could you tell me where is wrong ? <?php include'conn.php'; mysql_select_db("auction")or die("cannot select DB"); $sql="SELECT * FROM family"; $result=mysql_query($sql); $count=mysql_num_rows($result); ?> <table width="400" …  |
| | Hey guys I have a mysql database that has an events table. The events table consists of the fields Title, Date, Place and description. I am trying to display the table on the browser using php coding. it should list important events first according to the date. so as follows … |
| | i have tblStudents and tblDepartments, so which keys a weak entity (student_department) would have ? studentid and departmentid ? is it so ? and both foreign keys will work as a composite primary keys ? is it ? |
| | |
| | hi to all, can you help me in my program, i can't retrieve my image in the database to vb.net how can i view my image when i click in listview? plss help me THIS IS MY CODE HOPE YOU CAN HELP ME! Imports MySql.Data.MySqlClient Public Class Often_Motorcycle_Problems Public ConnString … |
| | Please help me for my problem in adding and retrieving video from mysql to vb 2008. I don't know the codes for it. |
 | I have no issues with the query in the below code. But the second code is throwing the error 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 1 Working code …  |
| | Hi guys, I´m attempting to write a simple "get quote" script, but need some advice about best practice. I want to structure it as follows, lets say a customer wants 1,2,3,4 or 5 apples - I want the quote to be $1. If the customer wants 6,7,8,9 or 10 apples … |
| | Hi I have the following code being used to insert some data into a MySql database, all the error checks etc. are done before and those are fine, and the code returns connected successfully but nothing is put into the database, nor does the database check for duplicate usernames, because … |
| | I have created two database tables, One which holds all of the users information, and another which holds the name of the videos they uploaded and who uploaded it. How do I get information from both tables? |
| | I have no issues with the query in the below code. But the second code is throwing the error 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 1 Working code … |
| | Here is a basic join code for two database tables, I want it to compare the two tables with a users email, it would have to be the current user logged on. How do i do so with php? SELECT column_name(s) FROM table_name1 INNER JOIN table_name2 ON table_name1.column_name=table_name2.column_name |
| | Hello I have made a php file upload for the visitors of my site to upload small videos too, now I want the users that are logged into their account to have the videos they upload be linked to their user id, so anyone vewing the small video can know … |
| | I'm making a B2B portal that can see just loggedin business customers that I add to base, I finished almost all, but there is one problem. When customer add some goods to his cart, goes to checkout and confirm his order he will have a link to invoice.php?ids=156 and that … |
 | Hi All , I need to get multiple result from same table my table structure is id category parentid 1 dress 0 2 men 1 3 mtshirt 2 4 women 1 5 wtshirt 4 If I give wtshirt it should produe result as wtshirt-men-derss how can I write query for … |
| | i have tow tables, posts and sections, i want to get the last 10 posts WHERE section = 1, but use the 10 results in different places, i make a function function sectionposts($section_id){ mysql_set_charset('utf8'); $maxpost1 ="SELECT max(id) from posts WHERE section_id = $section_id ORDER BY ID DESC LIMIT 10"; $maxpost10 … |
| | I have a table like this: tableA: id, a, b, c sample data: 1, x, y, sample1-get-by-y 2, x, y, sample2-get-by-y 3, x, '', sample1-get-by-x 4, x, '', sample2-get-by-x 5, '', '', saple1-general 6, '', '', saple2-general I want to get the data like this: if I have data where … |
| | Hi, I've two tables, one called users and one called playerweapons. In `users` it carries information and is defined by a Username field. In `playerweapons` it has the same define with using Username. I want it so when I update the Username field in `users` it will then update the … |
| | Please how can I export data from access to mysql database please help me oo  |
| | Hi All, I have a samll problem related to a specific query. It creates following error. **Unknown column 'attendance_state.state' in 'field list'** $query="SELECT attendance_state.state,attendance_state.state_id from attendance_state inner join attendance on attendance_state.state_id=attendance.state_id where attendance.admission_no='".$admission_id[$i]."' and attendance.date='$date'"; $result=mysql_query($query) or die (mysql_error()); The table related to the query looks like this. "state_id" is … |
 | Hi every one!! I need help to match user data from database inorder to log in to admin panel. Here is what I am trying. it works ok but it is giving dialog box containing text "Sorry! You have no access to Database" here is the code. Please help String … |
 | I am trying to do an INSERT statement. It is giving me an error #1064 - 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 'Telecaster’, 599.00)' at line 1 Here is the statement: … |
| | I need help, please how can I export my database from access to mysql. I do not want to start creating the tables one after the other ĩ̷̊ñ mysql. Thanks |
| | Hi guys , I am new to php. I want to fill a mysql table which contains numerous fields.I need to develop four form on different pages and i need to insert all the values in the same table . any help will be appricited. |
| | I have a small database of about 30 names that are all unique. The variable $member equals "Ann" but will change depending on the person to search for. I need to be able to return the exact match of the person's first name. I have tried many combinations of the … |
| | Iam working on a attendance management project to get inputs from fingerprint scanner and save it into mysql database such as date and time and also to vertify the staff members. If anyone could assist it would be a great help. |
| | What I'm trying to acomplish is to have a list of years in a <form> with a checkbox for each year and let the user select what year applies to the post such as: 2008, 2009, 2012 (they might select 4 out of 5 years, not just one year). Then … |
| | Hi all, I am new to Ext JS, I have tried 'drag and drop' and it is working fine when i drag rows. What I am trying now is dragging a row (a field from MySQL) from left grid and dropping it on right grid that gives data from database … |
| | Sorry if this is in the wrong section, but couldnt find anywhere else approriate. Im trying to alter a points column in a table when a user likes our facebook page through a button on our website. The button is to be displayed on a members area on our website … |
 | Are there any open source/free to use, commonly updated... either dumps or APIs that will let someone have zip codes and addresses validated? Think monster.com or careerbuilder.com's location search, or something similar. Thanks Ryan |
| | Im a newbie in PHP and I want to create a simple webpage app for my website, I was able to produce this page base on a tutorial here. <?php $con = mysql_connect("localhost","*****","*****"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("*****", $con); $result = mysql_query("SELECT * FROM … |
 | I have the following codes.. echo "<form><center><input type=submit name=subs value='Submit'></center></form>"; $val=$_POST['resulta']; //this is from a textarea name='resulta' if (isset($_POST['subs'])) //from submit name='subs' { $aa=mysql_query("select max(reservno) as 'maxr' from reservation") or die(mysql_error()); //select maximum reservno $bb=mysql_fetch_array($aa); $cc=$bb['maxr']; $lines = explode("\n", $val); foreach ($lines as $line) { mysql_query("insert into location_list (reservno, location) … |
| | Hi, how many index i can create for one table in mysql. |
 | I use MySQL database (innodb) I use Visual Basic 2008 I have a table Employees with two fields EmpNo and Managerno ALTER TABLE Employees ADD PRIMARY KEY (EmpNo CREATE INDEX index_Managerno ON Employees (ManagerNo) How do i now IF Mysql using this index is if i do this: SELECT * … |
| | Hey everyone, I know this probably seems simple but for some reason I can't get my head around the correct concept. Bare with me please. I have a form in html that is for uploading photos in a to a specific category. However I want to add a select menu … |
The End.