10,946 Topics
 | |
 | hi, it is possible that one column in a row has a data ? and how to code it in vb6 if possible, please help example NAME: rasha bonquel Age : 20 SUbject : Math , English, Science Grades : 78, 78, 78 NAME | Age | Subject | Grade …  |
 | **I got this error on line 369** Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/a4670304/public_html/lol.php on line 369 <?php // session_start(); require_once('auth.php'); include("dbconnection.php"); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <link rel="icon" href="img/Untitled-1.png" type="image" /> <link rel="shortcut icon" href="img/Untitled-1.png" type="image" … |
| | **I Get error like this when i start the host.** <script type="text/javascript" src="jquery.js"></script> <script type="text/javascript" src="jquery.watermarkinput.js"></script> <script type="text/javascript"> $(document).ready(function(){ $(".search").keyup(function() { var searchbox = $(this).val(); var dataString = 'searchword='+ searchbox; if(searchbox=='') { } else { $.ajax({ type: "POST", url: "search.php", data: dataString, cache: false, success: function(html) { $("#display").html(html).show(); } }); …  |
| | hi guys, i have 2 tables - tblproduct and tblretprod. i insert my product details to tbl product with prod_id being auto increment other fields are prod_name, prod_brand, prod_desc, prod_photo, cat, subcat i hv another table tblretprod with fields id, user_id, prod_id, prod_price i can add my products successfully i … |
| | ## Before You Ask ## - Engage your brain! We understand that running into a problem can turn off the rational centers of the brain, but please sit back and think for a bit about your problem before running off to find help. All too often a little common sense … |
| | Hello, I have a mysql query $query = "SELECT * FROM comments WHERE commenter_username IN (" . join(',', $list) . ") Or Number IN (" . join(',', $list) . ") ORDER BY comment_id DESC"; I want the query to select one row, the row with the highest id. Then store …  |
| | hello, am new here and new to php/mysql coding. i have 2 tables - tbl_prodstd and tbl_products tbl_prodstd - std_id, prod_name, prod_desc, prod_photo, prod_brand tbl_product - prod_id, std_id, prod_name, prod_brand, prod_desc, prod_price, cat, subcat, prod_photo i created 3 pages - add_prod.php, addprod.php, func.php the func.php displays prod_name and prod_brand as … |
| | I'm trying to set a query that will pull all clients whose birthday is today. I'm using phpmyadmin localhost via Unix socket, birthday is set as DATE. All I need returned is the firstname (emp.emp_firstname asfirst name) , lastname (emp.emp_lastname aslast name) and date of birth (emp_birthday as 'dob')  |
| | I have a form as follows, and I have set the session on clicking next. Each type of house is with a different set of rooms. Say, if I click Independent, I get a list of rooms below. If I choose Villa/Duplex, a different set will pop out. In the … |
 | I know this has been asked on almost every forum but I've been at this for two evenings now and I'm stumped. PHP 5.4.6-1ubuntu1.2 Server version: 5.5.31-0ubuntu0.12.10.1 (Ubuntu) Initially I had no access to mysql functions either but that hurdle has been overcome. I've placed the extension modules (.so files) … |
| | Hi, i'm doing a website where the user can add his favourite bands in his profile. But not every band is in the DB, so if the band isn't in the DB it adds the name in the column. this is what i have: if(mysql_query("INSERT INTO bandas_fav(band_fav_id_user, band_fav_id_banda) VALUES('".$_GET['iduser']."', '".$bands_name['banda_id']."')")) …  |
| | I want to upload images to my database, these can be done using php and mysqli . The form contains some information like file descriptiopn and input file and when i submit the file the file will automatically enters in to the database and the image will be stored in … |
| | Hello, there is a small php script that I am converting from using mysql to mysqli, but I am having a bit of an issue with mysqli_fetch_fields (this is where I assume the problem lies). Basically it is a form that allows someone to enter free form queries in order … |
 | Hello, i need help here...., i try to insert my data into mysql, but every time when i insert data into my database, its insert two record in one time, 1 row is the data that i insert and another row is empty, just the auto increment column have filled, … |
 | I want to know if its possible to store php variables in mysql database i currently have a text field which stores the value <div class="row-2"> <div class="titles"> <?=$config['slogan']?> </div> </div> this is the slogan for the website that is in anther table which is got before this - if … |
| | I have two tables named `stockin and stockout`. I can execute query easily separately for each table. Now, I want to bind both query in a table. Please check query and output below- query in stockin: select serialno, sum(in_quantity) SUMIN, group_concat(in_quantity) GCIN from stockin group by stockin.serialno output: +----------+-------+-------------+ | … |
| | Hi, Me again... Just wanted to know, i have this piece of code to enter the data from a registration form of mine into the user db. I want to use the mysql_real_escape_string to help stop those evil people who enjoys hacking from hacking my DB $query = "INSERT INTO … |
| |  I have three tables, and I'm going to show the third table. What I want to know is how to delete each entry from it? As, the first and the second tables ids are fetched and inserted in the third one. As in, I have my model as … |
| | Hello All: I am some difficulties getting some database variables from an included file to my mysql connection. Here is what i have: file one Called config.inc.php: session_register("client_id"); $_SESSION['client_id'] = $_SESSION['SESS_ACCT_ID'];// $club_id=$_SESSION['client_id']; ob_start(); include('../../../page_title.php'); ob_end_clean(); include('../../../datalogin.php'); if (!defined('DEFAULT_HOST')) define('DEFAULT_HOST','localhost'); if (!defined('DEFAULT_USER')) define('DEFAULT_USER',$account_user); if (!defined('DEFAULT_PASS')) define('DEFAULT_PASS',$account_pass); if (!defined('DEFAULT_DB')) define('DEFAULT_DB',$account_db); the variables … |
| | I am changing my web site from static html pages to php pages using includes and a mysql dbse. In the dbse table I store the blog body text and the blog title text, and the blog date. I have written a page I call 'previous_blogs.php' to list all the … |
| | Hello Friends!! I need some help here.... i build a website called E-Maintenance, now i need to make a form that user can choose date and the system will insert into database mysql after the user click submit, im searching on the internet and i found this Javascript calender, this … |
 | ## Stored Procedure ## -- Procedure name: billing_to_invoice_update BEGIN UPDATE accounts.0_debtor_trans SET ov_amount=ov_amount+fee-oldfee WHERE trans_no=encounter AND branch_code=pid; UPDATE accounts.0_debtor_trans_details SET unit_price=fee/units,quantity=units,qty_done=units WHERE debtor_trans_no=encounter AND stock_id=CONCAT(code_type,'/',code); -- gl updates UPDATE accounts.0_gl_trans SET amount=ROUND((-1)*fee) WHERE account=code_type AND memo_=CONCAT(code_type,'/',code) AND last_service_encounter=encounter; UPDATE accounts.0_gl_trans SET amount=ROUND(fee) WHERE account=1100 AND memo_=CONCAT(code_type,'/',code) AND last_service_encounter=encounter; END BEGIN … |
| | Hi all! I'm stuck somewhere. I have a table for Inventory (which contains the available amount of each food component) What I want to do: If I select a certain food (say salad) I want to be able to deduct the components (amount) of 'salad' from the inventory table. Consider …  |
| | Hi all! I don't know if that was a good title, but; I have this query (I will call it query1): "SELECT InvID, quantity FROM Recipe WHERE MenuID = 1" In my tables, this will give me something like Water(20), Oil(30) Now, from this result of a SELECT query1 (i.e … |
| | I'm totally new to php and learning. I have a table name *persons* which has columns * FirstName * LastName * Gender * Subject * Hobbies **The Task:** was to dynamically populate a drop down list with the data of FirstName, display the selected record of the name chosen in …  |
| | Hello, I want to make a conditional SQL. I have one table "users" and it has two columns (id, status) I need to search for users IDs based on their status. For example. Every 5 seconds I am querying from the database (by AJAX) as per the below description: Let … |
| | Hi. I have HTML form and i need php code when i want to subtract something from coulmn in mysql database. Something like http://www.daniweb.com/web-development/php/threads/101739/using-php-and-html-forms-to-update-a-mysql-database MY FORM - HTML <form action="objednat_potvrdenie.php" method="post"> Meno: <input type="text" name="meno"><br> Priezvisko: <input type="text" name="prie"><br> Mesto: <input type="text" name="mesto"><br> Ulica: <input type="text" name="ulica"><br> PSČ: <input type="text" …  |
| | Hi All - I am trying create classes for db connection and I am getting the following error Thanks in advance D Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'XXXXXXX_david'@'localhost' (using password: YES) in /home/djenning/public_html/dbconnection/connection.php on line 20 Cannot connect to the database page: connection.php <?php class createConnection //create a … |
| | I came up with this query now when i tried to create a view it failed to create SELECT aDate FROM ( SELECT @maxDate - INTERVAL (a.a+(10*b.a)+(100*c.a)+(1000*d.a)) DAY aDate FROM (SELECT 0 AS a UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 … |
| | |
| | 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 …  |
| |
The End.