[mysql] Forum Topics

We have various databases on several offsite locations and we want to do a backup to here. Problem is that database is problably going to weigh GBs of data so it would be better to split it into several "files" so we can only get the updates in small amounts. …

I' ve converted mssql database to mysql database (locally). I ve created a free subdomain and found a free webhoster on 000webhost.com. I m trying to import my mysql database onto the server using phpmyadmin interface but am unable to do this. I get the following error-->#1044 - Access denied …

<?php include ('pages/dbconnect.php'); $rekdep=mysql_query("SELECT * FROM t_org ORDER BY dept, com ASC"); echo "<table class='gridtable'>"; echo "<tr><tr><th> Departement</th><th> Commune </th><th> ORG </th><th>Animal</th>"; echo "</tr>"; echo "</tr>"; $odl_dept = null; $odl_com = null; $odl_org = null; while($dep=mysql_fetch_assoc($rekdep)){ //List of department if($dep['dept']!=$odl_dept){ echo "<td>".$dep['dept']."</td>"; } //display blank td if the same department …

I heard about decision making system like crystal report and I want to know how to implement CR with PHP? I have some basic knowledge about PHP,Mysql and Wordpress.

Good Morning All, I'm about to write a script that will actually be run in a CRON job weekly. I created an overview of the process so you would understand what I'm doing but I have questions with 2 of the MySql queries that will be required, and wondered if …

Please help. How to connect vb6 to mysql. What are the codes? Thanks.!

Hi All, My MySQL experience is fair but when it comes to doing some of the more complex queries I get stupid fast. That said, in the past, I have written queries that INSERT data to the DB based on clicks. In this case I want to use the same …

Want to remove everything after the .com address in a mysql table ... Suppose Sample Before: domain.com/friend Sample After: domain.com

hi Team, i am facing 1067 error while starting My SQl service in windows. share your suggestions for this request. OS: windows 7 pro 64bit AV: Symantec 12.14013 Thanks Shiva

I have pairs of hex digits that I want to convert to char. What is the best way to do it? Thank you

good evening people,i'm creating an application where i'd like to import and save a list of people in an excel sheet to my database in mysql, using php, And i'd like to modify it through a form using php! Can anyone have an idea or something which will help me …

halo sorry i distrub a i like to ask about vb and MySQL project

hi ! i ve just started doing mysql. i am making a web application in which employees database is reqiured to be shown in the table. i ve made a database name "educrm" and table name is "info", which i ve done in mysql through xampp(phpMyAdmin). i am showing u …

I have a list of id like this from mysql JM.1 JM.2 JM.2.1 JM.2.2 JM.2.1.0 JM.2.1.1 JM.3 ... ...etc I want to make a display as well JM.1 JM.2 ---JM.2.1 ---JM.2.2 ---------JM.2.1.0 ---------JM.2.1.1 JM.3 ... ...etc How to display using PHP and How To using CSS like that, Or is …

Hi I am trying to convert the following mysql function to mysqli. Thanks in advance David <?php /*------------------------------------------------- This class contains generic database functions to view, add, edit and delete all facets of a database -------------------------------------------------*/ require_once ("sitesettings.php"); class Database extends SiteSettings { var $Query; var $Connection; function Database() { …

Hey guys, I'm trying to start a yes/no vote div which, when clicked, increments MySQL entry either way. I've seen several examples of how to do this type of thing online, but can't seem to grasp this process on my current layout. I'll show a little as possible to not …

In my new project I decided that I will use RedBean ORM system with Codeigniter PHP Framework. How can I get all records from table with simple relation? I know, that I can use R::exec or R::getAll queries but I want to make sure if there any other solution(s). TABLE …

Hi all. sory but im beginner on web creating. I need create catalog. first page i need create item add form. after page i need create items catalog. all on mysql sory for bat English :) who can help me. i have login register index pages.

I am trying to code a mysql query that will enable me select and insert multiple vaules from one table to another table in the same mysql database. I want to automatically populate the values from my id,levy from my tb_residents into table 2 resident_payments uid , rate . I …

I can't seem to get a response from my query method. I have a database connection from method ping_server and use mysqli as connector. Can anyone help me figure out why I cannot print results from mysqli_fetch_array. dbclass.php class db { private $connection; private $selectdb; private $lastQuery; private $config; function …

i have a checkbox to show the below contents. how can i store the value of checkbox whether checkbox is checked or not and i have to get the value when checked any one suggest me am beginner to php

can anyone help to check my coding? what i need is to enter the groupcode and when i click search,it will retrieve all the modules. but only one module that appear instead of all. <?php $server="localhost"; $username="root"; $password=""; $connect_mysql=mysql_connect($server,$username,$password) or die ("Connection Failed!"); $mysql_db=mysql_select_db("reportdatabase",$connect_mysql) or die ("Could not Connect to …

Please can someone help me optmize this query, it is slow and brings the same data for the debtage column SELECT customer.custid,customer.compname,customer.phone,customer.depot,acctofficer.acctfullname AS acctoff, STR_TO_DATE(mastorders.lastsuppdate,'%d-%m-%Y') AS purchdate, STR_TO_DATE(transactions.timestamp,'%Y-%m-%d') AS debtage, format( customer.balance, 2) AS balance, customer.balance AS balance1 FROM customer,mastorders,acctofficer,transactions WHERE customer.custid=mastorders.custid and acctofficer.acctoffid=customer.acctoff AND customer.depot='$depot' GROUP by customer.id ASC. …

Hi, I am trying to insert data into 3 tables using mysql.. At first, I was able to insert in the first table (staffinfo), after coding for the second table insert (empinfo), It inserted into second table without inserting in first table AND finally it echoes 1 record added Successfully …

Raffle function to generate unique numbers for each player, related to the same table with a recursive aproach. I had to do a simple raffle system for a contest that I was working on and tried many things and the most simple and the most effective one to generate unique …

I want to get the max(id) from a table colum with variable characters. it always returns 999 as the highest yet I have values like 6008 or even over 10000. I have tried the following: 1. SELECT Max(column_name) from table_name where column_name REGEXP '^[0-9]+$' 2. isNumeric as one of the …

Hello, I have looked everywhere on the web for a solution to this problem. I am trying to store arabic characters into mysql via an html form. i have set the meta charset to utf-8 and have tried mysql_query('set names 'utf=8'") but still i get garbled characters in my table: …

Hi all, I need to do my own version of phpMyAdmin for my php class. I encountered problem when trying modify existing data on database. I don't know what would be best way to modify whole table's data when I don't know exact amount of rows or columns. At this …

I recently upgraded MySQL 5.5 to 5.6 because I needed some features but now Im not sure which my.cnf 5.6 loads... I try editing the my.cnf in /etc with some lines such as "port=hello" but it still loads and starts correctly. How can I see the exact route of the …