smantscheff

Here is a basic question, what is the fastest way to transfer a MySQL database? Here are the variables at play: 1) Database is just shy of 3GB 2) Transfer is between two servers running different versions of MySQL 3) There will not be usage of the database during transfer, …

This is the code to delete image in a folder... [CODE]<?php $path = "uploads"; if(isset($_POST['file']) && is_array($_POST['file'])) { foreach($_POST['file'] as $file) { unlink($path . "/" . $file) or die("Failed to <strong class='highlight'>delete</strong> file"); } header("location: " . $_SERVER['REQUEST_URI']); //redirect after deleting files so the user can refresh without that resending …

I have a Yahoo website that uses phpMyAdmin. I've been given the directive "Please run the script mysql_fix_privilege_tables that should be included in your MySQL server distribution to solve this problem!" I do not know how to run this script (or any script) through phpMyAdmin. I've been looking online and …

Hey everyone. First I'd like to say this is a great community and seeing as I've finally started attempting to learn PHP I decided I'd finally sign up for all of the current and future help I will need haha. Okay well I'm currently setting up a website for my …

Ok, what I'm trying to do is have next and prev buttons to navigate through a mysql database sorted by date. Currently, the code I wrote does this, but gets stuck on duplicate dates. $Next = mysql_query("SELECT * FROM $logbook WHERE Date>='$Date' AND ID!='$ID' ORDER BY Date LIMIT 1"); $Prev …

Hi All, While going through my project work, I just came across a situation, where I needed to alter my table. I needed to add a column at the beginning of the table, i.e. the first column of the table. We have syntax for appending a column to a table …

Hey I want to make a backup and restore of a MySQL **SERVER** to another machine. Please note the **SERVER** part; I want to backup/restore datebases, tables, procedures, users, configuration, etc....**EVERYTHING** What is the best way to do this? Thank you

Hi frens, I have already asked this question in another thread, but then felt this issue was irrelevent to that thread. I have a requirement to generate a invoice in pdf format and download it. i have a dynamic form, where user can enter date, choose option from dropdown, add/remove …

Hi, I would like to know how to export my schema WITH the table rows/content into a .sql script in MySQL (If it's possible). I tried using Forward Engineering with MySQL Workbench but when I select "GENERATE INSERT statements for Tables" it doesn't do it... I tried googling and finding …

I want to add text string at the end of the text file. I used "a+" for it but it delete all the content and than enters text to it. So please help.

Hey everyone! I have a members.php page/file in which i want logged in users to see the other users registered in the database. I'm not exactly quite sure how to do this and I'm struggling quite a while now with this so your help will be VERY much appreciated. I …

I have a javascript login box on my site ([url]www.cigardig.com[/url]) that a user can click on and login on any page. The way I would like it to work is that once a user hits submit, they are redirected back to the page they logged in on. So, for example, …

My school has an apache/mysql server that we make and host websites from as projects. I am doing an ebay type site where people bid on a product until time runs out. Problem is I don't know how to trigger that the product should be delisted and the buyer and …

Hi, I have a table and I need to write a SQL to limit the resulset set based on 2 conditions, by IP and out of that resultset, remove the rows which have nothing in 2 columns. So I have tried this but it's not producing the expected results: SELECT …

So I just started learning MySQL. I am learning from [Tizag](http://www.tizag.com). They are using PHP files. Now I can see that the PHP files are slightly complex, I'm only 15. And they also recommended PHPMyAdmin. This GUI tool has many complicated options. So I quite don't know what to use. …

Hello, I have problem with entering default values in MYSQL database. When i insert new record using phpmyadmin it works fine (empty fields get default value), but when i use the same query in my application (written in PHP), empty fields in html form don't get default value in MYSQL …

Okay, I am a total newbie stuck with the following task. I have one table, that looks like this: | id | name | rating | date | ------------------------------ What I am trying to do is gettin an output showing which 'name' has the best 'rating' based on months, showing …

Hi all. i would like to have fulltext search in my news site. I have added fulltext to the **text** column in my news table. but though it cannot grab two or more phrases at a time from database. the engine is MyISAM. what might be the problem? if possible …

Hi All... I have a simple table with 2 fields in it... mem_id and ref_id For each mem_id in the table, there is an undetermined number of ref_id records... How do I get a listing of the unique mem_ids along with a number that represents the number of records with …

I need to pull info from 2 tables using LIKE but also paginate the results. Table 1: publication Search by tags Need ID to search table 2 Table 2: publication_issue publication_id = publication.id <?php $query = ("SELECT * FROM publication WHERE tags LIKE '%news%'"); $result = mysql_query($query) or die(mysql_error()); while($row …

Hi everyone, just wanted to know what type should i use in mysql database to store the urls (for linking purposes) of videos(from youtube,vimeo) and slides (from slideshare)...i just want to store the urls not the whole video..for tht i wud use directory/ file functions.. please help... helpful comments will …

Hey all, I'm new to MySQL and never took a class in it. I have two questions. 1)) Can anyone suggest a good book to learn MySQL quickly. 2)) Can someone tell me how to set up a database that contains user accounts that can then be linked to other …

Hi I have looked around to see if it is possible to automatically delete records with a date field once that date is in the past. Everything I have found just gives the script but you would have to run it every day. Is there a way to have it …

Hi All, I want to generate time table reports. A form includes labels to enter grade, class and stream. After selecting data user should click on "Generate" button and relevant time table details. The data is submitted for the following page and there was an empty set of data shown …

Hi guys, i'm new here. First of all, i'm from Argentina... So maybe my english is a little crappy I'm developing a page with login. I uploaded it to a hosting with no poblem... But when i want to create a stored procedure an error appearse. I've searched on web …

i created database in mysql along with 3 tables but when i opened C:\ProgramData\MySQL\MySQL Server 5.5\data then i found on .frm files and a single .opt file so where is my originalo datbase and data ? my datbase name is kustkht

i have tblStudents and tblDepartments, so which keys a weak entity (student_department) would have ? studentid and departmentid ? is it so ? and both foreign keys will work as a composite primary keys ? is it ?

is it possible to run mysql and ms sql at one pc ? mean local host ?

I have no issues with the query in the below code. But the second code is throwing the error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Working code …

Hi All , I need to get multiple result from same table my table structure is id category parentid 1 dress 0 2 men 1 3 mtshirt 2 4 women 1 5 wtshirt 4 If I give wtshirt it should produe result as wtshirt-men-derss how can I write query for …