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