11,093 Topics
 | |
| | Hi, Can anyone please tell me how to log all activity of my mysql database. Also do you know if there any tripwire services/products that are available ? Thanks, |
| | Hi guys. I have a table as follows: [ICODE] ID | Data ---------------------- 1 | A 1 | B 1 | C[/ICODE] It is possible to make like this one. [ICODE]ID | Data1 | Data2 | Data3 ------------------------------------------------------- 1 | A | B | C[/ICODE] Thanks. |
| | Am having a hard time printing all record percent in my db my sql statement [CODE]$query="SELECT *, duedate,(TO_DAYS(duedate) - TO_DAYS(CurDate())) as difference FROM vehicle_info ORDER by svreg"; //$query="SELECT * FROM vehicle_info WHERE id='$id' ORDER by vreg"; $pager = new PS_Pagination($conn,$query,10,10); $accra = $pager->paginate(); while($row = mysql_fetch_assoc($accra)) { $id = $row['id']; …  |
| | Hi everyone, I'm new to mySQL. I have a table like this one: [ICODE]+-------+-------+-------+ | date | plant | value | +-------+-------+-------+ | date1 | 1 | 10 | | date2 | 1 | 12 | | date3 | 1 | 15 | | date4 | 2 | 30 | … |
| | how can i select all records from a table where a future date column is less than 14 days away within a php table. somthing similar to? [CODE]SELECT DISTINCT FROM table WHERE 'Date_Column' <14 days [/CODE] Thanx In Advance KeeF |
| | Hi, I have attached a printscreen version of my excel template here, Now I just want to know, using vb.net code, on how can I import this data from a specific cell, including the header itself so I can insert it into mysql database. Thanks |
| | I need to select data available between 20:00 and 08:00 (8 PM to 8 AM). How do I achieve this? The column is of type TIME. |
| | how can i rearrange the name by the miles sorting smallest to biggest [CODE] $result = mysql_query("SELECT * FROM directory WHERE category = '$category'"); while($row = mysql_fetch_array($result)) { $latd = $row['latitude']; $lond = $row['longitude']; $name = $row['name']; $theta = $lon - $lond; $dist = sin(deg2rad($lat)) * sin(deg2rad($latd)) + cos(deg2rad($lat)) * … |
| | hi guys. i hav this drop down menu, which i need to populate with data from one column of a particular table of MySQL dbase. i hav read a lot on this, but have not been able to come up wid any code. any and all help in this regard … |
| | Hello, I want to create a favorites option for something I am working on. I have two tables. The main table where the posts are kept called "place". [CODE]+---------+--------------+------+-----+-------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------+--------------+------+-----+-------------------+----------------+ | id | int(11) | NO | … |
| | *********************************************** select * from table_name where RIGHT_CODE IN (SELECT GROUP_CONCAT(''',`RIGHT_CODE',''')as right_code FROM table_name GROUP BY `GRP_CODE` , `ROOT_DESC` HAVING count( `RIGHT_CODE` ) >=2 **************************************************** Actually the above query returns empty result. But the query Inside IN cluase which returns ('1','28').. If i directly pass the value inside IN clause means … |
| | Thi si probably a really simple thing to solve but I am failry new to PHP and cannot find the answer anywhere. I have a search results page that calls data from a MYSQL database. All of the correct information is displaying but one of the fields contains text on … |
 | Hey Im trying to connect to a remote MySQL server running on Windows using a Ubuntu client (via a local IP on the same network) and I receive this: Lost connection to MySQL server at 'reading initial communication packet', system error: 110 I imagine that it is in the host … |
| | Hello, I'm trying to insert values from a form to a table (employee) on my database using prepared statements. From what I can tell the connections are fine, am able to query the database (as shown in the code to check the user type of the current logged in user). …  |
 | Hello, I'm normally pretty good with PHP but since updating to the latest version I can't seem to get most my script's to work. I am trying to pull two variables, from the database and count how many row's there are. [CODE] $query = mysql_query("SELECT * FROM notifications WHERE to='$username' … |
| | Hi, All i want to show is the 'fr_players' to have two categories of 'fr_nations' and 'fr_clubs' and fetch the names from the foreign id... Here what i have done so far but it doesnt shows any error or return any tables either: [CODE]SELECT a.id as club_id, a.fr_name as club_name, … |
 | I have a table in my database and i would like to bring up all the details where the datafield "votes" is the largest. i cannot get the fuctionality i desire. i would like a user to make a choice from the selection then have all the datafield where "votes" … |
| | Hi Guys. I'm having an error "Error No. 2003. Can't connect to MySQL server on 'localhost' (10061)". I am using windows XP in my laptop. Before, I have no problem in using MySQL. I also tried to connect using MySQL Administrator, but I got the same error. Sometimes I can … |
| | Hello everybody, My question is simple. I wish to develop a web site and I have been looking for web hosts and most offer MySql. At my job we use oracle, but after some searching I haven't found any great differences between them and any real reasons why I should … |
| | I have a php wizard for an application that does the MySQL insert but it comes back with an error message, and I can't seem to figure out what. Any help is greatly appreciated. Insert Statement [CODE]CREATE TABLE `{dbprefix}permissions` ( `ID` bigint(20) unsigned zerofill NOT NULL AUTO_INCREMENT, `permKey` varchar(30) NOT … |
| | I'm installing Drupal 6.22 to my host server but when registering the database upon install this is what I'm getting...I'll admit I'm new to coding but a fast learner. Any input is greatly appreciated. These are the errors. Warning: fopen(./sites/default/default.settings.php) [function.fopen]: failed to open stream: No such file or directory … |
| | I have a form which submits comments onto a page. When the comment is submitted I'm using jQuery to submit the variables and then return me a success message. I have also coded a way of reloading my <div> tag which contains a PHP include file, but I receive a … |
| | Hi guys, I have a project that reads a json data and parse it. The program is working properly except that I cannot get its individual rows and view it in separate panels. Here is my code: [CODE] Imports System.Net.Json Public Class Form2 Private Sub Button1_Click(ByVal sender As System.Object, ByVal … |
| | When I type in: "mysqladmin -u root -p" and enter the password I get reset I get the message: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)  |
 | So i was busy playing around with the python module MySQLdb and looking at sql injection. [CODE] import MySQLdb def hack(name): db=MySQLdb.connect('xxx','xxx','xxx','xxx') cursor=db.cursor() sql="SELECT * FROM PLAYERS WHERE NAME = %s" %(name) print sql cursor.execute(sql) print cursor.fetchall() [/CODE] i entered Hack("'pete' OR '1'='1'") results were: SELECT * FROM PLAYERS WHERE … |
| | |
 | I'm working on an auction script for a client. This portion of the script pulls all the open auctions from the database and allows bidding, but they only want bidding on auction with 30 seconds left until it ends. [CODE] $query = "select * from DSI_auctions WHERE closed='0' AND suspended='0' … |
| | My project scope is on android forensic. 1. After extracting all the information from an android phone, the information is saved to an excel file. Currently, I'm trying to transfer all the data saved in the excel file to MySQL database in Java. 2. After which, implement a feature that …  |
| | i want to send the mail , when product got expire from before and ondate and after day, in php i was used datediff mysql function with php, but if product expire date comes like 31-1-2012 , the differ value is not suit for my coding , plz help how … |
| | I have written a small query. I want to create link on my php site which on click will run this script automatically and export results to an excel file. I dont want to create a page to view the results. Any help to this new bie will be very … |
| | Hi all! Can anyone help me on finding out if it is possible to fill an iframe in a jsp loading text from MySQL? or a different way to do it? Thanks in advance [CODE] Example: <% Connection conn = null; Statement stmt = null; ResultSet rs = null; String … |
| | this my new syntax for my new website [CODE] echo "<li class='childmenu'><a href=#equipment?id='".$row['id']."'>".$row['name']."</a></li>"; [/CODE] and this is the old one for my another website [CODE] $isi .= "<li><b><a class='topikMenu' href=reset/survey.php?id=".$row['kodetopik']."><span title='".$row['jumlahpenyurvey']." surveyor'>".$row['namatopik']."</span></a></b>"; [/CODE] I think it's same concept about give the $row[''] in the middle of html syntax, but I … |
| | The attached image is the example of .xls file that I want to import those data to mysql database using Java. Any help I get will be very much appreciated. |
| | Hi There are two tables. Cities and Countries Countries have Id, Country name and Short Code (Id is primary key) Cities have Country_Short_Code, City and Populations. (city is indexed) There are 5000 records maximum to be processed. PHP will give 5000 city name and its country. What is the best … |
| | Hey guys.. i need some help.. lets say i have a table and i have a column called 'brand'. Then for each record, for brand name i put say Nokia, Apple etc. i want it so that i can create a php page that displays records with only brand = … |
| | I have two table named:[B] Blog[/B] for displaying blogs post and [B]comments[/B] for displaying comments section for each blog post. The fields for these are as follows: [B]For Blog:[/B] 1: blog_id 2: title 3: body 4: author 5: updated [B]For Comments:[/B] 1: comments_id 2: username 3: email 4: comment_body 5: … |
 | I found a way on how to code the backup for mysql database table. but I was wondering on how PMA(PHPMyAdmin) does this scenario on backing up the sql file. the one that has AUTOMATIC download to your machine. this is the simple syntax I made myself [CODE=PHP]<?php /*TOOLS YOU … |
| | Hey How do I mirror a entire database to another server? Federated tables arent a option in this case as I need foreign keys. Thanks |
| | I want to make option to approve users before they can login or to ban them, here is code [CODE]<HTML><HEAD><TITLE>Fakultet informacionih tehnologija</TITLE> </HEAD> <BODY TEXT="#ffffff" BACKGROUND="fakultet/Assets/bg.jpg" LINK="#FFFF00" VLINK="#CDCD00" BGCOLOR="#000000"> <CENTER><TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH="700"> <CENTER> <FONT SIZE=+4 FACE="arial,helvetica"> Fakultet informacionih tehnologija <HR> </CENTER> <?php session_start(); // dBase file include "dbConfig.php"; … |
| | Hey Im going to use some federated tables that I need but I know that the engine does not support foreign keys. Im thinking of alternatives and this is the one so far: Tables from the remote side and related related with a foreign key on the local side. Its … |
| | hi.. This is form validation code..im getting errors.. 1. I have to check whether all the field r empty and for certificates,photo,biodata field shud be validated for type,size,whether field is empty.. 2. how to validate the datepicker i used javascript <?php session_start(); if(isset($_POST['Role'],$_POST['Name'],$_POST['datepicker'],$_POST['gender'],$_POST['activity'],$_POST['Address'],$_POST['Photo'],$_POST['Biodata']$_POST['certificates'],$_POST['Salary'])) { $errors=array(); $Emp_Save=$_POST['Emp_Save']; $Emp_Cancel=$_POST['Emp_Cancel']; $Role=$_POST['Role']; $Name=$_POST['Name']; $datepicker=$_POST['datepicker']; … |
| | Hi all! Does anybody know a cool and cheap site where I could host my web application (jsp+Mysql)? Thanks in advance! Kind Regards |
 | I have very limited use of using MySql - but I am trying to fix this code and it seems to be corrent. But I am still getting the error. The website is a web directory, and the code itself checks to see the websites that arent linking back to … |
| | highlight listview item from mysql search statement then get the index  |
| | I am currently using MySQL so people can send my a message that shall be stored in the database. The only issue is I have no idea how to protect against SQL Injection, below is my HTML: [CODE]<form action="Action.php" method="POST" /> <p>Name: <input type="text" name="Name" /> </p> <p>Comment: <input type="text" … |
| | Hi I am using the fallowing code to give some information back to the user after running some queries. The information will be displayed in row only. [Code] $result1 = mysql_query("SELECT * FROM bookings WHERE bookingID='$last_insert_booking_id'"); echo "<table border='1'> <tr> <th>ID</th> <th>Firstname</th> <th>Lastname</th> <th>address1</th> <th>address2</th> <th>town</th> <th>postcode</th> <th>telephone</th> <th>email</th> <th>Arrival</th> … |
| | Hi Please take a look at my code snippet. Works fine, however I don't know how to get the number of rows returned so that I can handle it accordingly. Any ideas please? [CODE] <?php require ('mysqli_connect.php'); // Connect to the Db. $sql = "CALL customers_for_rep(?, ?)"; $stmt = $dbc->prepare($sql); … |
| | Hi.. this is code to display the datas from db to web page .. im not getting the outputphp,mysql <?php $host="localhost"; $username=""; $db_name="dbname"; . mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); $query="SELECT * FROM database"; $result=mysql_query($query); $num=mysql_num_rows($result); mysql_close(); echo "<b><center>List Of Employees</center></b><br><br>"; $i=0; while ($i < $num) { … |
| | Hello How do I go on about calling from Java stored procedures (which have variables going in and out) and transactions in MySQL? For a stored procedure example, something like 2 variables in that are numbers and the third going out that is the result. Thanks |
| | Hello Using MySQL, I have DB 1 with table T1 on Server 1 and DB 2 with table T1 on Server 2. Not on the same network and T1 contain the same columns with the same datatypes. I want to create a trigger on DB 1 so when there is … |
The End.