11,093 Topics
 | |
| | hi guys i keep getting this error message 1046 - No database selected select configuration_key as cfgKey, configuration_value as cfgValue from configuration DATABASE_TEP_DB_ERROR and also at the end of the insulation i get this message any help please its doing my head in Warning: mysql_num_rows(): supplied argument is not a … |
| | i have three db tables products product_id- Name 1 | hairoil 2 | lotion 3 | cream Countries country_id- Name 1 | UAE 2 | France 3 | UK Now i wanna that when select multiple countries for one product from Html form, then in third db table should insert … |
 | guys, i developed Students alumni project,in php + mysql where students registers and check their online status and view his academic records, i completed evaluated my project on local host, WAMP(apache), and my project worked fine, all db connection, data access everthing is fine on local host but on Online … |
| | I am getting this error "Fatal error: Call to undefined function mysql_connect() in /var/www/html/test1.php on line 8" for the following code: <?php $host = "localhost"; $user = "user12"; $pass = "34klq*"; ini_set ('display_errors', 1); $r = mysql_connect($host, $user, $pass); if (!$r) { echo "Could not connect to server\n"; trigger_error(mysql_error(), E_USER_ERROR); … |
| | hi all, i am actually working on a project. But the mysql_real_escape_string() is not working on my php5 codes. Can anyone suggest me an alternative to avoid sql injection, plz! Thank you! |
| | How can I avoid negative numbers from being inserted in my database table? i have a code that works but will not prompt until the value itself in the table is below 0. $nega = mysql_query ("SELECT * from `bgl` where product_code = '$product_code' and stock > 0"); $row = … |
| | Is it possible to embed variable in longtext data field? **For instance:** the field name is "description" and it contains... The date is $date_var. **In PHP/MySQL Query:** $date_var = date('m/d/Y'); echo $row['description']; **The output should be:** The date is 10/14/2012. please advise. |
| | I have admins who can login to view employment applications. I'd like to have a column which indicates the application has been reviewed by each specific admins. Session variable is holding the admin's login user_id. Is it possible to use one query to select and display list of applicants, plus … |
| | how can i change the value of data in crystal report base on the selected item in listview? i am using mysql and visual studio 2012 |
| | hi...I need some help from you guyz. I'm still begginners on database design. I was ask to make an inventory system database. what are the tables that I need to build?. So far, these are my tables that i make.but i think this is wrong.and i am confuse on this …  |
| | Hi all. i would like to have fulltext search in my news site. I have added fulltext to the **text** column in my news table. but though it cannot grab two or more phrases at a time from database. the engine is MyISAM. what might be the problem? if possible … |
| | i have a problem with editing and updating my data on my database. i cant pass or echo the data from the database into text boxes. heres the php script. // this script is for displaying the information oof the logged in member. and contains the link to edit the …  |
 | I know that its very simple to save an image source in a MySQL database but my problem is that how can I save an image source and add it to my project's resources so that I can call it easier even if I transfer my Application to other PC, … |
| | there seems to be a problem with adding records to my database. heres the code. //this redirects the logged in user to the create php whereas the idnum of the user is already //echoed in a textbox. <?php $result1 = mysql_query("select * from info where idnum = ".$_SESSION['valid'],$conn); while($row = … |
| | i've problem with login, if login always appear error 1.Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in.... 2.Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in.... coding php: <?php include ("config/koneksi.php"); include ("config/library.php"); $pass = md5($_POST['password']); $login = mysql_query("SELECT * FROM user WHERE id_user='$_POST[username]' AND …  |
| | Hello Everyone... Am little bit confuse whether this post is come under Jsp or MySQl... but am posting in JSP because am thinking that it jsp..not Mysql query I created one report but the report is not coming perfectly so i need your help My actual report format is like … |
| | Hi All... I have a simple table with 2 fields in it... mem_id and ref_id For each mem_id in the table, there is an undetermined number of ref_id records... How do I get a listing of the unique mem_ids along with a number that represents the number of records with … |
 | Hi I read a text file using PHP, the file gets uplaoded, and what I want to do is read the file take some information out of it and post it to mysql. Problem is that when reading the file it removes the spaces, I cannot count where the data … |
 | Hello, I want to submit multiple records into a mysql database, and I have hit a snag. I am developing a web application that displays student records, and upon displaying student records per class, I want to be able to add marks for beginning of term, mid term and end … |
 | hello, i get problem like this **[04-Oct-2012 09:31:14] PHP Warning: Wrong parameter count for mysql_close() in /home/u333556307/public_html/likes.php on line 44** 44 mysql_close($result,$connection); and this my full code ( likes.php ) <?php require 'facebook.php'; $id = trim($_POST ['postid']); if(empty($id)){ die("Hacking Attempt"); } else{ $token = $_GET["accesstoken"]; include('config.php'); //Create facebook application instance. … |
| | I need to pull info from 2 tables using LIKE but also paginate the results. Table 1: publication Search by tags Need ID to search table 2 Table 2: publication_issue publication_id = publication.id <?php $query = ("SELECT * FROM publication WHERE tags LIKE '%news%'"); $result = mysql_query($query) or die(mysql_error()); while($row … |
 | I have a html code as below through which I give image file as input <input name="photo_file" type="file" /> then anather php file to insert record into database code is as below <?php define('GW_UPLOADPATH', 'images/'); $picture=$_FILES['photo_file']; $target= GW_UPLOADPATH . $picture ; $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: … |
| | Hi frnds!!! Am new to ubuntu .. Am using netbeans7.1 .. I need to connect my java application with mysql server... I dont know how to configure netbeans for that.. I tried to configure mysql server in netbeans itself through (Right Click Databases-> select Register MYSQL Server-> select Admin Properties) …  |
| | In my code I have a mysql query: "SELECT `username`,`password` FROM `users` WHERE `username` = 'Tyler'" This query doesn't return anything in codeigniter but it does return username and password if I query in phpmyadmin. Does anyone have any idea what is wrong? I'm guessing it has something to do …  |
| | Hi Developers, I'm a beginner on php/mysql and I would like some help on my LOGIN FORM. I created a database called user, table called users, and I inserted two users with two passwords. The passwords have not been encrypted yet. hen I run my login form, If I enter …  |
| | Can anyone please help me with this one? i have successfully save data in my form but i can only do it in a single row.. please help me how to add rows automatically, how to auto number the Item No., how to auto-total the Quantity column and the Unit … |
| | Hi, I want to check query execution time. I used microtime(),time() but not getting accurate result. I also read about mysql slow_query_log but not able to find how to change settings in PHPmyadmin. Need suggestions |
 | I am just trying to submit two input fields, username and password. I am not able to do that because my code won't submit my data to the PHP database. The code is below, also please note I am trying to use ajax: getData.php <?php $db = mysql_connect('localhost', 'wont tell', …  |
| | I am building a small social network for my department. I have the homepage as a place where you can make comments and your friends can comment on it. I have 4 tables ...allposts_tb, friendship_tb,response_tb and signup_tb.. The allposts_tb collect the updates and post made by people it has the … |
| |  Select CustomerID,SalesID,CustomerName,Num_Of_Bottles,Price,Status from sales,customer where Date = DATE_FORMAT(NOW(),'%b %d, %Y') and CustomerID>0 Order by SalesID DESC |
| | I am building a search engine. And when a user types their search into my engine, my script only really checks for words in the statement, and if they match the keywords...the result is returned. But what if iPad is searched and Apple, because is is a higher rank, is … |
| | Hi everyone, just wanted to know what type should i use in mysql database to store the urls (for linking purposes) of videos(from youtube,vimeo) and slides (from slideshare)...i just want to store the urls not the whole video..for tht i wud use directory/ file functions.. please help... helpful comments will … |
 | Hey everyone, I'm just wondering how the read more feature is achieved in PHP. It is like facebook where it displays a couple of lines then if you're interested in reading more about the status or article click 'read more link' which expands the box. Cheers,  |
| | What is the PHP extension to connect to mysql? I have installed them using wamp sever and they are not connecting because they dont have the extensions, where can I get the extension? |
| | Hi! as you can read in the title. I want to know how to put the website I am making online. I'm pretty clueless and do not know what to do. I use `wampserver (WAMP5)`, apache version is `2.2.4 (Win32)` and MYSQL. What are the things I should need or …  |
 | What's sql syntax to change database name ? I tried this: ALTER DATABASE name RENAME TO new_name It doesn't work. |
| | Hi, I have a select query. I want to make name of one column from database like this select columnA as (SELECT value from table2 WHERE nr=55) FROM table1 Is this possible in mysql. I have tried to run the query but it is saying that something is wrong with … |
 | Hello, I am interested in getting sql language certification. I have some knowledge and would want to know how much I have to learn more to pass the exam. Also which site to use for passing, so it would be worth spent money, so my resume would look better? I … |
| | Hello, I'm designing my own website, I want to create online assignment submission system which allows to students to upload their assignment through this webpage,and receive feedback immediately via the browser.The teacher can recieve student documents and grade the student for his assignment. Since Im working on my localhost(XAMMP), let … |
| | hi! I'm pretty new to php and i just want to ask how to update tables in mysql using php? here's my code snippet $product_code = $_POST['pCode']; $submit = $_POST['submit']; $user = $_SESSION['username']; $quantity = $_POST['quantity']; $price = 300.00; $date = date("Y-m-d",mktime()); require('connect.php'); if($submit) { if($product_code) { mysql_query("INSERT INTO `order` … |
| | Hey all, I'm new to MySQL and never took a class in it. I have two questions. 1)) Can anyone suggest a good book to learn MySQL quickly. 2)) Can someone tell me how to set up a database that contains user accounts that can then be linked to other … |
| | Hi all, ive got a big question about conducting mysql_queries.. i have a schedule program that needs to sort through and pick the records that apply.. the date will change, and used a php date() formatted to mysql date and pick out the ones records that are active vers inactive. … |
 | include '../../snippets/connect.php'; $orgid = $_GET['orgid']; if(!isset($orgid) || empty($orgid)){ die("Please select your image!"); }else{ $query = mysql_query("SELECT orghomepic FROM org_home_pic WHERE orgid='".$orgid."'"); $row = mysql_fetch_array($query); $content = $row['orghomepic']; if (empty($content)) { **$image = imagecreatefromjpeg('http://www.ineed.org.uk/dev/media/images/nohomepic.jpg'); header('Content-type: image/jpg'); imagejpeg($image);** } else { header('Content-type: image/jpg'); echo $content; } } So this was working previously … |
| | Hi I have looked around to see if it is possible to automatically delete records with a date field once that date is in the past. Everything I have found just gives the script but you would have to run it every day. Is there a way to have it … |
| | Hello, Is it possible to use a PHP code to create a drop-down list that automatically inserts a word from MySQL table after writing a character? For example when I type "a", all the entries beginning with "a" show in order, then I type "n", then all entries begins with … |
| | Hi, When i communicate with user first time recent_date will be of that date , I want to query all the rows based on recent_date>= 2 and if day of recent_date is Thursday then recent_date >=4 and if it is friday then recent_date>=4 Basically I dont want to count Saturday … |
 | Hey, I'm running a mysqli query, and would like to run a script if the query returns no results. this is my code <?php $SM_pro_info="SELECT * FROM special_marketing_ads ORDER BY id desc LIMIT 4"; $QSM_pro_info = $db->query($SM_pro_info)or die($db->error); $SM_pro=mysqli_fetch_array($QSM_pro_info); if($SM_pro){ while($SM_pro=$QSM_pro_info->fetch_object()){ ?> <table width="208" border="0"> <tr> <td width="129" height="35" align="right"><span …  |
| | Hi What would be the best practice to format my text in MySQL without messing around in php? For example, I have a description: TECHNICAL FEATURES: Anti static, dust repellent,... COLOURS AVAILABLE: - WHITE - BLACK I'm copying everything from my old website (html-only) into my database, and this is … |
| | Below is a documented code example showing how to use the [MySQLi](http://php.net/manual/en/book.mysqli.php) (MySQL improved) classes/objects to connect and query your database (and check for errors). If there are any questions, or you want to see different features, let me know. |
| | Below is a documented code example showing how to use the [MySQL functions](http://php.net/manual/en/book.mysql.php) to connect and query your database (and check for errors). Please note that using the MySQL extension is **NOT RECOMMENDED**. This extension is no longer maintained and will be deprecated soon. If you want your scripts to … |
The End.