7,494 Archived Topics
Remove Filter  | |
 | studentmgt.php $search = $_GET['search']; echo $search; ?> <div align="center"> <div style="width:700px;text-align:left;padding-top:5px;"> <?php if (isset($confirmation)) { echo $confirmation; } ?> <form method="get" action="<?php $_SERVER['PHP_SELF'] ?>"> <br/> <?php //LOAD STUDENTS INFO $result = mysql_query("SELECT * FROM `student` INNER JOIN `group` ON group.group_id = student.group_id INNER JOIN `access` ON access.access_level_id = student.access_level_id ORDER …  |
 | Hy io have this php script(if you can call php script) anyway i whant that every result to show it one down the another(mysql grid table) but with that kind of search....i've tryied but unf nothing.... this is the "code" <?php $i = 0; if ($_REQUEST["string"]<>'') { $search_string = " … Databases mysql |
| | While pressing start button in control panel it's showing some problem detected. |
 | Hi, I need some help with my college work, with the database I am designing. # Assuming I want this to happen: # **Main Category:** Level1 Level1 >Level1.1 >Level1.2 >>Level1.2.a >>Level1.2.b >>>Level1.2.b.a >>Level1.2.b.a.a >>>Level1.2.b.b How do I design this? Thank you! Databases database-design mysql  |
