10,946 Topics
 | |
| | 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 …  |
| | Can someone help me, I was getting an error message about SQL syntax, now I get no error message, it redirects, but database does not change. I also made sure autocommit was enabled. Any ideas? [code=jsp]<%@page import="java.sql.*,java.util.*" %> <% Connection conn = null; PreparedStatement stmt = null; String userName = …  |
| | Im doing a login facility for my website iv connected it to the database but when i try to enter some values for login name and password i get the following message: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/milkitshakeit.freehostia.com/log.php on line 16 Here is … |
| | hi, im doing a project on 'courier management systems' . i am using asp.net as the application and mysql as the database. im not clear on how to integrate mysql with asp.net... i would appreaciate if some description plus some examples are posted on...thank you |
 | i am makin a simple account creation screen for my website and i have an error: Error: No database selected and i dont know why im getting this because i have used mysql_select_db(), heres my code: [code="php"] <?php $con = mysql_connect("localhost"); if (!$con) { echo "Could not connect:" . mysql_error() … |
| | i am doing a prioject on 'courier management system. im planning to use asp.net and mysql...is it appropriate? if i do choose these languages...will i sustain? |
| | 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 … |
| | ok so the code inserts into the database a default status when the user sign ups. But I get an error saying: 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 ''status' ) Values(`asd.asd`, … |
| | I want to put image uploading in my page and i searched all over the net for some ways on doing this and its seems like almost all of the ways states that i should save it in the database itself not i directories. Will the image retain its properties … |
| | 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 I had a login script in php, Mysql. Users can make their accounts and they can add their property in my database. I need to do a mail to all of the other users when an user add a property. Kindly Let me know about the script. I had … |
| | 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.... |
| | good day.! I am currently developing an enrolment system which will be on february 12-13 the deadline. In the middle of development, the client wants that on every link the pop-up info to be display on that link will be from the mysql database. Assuming that i already have a … |
| | Hi I have been searching everywhere including daniweb about retrieving image paths out of a mysql database and outputting them as images on the page using PHP. Does anyone know of a good tutorial that will help me do this. Thanks Studio |
| | 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 …  |
| | I have a script which uploads image in a folder then then path to the database. it works well. the problem is that i can`t display the image using the path. [code=php] <?php $sql=mysql_query("SELECT path,user,date,filename FROM picha WHERE user='peacemaker'"); $row = mysql_fetch_array($sql); $user=$row['user']; $filename=$row['filename']; $path=$row['path'];//here you get path where you … |
| | Hello, can someone tell me how can I output all fields of a row in a mysql db using php? and then write.  |
| | |
| | Hi All I am trying to create a page to delete records from a database, but i cannot seem to get the right code in hereunder please find my code [code=php]<?php require_once('Connections/conn.php'); ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = get_magic_quotes_gpc() … |
| | 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 I have a simple Table (Table1) with 3 fields (ID, Date, Value). So if I query the DB for a certain date it lists the ID and value of all rows with that date. What I need to do is have a checkbox next to each table row and … |
| | 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 … |
| | [QUOTE=newtonorina][QUOTE=masijade][QUOTE=newtonorina]Am new in the programming sector. I have a task that requiires me to join a java interface to mysql but I don't know the code to do that. Can you please help.[/QUOTE] [url]http://dev.mysql.com/doc/refman/6.0/en/connector-j.html[/url] Next time start a thread.[/QUOTE] I just wanted a small program in Java for eaxample that … |
| | Hello, I am trying to insert values from a .csv file into a MySQL database from a GUI. I cannot seem to accomplish this. I keep getting a null pointer exception where I set the connection properties in my main method. I also cannot seem to figure out how to …  |
| | 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 … |
| | Hello! Im new to PHP and have a need for what I have found out is called AJAX. I prefer to code in PHP for my DB access. I need to create a dropdown list using AJAX that updates it self depending on what is slected in the parent dropdown … |
| | Hello. I have a php script that is pulling records from a database. Everything up until now has been working great. Even now the first page of results show up as they should. (5 records are displayed per page) When I click on "next page" to view more results I … |
| | ok so here is the error:[ICODE] 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 'from, content, date) VALUES('', '', '', '')' at line 1 [/ICODE] Between the apostrophes is the information from the …  |
| | I'm not nearly as advanced as most of you so please respond to me like I'm a fourth grader. :) I need to see what a password is in my cpanel. I don't want to reset it or change it. I just need to see what it is because it's … |
| | hello i have the following code [COde=php]<?php mysql_connect("localhost", "lekan", "") or die(mysql_error()); echo "connected to database"; mysql_select_db("today") or die(mysql_error()); echo "Connected to database<br>"; $tables=mysql_list_tables("today"); if ($tables ==""){ echo "this database does not have a table"; exit; }else { echo $tables; } //number of rows $row_num = mysql_num_rows('first name'); if (!$row_num){ … |
 | I am working on a project that requires a MySQL database to store important information (So a little security would be nice). I realize that some users can't find or don't have MySQL databases with their hosting accounts. I would like to provide users with the ability to get a … |
| | hello I've got two tables that I want to be connected(let's call the A and B), so I made a third table. In table A and B i got two primary keys a_id and b_id. Now I create the third table named AB. Inside that I create ab_id as primary … |
| | Hello everybody, i am trying to import an mysql table to sql server both has the same attribute and with the same datatype. and here is what i did : 1- i export the mysql table to excel sheet. 2-then i went to the sql server and import this sheet … |
| | MySQL is great, especially for storing large amounts of data such as users, event logs, and tables for forms or CMS systems. There is one big problem though that faces PHP/MySQL developers: MySQL injection. Hackers usually try something like a username and password of ' a='a'. This is a MySQLer's … |
| | Hi all, I need to save a number to 3 decimal points, however I want 10.3 to be saved like this: 10.3 not this: 10.300 varchar will not work because ORDER BY rating treats 10 as being lower than 9... So what datatype should I use? Thanks, Max. |
| | hello Everyone I was wondering if anyone can help me with a little php and mysql problem occurred to the CMS i am using. I have a function which is get data from a table after updating the table, the code is as follow: [code=php]public function getHtmlWrapper($id) { //get entire … |
| | Hi all, I am fighting with this a while allready, a moving average with mutilty items The (example) tabel : item datum volume item1 1/1/2009 10 item1 1/2/2009 11 item1 1/3/2009 12 item1 1/4/2009 11 item1 1/5/2009 10 item1 1/6/2009 10 item1 1/7/2009 10 When i do this with only … |
| | hello everyone i am currently working on a php script on my website. I wanted to make a script for registering users. So that they may log in, log out, register, and access member only functions. I found a good tutorial online but since im fairly new to php and … |
| | i am trying to retreive the contents of the table in my databse into a html form using servlets in tomcat. here isthe code: [code] import java.io.*; import java.lang.*; import java.sql.*; import javax.servlet.*; import javax.servlet.http.*; public class ServletusingData extends HttpServlet{ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{ response.setContentType("text/html"); …  |
The End.