[mysql] Forum Topics

I have three tables 1.course(c_id(pk),c_name,sem_no); 2.student(s_id(pk),s_name,user_name,password); 3.student_info(s_id(fk),c_id(fk)); i have logged in the student.. den i run this query select distinct sem_no from course,student_info where course.c_id=student_info.c_id and s_id='0001' order by sem_no; it shows all the semster he passed inclueding the running semster.. now i want to show the last value of …

Hello, What's the mysql syntax to rename column in a table? I try this: ALTER TABLE static_content RENAME COLUMN title TO shorttext MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to …

I am doing an investigation in to cross site scripting and sql injection and maybe other attacks for my thesis basically looking at vulnerabilities in websites that could potentially cause these attacks, I am struggling to come up with ways in which to demonstrate this. Intially I was thinking about …

Notice: Undefined index: item_number in C:\xampp\htdocs\paypal\success.php on line 6 Notice: Undefined index: tx in C:\xampp\htdocs\paypal\success.php on line 7 Notice: Undefined index: amt in C:\xampp\htdocs\paypal\success.php on line 8 Notice: Undefined index: cc in C:\xampp\htdocs\paypal\success.php on line 9 Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\paypal\success.php on line …

<?php mysql_select_db("store"); $t="SELECT COLUMN_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'stoke' AND COLUMN_NAME = 'catogory'"; $q=mysql_query($t); while($r=mysql_fetch_array($q)) { $y=$r['COLUMN_TYPE']; $u=explode("','",substr($y,6,-2)); //print_r($u); ?> <select name="category" > <option value="">Select Category:</option> <?php foreach($u as $option) { print("<option>$option</option> "); } ?> </select> <?php } ?>

hi im making a database for my project is it possible to have multiple foreign keys shown at the picture? i tried to alter the tables and add foreign keys but i always get a #105 error, so i deleted all of my tables and will make a new set …

I created a table in phpmyadmin and i was curious to know if it is possible to assign multiple values to one variable/field in the same table. For example here is what i have: ID | Shoe | Sizes ____________________ 1 | CK | 7 ____________________ 2 | LV | …

Hello, guys.. I am actually working on a project. I can't figure out how to limit the displayed content on a table of a particular data. I have a table (tblservices) that have fields (service_id, service_name, service_content, date_created).. *the service_name* is the title of the service, *service_content* is the whole …

HELLO! I've been debugging my code for an hour now. seriously. So I have this string: SQLString = "UPDATE `etmsystem`.`main` SET `timeIn` = '22:00' WHERE `main`.`serialNo` = '70002B4A8F9E'" actually the TIME and the SERIAL NO. here is to be represented by a variable. But I changed the code into that …

Hi, i'm trying to select two values from my database. $nc ='North Carolina'; $t ='Hello'; $q = 'SELECT COUNT(state, title) AS c FROM all WHERE state = "' . mysql_real_escape_string($nc) . '" AND title = "' . mysql_real_escape_string($t) . '"'; $rq = mysql_query($q); $fetch = mysql_fetch_assoc($rq); $count = $fetch['c']; echo …

Below are 2 functions that will handle the Query and rending of the menu from MySQL Database. This function Loops through the array. Takes in 2 arguments. function loop_section($array, $parent_id = 0){ echo '<ul>'; foreach($array as $section){ echo '<li>'; echo $section->section_name; echo '</li>'; } echo '</ul>'; } This function handles …

Hello. I am beginning to re-develop a small database using PHP/MyQL; I have already sucessfully done this a year ago but no longer have access to the machine, code or credentials. It worked great! But now, I'm rebuilding it. The test site (PHP) seems to be fine. I see no …

Hello all, It’s a problem which is giving me pain. I have a table agent_registration which have following structure: agentID agentname patentID 001 a NONE 002 b 001 003 c 001 004 d 002 005 e 003 So, whenever we register a customer whose agentID is ‘005’ then how can …

Please provide detailed description of how to update ft_min_word_len value in global_variables table of information_schema database.

hi i am currently working with php which requires registration once the user registers with his/or her details then an email is sent to the user for activation once the link is clicked the account is activated this works perfectly but the question is how do i expire the link …

Somebody can help me. I'm new in php and highcharts. I tried to populate my chart using mysql and php, but when I tried to run it, the chart didn't appear, only a blank web page. And there's no error appeared. Her's my codes (sorry for messy code): <!DOCTYPE HTML> …

A few years ago I posted this: http://www.daniweb.com/web-development/php/threads/300959/checkbox-loop-in-php Looking for some help. I got the help that I needed and finished my project days after I got help. After using the PHP script for two+ years just last week an error started popping up. I never had a single issue …

my form has an option where user can choose to fill but should that option be choose then the form will will submit to two tables if not chosen the one table using php/mysql.table being patient and insurance table. Prompt assistance will be appreciated.thanks $query = "insert into patients (title,patientid,name1, …

Hi, I am using VB6 and phpMyAdmin connected by WAMPServer for my system. I am new in this language. Here's the code in my that seems to be wrong: Private Sub cmdsubmit_Click() Dim rs As ADODB.Recordset Dim strsql As String strsql = "insert into table1 ( surname, firstname, middlename, house, …

I have a table EmpList. I want to use loop to bring result as I expected. Example, EmpNo ReportingTo ------------------- 27 14 68 14 104 27 105 27 138 27 139 68 150 8 151 8 8 5 Suppose query input is 14, I need result like this EmpNo ------ …

So I am reading a book from Pratt and it is called A Guide to MySQL. Apparently the book stinks and I am trying to answer some of the questions from the book. #fc1 show tables in the current selected database # for your current database it should be two …

hi iam working on building a website for maintaining PCs, and if anyone get in my site asking for help, if i try to answer him the answer will go to the werong person, so please any help <html> <head> <meta charset='utf-8'> </head> <body > </body> </html> <?php $dbhost = …

When checkbox is clicked(checked) dynamically redirect value to sql query and return value on same page.Please reply example with array of check box if possible. code is in PHP

hi all.. i am having an problem during mysql installation..hopefully you all can give me advice and solution on how to solve it...below is the image of screenshot that i take.please help :) 

