10,946 Topics
 | |
| | I was wondering if anyone could point me what coding feature I'm talking about that can fulfill this role. - So I need to update data values from many users at the same time at a specific X amounts of time or specific hours of the day. What programing process … |
| | Hi, Hoping someone can help with a query I'm stuck on. I've got a field (sm_contact1number) containing phone numbers. Some of the data has been imported via Excel and its stripped some of the 0's out of the start of telephone numbers, so 0121 3324234 now looks like 121 3324234.. … |
| | I need a pvp system and tutorial please XD it is simple... just a turn based pvp system help pls :P |
| | Can you all tell me the difference in these 2 codes? I'm trying to learn JQuery and ive seen this code below in the tutorials. [CODE] $DB->Query("Select * FROM time"); [/CODE] I'm use to coding queries like this. [CODE] $res = mysql_query("SELECT timestamp, name FROM time ORDER BY timestamp DESC"); … |
| | Hi, When a SELECT query is executed does MySQL store the resultset in some table? If it does, is there a way to find out that table and access it later before the session is closed? thanks, |
| | Hello folks, I'm having a bit of a nightmare getting a particular query to work the way I want it to. I have two tables; One for a catalogue, another for customer orders (which will always be items from the catalogue) What i'm trying to achieve; A query that will … |
| | hi all, for example. this is my mysql query result. A | B | C --------- a1| a2| a3 b1| b2| b3 c1| c2| c3 d1| d2| d3 i want to print the result like columnwise as following. a2|b2|c2|d2 Any suggestions please....  |
 | How can i select a data (any location) from Google map and also i want to store that data in database in order to list that contents in another page... Please provide me the idea,explanation and code.. Thanks |
 | Dear all! I have a final year project on Google maps. The aim of the project create a map for a farm land in a city and to read the data to be displayed on the maps from a database. But the thing is I need someone who has done … |
| | Hi there, I need some help with this error/warning Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource here is the code: [CODE=php] include "connect.php"; include "comment.class.php"; $result = mysql_query("select * from comments order by id"); $comments = array(); while($row = mysql_fetch_assoc($result)) { $comments[] = new Comment($row); } … |
| | I creat this form which contain dynamic table: [CODE]<form action="<?php echo $editFormAction;?>" method="post" name="form1"> <table cellspacing="0"> <tr> <th>#</th> <th>ORDER DESC</th> <th>ORDERING DEPT</th> <th>ORDERING SERVICE</th> <th>STATUS</th> <th>SENDING DATE</th> <th>DELIVERING NO</th> <th>DELIVERING DATE</th> <th>COMMENT</th> </tr> <?php do { ?> <tr> <td><?php echo $row_medi['order_no']; ?></td> <td><?php echo $row_medi['ORDER_DESC']; ?></td> <td><?php echo $row_medi['ORDERING_DEPT']; ?></td> … |
| | [CODE]$query = "SELECT * FROM image_share WHERE to='$username'"; $result = mysql_query($query); while($row = mysql_fetch_assoc($result)) { echo '<tr> <td width="100%" align="left" valign="top"> <div style="border-bottom:1px solid #6F6F6F;"><span style="color:#C0B184;"><a href=""><img src="'.$row['image_sharelink'].'" width="150" height="137"/></a></span><br/> <br/> </td> </tr>'; } [/CODE] cant figure out why it wont work. I got my error display on E_ALL mysql_fetch_assoc(): … |
| | guys i need some help!.. my friends are having their project on web developing?? How can i create a Login System with this database?? [B]tbl_stud[/B] st_uname = logmein st_pw = 123 type_id = student [B]tbl_prof[/B] pr_uname = pro pr_pw = 321 type_id = prof [B]tbl_admin[/B] ad_uname = adm ad_pw = …  |
| | Hi Everyone, this my first time. My question is how can I locate a non-ascii character in a string/field? Thanks, C |
| | hello to all, how to make global data from mysql example: data1 from table data2 from table ... i want to make the data[] global so that i can call anywhere in the page. i'm using php thanks,  |
| | I built a quick date time test page. The coding is below followed by its results. I'm entering the raw timestamp into table time because i want to be able to manipulate it once i show it (say if i want to show time and date using the same timestamp). … |
| | Hello everyone. Please somebody teach me how to setup mysql database. I have register a free domain for social bookmark website. But I found problems when making database. Please teach me step-by-step to create bookmark website database. Ohya, I use Pligg free software for social bookmark site. Thank you before. … |
| | hi all, first i want to say I am new to php. I'm developing a blog where administrator can get all comments replied by the users. I can view it in a html table. But now what I need is dynamically delete , edit them. i tried this [CODE] include … |
| | Please help on the multiple textbox as date in mysql [CODE] <input type="text" name="date" class="f_input input1" style="width:32px;" value="D" maxlength="1" onBlur="if(this.value=='') this.value='D'" onFocus="if(this.value =='D' ) this.value=''" > <input type="text" name="date" class="f_input input1" style="width:32px;" maxlength="1" value="D" onBlur="if(this.value=='') this.value='D'" onFocus="if(this.value =='D' ) this.value=''" > <input type="text" name="date" class="f_input input1" style="width:32px;" maxlength="1" value="M" onBlur="if(this.value=='') … |
 | Hi All, as i am new to asp.net as well oracle /mysql. i have been given a task to shift website from Oracle databse to Mysql ,i found some tools to convert databse. database converter , procedures / functions /packages copied, but facing problem to make a connection. I checked … |
