10,932 Topics
| |
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 … | |
Hi, I have a form to upload images one at a time with text to a mysql database table, but I need to resize these images before adding them to the table, I want to retain aspect ratio and I need it to always resize the longest side of the … | |
I have the following table structure of my db: * tbl_project * tbl_employee * tbl_deliverable * user_to_deliverable as tbl_prjct and tbl_deliverable has 1-many relation, tbl_employee and tbl_deliverable have many-many relation so they are splited into user_to_deliverable table All i want is that a query to show project_name(from tbl_project), project's deliverables … | |
I am having some issues with some code i am trying to use. Can you please take a look at the code and give me some fixes to this. The error i am getting is this: Warning: Wrong parameter count for mysql_fetch_assoc() in /home/content/33/5271833/html/cfr_forms/edit.php on line 10. What i am … | |
how can I install the mysql server into CentOS 6.can someone give me the step please :( | |
I have the following code in my **PHP** program: $query = "SELECT * FROM board_members"; $result = mysql_query($query) or die(mysql_error()); $data = array(); // create a variable to hold the information while (($row = mysql_fetch_array($result, MYSQL_ASSOC)) !== false){ $data[] = $row; // add the row in to the results (data) … | |
I have located a potential issue in the correlation between 2 tables and would like to correct it before it actually becomes one. (actually I need to fix it so the new scripting I'm doing will work correctly) I have a member information table called 'members' (38,881 records) I have … | |
I have a database created in mysql iwant to create a backup utility for backing up the data on a routine base | |
What I am trying to do is: I have my database in phpMyAdmin constructed, with pages coming into Content Mangement system. What I would like to do is link a page directly to a website page by creating a direct link in phpMyAdmin. Can someone explain how I can do … | |
Hi there, Just wondering if there is a way of inserting tuples into a table without specifying the primary key id. insert into myTable (username, password) values (value1, value2); Ok. When I use the above mentioned statement, it complains about duplicate keys. Anyone know why? shouldn't the key be generated … | |
I'm trying to do a php-mysql project that can make phone calls from the computer. The concept is - My call list is stored in a mysql database and when a tele-caller login in to their account. The call list is displayed and a call button is placed beside every … | |
I have written a mysql query- SELECT questions.id,questions.date,questions.title,users.user_name,subjects.subject FROM questions INNER JOIN topics ON questions.topic_id=topics.id INNER JOIN subjects topics.subject_id=subjects.id INNER JOIN users ON subjects.id=users.sub1 OR subjects.id=users.sub2 WHERE users.id=8; which is giving error- #1066 - Not unique table/alias: 'topics' .i am unable to understand the problem. | |
mysql Inner join problem I have written a mysql query- SELECT questions.id,questions.date,questions.title,users.user_name,subjects.subject FROM questions INNER JOIN topics ON questions.topic_id=topics.id INNER JOIN subjects topics.subject_id=subjects.id INNER JOIN users ON subjects.id=users.sub1 OR subjects.id=users.sub2 WHERE users.id=8; which is giving error- 1066 - Not unique table/alias: 'topics' .i am unable to understand the problem. | |
I am not new to OOP I am tidying up a very large site of mine and trying to create a much better structure (more in keeping with the whole point of OOP). I have decided to use mysqli (please don't suggest PDO as I have decided againast it) which … | |
hi guys, need your help on this. had a form on html and saving data to mysql but it's not working here's the html code: <html> <body> <table width="300" border="0" align="center" cellpadding="0" cellspacing="1"> <tr> <td><form name="form1" method="post" action="insertac.php"> <table width="100%" border="0" cellspacing="1" cellpadding="3"> <tr> <td colspan="3"><strong>Insert Data Into mySQL Database … |
The End.