10,944 Topics
 | |
| | I've had a good trawl through search and Google, but can't get to grips with a problem. I don't know if it is possible, but here goes: A friend asked me to install a few mods to his phpBB3 site. No problem. However, there were a few that required SQL … |
| | 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, … |
| | how to display formatted text, images and flash those url stored in mysql database in php? |
 | I have been learning PHP for sometimes and it is interesting. Can anyone point me to good PHP/MySQL tutorials for newbie :) So far I have been playing with simple PHP scripts like Forms etc. Thanks all |
| | Hey Guys, I'm having a very difficult time. I'm not sure exactly what to do. I have a form that contains fields for HEX, DEC value. I'm using a color picker (RGB ColorPicker 1.1) along with php5 and MySQL. All I want to do is be able to save the … |
| | Hello. I'm trying to select users from database that were last active today or yesterday...but there is a problem... When a user logs in, it stores both date and the exact time. So when i want to select user from db that logged in today or yesterday i must use … |
| | 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 …  |
| | 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 …  |
The End.