| | Look at my table design below. It is a table that shows the roles of users. CREATE TABLE `userrole` ( `userid` bigint(20) unsigned NOT NULL, `roleid` int(10) unsigned NOT NULL, PRIMARY KEY (`userid`,`roleid`), KEY `fk_userrole_roleid` (`roleid`), CONSTRAINT `fk_userrole_userid` FOREIGN KEY (`userid`) REFERENCES `user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE, … Databases mysql  |
| | This is my query : CREATE TABLE userrole ( userid BIGINT NOT NULL, roleid INT NOT NULL, PRIMARY KEY(userid,roleid), CONSTRAINT fk_userid FOREIGN KEY (userid) REFERENCES user(user_id) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT fk_roleid FOREIGN KEY (roleid) REFERENCES role(role_id) ON DELETE CASCADE ON UPDATE CASCADE ) So, what i want … Databases mysql  |
 | I have a table with highschools in different cities. I want to give the user the option to choose a certain city and view the schools there, or view all schools. This is my original query: SELECT * FROM highschools WHERE city = '$givenCity' I need to compare 'city' to … Databases mysql  |
| | Hi, I have a query that has a condition that count persons whose blood pressure, weight and height are calculated whose age is greater than 3. I have made this query and this query is working fine but there is a condition that if the age is greater then 2 … Databases mysql |
| | Hi guys i have an sql query string that in my view there is something wrong with it but i an handicaped since i am very new to sql so my question is, is there any way of optimizing this query string select t1.cat,t1.site from (select cat,site from news where … |
| | Hi guys i have a table with this data ______________ | site | cat | ______________ | my | sp | | my | sp | | my | cc | | my | cc | | yo | sp | | yo | sp | | yo | cc … |
| | Hi.. I want to call mysql Stored procedure with OUT parameter. Its worked in phpamyadmin But in php it returning empty result. I have used the following php script. Can anyone help me? <?php include("dbcon.php"); $countryname="india"; $rs1 = mysql_query( 'CALL countCountry($countryname,@totalcount)' ); $rs = mysql_query( 'SELECT @totalcount as totalcount' ); … Databases mysql |
 | I have a table called Report Card Table. In that table there is colum called expiry date. I would like to know everybody who's card is expring in less than or equal to 90 days Databases mysql |
 | Hey guys, so I've been having an errorwith Php/MySQL for a long time with something I'm trying to do. I posted it in the PHP section before I found this subforum, so I'm just going to place the link to it below. Was hoping maybe I'd have a better chance … Databases mysql |
| | I want to make a recipe website.In that I had added the add to favourite button.If i click my favourite button the recipe which i clicked will add to favourites.I i re-click it will remove from my favourites.It is controlled by the status field in the favourites table in sql.How … Databases ide javascript-jquery mssql |
| | Hi I encounter the above error message while executing import excel data into sql data table. It worked fine in Mssql 2005 x86 and MS Office 2007 x86. But currently we upgraded the system to MSSql 2012 x64 and MS Office 2010 x86. I downloaded the accessdatabaseEngine.exe for MSoffice 2010 … Databases asp.net client-server microsoft-office mssql |
 | i have three table i attached db files with query result i am getting. my query is below select tts.transaction_id,tts.service_type,tt.theme_name from transactions tts inner join users tu on tu.user_id=tts.user_id inner join themes tt where tts.user_id = 71 and tts.service_type in ('purchased','startup_service') group by tts.theme_transaction_id; i am not getting write theme … |
 | I usually use ASP.NET for web development but I haven't yet dived into any database stuff. So what database should I learn? Databases |
| | I have a question about how to set up a page in php to allow the user to create reports from a mysql database and display in a grid on the page. I want them to build the query and save it to the another table and list on their … |
 | Hi, I'm still very new to MySQL and I'm having some issues trying to generate the right set of results. I have two tables, that follow the structure as below: mod_site_content +----+-----------+--------------+ | id | pagetitle | content | +----+-----------+--------------+ | 1 | home | <p> ... </p> | | … Databases mysql |
| | i have the following sql query i seem to be having this error "Incorrect syntax near the keyword 'INSERT'" Databases mysql |
 | Hi All, I'm not sure if this is a technical issue, preference or a question about best form. I have a 'users' table and a 'contacts' table. 'users' and 'contacts' have no direct relation. Both contain an email address for each record in their own table. I want to send … Databases mysql |
| | Hi all, i would like to ask, if i have **3 tables in database** and i have a **search bar** in my web page to **search staff id** to update details. The staff id being searched in search bar is assume as **$search_id = $_POST['searchid'];** The 3 tables in database … Databases mysql |
| | Hello guys I've coded cart class with cart items and showed cart items in a table but I had a problem when I try to update the cart.. It updates all the cart items when I'm changing quantity in one of the items **HTML** <div class="cartContainer"> <h1 class="shoppingBag">your shopping bag</h1> … |
| | Hy i have a search that now its works only if write or the first name or the last name, both didnt work....fn+ln....what i need to change?...ive tryied JOIN but nothing... if (Input::has('name')) { $name = Input::get('name'); $name = T_entity_details::where('First_Name','LIKE','%'.$name.'%') ->where('Last_Name','LIKE','%'.$name.'%','OR') ->where('Entity_Id','!=',$this->userId) ->get(array('Entity_Id')) ->toArray(); $array1 = []; foreach ($name as … Databases mysql |
| | Hi, By using **group by c3.source**,getting below result. I am trying to add condition in group by clause such that 3 rows should come 1)0+3 source result should merged 50+48 52+75 99+102 2) 4 source result contains ids having source 4 and url like '%daniweb%' source 0_to_7_days 7_to_14_days more_then_15_days 0 … Databases mysql |
| | please help with the query..I want to have a conditional statement in where clause depending on the result of select Count(*) statement originally my query is: select * from StudentMaster where StudentMaster.StudId = @pStudId and exists (select * from tblFinals where tblFinals.StudId=StudentMaster.StudId) but just today, I realize that user will … Databases mysql |
 | I tried to create the database connection SQL Server 2008 R2 Express with ODBC connection using TCP / IP After I try the following error appears : Connection failed : SQLState : '01000 ' SQL Server Error : 10060 [ Microsoft ] [ ODBC SQLServer Driver ] [ TCP / … Databases client-server sql |
| | how can i delete a record from multiple tables Iam having category id in category table,and in orders table.If iam deleting in that id in category table at a time it should delete in orders table also how can i do this can anyone help me. Thanks in advance Databases mysql  |
| | dept (dept_no, dname, loc, mgrcode) emp (emp_no, ename, designation) project (proj_no, proj_name, status) dept. and emp. are related as 1 to many. Project and emp are related as 1 to many. i) Give the names of employees who are working on ‘Blood Bank’ project.`Inline Code Example Here` Databases mysql |
 | I have several databases located over the world, this all have the same structure, with the same tables and triggers. For clarification purposes: Site 1: database_1 (with all its tables same as other sites) Site 2: database_1 (with all its tables same as other sites) Site 3: database_1 (with all … Databases mysql |
| | ** Hello i am newbiw to MYSQL .... iwant to create stored procedure in PHPMYADMIN . But when i am same procedue od MS SQL in MYSQL it is giving error . #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL …  |
| | hello guys i am trying to do something wierd in my query here is my query SELECT * FROM products INNER JOIN smartdevices ON products.id = smartdevices.productId WHERE products.clearName LIKE :keyword1 OR products.clearName LIKE :keyword2 OR products.clearName LIKE :keyword3 when the user enter the search phrase my php code will … Databases mysql |
| | Hello, I wonder why in this specific sql table I do not see edit, copy & delete in xampp: from_stu_username date messages to_stu_username admin 0000-00-00 messages btjong ----------------------- Other Sql Table has Edit, Copy & Delete Except for messages. Here is my php code for adding the new data in … Databases mysql  |
| | Hi guys, I have 3 classes : 1.Product(Super Class) 2.SmartDevice(Sub Class) 3.Accessories(Sub Class) so I made 3 tables in database and made productId as a foreign key for smartDevice table and accessories table so I've had a trouble thinking about what the code of CRUD will be if I used … Databases mysql |
 | create table invoices( year int not null ,invoice_number int not null auto_increment ,primary key(year, invoice_number) ); insert into invoices(year) values(2009); insert into invoices(year) values(2009); insert into invoices(year) values(2009); insert into invoices(year) values(2010); insert into invoices(year) values(2010); insert into invoices(year) values(2010); select * from invoices; +------+----------------+ | year | invoice_number | … Databases mysql web-design |
| | Hello, I'm having a problem with my MySQL InnoDB table, only one of five. Every now and then a row or two will go missing completely with no trace of it being there in the first place. I have a website which takes HTTP requests from my desktop side client … Databases mysql |
| | I am building a url shortner application in php and mysql and i am using the follwing logic to create short urls, pls tell me how is it First i fetch the last id from the database using select max(id) from urls then suppose if it returns 100 then i … Databases mysql |
| | I am building a site where members can create profiles that other members can view. I want to add a favourites feature to the profiles so a member can keep a list of their favourties members. This all works fine but now I want to find a way that a … Databases mysql |
| | I have recently started to write server scripts. Although the question may seem to be very basic but i am not able to get a solution. I have two tables one is PRODUCTS and the other is DEALS PRODUCTS TABLE: Id product_name product_desc category brand 1 product1 desc1 cat1 brand1 … Databases json  |
| | hey guys. I've always had problems when it comes to getting data from multiple tables in a database and so now I have another one. I want to get data from 3 different tables: contact1, child1 and spouse1. columns in contact1 where i want to get data from: contact_id | … Databases mysql |
 | i have a prinscreen of the problem http://i.imgur.com/GMJho9r.jpg i use mySQL to create the query and i have a database called tap that contains the events table I try SELECT sensor_id,event_type,value from tap.events where events.time = (SELECT MAX(events.time) from tap.events) group by sensor_id,event_type ORDER BY sensor_id,event_type; I get only the … |
| | Kindly note that I have the below table, I am trying to spool the count of the sum of the amtpd by grouping the duedt where it is less than or equal to 31-dec-2013, but the amtpd that has the duedt of 31-dec-2013 and that has trndt between 01-dec-2013 and … Databases oracle |
| | Hello all I have installed fantastico deluxe but when I try to install any script it gave me error You do not have access to that database (wrdp1)! can any body help me out on this please Databases |
| | i have a table fieldname like companyname and Created Date shown in below image. in that i want to display data's date wise ASC or DESC, like that if i click companyname the data's will show ASC and again if click will show DESC order format. and here i added … Databases mysql |
 | Hi, I want to Count the number of occurences of data in a table, then multiply it in a value from other table, After that I want to sum up the product of count and the value from other table, As of now, I cant count and then multiple but … Databases mathematics sql |
| | Hi All, I am trying to create a drawing database in Microsoft Access. Each user has a unique log in to the databse, when they log in and go to a part I am wanting them to be able to open the drawing by pressing a button and print it. … Databases microsoft microsoft-access pdf |
| | Hi i have installed prestashop 1.4.8.2, i want report from mysql, Number of orders per customer with customer name & customer id plus i want total amount of order customer wise. can you help me with SQL query so i can generate this report from phpmyadmin. thanks, regards, Ritesh Databases mysql |
| | Hi there, wanna ask if the sql syntax order by and group by the same? eg: i have a dropdownlist and the values displayed should be in ascending order. hence is there any difference if i use these 2 sql statements below. [CODE]sql1 = "select distinct * from t_staff group … |
| | Hello, I need for my game inventory function a mysql query which checks the next available free slot id. example: I have item on slot 1, 2, 3 and 5. Slot 4,6,7,8,9 ... are free.. Now I need query which would get the number 4. Something like SELECT * FROM … Databases mysql  |
| | Hi i have issue in stored procedure converting data type Destination table dbo.Z_tbl_CirculationCopy_TEMP has numeric data type But source table Z_tbl_Import_temp have VarChar Type If I export data from source, I have error message Msg 8114, Level 16, State 5, Procedure Z_usp_IMPORT_EXCEL_UNPIVOT_1, Line 10 Error converting data type varchar to … Databases mssql |
The End.