10,938 Topics
 | |
| | |
| | The code below is to select and then echo stuff from my db grouped by either weeks or months. I have a couple of more of these and then use offset to get the second week etc. FROM my_db WHERE DATE >= CURDATE() - INTERVAL 10 ".$grouping1." GROUP BY ".$grouping."(DATE) …  |
 | Hello, I am using xampp for mysql: When I try to delete a database : "DROP DATABASE" statements are disabled. That statement appears. Why is it? What other alternative I could use? Thanks. |
| | Hi all I am experiencing the following error. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean givenit refers to line 94 which is the while loop start point. Thanks in advance D <?php $x=0; $remainder=0; $image_value = array(); $partners_id = array(); $description_value = array(); $url_value= array(); $image_filename_value = array(); … |
 | Hullo, I am working on a php application that is meant to respond to user requests to create accounts. For instance; whoever wants to create an account has to send a text with "Login" as the message content. Only problem is that the mysql queries are not being executed. Can … |
| | Hello, I need advice about making a PHP form and MYSQL base. First, I'll give an example of what I trying to make: I'm trying to make a MYSQL base of products, then to make new base of ingredients and then to make php form for Add new products and … |
 | Hi, I have imported a csv file but for some reason in some values the data after . is missing for e.g. If my value in csv is 0.5 it displays 0. and 5 went missing but in my csv file i have value as 0.5 I don't what step … |
| | I have tried many different scripts I have found but cannot find one that does exactly what I am looking for. I have a table that has parts with multiple characteristics. Part Number, Height, Width, Capacity, Price, Etc. I would like to have a drop downs for all of these … |
| | I have the following simple table: CustomerID CustomerName NumOfOrders 1 Joe 15 2 Jane 20 7 Clara 1 I want to find the customer with maximum number of orders. Seems trivial enough but I can,t seem to find a solution. |
| | Hi I take data from a html form to inseert to mysql, sometimes that data has single and double quotes in it. How do you get the quotes to be part of the string so i can add to mysql. Hers what I have, but this still gives me a … |
| | Hi i'm practising in creating an android application where a user can store records into an external database (my local server in myphpadmin). I can store records into the the database just fine but I wish to prevent the same information being entered twice. I wish for my system to …  |
| | Hi there, I want to execute a query that i saved in my database like this: ID | NAME | QUERY 1 | show_names | "SELECT names.first, names.last FROM names;" 2 | show_5_cities | "SELECT cities.city FROM city WHERE id = 4;" Is this possible ? I am kinda noob … |
| | Hello. So, I have 2 questions. First is: I am trying to calculate the expiration date which will be calculated as adding the current date + the option that has been select i.e. 30, 60 or 90 days. $EXday = date('d', mktime(0,0,0,0, date(d) + $_POST[exdays], 0)); $EXmonth = date('m', mktime(0,0,0, … |
| | Hi, I have imported .csv file and column is appearing as Col 1, Col 2... and the data I want as a column name is appearing as a first row. How do I convert my first row into column name in phpmyadmin. Thanks in advance |
 | Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'some_user'@'abcd.efgh.com' (using password: YES) in /home/some_dir/public_html/some_dir/db.php on line 1 Fatal Error: MySql connection failed.Access denied for user 'some_user'@'abcd.efgh.com' (using password: YES) Here is my code of db.php <?php $connect = mysql_connect('www.example.com','some_user','some_password'); if(!$connect) die('Fatal Error: MySql connection failed.' . mysql_error()); $connect_db = mysql_select_db('db_name'); if(!$connect_db) … |
 | Hi! Ok, here's my problem... Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'hjhwkhjrf'@'10.1.1.43' (using password: YES) in /home/a6653219/public_html/connect.php on line 12 (pw changed) Lower part of connect.php..... $=line 12 // do not edit below this line!! /////////////////////////////////////////////////////////////////////// $dblink=MYSQL_CONNECT($MySqlHostname, $MySqlUsername, $MySqlPassword) or die("Could not connect to database"); @mysql_select_db("$MySqlDatabase") or die( "Could …  |
| | Hi all, Im working on a web application in which I need to show data from MySQL on page scroll. Ive found a reference online, below is the code. I want to customize this and show my data in ASP:GridView ASPX page <form id="form1" runat="server"> <div> <h1> Demo page: Load … |
| | Hi all I have an sql output query problem I am trying to resolve. The problem is that I have centres that offer Awards and quals and some centres only offer awards or quals only. What I need to process is the centres that offer both awards and quals. tbl.net.qualification … |
| | hello friends, What is the difference between Mysql_fetch_object and mysql_fetch_array ?  |
| | Hello I need to install magento on my server and for this it requires pdo_mysql I am trying to install pdo_mysql via whm option "Easy Apache" I tick the pdo_mysql option but after apache rebuilding process the phpinfo not showing pdo_mysql Do I need to enable it some where I …  |
| | |
| | Hello, I'm trying to make notification when msql column reach a certain number. For exemple, I have table "items" with products, witch in their structure have columns id, name and quantity, and when column "quantity" reached 5, I want to make automatic notification: - In new table called "notifications" witch …  |
| | HI! Just setting up my site... first thing I see after domain working is..... Fatal error: Call to undefined function session_is_registered() in /home/vhosts/www.universal-abundance.com/config.php on line 87 Any ideas..... I'm db impaired! Thanks, L-D |
| | Hello, I have a table called product and whenever the value of the field stock = 0 I want to send a notification email to a specific email address. I would like your help guys on how I can implement that and if this is possible. I considered using PHP … |
| | Hey everyone, Sorry for the lack of knowlege. I've tried google-ing how to imput and display images on a web page without the image showing up in weird symbols, but I've had no luck. Can anyone help me? My purpose is to simply store an image manually into a mysql … |
| | -- phpMyAdmin SQL Dump -- version 3.4.5 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: May 29, 2013 at 04:31 PM -- Server version: 5.5.16 -- PHP Version: 5.3.8 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET … |
| | I have a MySQL dump and the dump has timestamp datatype. But the values are not escaped in qoutes. I want to write a regular expression to write to match the time tamp column and replace it by enclosing in quotes I have some thing like this: 2006-02-15 04:44:00 I … |
 | hi, im a newbie and just read about triggers.. i am trying to create a trigger using navicat for mysql in the triggers tab for the table i select new trigger with update after insert( these are the ready options it has) then in the definition i added ` DELIMITER … |
| | Hello Guys, During the process of making my website I have been stopped by a problem. Background Info: I am using jQuery sortable lists and I have multiple lists on the site which submit the information to the file that updates them in the database. Problem: If I want to … |
 | Hi All, I am running the following query: UPDATE YFR_Master_Fundraisers SET FRActive=0 WHERE FRNameCode IN ( SELECT FundRaiser FROM YFR_Master GROUP BY FundRaiser HAVING MAX(CollectionDate) < DATE_SUB(CURDATE(),INTERVAL 2 MONTH) ) It is giving the error described in the subject line. The query seems to be taking too long and timing … |
The End.