11,093 Topics
 | |
| | Hi all been working on this for a couple of days. I want to upload 4 image names to the mysql database and upload the images to a folder on the local server. I also want to display my images that goes with the text data. So far I can … |
| | I restart a project of mine which use mysql, I used xampp in the past to test the code on the mysql server so I update to lasted version but a piece of code that is identical and was working, I now get an error in [U]the class check in … |
 | I am very new to php and mysql. I have read and re-read many forum posts on this subject, but I just cannot figure this out. I have been at it for almost two weeks now. This is my hope: Load images and captions from a database into an html …  |
 | I hope I can explain this. I have a table which contains a field named ID. This is set as PRIMARY. Because users registered on my site and after that deleted their accounts (so a lot of rows got deleted, too) the table rows now are jumping, for example, from …  |
| | I'm trying to create a form where I can type in a piece of news as I would normally type and include links in the form [CODE]<a href="www.google.com">google</a>[/CODE] and have it preserve the formatting and display the link as a link when echoing back. My problem is that despite a … |
| | New to PHP and need some help with this. I'm creating a test, but I'm getting all of my questions randomly from my database. For example, if this is my table: ID S Q1 A1 A2 1 C Why A B 2 F When A B I know that I … |
| | Hello! please i need help with this,after sumiting my form i get this error message on line 111 any help i will appreciate, thx [CODE]<?php session_start(); include("../Connections/recruit.php"); echo "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?".">"; //check certification $certification = $HTTP_POST_VARS['certification']; if($certification != "accept") { echo(" Your application has been terminated as a result of … |
| | I have the following code. [CODE]$result = mysql_query("SELECT * FROM topics LEFT JOIN quiz ON topics.managerId = quiz.managerId WHERE quiz.userId = '$userId' AND userId= '$userId' AND $egroup = 1 GROUP BY topics.title")or die(mysql_error()); while ($row = mysql_fetch_array($result)){ echo "{$row['quizId']} <br />\n"; echo "{$row['title']} <br />\n"; echo "{$row['passState']} <br />\n"; } … |
| | please tell me how to convert a sql file which contain a table into .csv file in sql please tell me whether there is any c program to do this conversion or any other program insql for doing this |
| | Hi I am trying to write a stored procedure which will execute a query and if resultset is not empty results will be inserted into a table passed as the second parameter to the procedure. Below is what I wrote but I am having error with declaring the cursor, any … |
| | I've just removed and reinstalled mysql on my Amazon EC2 server. When I went to change the root password on the new install: sudo /usr/bin/mysqladmin -u root password 'MYNEWPASSWORD' I get an access denied error: error: 'Access denied for user 'root'@'localhost' (using password: NO)' Has it held onto the old … |
| | Hey everyone, PHP and MYSQL newbie here.....can really use your help right now. I implemented a Submodal into my script, and finally got it to submit "User Notes" into the database. Unfortunately with each new submission, the text that is submitted overwrites the previous submission. I was told to use … |
| | 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 … |
The End.