| | Hi folks I have several JPEG thumbnail images in a database and need to select particular ones, stitch them together and post them into single cell in the table on a website. I've created the following query: [CODE]SELECT s.Set_Code, t.Mimetype, GROUP_CONCAT(t.Image SEPARATOR '< \;>') AS 'Image' FROM Thumbnails t INNER JOIN … |
| | I have a form in account.php that is prefilled with the user's current info but can be changed and then when you submit, it updates the database. However, when returned to the page after the update, the prefilled text is not updated. It only updates if you re-log in. At … |
| | View the full tutorial at [URL="http://www.effectivewebdesign.co.nz/tutorial.php"]http://www.effectivewebdesign.co.nz/tutorial.php[/URL] I have tested this many times and it works fine. Please don't complain unless you really can't get it working, Just PM me and I'll fill in the blanks Happy Coding :) |
| | I found this code [url]http://www.daniweb.com/web-development/php/code/301902[/url] but when I run it I get several \n followed by Count item Name max(ts) then several a href="/testing.php?sort=max(ts)>"2011-07-08 00:00:00 can you tell me what I am doing wrong? [CODE]<?PHP //connect info $hostname = "localhost"; $database = "db"; $username = "user"; $password = "password"; $conn … |
| | is there a way that i can check to see if a mysql table exists and if not add the table to the database with a session_id as a table name |
| | Hi all, This has always confused me to no end and now that I really need a JOIN I need to get this. I am working with a small blogging section of my site here. In one table I have "blogs" and another table I have "comments". My comments table … |
| | |
| | I have a table similar to the one below: Month | Item | Qty | Cost of Items purchased Jun | 1 | 10 | 50 May | 1 | 5 | 0 Apr | 1 | 5 | -18 Mar | 1 | 7 | 0 Feb | 1 … |
 | I have a somewhat complicated select query which returns, in part, the following resultset (as an example): [code=text] threadid views -------- ----- 1 5 1 5 2 10 3 15 4 10 [/code] If I were to do the following select: [code]COUNT (DISTINCT threadid), SUM (DISTINCT views)[/code] then it would … |
| | I am making a project where when you select a city, you will get all the hotels on google map as markers.. now i got two options whether make an external xml file for all the hotels and read that file.. or get result for database.. so friends what you …  |
| | I am trying to create a plant reference guide where the customer can grab plant description from one table (findplantsdb) and the availability from another table (plantsdb). I am new to PHP and I think I am close, but what is happening is that the plant description is coming up, … |
| | I'm trying to formulate the proper SQL query to pull a roster up on this database I was asked to produce for my kids' HS band. Arrghh. Any help would be great. I have 3 tables. [CODE][U]student[/U] student_ID {PK} first_name last_name email family_ID {FK} [U]family[/U] family_ID {PK} family_phone [U]adult[/U] adult_ID … |
 | I'm trying to create a message board where members can post messages to other members. I'd like to have a section where it says "4 posts since Jan 2011" just like DaniWeb does. How do I get the date from the [CODE]"first row WHERE user='username'"[/CODE] with PHP & MySQL? Also, … |
 | HI,..i've been working on this simple project that i need to submit it tomorrow. I really in rushing a little bit. But while i working on this oop project, my program give the strange little fatal error about my query which is this [B]Fatal error: Call to a member function … |
