11,093 Topics
 | |
| | I am getting this message and I have checked my code and it seems to be all OK but I ther another reason that this message is showing up, that I maigt not know. PLESE HELP.... Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in file.php on … |
| | I recently came across an example where binary data was stored in a column which related to the sum of all foreign key id integers. This was the scenario: id [int] from [int] message_title [varchar,100] message [text] to [int] I assumed the 'to' field was a foreign key on the … |
| | Hi, [B]This was Mysql Backup Batch Script [/B] Script named as [B]mysqlbackup.bat[/B] REM [at] echo off for /f "tokens=1" %%i in ('date /t') do set DATE_DOW=%%i for /f "tokens=2" %%i in ('date /t') do set DATE_DAY=%%i for /f %%i in ('echo %date_day:/=-%') do set DATE_DAY=%%i for /f %%i in ('time …  |
| | Its urgent please help!!!!! animaldetails(Table 1 ) Animal_Id int (primary key) IsMilking boolean Milking_Capacity varchar milking (Table 2) Animal_Id int (primary key) Month_Year varcahr (eg. '6 2009' -- Means June 2009) Day1 varchar Day2 varchar and so on (till 31) milkingevent(Table 3) milking int (primary key) Requirements: 1. I need … |
| | Hello all... Anyone plz help for "TRIGGER CONCEPTS" & "STORED PROCEDURES". Materials wanted. |
| | Hi, I have 2 questions regarding the auto increment datatype in mysql. Q1) Since we all know that if we create an auto increment column, it will start from the number '1' but is there a way we can force it to start with the number '300' and it should … |
 | EDIT: I just realized I should have posted this in the MySQL section. If a mod can move it there I'd appreciate it. Thanks :) Hi all I have two tables. The first one has the details of each fruit, its code, markup percentage, it's cost price and the amount … |
| | Hello everybody, how do I rank mysql search results by column weighting? thanks for your input. |
| | Hey guys.. I have been trying to debug this mysql statement for the past 2 hours.. here is the statement: [CODE] $sql1 = "SELECT * FROM cpmip WHERE adid='$a' and ip='$ip'"; $res1 = mysql_query($sql1) or die(mysql_error()); [/CODE] I just can't figure out why this won't work.. it throws the following … |
| | Hello. I am new and hope to find an answer to my query. I run a classified database and have been doing so for quite a few years, I recently upgraded the Plesk CP on my server and suddenly a problem appeared with the way the DB is returning the … |
| | Hi, PO-1-09/09 is a data stored in varchar column. When i do [inlinecode]select * from table myid='PO-1-09/09'[/inlinecode], it doesn't return any value. If i change PO-1-09/09 to 5, and search for it, 5 returned related data. Why PO-1-09/09 doesn't work? Thanks |
| | hello all. I have python 3 and want use mysql but i dont find mysqls modouls please say me a link.  |
| | Hello... I need to get data from one table while omitting data that exist in the other table. This is the query I am running but I keep on getting duplicates since there are more the one row in the second table. Table1 - 'countries' with fields 'Country_Code' and 'Country_Name' …  |
| | Hi all, I have 2 tables.i.e. Table1 and Table2. Table1 --------------- Code --------------- a_b c_d e_f f_g Table2 ------------ Msg ------------ s_c_d_1 r_a_b_o t_f_g_k A_e_f_D I want to compare the two columns of the respective Tables and get the output as.. Table2 ---------------------- Msg || Code --------------------- s_c_d_1 || c_d … |
| | I created a job site using my web masters, now I wanted to use the same script for my other job domains. I tried copying all my php web pages in to the server, and also changed the database configuration to match the new server password, I created tables in … |
 | Hello everyone i have been looking on ebay and i went to mysql home page to trying follow their directions but for some reason I cant create a new user. I do not know how to get started, i choose the mysql file in the temp folder and that opens … |
