10,946 Topics
 | |
| | Hello All, I have declared one of my fields in the database as PropertyName varchar(100); Now the problem is that when I try to insert the text having an apostrophe using my html form it gives me an error. Can you please help me with the issue as I am …  |
| | hello im doing a driving instructor website for my project, and a driving instructor enters his or her times of booking and the search below gets the results and displays them, but i want the user to be able 2select upto 2results and once they have selected them they click … |
| | This code works but i want to add all the total costs up at the bottom of the search output, the[B] // Loop through data and display[/B] is outputs displayed from MySQL, from this code all i get is the total price for each booking but i want to add … |
| | Hello, I am having difficulties with this, I have been working weeks on getting a site finished and I'm down to the last couple of pages and this has become irritating. If you could help I would be very thankful. Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource …  |
| | I am running a .sql file against my database to build the tables. However Once i reach the Create tbl_static i recieve the following error on one of the insert statements: MySQL said: Documentation #1366 - Incorrect string value: '\x80\x99s Ba...' for column 'fld_description' at row 1 The Insert Statement … |
| | I am relatively new to mysql. I am updating a site for a customer, and I'm using mysql 5 w/ phpMyAdmin. I was supplied an .sql (echeck.sql) script to build the database for this site. I create a database named "echeck" in phpMyAdmin, and once created go to the import … |
| | Hi everyone, i am a newbie to PHP and i am struggling with the following error. i am trying to follow this [URL="http://www.roscripts.com/PHP_login_script-143.html"]link[/URL]l tutorial but its not working. Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /Applications/MAMP/htdocs/functions.php on line 73 Warning: mysql_num_rows(): supplied argument is not … |
| | Hey all, first post here and im also very new to PHP, but been having major headaches over one query. The query simply inserts some data into a table, which i've done in myphpadmin, the myphpadmin looks like this: Registration_ID int(10) No auto_increment Registration_Date date No Academic_Year int(2) No Year_of_Study … |
| | hi all experts here, i am currently doing my web project using PHP and facing no clue for the database connection between 3 tables....here it is: i'd created 3 tables, one keeps users' username, password, and id....the other keeps the details that user input from a form...both contain a common …  |
| | Hi guys. I have a DB table looking like this: #DATE #NAME #C1 #C2 2007-08-27 user 1250 2294 2007-08-28 user 1816 3096 2007-08-29 user 89 3153 2007-08-30 user 71 2986 [..] I started collecting data in late August 2007 and it's being updated every day. I want to fetch the …  |
| | i am adding elements to my db and the elemtents which have been add will be displayed on a different page. i am using an upload page which creates a thumb nail of an uploaded image and then stores the path for this image in a variable called $thumb_name. the … |
| | Hello I'm trying to teach myself how to use mysql and php via a couple of books and a lot of hacking away. I have Jesse Feiler's book "How to Do everything with Web 2.0 Mashups" and I'm stuck on chapter 11 which is a practical exercise in mashup building. … |
| | I have a timestamp column in a mysql table. Using PHP, how do I convert the timestamp format which is "YYYY-MM-DD HH:MM:SS" into a format like "March 16 2008, 08:41 am" ? Please help Thanx |
| | hi for all the expert here, i am now facing a minor problem on retrieving data here. MySQL do contain all the variables defined with data inside it. However, i juz need to know how to loop through the array to get all the data in a row? Below is … |
| | Hello, I created this site on my local machine using PHP 5.0.4 and mysql 4.1 and it works perfectly fine. I then ftp it to my webhost but the code to retrieve values give me this error. Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/laterallinks/ApplicantInformation.php … |
| | i am trying to connect to my database which i have set up and i keep getting the same message 'could not connect'. i have a php page which sets up the database, and i recall this page with the include db.php to connect to the server. i have tried … |
| | anybody mind teach me how to connect between tables in db??say theres table a, b and c in db .how can i make all these table connected??theres any coding??im using EasyPHP as server  |
| | Dear all site members, my hosting provider says that there are SQL queries running from my i.p address (I am renting a dedicated server, if it matters to the question) to another i.p address on their network. Basically, something on my server is connecting to a MySql database on a … |
| | Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/doreen/public_html/trunk/template/posts.php on line 19 I don't know how to fix it |
 | hi , M facing the problem to get first 4 rows from the table . m using sql2000. i used count but it is showing total no of rows in a table . please let me know the query used to display rowcount. |
