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