Tagged Questions

1
vote
3answers
37 views

MYSQL returning incomplete results

I have a table called books with following data: id | description | section 1 | textbook 1 | 1 2 | textbook 2 | 1 3 | textbook 3 | 1 I use the following query to select id 2 and the next ...
0
votes
2answers
17 views

mySQL- how to show all contact and their status by using INNER JOIN

This is my company Table CompanyID, CompanyName This is my Contact Table ContactID, ContactName, CompanyID This is my Report Table ReportID, ReportName This is my ReportContact Table, Many to ...
1
vote
1answer
22 views

Table in Database, where the combination of two is unique but either of them isn't

I am just learning programming and I am not really good at databases. I am trying to make a University Management Website. So I have to make a table with columns - teacher, class, period, day. If ...
0
votes
2answers
23 views

MySQL Request from two tables advanced

I have request from my MySQL table. It looks like below: SELECT s . * , if( v.ip IS NULL , 0, 1 ) AS voted, v.vote FROM `emvc4_records` s LEFT JOIN `emvc4_records_votes` v ON ( s.id = v.record_id AND ...
0
votes
1answer
9 views

Access local MySQL database via LAN through Visual C++ DLL

I'm writing a wrapper for a local MySQL database. So far, I've made a Visual C++ DLL that opens a connection to the database from the local computer using MySQL's C connector. How can I extend the ...
1
vote
2answers
27 views

DB Schema for Dynamic Categories

Added Update #1. Please check at the end of the question. Thanks. Friends, I am designing a Product Listing with categories and filters tied to the categories. I currently have a database schema ...
0
votes
3answers
26 views

SQL Database Setup

I'm setting up a database to run practice management software for lawsuits. When adding people associated with the suit, some of them will be repeat parties (eg lawyers for the firm) and some will be ...
0
votes
1answer
16 views

MySql, date datatype. Query

I have a table called Driver. There is a column called birthDate in date datatype. it is entered as '1995-05-18' YEAR-MONTH-DATE I need to do a query to list all drivers who were born in the years ...
0
votes
2answers
12 views

Ecommerce, storing ordered products with product options

I'm trying to settle on the best way to store an order within the database. Each product can be configured, and not all options are the same. For example: Product A Size: small, medium, large ...
-3
votes
1answer
15 views

How should I go about database architecture for my website

I am trying to make a website for my families antique store (for showings and appraisals). The website is for booking appointments. I understand that there is software out there for this, but I want ...
0
votes
3answers
41 views

Stuck with mysqli class in PHP

I am fairly new to object oriented programming with PHP and cannot figure out why the code below will not work. Any help would be greatly appreciated! public function connect() { $db = new ...
0
votes
0answers
9 views

MySQL with Cocos2d-x

I would like to use MySQL within my application which I am creating using cocos2d-x. Within the Classes directory, I have created a folder MySQL and copied all the files from usr/local/mysql/include ...
0
votes
1answer
13 views

Doing a pattern match MySQL-side before data is inserted into a table?

I'm new to MySQL, and am wondering: Is it possible to make a table check attempted inserts against some sort of pattern match, and reject any inserts that fail to match the pattern, or must this ...
-1
votes
1answer
21 views

Import .sql file via PHP upload

I working on doing a file upload in-order to restore a backup table (.sql format)... The code below is for uploading the .sql file : <form enctype="multipart/form-data" method="post"> <font ...
1
vote
0answers
43 views

PDO Sessions (can't see session variable)

I am trying to create a user login system. I know there are probably some security issues with my code...but I am just learning. I am trying to take the session data from the initial user sign up and ...

1 2 3 4 5 … 927
15 30 50 per page