10,938 Topics
 | |
| | 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 …  |
| | 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? |
The End.