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