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