10,938 Topics
 | |
 | 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 … |
| | **i have this connection** <?php $db_host = 'localhost'; $db_user = 'root'; $db_pass = ''; $db_name = 'databasename'; $conn = mysql_connect($db_host,$db_user,$db_pass) or die(mysql_error()); mysql_select_db($db_name,$conn); mysql_query("SET NAMES 'utf8'"); mysql_query('SET CHARACTER SET utf8'); ?> **but my old connection dosen't work with this code** //connect to database $link = mysqli_connect('localhost','root',''); mysqli_select_db($link,'databasename'); //get all rows … |
 | I have a a table with the following data: reservno || icode || location 00004 || 00021 || Bohol - Cebu 00004 || 00022 || Cebu - Manila 00004 || 00014 || Manila - Bohol I use this query to retrieve the concatenated value of location. `SELECT GROUP_CONCAT(location) from location_list … |
 | Hello, I was wondering if somone might be able to help me. I have a txt file, it looks like this ID1|NAME1|URL1|EMAIL1|LOGO1|ADTEXT1|ADTEXT1|CATEGORY1|PUBDATE1 ID2|NAME2|URL2|EMAIL2|LOGO2|ADTEXT2|ADTEXT2|CATEGORY2|PUBDATE2 ID3|NAME3|URL3|EMAIL3|LOGO3|ADTEXT3|ADTEXT3|CATEGORY3|PUBDATE3 This is my php code // initial database stuff $host = "localhost"; $user = "root"; $pass = "root"; $db = "database"; $connection = mysql_connect($host, $user, $pass) …  |
| | Hey everyone, I am looking to write a query that I think can be solved a nested select but I am not yet that fluent in MySQL to be able to get the query working correctly. Basically what I want to do is this; SELECT count(*) from Inquiry Inner Join …  |
| | I have a database table like the one mentioned below. id | lecture | subject_id | date | is_deleted ------|--------------------|------------|------------|----------- 1 | Introduction | 1 | 2012-08-10 | 0 2 | Structure | 2 | 2012-08-15 | 1 3 | Introduction | 2 | 2012-08-12 | 0 4 | Functions … |
| | I have gotten a php file where users can create their own user ids and login and out with them and it saves their name in mysql, now i want these users to be able to upload small videos, can someone please tell me a php code for how a … |
| | I have to retrevie data from the database using "SELECT * FROM $tbl_name WHERE cat1 = technicalfest ORDER BY id DESC"; can any one tell me how to use multiple |
| | I want to make every single change on a local database to also be *immediately* done on the remote database. The remote database is always online but the local one is not. I was hoping of using RabbitMQ to queue the records so they could be sent immediately when the … |
| | i've displayed a table from database using php.and now what i want is to edit records seperately as i've placed an edit and a delete link in front of each record which edits the record from sql.and it is now giving this warning.Please help me to find the error correctly.as … |
| | Hi everyone i dont know how to get the already filled value of radio buttons from sql using html/php here is my code but its giving error <?php include("../includes/config.php"); ?> <?php if ($_SESSION["isadmin"]) { $con=mysql_connect($dbserver,$dbusername,$dbpassword); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db($dbname, $con); $accountid=$_GET["id"]; $result = … |
| | hi guys, please help me out on this issue. i had this code to connect to mysql using php but there is no any message displayed. nothing is displayed on the screen, whether the connection is successful or there is an error. any ideas? i can connect to mysql using … |
| | Hi there! I'm new to MySQL. What security measures should I take to ensure security of my databases? Any keywords? For instance, often times when logging into the DB, you must enter the user and pwd to gain access. How can I make that more secure? It's obviously in plain … |
| | Hi there, i need to draw an ERD Diagram and i can only draw the, product,blueprint,hardware,software and i am stuck Please help...i would appreciate it a lot.Many thanks. **Scenario:** You have been asked to create a database design for the BoingX Aircraft Company (BAC), which has two products: TRX-5A and … |
| | Got a problem that has completely stumped me... am hoping the combined wisdom of the forum could assist... I have a php script that enables a user to follow and unfollow items on a site... Am doing this with a table that captures basically the user's id and the item … |
 | Pls design a site but am still a dummie so I cant connect my site with a table in my db am using phpmyadmin. Please I need a tutor to guide me on how to begin connection to db using php. |
| | I want to delete a table after 15 days automatically from the date of its creation , please soem one help me to find out the solution , Some one suggest me to use trigger but i search a lot but unable to find out the solution . |
| | Hello, When I run this query then i am getting **SELECT * FROM upload where cas_no=''104-55-2''** Why I get backslash in my query ? Otherwise query is ok. and URL value is exact value. www.abc.com/upload_reportt.php?cas_no='104-55-2'.... so what happen with my sql query? <?php session_start(); include(functions.php); ?> <body bgcolor="#F5F5DC"> <a href="logout.php"><h3 … |
| | I need help on my update statement, the condition is , i have to update the status . the table name is leave_request , it contain leave_req_id, date_applied,emp_id,leave_type_id,leave_period_id,leave_status and the default for leave_status is 'Pending' the problem is, choose approve, and on the database should change the leave_status into 'Approve' … |
| | Im trying to get transaction details of a paypal account, which I was successful in doing so, but I get this long (what i assume is an array) but I need to insert the details into a mysql database. I've tried several foreach methods but apparently I am doing something … |
| | I am a new PHP developer, I run a LAMP server but use Win 7. For the PHP Developers out there, is it much more helpful to have a local WAMP server? I can see how it would be nice to be able to develop without uploading every four seconds … |
| | I installed Xampp and have the apache, FTP and MySql server running. Initially i was getting an error:- ## error :- ## MySQL said: Documentation 1045 - Access denied for user 'root'@'localhost' (using password: NO). Connection for controluser as defined in your configuration failed. phpMyAdmin tried to connect to the … |
| | Hi all, i manage to write this query to select data from 2 different tables, here is it $query ="SELECT * FROM illness,symptoms WHERE symptoms.sympId = illness.illId"; am trying to echo the result of the query, here is my script if($med == !'') { $query ="SELECT * FROM symptoms,illness WHERE …  |
| | I need help in using a variable passed in a hyperlink query string to do PHP query of a MySQL database. I want use the variable to query the database and return the unique row field data to display in a table The hyperlink is: [CODE]http://www.site.com/bios.php?pc=ab [/CODE] After connecting to … |
| | arent those two the same function? and i want to ask, can i use 2 query statement in 1 while? `while($row = mysql_fetch_array($result))` i want to add another one beside that, it will be like this `while($row = mysql_fetch_array($result) && $row1 = mysql_fetch_array($result1))` is it valid? |
The End.