i have 3 table with different structure.. * article (content of only text) * download (content of text,file and image) * market (text, image) i want to show the search result from those table together but with different style (only text, or image, or both) but when i use UNION …

Hi i have input type text as date with a value of "2013-12-25" and i have a database with a field of month and a value of (December) and Year (2013). How can i convert the value of (2013-12-25) to a string of December and Year so i can use …

I'm having a brain fart and for some reason it's not coming to me how to do this right now. I'm trying to tally up a table, and store the results in a different table. Like so user score ---- ----- 1 4 1 5 1 2 2 1 2 …

Hey guys looking to create a cool database. But i need some help on what languanges I might need to complete this thing. Just looking for some pros and cons to compare. any ideas? Im a beginner so speak plain languange :)

I need help with the queries I wrote and I don't understand what is wrong with them? Can someone help me correct them? #11 SELECT BOOK_CODE, TITLE, PUBLISHER.PUBLISHER_CODE, PUBLISHER_NAME FROM BOOK, PUBLISHER WHERE PUBLISHER.PUBLISHER_CODE = BOOK.PUBLISHER_CODE ORDER BY PUBLISHER_NAME; #12 SELECT BOOK_CODE, TITLE, PRICE FROM BOOK, PUBLISHER WHERE PUBLISHER_NAME = …

if run to a delemia when im out of the hosue and not near a net work i want to be able to run on local, but i dont want to have to change the credientials is there a way i can have it try one and if it snt …

OS:windows 8,compiler:g++,mysql version:5.6 //bookshop.cpp #include <my_global.h> int main() { return 0; } //bookshop.cpp //Makefile CC = g++ LIBS = -L"C:\Program Files\MySQL\MySQL Server 5.6\lib\" -lmysqlclient INCLUDES = -I"C:\Program Files\MySQL\MySQL Server 5.6\include" all:bookshop bookshop: bookshop.cpp $(CC) -fpermissive -o bookshop $(INCLUDES) bookshop.cpp $(LIBS) //Makefile error： In file included from C:\Program Files\MySQL\MySQL Server 5.6\include/my_global.h:68:0, …

