MySQL is an open-source, relational database management system.
0
votes
0answers
4 views
Creating connection pool with Java JDBC Connector/J
I want to learn how to create a connection pool in Java. I followed the Oracle Tutorial. But I could not understand their example. Can someone please explain how to create a simple connection pool.
...
0
votes
2answers
21 views
Running MySQL from command line
I have very recently installed MySQL using Zend Server in an effort to learn PHP and MySQL.
Installation went perfectly, however I installed it in my E: Drive as opposed to installing it in C drive. ...
0
votes
0answers
9 views
get top 10 records from db and record from current log in user
i have table which consist of some data , just i want to show the top 10 ranks from that table and at the last column i want show the rank of the user who login to application.
example
rank | name ...
-1
votes
4answers
19 views
unable to fix mysql_num_rows error message
i tried to count num_rows using the mysql_num_rows funtion, i keep getting an error. my query has no error. what could be the problem
<?php
if(isset($_POST['search'])){
$search = ...
0
votes
3answers
16 views
Submitting form error
The error shown is:
Parse error: syntax error, unexpected '"' in C:\Abyss Web
Server\htdocs\addemail.php on line 11
Using a basic HTML form, and the following php:
<?php
$dbc = ...
-5
votes
1answer
20 views
PHP substract to mysql
I have site and ordering form
<form action="aaa.php" method="post">
Name: <input type="text" name="meno"><br>
Surname: <input type="text" name="prie"><br>
City: ...
0
votes
0answers
7 views
Importing a SQL db into mysql using the terminal
I'm struggling to do this.
I have created a new database in the terminal called "somedb" using
CREATE DATABASE somedb
On my desktop I have the SQL dump downloaded from phpMyadmin: somedb.sql
I ...
0
votes
0answers
5 views
User submitted content to mysql with moderation: separate table?
In an mysql table I would like to get data from user, however the data would need to be moderated by admin first. My question is that is it normal to just insert into the original table and use a ...
0
votes
1answer
14 views
Merging two select queries and displaying first queries record in top
I have one query result having data in lastName column as below
Select * from department where departmentid in (1,2)
DepartmentID LastName
------------ --------
1,2 A
2 D
1 ...
0
votes
1answer
24 views
Insert data into MYSQL using jquery modal form
I have a page shown below that displays a list of user records from a database with a button. When I clicked on that button display a jquery modal form with a form that allows someone to enter their ...
0
votes
0answers
6 views
Issue with trigger
Hi I have created a Insert trigger but it is inserting duplicate values
CREATE TRIGGER sdata_insert AFTER INSERT ON amconsole_access
FOR EACH ROW
BEGIN
INSERT INTO user_deprovision (UserName, ...
1
vote
1answer
30 views
Undefined Index with PHP code
( ! ) SCREAM: Error suppression ignored for
( ! ) Notice: Undefined index: q_sold in C:\wamp\www\aaa\mup.php on line 93
Call Stack
# Time Memory Function Location
1 ...
0
votes
0answers
5 views
Cakephp sql Update: add up old field value with value from form
So I am relatively new to the MVC world. What I am doing at the moment is rewriting a php project in CakePHP2.0. Currently I am working on orders, more specifically the delivery of products/stock.
...
-1
votes
2answers
32 views
If the price is promotional, check if it is lower than original price
The goal
Within a list, I need to get the lowest possible price for each item.
The problem
To get the lowest price of a product, I'm using this:
ROUND(CAST(MIN(`map`.`Product_Original_Price`) AS ...
0
votes
0answers
11 views
Extended breadcrumbs with PHP
I took some code from another answer to get a very simple breadcrumb on my website. It works ok but what I need is to extend it to include more than just the home page and the current page.
currently ...
