I am writing an inventory Management system. I am mostly complete with it. It is pretty basic, but does the job. So now I am working on the look of it. I placed a Searchbox/Query inside a div at the top of the page. The Search works. But it only disp
How to write a SQl query to create "NewTable" using Table1 and Table2 which the result look like "NewTable" below ? Table1 EmmployeeID | 1 | | 2 | | 3 | Table2 AgencyID | a | | b | | c | NewTable |EmmployeeID|AgencyID| | 1 | a | | 1 |
Are there any drawbacks to storing addition data in my join/junction table. For example, I am working on a database of trucking companies and I have 3 tables: Table 1 - company, Table 2 - trailer_type, Table 3 - junction_table, Each company can have
Hello I am getting Undefined offset: 2 notice when I am trying to insert multiple html table row in mysql . Here is my html form code ` <form action="insert_array.php" method="post"> <table class="table table-bordered&quo
I have the first table 'users' | id | name ------------------ | 1 | james | 2 | johnny | 3 | Carl | 4 | Lea And my second table contain the linked users linked_users | id | linked_id -------------------- | 1 | 2 | 1 | 4 | 2 | 3 I need to get two fiel
I have googled to do this but I think I am lacking something to make it work and after the merging I will save it to csv file or mysql db. This is the sample data: 01 2015-09-03 08:01 01 2015-09-03 11:03 01 2015-09-03 13:15 01 2015-09-03 17:12 07 201
function getForum($class_divisionId) { $qry = "SELECT fm.uid,fm.class_divisionId,fm.username,fm.description,fm.date_time,si.name FROM forum as fm INNER JOIN studentinfo as si ON fm.username = si.username WHERE fm.class_divisionId='".mysql_real_e
I have the following mysql statement SELECT login, personal_email FROM users WHERE personal_email in ('cc', 'bb', 'dd', 'aa') I want the output in the following order. +-------------------------------------+-------------------------------+ | login |
I have table with 4 columns: Date, John, Frank, Anthony I want to make a form which can be filled in by these 3 people everyday and store these values in the database. When John fills in the form today, a new row should be created with the date of to
Here is my function in DB_Functions.php, i want to get two different values from two different tables in single function only here is the code what i have tried so far but the values are coming null. public function getUserMetvalue($exname,$fname) {
I am looking for a way to increment and decrement by a step of three records in a table and return them. Say ID '4' is currently active. I want to get the next 3 and the previous 3 records with IDs and category of 3.2.1 and 5.6.7 (via incrementing an
I have Googled and I give up, here goes... I have always had issues dealing with times/timestamps etc, I am trying to pull a date from my database in SQL TIMESTAMP format, this is what I have so far... $db = $row_rsSearch['created_date']; $newdate =
This question already has an answer here: How can I prevent SQL injection in PHP? 28 answers I have been fussing around with my PHP code and SQL statements and while I do know that one could use prepared statements when dealing with this, I still won
I have a question and try searching on Google and Stakoverflow and could't find any perfect solution. I am using phpmailer and want to let the user to customize it's body message. So I have given and option to edit the email body text by providing a
I need Auto generated sequence number staring from 001 ONLY FOR 3 DIGITS in PHP / MYSQL ex: 001 next will be 002 and next will be 003 ... 009 .. 010 ..119..120..etc but number generated should be in sequence wise not like 001 then 120 or 008 etc , i
I'm implementing a leaderboard for our group project. this is my query for counting the number of status userid 2 have in the table. $query = "SELECT COUNT(content) FROM status WHERE userid=2 "; now, how could i query the userid with most number
I have a table contains two columns like this. (item name & item description) item_name item_des jasmine beautiful flower & nice smell rose flower orange gud fruit apple fruit books books I want to find matching items from this table on the basis
I would like to know if I can use the database created on phpmyadmin on visual studios c#? In the past, I have only used it for php projects. Now that I am making a c# project using Visual studios, would I be able to connect my database created on ph
I'm working on a personal CMS and I've got a problem. I wanted to define access levels such as CAN_DELETE_THREAD, CAN_EDIT_MESSAGE or CAN_CREATE_THREAD as binary flags, but I don't know how a function 'has_flag' would work. For example, if I took a u
I have a field in my database that I don't want to exceed 100. Is there something in a query I can add to make sure it doesn't? I usually end up doing this: UPDATE table SET field = field + $x UPDATE table SET field = 100 WHERE field > 100 Does anyth
SELECT * FROM afspraken WHERE user_id = '2' AND datum > '2012-06-05' OR ( user_id = '2' AND datum = '2012-06-05' AND begintijd >= '22:47' ) ORDER BY datum DESC , begintijd ASC This above is my query.. And while i should get zero result i still get o
I have a books database with categories and tags associated with books. I am trying to build a filter that will let users filter on multiple categories or tags and see books that have those tags or categories. It works fine with a single category or
Im stumbling upon a problem where i need to retrieve data from the following tables events +-------+---------+---------+ | e_id | e_title | e_link | +-------+---------+---------+ | 1 | Event 1 | event_1 | | 2 | Event 2 | event_2 | | 3 | Event 3 | eve
I have an idea for a project that I am currently working on, I am however struggling to find a way to implement this in PHP/MySQL. I have a database with a list of activities that a tattoo parlour has, basically he works from 9 to 5 and when an event
I'm trying to install DBD::mysql using most of the popular methods, including sudo cpanm -S DBD::mysql. However, I am having some serious problems with this and I am beginning to think it might be my processor. I have successfully installed this on m
I've just started using OOP PHP and ran into a question. I've set up a generic mysql class that allows me to connect to a database and has some functions to obtain records from a table: class mysql{ //some lines to connect, followed by: public functi
Do anyone know how to request a "live result set" in MySql when query has offset(eg: select * from table limit 10 offset 20;). it is throughing an error like 'invalid use of keyword' . Thanks, Vijay.you have no condition behind where and before
I am busy developing 2 web based systems with MySql databases and the amount of tables/views/stored routines is really becoming a lot and it is more and more challenging to handle the complexity. Now in programming languages we have namespacing e.g.
I am attempting to return a rowcount from a subquery as part of a result set. Here is a sample that I've tried that didn't work: SELECT recordID , GroupIdentifier , count() AS total , (SELECT COUNT() FROM table WHERE intActingAsBoolean = 1) AS Approv
I am able to complete this query but it takes 25 seconds. That's too long! How can I optimize this query? SELECT COUNT(DISTINCT u1.User_ID ) AS total FROM UserClicks u1 INNER JOIN (SELECT DISTINCT User_ID FROM UserClicks WHERE (Date BETWEEN DATE_SUB(