| | Hello everyone, I am working on a project and this is the error I keep getting.. Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\wamp\www\member-form.php on line 69 error on connect Can someone help me understand.. this is my code [CODE]<?php function FormDisplay($strMessage="**All fields are required!"){ … |
| | hi im working on on a personal project and i need some help on how to structure my database and query. so here is my problem and searching for a solution. on my site everyday there will have a daily article or item grouped in categories. now a user has … |
| | Hello to all reading this thread. I want to ask you a question about mysql records and more specifically deleting them. I have a database which has a table called orders. In orders I have fields: ID, Name, Date created, Date expire. My question is, how can an order be …  |
| | Hello, I've tried to search solution for selecting name from table1, for table2 id's. Table structures are like table1 (persons): id name created table2 (linking): sup_id emp_id where sup_id is id from table1, and emp_id is id from table1. Can I directly replace those ID:s with correct person names from … |
| | I need to use the mysql query result.following is the mysql query. [CODE] while($row = mysql_fetch_array($result)) { $name=$row['name']; } [/CODE] For example: result of above query is (name1,name2,name3...) The problem is... i need to return that result in the following function.How can i do it? [CODE] function results() { return … |
| | Is this code correct? It is supposed to get input from SMS messaging API and save it to database. Mysql database is created with Table inbox and 2 columns called ID & Msg. I want to know if this code is going to do the job? Else help me in … |
| | Back in February,smantscheff helped me with a problem where I was trying to aggregate data between two queries and after the suggestion of creating two views, everything worked perfectly. However, I failed to look ahead and see a potential future problem! The original thread is [URL="http://www.daniweb.com/web-development/databases/mysql/threads/347065/1473368#post1473368"]http://www.daniweb.com/web-development/databases/mysql/threads/347065/1473368#post1473368[/URL] and quite simply, as … |
 | Hi all. I have a database table containing the details of, lets say, Ninjas. It has a primary key called NinjaID. I have a second table containing a match-up of which Ninjas will be fighting eachother. This table has 4 Columns: 1.) MatchID 2.) BlueCornerNinjaID 3.) RedCornerNinjaID 4.) DateTime What … |
| | Hi to all, first of all thanks to all those who reply... appreciate the input I am using OpenContacts as an address book style program. However it uses a firebird backend db. I have a mySQL webserver and I want to synchronize the two databases by "Replacing All of Local … |
| | Good day, I am climbing a wall trying to figure out why I can not retrieve the results of a mysql query to a php array. My query polls the database and it is retrieved but all the data is encrypted. I need to take the results and put them … |
| | I am having trouble merging two queries. I want to be able to search my recipe inventory by ingredient, but I also want it to tell me how many ingredients I am missing for that certain recipe. I am able to do a search by just ingredient and I am … |
| | im pondering on some functions on MySQL especially on dates and times and i stumbled upon an idea where i can't find a predefined function that gets the next day of a specific day. For example: As of this post, the Date and Time is (GMT +8) : July 4, … |
| | Dear All, I got few tables as below. So then what I do on any time I will calculate the total points collected based on each table via some of this queries like below. What I am using now is the sum function. I am confuse should I like run … |
| | Hello every one whats the difference between mysql_.... and mysqli_.... functions in PHP??? Arent they both for mysql??? |
| | I am attempting to dump a portion of my table after 7 days. This table will hold access logs so will fill up pretty quickly. I'm not too sure if this is entirely possible but this is what I'm trying to use. Any help or a push in the right … |
| | HI friends..I have a tab delimited text file with country, city, Participants field.. Now, when I search for a particular entry for eg. Country England, then I want it to show all the cities associated with it Inot just one). My actual table looks like this. [IMG]http://i56.tinypic.com/2dceg4p.jpg[/IMG] Now, If I … |
The End.