10,940 Topics
 | |
 | I am new to the datebase concepts.. I am having a DataBase Management course in my engineering program now a days and i have to submit a small database project in 2 weeks which should be based on the core and complete fundamentals Database... I m using mysQL can any …  |
| | I m working on project in which i have to store member automatically in binary tree form like 1 is root 2 is child of 1 3 is child of 1 Then 4 is child of 2 5 is child of 2 6 is child of 3 7 is child … |
| | Hello all, I'm fairly new to using PHP, and for my assignment I've coded it all but I'm trying to go the extra step, and code something that if the item amount = 0 it doesn't print it out on the order form The items are $LAPTOP $MONITOR $KEYBOARD $PRINTER … |
| | Dear all i have created a small windows form application, which connect to mysql database, and the database is installed on a remote pc( virtual machine), i am using visual studio 2010 in winxp 32 bit , and i have build this application using .NET2.0, so that it can work … |
| | I created a stored Proc: Create PRocedure InsertTBL_Supplier ( @SupplierNumber nvarchar(50), @SupplierName nvarchar(50), @Address nvarchar(50), @ContactNumber nvarchar(50), @ContactPerson nvarchar(50) ) AS BEGIN INSERT INTO TBL_Supplier (SupplierNumber, SupplierName , Address, ContactNumber , ContactPerson ) VALUES ('10000','JenRoses Shop','Pasig City','09159675567','Dara Lim'), ('20000','Lawren FlowerFave','Makati City','5564818','Aiden Lee'), ('30000','FLowers&Scents','Marikina City','7280823','Dennis Park'), ('40000','Pretty Flower Spot','Pasay City','09276543789','Joshua Tan'), …  |
| | Hi Hope someone can help with this as I dont really know where to start. I am trying to automate a quite large txt feed I get from an external url to import into database. I currently do it manually through database software, but it takes too long each day. … |
 | |
 | So Heres The problem code i get a Parse error: syntax error, unexpected $end in /home/crysta21/public_html/4dM1n1STr4+10nB4nk.php on line 149 from <?php /* MCCodes FREE cyberbank.php Rev 1.1.0c Copyright (C) 2005-2012 Dabomstew This program is free software; you can redistribute it and/or modify it under the terms of the GNU General …  |
 | Hello there, today I noticed there are two operation in PhpMyAdmin, Replication and Synchronization. and now I want to use these operation as the following scenario. I have local db, I want to copy its content to remotly db so when I connect to any db I see the same … |
| | I am trying to make a movie list for myself, I got everything working like add and delete but the edit gives me some headace. I get all the values fine, id, movie title, director and year are all filled in, well not what category I added using radio buttons … |
| | I am having trouble with a registration script that I am trying to implement. When I click the "Register" button, I get this error: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens This is my coding for the register function: `public function register() { …  |
 | I am first time using like in mysql .but it is giving error.my query with like is $user_query="SELECT * FROM rt_user WHERE rt_user_username LIKE %".$_GET['term']."% OR rt_user_name LIKE %".$_GET['term']."% OR rt_user_description LIKE %".$_GET['term']."% LIMIT 10"; it is giving syntax error. |
 | Hello, I have made an Employee Time clock application. I have been working on connecting my application to a MySQL database, I have a textbox wich is used to add an employee name to my database (this is working perfectly.), but I also a combobox where I want the list … |
 | My while keeps looping and i dont know why: code <?php $result = mysql_query("SELECT * FROM tag WHERE point='$pagename'"); while($row = mysql_fetch_array($result)) { $result = mysql_query("SELECT * FROM tag WHERE point='$pagename'"); //username echo $row["user"] . " ||"; //alias check $result = mysql_query("SELECT * FROM tag WHERE (user='$my_name' && point='$pagename')"); if …  |
| | Hi guys, I am a little new to this stuff but have done a few research regarding PHP. Currently, I am trying to learn PHP to allow a web portal to interact with data stored on MySQL database. In other words, lets say I have a website that displays information … |
 | how to insert data in multi dimension array into mysql database in php. |
 | Hello everyone, i need small help since im stuck, and im not that good with php and vB.net connections... So here is the problem, i manage to get connected to db and php script shows me if im connected or not, grab if user/pw is correct everything works fine, but … |
| | Hi i have a query that i want to display the pulser1 pulser2 pulser3 pulser4 from table but only when the input type for each pulser=2 when i run the query not working as i want it please check my query $netw is a variable it can be any value … |
| | Dear Friends, Help me to fix this.. Error Message : **mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in** Code is, <?php $database=$diocese; $table=$category; //capture search term and remove spaces at its both ends if the is any $searchTerm = trim($_GET['query']); //check whether the name parsed is empty if($searchTerm … |
| | i want to compare dates stored in database in the format yyyy-mm-dd by changing it in unixtimestamp in the mysql query.for this my query is $bquery="SELECT * FROM rt_booking WHERE rt_unit_id='".$_POST['unit_id']."' AND (SELECT UNIX_TIMESTAMP(str_to_date(rt_start_date,'%Y-%m-%d'))>=".$my11." OR SELECT UNIX_TIMESTAMP(str_to_date(rt_end_date,'%Y-%m-%d'))<=".$my22.")"; but it is giving syntax error. |
| | Hi, I want users on my website to upload their company logo (if they have one) while filling out my form. Right now i only have one row designated for the company logo called 'images' with the type set to BLOB. Is this adequate for both uploading images and displaying … |
 | Hello, How to create a crystal report in vb.net 2008? |
| | I am new in using MySQL database and need some help. The scenario is pretty much like this: I collect data from some sensor which come with their own software. The software builds a .db file as it takes data from the sensors and saves it locally in the computer. … |
| | am using dev c++ updated version for my project am using myql c api problem is when i run my application it stop and says that mysql.dll is missing , currently when i place mysql.dll in the app folder it cant give me the error , so i want to …  |
| | trying to search by the file name keep getting a "expects parameter 1 to be resource, boolean" error what am i missing? $pagename = basename($_SERVER['PHP_SELF'], ".php"); mysql_select_db("tagpoint", $con); $sql="SELECT * FROM tagpoint WHERE title = '".$pagename."'"; $result=@mysql_query($sql); $row = mysql_fetch_array($result); |
| | is it possible to use a string array in mysql using the set data type and add a valuse to it, like a list of names? |
| | Hello, how do i add an hour to time with DATE_ADD in DATE_FORMAT? Here is my code : <?php session_start(); include('includes/main_funcs.php'); $db = db(); $reponse = $db->query('SELECT name, message, DATE_FORMAT(time, '%H:%i') AS forTime FROM chat ORDER BY ID DESC LIMIT 0, 10'); while ($donnees = $reponse->fetch()) { echo'['.$donnees['forTime'].'] <strong>'.htmlspecialchars($donnees['name']).'</strong> : … |
| | I have been having problems with this code and i cant find out why I am trying to add a new element to an array. it says it goes throu butwhen i check its empty: $sql="UPDATE $title SET arole = CONCAT_WS(',', arole, '$name') WHERE op = '$name'"; if (!mysql_query($sql,$con)) { … |
 | Hi, I want to select all records from a table where the DateAdded field's date and time (Default value Timestamp field) is more than say 3 hrs ago. eg: something like SELECT tbldata.* FROM tbldata WHERE (tbldata.DateAdded <= now()-3); I can get it working with days difference but do not … |
| | I have a script that uploads documents, it uploads them in the destination folder, but not the info about the document. Pleasa help i need this as soon as possible. No errors show. <?php $UploadDirectory = 'C:/wamp/www/agenda1/uploaddok/uploads/'; //Upload Directory, ends with slash & make sure folder exist $SuccessRedirect = 'http://localhost:8080/agenda1/index2.php'; … |
The End.