MySQL is an open-source, relational database management system.
0
votes
0answers
3 views
Dynamic image gallery with editable captions
I've created a website with three different slideshows. I'm using the jQuery Cycle Plugin for the slideshow, but as far as this question is concerned, the slideshow is basically just an unordered ...
0
votes
0answers
12 views
MySQL query returning null (Advanced)
select sum(c.cost)
from (select x.num as x, y.num as y, max(priority) as maxpriority
from numbers x cross join
numbers y join
costs c
on x.num between c.x and ...
0
votes
1answer
23 views
Search engine only single return?
Hello everyone i made a simple search engine but there is one problem with it, when i search a string my result is only one line what did i do wrong i can't find it for multiple results.
Search.php:
...
0
votes
0answers
11 views
How to openssl passwd -1 in C# against MySQL
I am making one extension for iRedMail server, I want to add new user using C# code.
IrerdMail holding users inside MySQL database, passwords of users are encrypted using openssl (MD5).
When I look at ...
0
votes
1answer
26 views
Displaying php code from mysql database
I am trying to use https://github.com/laukstein/ajax-seo for my website. Basically, it is a one page website that loads content from other pages without refreshing the page. ...
0
votes
3answers
26 views
SQL Query Grabbing data from two tables
My code right now is this
$extract = mysqli_query($dbc, "SELECT * FROM items");
$numrows = mysqli_num_rows($extract);
while($row = mysqli_fetch_assoc($extract)) {
$id = $row['i_id'];
$iname = ...
0
votes
0answers
10 views
MYSQL UPDATE date field not working
Why won't this work:
USE presentations_db; UPDATE presentations_tbl SET `date` = '2012-12-13' WHERE `date` = '2013-12-12'
I have tried everywhere I could and can't find an answer.
date is the ...
0
votes
3answers
14 views
How does this query with HAVING MAX actually works correctly?
I have 2 simple tables: students(sno,sname,age) and take(sno,cno). Take is the table of a N-N relationship between students and courses.
I want to find students NOT taking a specific course.
The ...
0
votes
0answers
15 views
Encoding error PHP and Mysql for french
I have a function that adds words in my database and for some reason it's putting them in all weird.
Here is my function :
function change_team($picname, $text){
include 'dbconnector.php';
...
0
votes
1answer
14 views
Updating certain columns in a mySql table?
Hello I am new into PHP and Mysql - well I am developing an android app that will retrieve some user data from a server mysql db table - data like username, firstname, last name, addresse etc..and the ...
android
0
votes
2answers
27 views
I can't insert data in my db cause of an empty primarykey
I'm new to PHP, MySQL and working on an project for my school. I need to make a form that inserts new students into a database.
I need to have an primary key named studentnummer so I can use this ...
1
vote
0answers
18 views
C++, Linking MySQL with visual studio 2010
I’m trying to make a C++ application that can connect with MySQL. I have some troubles with linking. Visual studio 2010 can’t find the MySQL functions.
I recorded a video where you can see my ...
0
votes
1answer
39 views
JPA @OneToMany results empty
I'm trying acces a MySQL databese through JPA, but the result is always empty.
public class Part {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private long id;
...
...
1
vote
1answer
7 views
MySQL Global Triggers for a connection
Is it possible to create a trigger that will listen for any insert or update for one database connection/instance (all schemas)?
Here is my business case:
I have multiple schemas on one MySQL ...
0
votes
0answers
5 views
Search titles does not work with OSQA on Windows with MySQL - how to resolve?
With OSQA installed using IIS and MySQL, tag search works, however questions search does not. All results show blank.
I read through this post and this one, but I don't see an actual solution. If I ...