hi can anyone see why this is not working please ? `mysqli_query($con,"UPDATE goodship SET brick=brick+1 WHERE id= $_COOKIE['id']");` all i am trying to do is add one to the sessions id col brick, thanks.

Hi there. I was kinda researching on how I could store data at best (in my opinion). I came on "CSV" files. Which looked great to use. I found out there are two functions that can operate file. So I keep Googling on how to use the syntax and how …

Hi I am New to PHP and my question looks stupid but i am stuck I want to search operation register to search by id and print out put of perticular id my first file has this code: <form action="printotreport2.php" method="POST" target="_blank"> <tr> <td>Ot Reg ID of Patient </td> <td> …

Hi all, I just came up with a little problem.I used crystal reports for my reporting. And i used five tables for the report.I've used SQL statement to select the records that i want. But crystal reports displays each record (selected by the sql) on a different page which makes …

Hi I have data to upload to a Mysql database and I need to get the time taken for each row to be inserted so that I can pass that number through to a progress bar. I have alreay tried accomplishing this by determining the number of rows affetced by …

Hi Everyone, Can I ask your favor, I have a code that I customize. DBConnect.CS //here ismy db connection using System; using System.Collections.Generic; using System.Linq; using System.Text; using MySql.Data; using MySql.Data.MySqlClient; using System.Windows.Forms; using System.Data; namespace PAIRDevelopment.Classes { public class DBConnect { public static string csConnect = "uid=root; database=membership; pooling …

According to my professor's program, it says that the snippet of code that i wrote has a syntax or runtime error. This is my code: #S3 display fruit name, inventory quantity sum, price and sum quantity*price displayed as value for each row in fruit SELECT name, sum(quantity), price, price * …

I save a variable in my db row like this: http://www.$site.com When i fetch from my db it echo this :http://www.$site.com but i have a variable $site='google' and i want to change $site to google automatically when fetched from db. Is there a way to this.

Hi Guys I need to create an SQL database for my work, and use visual c# to build the application. I work for a college and we have just opened up an IT support shop that is run by the students. They need a database created, but I am unsure …

Hello. How can i know the data source of my sql 2008? Dim strconnection As String = "Data Source=.............;Initial Catalog=DatabaseConnection;Integrated Security=True;" How am i suppose to know the the data source? i it my computer name?

I wrote 2 queries and I am not sure what is wrong with them. Can someone tell me what to do in order to fix them? #T8 select sum( quantity ) * (select price from fruit where name like 'apple') from inventory where fruitID=(select fruitID from fruit where name like …

Hi I have been struggling with this query for a while now I need to get the number of rows inserted into my database table, but I keep getting this error I can't seem to get rid of. $result3=mysql_query("INSERT INTO dest_table.create_info SELECT * from Profusion.source_cdr"); $num_rows = array($result3); $progress=mysql_num_rows($num_rows); echo …

I am trying to get a total of all the records for playerid from table1, table2 and table3 by playername. There are 4 tables, table-1, table-2, table-3, and players. I am not great with queries and I expect somebody here can instantly see where I am going wrong. This is …

Hello in my code i am unable to fetch rows please check if (isset($email) && isset($key)) { $get_verify_email = "SELECT * FROM users_registration WHERE email_address ='$email' AND com_code='$key'"; if ($result = mysqli_query($dbc, $get_verify_email)) { while ($row = $result->fetch_row()) { $name = $row["Name"]; $business = $row["business_type"]; } /* free result set …

I have a form for adding products and their detail to a mysql db. I have another form that shows the products where I can remove the product from the db, I can also hide or show the product in the website. I need to be able to edite the …

Ok this is a basic question. I suspect that I do not know the correct terminology to search for the answer. I am playing in a development environment and this is all about learning and pushing my skills to learn more. My main web site is an HTML Form that …

hello everyone.. im trying to insert date into mysql..the field is of date type bt when i select a date from datepicker and insert it into database,it takes a random date..not getting where the problem is.. the code is as follow SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd"); java.sql.Date d = null; …