[mysql] Forum Topics

Hi, I'm new to coding (anything) and my manager has tasked me with developing a stats page for the IT dept. trouble ticket system (php helpdesk by EXOScripts.com)(MySQL database) I have laid out the table on the page but just need to populate it. the table has the following coloumns …

Hi, I get this error in my myPhpAdmin in WAMPserver 2f. [code]#1045 - Access denied for user 'root'@'localhost' (using password: NO)[/code] How can i solve it?

Hi I am trying to set up remote access to mysql on a headless server. From what I have read this can be done by installing phpmyadmin on the client pc. Is this all I need? I have changed the entry in my.cnf "bind = localhost" to "bind = ipofserver". …

Hi, I'm trying to create a database that stores shoes. Each shoe must have more than one size so I have created a table "mens_boot_test" with a field "size". In the size field I have an integer which holds the delimited values 1,2,3,4,5,6,7,8,9. I'm then trying to retrieve these values …

Hi, i've been trying to make a simple login script php and have come across these error messages Notice: Undefined variable: pass in /var/www/vhosts/numyspace.co.uk/web_users/home/~unn_t013534/public_html/adminlog.php on line 15 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/numyspace.co.uk/web_users/home/~unn_t013534/public_html/adminlog.php on line 18 The code i've used so far is: …

Hello, Lets assume that I have the following four tables in my database: Magazine: mag_id (primary key) name (Nature, Time, etc) cat_id (reference to Magazine_Category.cat_id) Magazine_Category: cat_id (primary key) category_name (Weekly, Monthly, etc) User user_id (primary key) user_name Subscription user_id (reference to User.user_id) mag_id (reference to Magazine.mag_id) Now I wish …

Hi All I'm new here and have searched high and low for an answer to my problem, and have so far had no joy. I am trying to create a if/else statement depending on the outcome of a SQL command that should be extremely simple and basic, but for some …

Hi, first of all Hi to all members. i have a shopping portal in which we data coming from different merchant on web of there products in CSV format. the CSV of the product come in standard Structure from all the merchant. we get these CSV at same time schedule …

Hi folks, I’m planning on building a site somewhat similar to a web hosting directory and was hoping to get some input/advice on the database design from all you coding gurus :P I’d like to have two different types of users: 1) hosts 2) normal users Because of the this, …

Hi guys, i have a big problem, hope you gurus in MySQL can give me a hand. I installed the following package in 2 servers that have all in common except that the server A is in a Domain, and have SQL SERVER 2005 installed. The package installs with no …

I'm trying to construct a sql statement to check 2 tables. Here's what I am trying to do. tableA - is a list of fruits (fruits) apples bananas pears grapes orange table B - is a list of fruit combinations (fruit_1) (fruit_2) apple banana orange banana apple pear I want …

If i wanted to select certain columns in 2 different fields would i Do [code=sql]'Select "Column Name1, Column Name2 from "Table1" INNER JOIN "Table2" ON "Column Name1, Column Name2"[/code] Obviously i'm using column name and table name as an example so would using Inner join be appropriate, if so am …

hi, to all... im coming up with mysql codes...i have to come up with a command where reports which r produced is to be printed according to business needs, for example, clients, managers and clerk..im trying to use the 'select' to code this command,but it doesnt work. so, i tried …

Hi I have two tables that I want to use to build a third. They have a many-to-one relationship for one of the columns. Table A has the "one" side of the many-to-one relationship. Table B has many rows that have foreign keys referencing Table A. I want to write …

I'm not new to php, but, I'm not a great coder either... I'm not too familiar with sessions and session variables. I have been tasked with building an online "management" system for the eLearning we're offering. We have one .swf file for eLearning currently, but, have 23 in production so …

Hi, I am trying to build an SQL statement for a reporting tool, the idea is to count from multiple statements and group my output by date, I've also learnt that GROUP is an intensive statement - 'not sure' again. I'm a newbie to PHP so please help. I just …

Hi All, I am mysql newbie. Please have alook at this querry. [code=sql]SELECT b.date as date, a.tirthankar_name as tirthankar_name, a.kalyanak as kalyanak FROM table1 a, table2 b WHERE a.mass = b.mass AND a.paksh = b.paksh AND a.tithi = b.tithi AND b.date BETWEEN CURdate( ) AND (CURdate( ) +9) ORDER BY …

Hello, I need to select data from 3 table simultaneously in one query and i can't get iti work...please help if you can. Thanks in advance! my tables: [ICODE]mysql> describe produse_ofertate; +-------------+-----------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+-----------------+------+-----+---------+----------------+ | id | int(6) …

hi all..i need help. I have this Supplier table with fields:supplier_num(key),supplier_name,supplier_address,etc.then supplier_TIN. In this table many suppliers have same TIN number but with different supplier_num. what I need to do is: Get the all the data from all the suppliers with distinct TIN number. With those having the same TIN …

I have a query which works in MYSQL 5, but doesn't work in MYSQL 4.. anybody ?? [CODE] SELECT DATE_FORMAT(DATE_ADD(DATE_ADD(CURDATE(), INTERVAL 0 - '52' WEEK), INTERVAL 2 - DAYOFWEEK(CURDATE()) DAY), '%v') as date, DATE_FORMAT(DATE_ADD(DATE_ADD(CURDATE(), INTERVAL 0 - '52' WEEK), INTERVAL 2 - DAYOFWEEK(CURDATE()) DAY), '%Y%v') as date_ordered [/CODE]

i created a new user with all the privileges in mysql and it didn't work. no user works except "root with no password" which is why i created several user and tried it...still didn't work....if anyone know what is wrong....please lemme know.... thank you....

In my mysql table there are following values: ID (unique)(Auto incre.) INI URL Name DeprSize Dept. Location Knownsince MeetingNotes The php queries are 1) SELECT * FROM `dep1` WHERE `INI` 2) SELECT * FROM `dep1` ORDER BY `dep1` .`Name` DESC And the sql indexes are: ---------------------------------------------------------------------------- Keyname Type Cardinality Field …

How do I analyze all tables in a database?

Im a newbie at this stuff, so could someone please post how to alter a table so that i can make a field called numbers to be auto incremented. I dont know how to do this please. The table is called blog. Or can you post how to setup a …

I have a column "ID" in a table, and I need to move that to another table in the same database. How do I do this?

Hi all, I'm creating an appointments scheduling system. I have a bookings table and a time table among others in a MySQL database. Each entry in the bookings table has a slotId value. In the time table each slotId has a startTime and an endTime. This is what i want …

Hi Friends, In the website in which i am developing for every searches made an entry would be made in a table. As a result of this the size of the table grows to great extend. Now i am planning to take the backup of that table periodically and to …

Hi, I have an ms-access database (.mdb) which I need to import to mysql. Is there a free software to make a .sql dump of this ms-access database? I have been trying some softwares (google searched) but none of them worked. One of them was able to replicate the table …

Hi all. I have a table with a this records: [CODE] <!-- Table user_activity --> <user_activity> <id>1</id> <event>LOGIN</event> <username>user@domain.com</username> <domain>domain.com</domain> <remote_address>ip_address</remote_address> <date>2008-05-23 20:19:36</date> <comments></comments> </user_activity> [/CODE] I am trying to query the DB to get the total results of activity PER DAY. This is my query (which obviously doesn't work): …

Hello i am trying to generate mysql reports. I have them working but my problem is: i want to happen is when u click an option value e.g. list customer details, i want it to generate the report automatically. Here is my code below it is all correct i just …