| | I get the following error: [B]Warning: mysqli_query() expects parameter 1 to be mysqli, string given in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\docdue\create_group.php on line 50[/B] Anyone have any ideas what is wrong? Thanks [CODE] <?php session_name("duedate_session"); session_start(); ?> <?php require_once("includes/db_connection.php"); ?> <?php require_once("includes/functions.php"); ?> <?php include("javascripts/validation.js"); ?> <?php include("includes/header.php"); ?> <?php $groupid …  |
| | I would like to have a graphic interface for MYSQL database, most people use PHPmyadmin for browsing DBA stuff [B]any other alternative software that will connect to MYSQL database[/B] -- i.e. alternative to PHPmyadmin and look more pretty and can do most stuff by MOUSE ?? many thanks |
| | Hey, first of all... I have no experience on JSP at all so my question might be a bit silly.. However, what I want to do is to query mysql database and get three columns and put them into a table, so that the "URL" column would be a link …  |
| | I've searched through the threads and I can't find what I am looking for exactly. I apologise if I'm posting something already resolved for someone else. I have a page for browsing the contents of a database. An option for each of those records is to update/edit. The user clicks … |
| | Hi there I need to create three dropdown boxes (box 1:colour, box 2: price, box 3:brand) and when the user presses "GO" they are returned with the correct information, pulled from corresponding fields in my MYSQL database. For example, colour: silver, price £100-£200, brand:samsung...should return 5 items on the page. … |
| | Hi all, I've recently begun working with mysqli in a php site in order to make use of bound queries. Now I have a config file that I am including in all pages that has something similar to: $dbc = new mysqli(_HOST,_USER,_PASS,_DBNAME); and this works as expected. If I then …  |
| | I am using mySQL to develop a database collected from internet sources. Python is used for the spider coding, but I'm having issues with the mySQL portion. I'm pretty new to mySQL, so I'm a bit lost. I need a way to lock a single row of a table and … |
| | Hi, i really need help with this :/ the export field in my localhost PHPmyadmin has many fields and I must be doing something wrong, because the receiving end doesnt load the database at all. I set: SQL in STRUCTURE: Add AUTO_INCREMENT value Enclose table and field names with backquotes … |
| | I'm writing a query to summarize survey results. There are two tables... 1) The Profiles table contains the users' answers. There are four columns: ProfileID (for the unique key), QuestionID (a number representing canned questions from another table), Answer (a number representing multiple choice answers from another table), and UserID. … |
| | Hi, How to find number of rows affected in update statement using mysql (not using php mysql). Thanks, Pradeep  |
| | Hello all, Just wanted to see if I am leaving open some security hole in a script I have! When the user logs in it creates a session based on the id field of the users table! For example .... my id is 10 so a session is created with …  |
| | Hi, I have the following query, which does not return any results. [ICODE] select (sum(t.minutes) / 60),d.fiscalmonthnum from kpifntime t inner join kpiddate d on t.datekey=d.datekey inner join kpidacts a on t.activitykey=a.activitykey inner join kpidfees f on t.feeearnerkey=f.feeearnerkey where a.activitycode in (11,12,13,14,15,16,17,18) and d.fiscalmonthnum=11 and d.fiscalyearnum=2009 and t.feeearnerkey=520 group by … |
| | hai am using a stored procedure in mysql. in that stored procedure i have an temporary table. i want to check if that temporary table is already exist then drop it. else create it. reply your comments |
| | Hi, I've having a bit of difficulty with an update statement. The following select statement returns 34 records... [CODE] select b.* from budget as b inner join ntime t on b.feeearnerkey=t.feeearnerkey inner join date d on t.datekey=d.datekey inner join acts a on t.activitykey=a.activitykey where a.activitycode in (11,12,13,14,15,16,17,18) and b.fiscalmonth=d.fiscalmonthnum and … |
| | Can Crystal Reports be used with MySQL? If not, what reporting tool do you recommend?  |
 | Length/Values1 what do i put there. this is a collumn in one of my tables its bigint so the number can get increased by alot. its a point system. it asks for length/values whn i edit the name of the column but i dont understand what to put there. i … |
