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