| | I need some help suggesting an elegant way of doing something. I'm currently in the planning phase of a media management solution that comes in two parts; The administration website, and the deployment website. What I'm considering doing is, at the time a member signs up for an account, I … |
| | How can I create a trigger to UPDATE this for me when a new record is inserted. I want to create a column called "fullthumb" where by default it has the words "http://example.com/thumbs/" and add the words in "thumb" column. In syntax: [code]UPDATE files SET fullthumb = CONCAT('http://example.com/thumbs/', thumb);[/code] I … |
| | Hey everybody, I'm new to mysql, but I'm developing a real estate website, mostly for condos. I'm setting up the database and want to make sure it's sufficiently designed so that customers can search the database for the type of place they want. Specifically, if someone wants to search for … |
| | i have created an image upload page in my web site which stores the images on the server using php. i now need to get the images to display on a different page. here is the code i have used to set a variable to the file directory // the … |
| | What would fundamentally change with MySQL between using XAMP or WAMPserver so as to render MySQL inaccessible, triggering a MySQL 2003 error code? Last Sunday I was comparing XAMPP with Wampserver. I used the same MySQL database. I approached the experiment from the analogous point of view of using the …  |
| | Could some please help me. I am following a tutorial from "http://www.devarticles.com/c/a/MySQL/Building-A-Persistent-Shopping-Cart-With-PHP-and-MySQL/2/" I keep getting a " Parse error: syntax error, unexpected $end in C:\xampp\htdocs\cart1\products.php on line 59" My db connection is fine but I am trying bring a result from the diagram shown in the url. Please help. This … |
| | How to create a trigger to UPDATE this for me when a new record is inserted. I want to create a column called "fullthumb" where by default it has the words "http://example.com/thumbs/" and add the words in "thumb" column. UPDATE files SET fullthumb = CONCAT('http://example.com/thumbs/', thumb); |
| | Ok I got a new multimedia search engine that im hoping to launch pretty soon. ([URL="http://im1musicc.cs-webhost.com/search/"]temporary link here[/URL]) I all ready got the number of mp3 downloads counter set up there using flat files, but I didnt do that. It was all ready done when I got the script. Now … |
 | [code=mysql] $result = mysql_query("SELECT * FROM cycles WHERE Upper(brand) LIKE '%$brandC%' AND type LIKE '%$typeC%'"); [/code] Above code is not working, pls help. |