| | I have a mysql table that was working fine. I'll try to be brief. I have a table that has two primary keys, both are also foreign keys to other tables. The primary keys are qid and pid. If I try to enter a record, using pid > 10, I … |
| | Hey guys, I have a new server :P I am currently configuring it and I ahve come across an issue. The issue being that PHP 5 does not support MySql from standard. I have managed to resolve an issue with the installation of PHP on IIS BUT I am strugling … |
| | Hello All. Is there any syntax for [COLOR="Red"]getting fields in a column in an alphabetical order[/COLOR] in mysql? See, for example... I have a two column with "NAME & NUM". NAME NUM BHANU 6 KIRAN 3 ADAPA 8 CHANDU 7 I need to get the names in alphabetical order. There … |
| | this code isnt workin: [CODE]$newer = mysql_query("DELETE FROM messages WHERE id = '$rawr', user = '$rew', read = '$roll'"); [/CODE] this code works: [CODE]$newer = mysql_query("DELETE FROM messages WHERE id = '$rawr' AND user = '$rew'");[/CODE] the variable is the same that is included in the first, so its not … |
| | its a mess. i dont know why it would be doing this. considering the message it says its in the inbox in the mysql database and then its not. i dont know what to do. its php and mysql database. is there a posiblitily its showing up on the webpage … |
| | [code] <?php require("config.php"); if(isset($_GET['id']) == TRUE) { if(is_numeric($_GET['id']) == FALSE) { $error = 1; } if($error == 1) { header("Location: " . $config_basedir); } else { $validtopic = $_GET['id']; } } else { header("Location: " . $config_basedir); } require("header.php"); $topicsql = "SELECT topics.subject, topics.forum_id, forums.name FROM topics, forums WHERE topics.forum_id … |
| | i m using ORANGEHRM, for dis first of all i installed basi package of XAMPP,i have created my account on the site of orangehrm.The account run on localhost i.e it runs on single system.My problem is i have to RUN IT ON D ANOTHER SYSTEM,is it possible to run d … |
| | Hey guys/gals, I literally just started teaching myself MySQL today and have started to write a email list script for mass emails. Ive got the adding emails and sending mail scripts working but i cannot figure out for the life of me what is wrong with the deleting script. I … |
| | Hope this is the most suitable forum for this question if it is not let me know. I've had this error on my computer for a while and have been unable to find a solution, which I think it is the result of some xampp and sql software I tried … |
| | Hi all, Goodday...! Im delevoping a struts project of my own. Having doubt in database connection. Actually where i have to write code for connection, there itself my doubt starts.... whether i hv to write a connection code in (1) execute method in Action class, OR in (2) servlets, OR … |
| | I have been unable to figure out how to insert data into My database. I am just learning PHP so please ignore comments [CODE] <?php if (isset($_POST['submit'])) { if (isset($_POST['question'])) { $DBhost = "localhost"; $DBuser = "root"; $DBpass = ""; $DBName = "exit_poll"; $table = "exit_reason"; mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to … |
| | Hello can someone please help me, I am trying to add information to a database with checkbox. I have every thing working expect for the checkbox. I am fairly new to the php/sql side of web coding. Anyway I want to add information to the one field of a database, … |
| | can sombody give me a great example to make a connection php - mysql ( oop - best practice ) ? [ICODE]<?php /* Database Connection */ class db { private $db['host']='localhost'; private $db['user']='root'; private $db['pass']=''; private $db['name']='build'; public function connect($db['host'],$db['user'],$db['pass']) { $db['connect'] = mysql_connect($db['host'],$db['user'],$db['pass']); if (!$db['connect']) { printf("Cannot connect to … |
 | :rolleyes: nothig at all I dont know what to do ? dont know anythig about PHp ? To start my doing Php , what i need ? Do i have to install mySQL in my computer or anythig else ? Just tell me tools what i need to learn Php????  |
| | i have this code, im using jquery which im not very familiar and i need help please:D [code] <html> <head> <title>Select and drag?</title> <style type='text/css'> body,html { color:#333; font-family:Calibri; font-size:11px; } .panel {float:left;width:200px;margin:20px;} ul { list-style-type:none; border:1px solid #999; background:#ccc; padding:20px; min-height:150px; width:100px; } li { display:block; border:1px solid #999; … |
| | Hi all, I have a web app that is used in a number of countries, including ones such as Brazil, where the comma is used as a decimal separator. This is causing problems with my SQL queries, as it is trying to update a number field with "0,013" when it … |
| | import java.awt.BasicStroke; import java.awt.Color; import java.awt.Dimension; import java.awt.*; import java.sql.*; import java.util.*; import java.util.Date; import java.lang.*; import javax.swing.JApplet; import org.jfree.chart.ChartFactory; import org.jfree.chart.ChartPanel; import org.jfree.chart.JFreeChart; import org.jfree.chart.axis.NumberAxis; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.plot.PlotOrientation; import org.jfree.chart.renderer.category.LineAndShapeRenderer; import org.jfree.data.category.CategoryDataset; import org.jfree.data.category.DefaultCategoryDataset; import org.jfree.ui.ApplicationFrame; import org.jfree.ui.RefineryUtilities; //import org.jfree.chart.demo.Time; /** * A simple demonstration application showing how …  |
| | Anyhelp with code below would be greatly appreciated Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /usr/home/rconn/domains/dadpop.net/htdocs/online-bookmarks/register.php on line 44 you have been successfully registered. Read your email and click the link to activate your account. [code=language] <?php require_once ("./header.php"); $secret = "dDWUc72sCcs20cXskcw"; $reg_register = set_post_bool_var … |
The End.