11,093 Topics
 | |
 | So I received awesome help from here before but forgot to ask at the time about one small thing. He taught me how to exclude my "ID" field displaying and about the implode function in PHP but if I display my data using it is there a way to make … |
| | [CODE]$wordpress_user_db_query = mysql_query("INSERT INTO cedsite_wrdp1.wp_users (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES ('".$username."', '".md5($pass)."', '".$username."', '".$email."', '', '".$date."', '', 0, '".$username."');");[/CODE] Using PHP I am trying to do that, but it isn't working. Can someone help?  |
| | Hi this is my first post on DaniWeb.... the information has helped me in the past but im seriously stuck.... Help would be very much appreciated.. Im trying to create a form where the user can upload 5 pictures to a mysql database (members) field names are img1, img2, img3, … |
| | Hello, I have a mysql field that is a blob and I use encode to encrypt the values for that field. One of the values is: 62756d7069886d66 When I use the salt: ulabula to decode it via phpmyadmin, the correct value returns: 62756d7069886d66 However when I do the exact same … |
| | Hello! I run SQL queries from JAVA program (an example is shown below). My question is: Is it possible to run SQL query, if column names are defined in an array and the array size is not known apriori? Thanks! [CODE] public void setQuery(String query) { try { int rs … |
| | I have this code: [CODE]$sql=mysql_query("select distinct one.ime_kategorije AS ime_kat,count, two.kategorija_g AS kategorija_g FROM (SELECT *, COUNT(DISTINCT kategorija_g) AS count FROM galerija_slik LEFT JOIN kategorija ON galerija_slik.id_kat=kategorija.id_kategorija GROUP BY id_kat) AS one JOIN ( select * from galerija_slik group by kategorija_g) AS two WHERE one.id_kat = two.id_kat;"); while ($row=mysql_fetch_array($sql)) { $kategorija=$row['ime_kat']; … |
 | Hello)) I have a text file with a script that can be used to create an Oracle database, but I want to use this script to create MySQL one) Unfortunately, not all commands are similar. I've already changed the commands for creating tables. And now I can not understand how … |
