10,946 Topics
 | |
| | 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? |
 | Hi everyone, Trying to do a subquery to select the minimum price from table1, table what holds 15 million rows. I think that my approach is not the most suitable way of doing this. I want to select after oen_norm because oen_norm may have 1-10 rows per entry, but I … |
| | hi, i want to make a program where the csv file directly insert into the mysql database table. i found the code: [CODE]<?php include 'mysql-connect.php'; $rec=0; $handle = fopen ('datafile1.csv', 'r'); while (($data = fgetcsv($handle, 1000, ',', '"')) !== FALSE) { $rec++; if($rec==1) { continue; } else { $query = … |
| | hi everyone :) i know how to show all the records from database in an html table but how would i show specific category.for example i want to show records only with type T (type T is in database).im new with php and i dont know how to do it … |
| | Hello! I have a code here that has a dropdown box which is populated with data from mysql table, itinerary to be spicific (e.g. Tokyo- London, London - Tokyo, etc.). I also have a textbox that displays the block time (no. of hours required to travel a specific itinerary) of … |
| | Hello! This is my first post here, hehe. Seems to be a great site. Anyways, I'm quite new in PHP, but it's fun and I think I'm learning quite fast :) There's appeared a problem for me now though, and I can't see what the problem is...? I have made …  |
| | Hi! I referred to this forum thread when trying to build a MySQL search query for my site: http://www.daniweb.com/web-development/databases/mysql/threads/53025/mysql-select-rows-in-a-date-range But I just keep getting this syntax error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to … |
| | Hi, I used fpdf lib to print pdf. And I want my php class be integrate in fpdf? Can anyone help me? |
| | as the thread name $query2= "alter table employee_leave_quota auto_increment= LAST_INSERT_ID()"; That is my query to reset auto_increment in my table, but it show error.. anybody know how to do it? |
| | Hi every one, I have 3 table table temp: Name | Description A | Description A B | Description B C | Description C table temp1: Name | order A | 5 A | 4 B | 2 C | 3 table temp2: Name | Payment A | 3 B … |
| | Hi all, I have code as follows, to fetch rows from mysql table. Table it fetches is given below. I want to access now each cell in the table, how do I do that? For e.g, I want to multiply Rank for the Job "transform Brand image by 82% and … |
| | I want to creat a blog for my site, which is hosted on windows server. Can we host a wordpress site or blog on windows.  |
| | Please can someone show me how to retrieve database tables and add them as items to my JComboBox?.i have this app that i'm creating and it has a database which contains tables with their names and i want to add them as items into my JComboBox to aid file insertion …  |
| | Hello, I have got an error when i run this code.My query is updated but when I fetch the query then i got this error **mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\html-contact-form-captcha\update.php on line 44** please check the code is given below:- **** <!DOCTYPE html PUBLIC … |
| | Hi, I'm trying to write a program using mysqli, so I have created a login page. I've tried looking for how to get an Insert statement ran using MySQLi, object orientated style. So it looks like my query isn't working but I don't know why so I wondered if someone … |
| | hi, i write a code like this $user_id = $hd_cookie['user_id']; $user_password = $hd_cookie['auth']; $sql = "SELECT * FROM hd_users WHERE user_id='$user_id' AND user_password='$user_password'"; $r_user = mysql_query($sql); $num=mysql_num_rows($r_user); //line 24 it shows Warning Warning: Supplied argument is not a valid MySQL result resource in c:\apache\htdocs\helpdeskfinal\includes\auth.php on line 24 when i print … |
| | so i have this mini project to make i'am thinking of making a website just like grooveshark basically what i want in my website would be :- A LIBRARY OF SONGS PLAYER ON WHICH ONE CAN LISTEN DIFFERENT SONGS USER CAN CREATE HIS PROFILE AND CAN MAKE HIS OWN PLAYLIST … |
| | Can somebody help me to create an appointment scheduler with php/mysql that automatically create appointments.  |
| | HI GUYS .. im trying to make foreign key relation between whishlist_tbl(foreign) table and account_tbl(primary key) table both are integer data container ## scenario ## i have user deatail table that is account_tbl and whish list table i.e wishlist_tbl i want that when user make a wish book then he … |
| | Hi I'm having issue with editing the **Input Type** in **2** different position. I want to edit and add input text in the img. I also want to edit and add input text in the content. What I want to learn is how to add **2** **Input Type** areas in … |
| | Hi, Can we call Mysql Storedprocedure in SqlDatasource. My Connection String is Works fine. If not Is any other alternate available? Thanks in Advance  |
| | I want to store a Vector<Vector<Object>> in mysql database. What is the best data Tpye that i can use in mysql and java to store and retrieve the datas.  |
The End.