| | Attached to this thread is the DB schema I've come up with. I'm trying to do an outer join to join the exercises to the submissions regardless if there's a related record in the submissions table. Trouble is when a user logs in I want to execute this query and … |
| | i have a text area where user can enter some notes ,i save that in database by taking text as data type ,and while retrieving it through Ajax its not retrieving as each new line in text area is entered as a special character ,please help me anyone to get …  |
| | This has become a horror, a horror I tell you. I am not a techie. I am not a developer. I do not want to be a developer. I am trying to set up a pro bono program for a non-profit law office that serves the poor. Every time I … |
| | I am a beginner in JSP, I am just wondering will it be possible to create a pie chart in jsp without installing new classes and stuff? If yes, how can I do it? Or else will it be possible if I retreieve the data from mysql and display it … |
| | I want to add an image to my php script: [QUOTE]<?php $sql = "select * from Prod_listing"; $result = mysql_query ($sql); while ($row = mysql_fetch_array($result)) { $field1= $row["Product_Name"]; $field2= $row["Product_Id"]; $field3= $row["Product_Description"]; $field4= $row["Product_picurl"]; echo "<h1> <strong> $field1 <br> </strong> </h1>"; // Header Tag, bold.tag echo "$field2<br>"; echo "$field3<br>"; echo … |
| | Is it possible to make a column on my database that automatically copy another column on the same table string together with another url? for example on my database "ewelby_k5" I want to create a new column called (fullthumb) on table "files" where "fullthumb" stores "http://k5live.com/thumbs/ + column "thumb" " … |
| | after some troubleshooting inside the tables of a mysql database the system still not runs stable. The next day I wanted to login via Plesk it stated: 'ERROR: PleskFatalException Unable to connect to database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 0: /usr/local/psa/admin/plib/common_func.php3:156 psaerror(string 'Unable to connect … |
| | mysql4.X is installed on my system.while i tried to install Phpbb forums in my personal computer it is giving the following error: Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Program Files\Apache Group\Apache2\htdocs\phpBB2\db\mysql4.php on line 48 Warning: mysql_error(): supplied argument is not … |
| | hi all, i just want to know whether it is useful to alter the 50% threshold scheme that mysql uses by default ,is it beneficial in any way regarding serach(either by increasing or decreasing its value)or is it good to use default value of 50% only. which is better (altering …  |
| | I am relatively new to mysql. I am updating a site for a customer, and I'm using mysql 5 w/ phpMyAdmin. I was supplied an .sql (echeck.sql) script to build the database for this site. I create a database named "echeck" in phpMyAdmin, and once created go to the import … |
| | Can not get the following code to delete Jack.... What is wrong with the code? <?php ===QueryString=== delete.php?q=169|170|171| $arr = explode('|', $q); for ($i = 0; $i < count($arr); $i++) { $query .= "DELETE FROM aCar WHERE aID = '".$arr[i]."'"; $result =mysql_query($query); } ?> Thanks in Advance!  |
| | I had my site working which require mysql database... so now im trying to host that site here at home... my site comes up but now on the top of the main site 3 errors come up... Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'milatcom_clipsha'@'localhost' (using password: YES) in /www/www.mysitesname.com/include/adodb/drivers/adodb-mysql.inc.php … |
| | Hello Everyone i need help connecting my site to a database.. Either MySQL or PHP Which Is better. |
| | I used both Myisam and InnoDB. We have something like 500k update, 500k and 500k insert/delete/replace per hour. Many full scan because of updation.Both give me some problem either dead lock occurs or too many connection rise. Also insert/delete/replace operation takes long time. If i used innodb then dead lock … |
| | I'm looking for some PHP scripts that be able to search into the Database and retrieve all the records that matches the user input string in the search form. Please advise. |
| | I want to apologize for this morning's downtime. We were having some mysql problems this morning, and I didn't realize it until I woke up, a few hours too late. Sorry everyone! Cheers, Dani |
 | I am emailing a field from a MySQL DB table. The field type is text. Basically, it is an accept email. How can I make it so the email sent is capable of emailing HTML to make the message more attractive? I have already tried to insert < html > … |
| | I want to build a web application with MySQL database. When more users will visit my site, more database queries will be initiated and the response time will increase. - Is there a limitation for the number of users who can query MySQL? - What are the ways to handle … |
| | hi i want to know how to fetch data by giving more than two condition...please tell me wat should i use eg i have a query [ICODE]SELECT * from post_resume WHERE ind_type='IT'and career='Engineering' order by tdate DESC[/ICODE] i want to check based on another condition also... [ICODE]select association from employer … |
| | hi, i need ur help. can u help me how to remotely connect some database like ms access,sql server,etc to mysql?every minute i hav to send new information from database ex ms access to mysql. I use VB6.  |
| | guys i m really havin hard time to establish connection bet jsp n mysql...give me some tips..i ve done all the procedures required for that n i couldn execute the followin code [code=html]<%@ page import="java.sql.*" %> <% String username="mahesh"; String password="mahesh"; String connectionURL = "jdbc:mysql://localhost:3306/mahesh"; Connection connection = null; //Statement …  |
The End.