| | Hi guys! I can not understand - what is wrong with this simple line - [CODE]create table SUBJECT ( SUBJ_ID NUMERUC not null, SUBJ_NAME VARCHAR(100));[/CODE] error message -[QUOTE]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to … |
| | Hello! I’ve got three tables that I want to link together. When I try to upload images and text throught a form, the web browser show this error message: [QUOTE]Error, query failed 1452-Cannot add or update a child row: a foreign key constraint fails (`mn000532_almacen`.`images`, CONSTRAINT `images_ibfk_1` FOREIGN KEY (`itemID`) … |
| | [CODE]<?php include("includes/connection.php");?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> </head> <body> <?php echo $sql= "SELECT * FROM forms WHERE today >= CURDATE() - INTERVAL 30 DAY"; $result=mysql_query($sql); while($row=mysql_fetch_array($result)) {echo $City= $row['City']; echo $Name=$$row['Name'];} ?> </body> </html> [/CODE] i just … |
| | [CODE]$wordpress_user_db_query = mysql_query("INSERT INTO cedsite_wrdp1.wp_users (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES ('".$username."', '".md5($pass)."', '".$username."', '".$email."', '', '".$date."', '', 0, '".$username."');");[/CODE] Using PHP I am trying to do that, but it isn't working. Can someone help?  |
| | Hi friends , I had a table which contains tourist information of a country. the table structure as follows state | place | placeid | activities ============================================================================== state1 | palce 1 | 12457 | swimming,trekking,hillstation,waterfall | ------------------------------------------------------------------------------ state2 | palce 2 | 12458 | beach,backwater,ayurveda,fishing | ------------------------------------------------------------------------------- Ok now I … |
| | Hi, i have made a form in which people fill out their details and its gets saved in database with [CODE] $today = date("F j, Y");[/CODE] now i want to make a search for that forms with date , like Search with in last 3 days or Last 6 months. … |
| | |
| | [CODE]<cfquery name="Sort" datasource="JD8989776555"> SELECT * FROM ResMenuItems ORDER BY "ItemOrder" ASC </cfquery> <p>Output</p> <cfoutput query="Sort"> #ItemOrder# - #ItemName#<br /> </cfoutput> <p>loop</p> <cfloop query="Sort"> <cfoutput>#ItemOrder# - #ItemName#<br /></cfoutput> </cfloop>[/CODE] I am honestly not joking :S That code there, is here : [url]http://jadedragon-co-uk.securec12.ezhostingserver.com/admin/MenuManager/TEST.cfm[/url] |
 | Hey! I've got a SELECT query which fetches rows based on a search string using LIKE command. I was wondering, how could I make it to skip "The " from the beginning of the value? For example, I have TV series listed in the database, like "Futurama", "The Office", "The …  |
| | hai, friends i have problem in inserting image into mysql database using a small java program.... here is my code for inserting image into database............ [CODE] import java.io.*; import java.sql.*; class ImageUpload { public static void connection() { Connection con=null; Statement st=null; PreparedStatement pst=null; try { Class.forName("com.mysql.jdbc.Driver"); System.out.println("driver is loaded"); … |
| | hey guys i m new in mysql can u tell tat how select data through a store proceedure in mysql or how i hvae to put a select query in store proceedure of mysql pls help me........ thanks |
| | [CODE]DROP PROCEDURE IF EXISTS `uniqueId`; DELIMITER $$ CREATE PROCEDURE `unique`(IN deepak VARCHAR(100),OUT UNIQUEID INT) BEGIN SELECT UNIQUEID FROM products WHERE PRODNUM='deepak'; END$$ DELIMITER ;[/CODE] how to select uery work in this procedure.............help me |
| | Hi all, i decided to try and make a php shopping cart with sessions and manged to do so with the help of online turorials and references. However, i decided to try and pass over multiple items form a table, but i must have gone wrong somewhere, as some of … |
| | Hi, i have four tables: books info autor publisher ---------- ------------- --------------- -------------- id id id id bookname type name publisher name autor_id year second name quantity publisher_id autor year country I tried with this relations but it did not work (is this normalization ok) relations: `autor.id = books.autor_id` AND … |
| | This SQL operation will get the desired Proposal_ID. [CODE]SELECT P.Proposal_ID, AVG(c.Task_Good_Idea) AS Average FROM proposals P, proposal_appraisal c LEFT OUTER JOIN users b ON (c.Evaluator_ID = b.User_ID) LEFT OUTER JOIN submission_status d ON (c.Primary_Evaluation_Status_ID = d.submission_status_ID) WHERE (P.Proposal_ID = c.Proposal_ID) AND P.Proposal_ID >= 931 AND d.Submission_Status_ID = 2 GROUP BY … |
| | Hi All, Another roadblock on my way to fame and fortune... LOL I am attempting to convert a csv file to a mysql table, and am using a converter that takes the csv and converts each line into an insert statement. that part works fine. But the issue I run … |
| | Hi, I need help to insert multiple checkbox data into MySQL using PHP. I'm new here, any code I can refer? I have a database name called subject_name and there is only 2 column in the table which is id and subject. I would like to insert multiple checkbox data … |
| | Given the following two SQL operations: [CODE]select prod_Id, P.proposal_id, P.institution_Name from proposals P group by P.proposal_ID having mark >= 50 order by P.proposal_id desc select prod_id, P.proposal_id, PA.evaluator_ID, U.user_Given_Name, U.user_surname from users U, proposals P LEFT outer JOIN proposal_appraisal PA ON (P.proposal_Id = PA.proposal_id) where PA.evaluator_ID = U.user_id group by … |
| | How to calculate an average and use that average to select some data? e.g. for this query and its result. [CODE]select Proposal_ID, Mark, AVG(Mark) AS Average from proposal where (Proposal_ID >= 931) GROUP BY Proposal_ID 931 20 22.2222 935 30 22.2222 936 30 21.1111 967 30 25.5556 968 30 20.0000 … |
 | I use Visual studio 2008 I use MYSQL 5.1 I want only to backup database Test to to a specific directory. I use the [COLOR="Green"]application settings [/COLOR]to determine which directory(see attachment). [COLOR="Green"]Green[/COLOR] shaded code works perfect. [COLOR="Red"]Red [/COLOR]shaded code works not!! This is with My.settings. I can not see the … |
| | Hi guys, I'm new to forum and to Python. I need some help with the python - MySQL interaction. I'm creating a program for my conclusion project in College and it's not working. I gotta present it on Wed, 11/24, and I'm really desperate for some help. It's suposed to … |
| | Hello. I am kind of new to PHP and mysql, and I am wondering on how I would go about coding up a system that would allow me to save multiple values to one row in a mysql database, and later read each separately. I am coding up a mac … |
| | I have a machine logging production info to a database whenever certain conditions change state, so pretty much randomly throughout the day. The plant runs 24/7 so data is continuously flowing into it with about 500 entries in a 24 hour cycle. The shifts are strictly time based and are … |
| | Hi I am a bit rusty with SQL, not used it for about 8 years so would appreciate a bit of help. I have three tables, normalised, organisation, stores org_name and org_id ativities stores activity_name and ativity_id org_activity stores org_id and activity_id I need to get a list that contains … |
| | hi, i'm using phpmyadmin & would like to create an additional field in the following table. Field // Type Collation Attributes Null Default Extra Action user_id // int(10) first_name //varchar(20) last_name // varchar(40) email // varchar(80) pass // char(40) user_level //tinyint(1) active // char(32) registration_date// datetime the field would be … |
| | I'm trying to create an object derived from the MySQLi object to easier handle database connections for my application. The thing is that I do not know how I shall be able to initalize the connection and keep it contained in the object. Let me illustrate what I mean: [CODE] … |
| | Hi, i have four tables:books, info, autor, publisher and columns under tables; books........... info............ autor............. publisher ------------... -------------... ---------------... -------------- id............. id............... id.................id bookname .......type .............name ..............publisher name autor_id .......year .............second name .......quantity publisher_id ...autor............. year..............country I tried with this relations but it did not work (is this normalization ok) … |
 | Hi Guys, Can anyone help me out about displaying 10 data from my database?My codes goes like this. I have 4 fields (id, local_title, local_desc, local_date ) [CODE] <?php $last_date = ""; $result = mysql_query("SELECT * FROM tbl_localnews ORDER BY local_date DESC"); while ($row = mysql_fetch_array($result)) { for($i=0; $i<10; $i++){ … |
 | Hi All, Im accessing a function with paticular parameters, but my response is not recognising the parameter of the count value. If I change the variable in the COUNT part of the query to a static value it works fine, but if i use the variable name it returns "undefined … |
| | Hello i've got a problem here, i want to insert some data into my table and everything is all right for the first 3 or 4 but the last does not work [CODE]<?php // include("config.php"); // $db_connection = mysql_connect($db_host, $db_user, $db_slaptazodis); mysql_select_db($db_table, $db_connection); // if ($id == "") { // … |
 | [url]http://www.mycircle.freevar.com[/url] This is my website. Whenever a user logs in using correct username and password, a field(flag=1) in the database is updated to show that the user is online(for chat). When user logs out, it is set to flag=0 to indicate offline. This works properly. Consider the situation. The user …  |
| | Hi all, I have the following code:[CODE]$Connection = mysql_connect("127.0.0.1", "user", "pass") or die(mysql_error()); $Database = mysql_select_db('db', $Connection) or die(mysql_error()); $Url = mysql_real_escape_string("exampleurlwithonlycharacters"); $Query = "SELECT `col` FROM `table` WHERE `url` = '$Url';"; $Resource = mysql_query($Query, $Connection) or die(mysql_error()); $Result = mysql_fetch_object($Resource); var_dump($Result);[/CODE]and was expecting to see the Col => 1 … |
| | Hi, i am new on vb.net and MySql, and i have a problem. My database name is "plant3", i have a table named "itemlist" which has a field named "itemname", "task", and "status". I want to show the itemname on combobox and when user choice an itemname the program will … |
| | I'm working on a mysql server 5.0.45 hosted on linux RHEL 5.0. 1. I've 2-tables as below: [INDENT]table1: acct_no VARCHAR(15) column1 varchar(10) table2: acct_no VARCHAR(12) column2 varchar(10)[/INDENT] In both the tables, there are many rows with identical A/c nos. 2. Of the below 2-queries, only the second one works. [INDENT][COLOR="maroon"]SELECT … |
| | hi guys, i am struggling with cross tab query in mysql. if you have any idea could you please help me? basically i have data into the table like... cid | Q# | marks c1 | 1| 50 c1 | 2 | 50 c1 | 3 | 50 but i …  |
| | Hi, I am a PHP beginner, I am working this code and I need help, And kinda stack of it. I have a database with 5 fields(id, date, time , title and description). This is what I want to do; I want my script to go into the database fetch … |
| | Hello Everyone, i am wanting to build a leaderboard for my site for the members gamerscore on Xbox LIVE. I know how to fech from a MySQL database, etc but this is the hard bit. So the users table in MySQL contains their gamertag and i want to pull that … |
| | hi can anyone help me with this ive trying for 2days to get this sorted but cant figure it out. i want to be able to list my data in the table which works fine then i want a link next to each data line to amend it heres my … |
| | [CODE]SELECT t1.name AS lev1, t2.name as lev2, t3.name as lev3, t4.name as lev4,t5.name as lev5 FROM members AS t1 LEFT JOIN members AS t2 ON t2.upline_id = t1.member_id LEFT JOIN members AS t3 ON t3.upline_id = t2.member_id LEFT JOIN members AS t4 ON t4.upline_id = t3.member_id LEFT JOIN members AS … |
| | Wasn't sure whether to put this with PHP or Mysql I'm having trouble with the below code, it only does the inner while loop once, while still cycling past it every time. It should update the "favourite" integer column in each "link" by checking if it's in the favourites of … |
| | Good day all: I have a mysql insert statement inserting data to db. The value of one of the variables is: [code] ' $_POST[servicedesc]')[/code] I want to be able to append the current date and time in front of this value and then insert into the db. This value will … |
 | I have two tables in my db. One table contains portfolio images with a primay key set to AI. The other table contains all of the thumbnails that need to be associated with each portfolio image with no primary key. I'm trying to grab the last inserted id of the … |
| | Hello Could help me get the right MySQL on my computer. I had it installed but it was a couple years ago. My cp crashed. I can't remeber how or what to install. All I have left is the script I used. I was running the command window one. that … |
The End.