10,940 Topics
 | |
| | |
| | I have made this stored procedure DELIMITER // DROP PROCEDURE IF EXISTS find_max; CREATE PROCEDURE find_max (IN type INT,OUT maxx INT) BEGIN SELECT max(card_id)+1 INTO maxx FROM cards; END; // DELIMITER; and i want to have this stored procedure DELIMITER // DROP PROCEDURE IF EXISTS add_card; CREATE PROCEDURE add_card (var_member_id … |
| | i am learning php and i am trying to insert data into a database from a form using php. here is the php [CODE]<?php include "connecttodb.php"; $name = $_POST['name']; $email = $_POST['email']; $password = $_POST['pass']; $query = "INSERT INTO ******* SET username='$name', password='$password', email='$email'"; mysql_query($query) or die('There was an error … |
| | Here's the code I have [code] $query = "SELECT partID, fname, lname FROM tblPartInfo WHERE lname = '$lname' or fname = '$fname'"; [/code] Works like a charm. Now, I want to be able to use wildcards so that the user can enter, for exemple, HO to search for HOUSE so … |
| | i have created new database it is there in C:\xampp-win32-1.7.3\xampp\mysql\data that directory but it can't visible in [url]http://localhost/phpmyadmin/[/url] in that phpmyadmin that combo box please can u help me |
| | I am only new in vb 2008 .I Want to populate a combo box in vb 2008 with mysql, but when i run the thing that appear is "System.__ComObject"..kindly check the errors...plz.. [code] Dim conn As ADODB.Connection Dim rs As ADODB.Recordset conn = New ADODB.Connection rs = New ADODB.Recordset With …  |
| | I'm having trouble getting my python scripts to insert into a mysql database. I'm able to do other commands successfully such as adding or dropping tables, selecting items from tables but inserting into tables isn't working. I can manually insert but the script won't do it. I have an entry …  |
 | Hi guys! Im kinda new here and lately I'm developing a[B] PHP MySQL Module Generator[/B] that will help us to easily manipulate the database. since I want to make thing fast and I know lots of you agree with me that doing data manipulation stuffs like MySQL is boring so … |
| | I am still fairly new to PHP, so I will do the best at explaining what I am trying to do here... I have a database table where I store a bunch of invoices. I am now trying to make a front end to run queries. I don't know how … |
| | Hi, I'm trying to create a drop down menu with dynamically populated options. So, within a typical HTML form I have: [CODE] $conn = mysql_connect ("localhost", "xxxx", "xxxx"); mysql_select_db ("wkho_TTX", $conn); $query = "SELECT * FROM venues"; $result = mysql_query($query) or die(mysql_error()); $num=mysql_numrows($result); $i=0; while ($i < $num) { $option … |
| | Is there any free migration tool for mySQL to Oracle ?  |
| | Hi, I'm trying to access two databases and retrieve the same data from each but I only want one "No People are on" to be displayed if there is no one on in both databases. If one user is online, in only one database, I would like only the users … |
| | Hello everyone, I have a database with a list of characters and I would like to display which characters are currently logged in on a webpage I have. My database looks like this: [CODE]`characters` (`account`, `name`, `online`) VALUES (6, 'Frod', 1);[/CODE] I hope that makes sense. So if 'online' = … |
| | Guys i`m trying to archive something like facebook,twitter wall Display. I have a friend table,inside it has id,friendid and userid. also got feeds table which contains id,action,sender_id,statusid,status,date. What i have succeeded to do is if You are logged in you can see all the updates from your friends...As the code … |
| | I have a database which, because of a Vbulletin mod error during uninstall, has left me with a database I can't restore. It says there is a query for a table that doesn't exist and a username attached to the table. Is this fixable? |
| | I'm trying to pick up the latest record for 6 groups, and I'm using the following Select statement: [CODE]SELECT * FROM newproducts LEFT JOIN (suppliers, newsrchGrps) ON (suppliers.supplierName = newproducts.supplierName AND newsrchGrps.groupCode = newproducts.groupCode) GROUP BY newproducts.groupCode ORDER BY newproducts.updated DESC LIMIT 6[/CODE] which does pick up a total of … |
| | Hey guys, I have been trying to create a registration page for a while now, and I just can't seem to get it right. Could any of you help me? I currently have 3 php pages. The first is the homepage, which also includes a sign up form: [code] <form … |
| | i am trying to create a simple guestbook to include in a web site. i cant get the form to add the data to the database nevermind post the entries. there are 3 files guestbook, addguestbook and view guestbook. im using server2go and dont know whether there is something in … |
 | Hi, I'm running my server on localhost. I'm trying to make a forum database program in php, but I can't get mysql to work! whenever I try to add a table, it says there isn't any database. How do I add a database to localhost? Thanks in advanced for your … |
| | How to use dreamweaver to create a database? |
| | Well im currently coding up a paypal payment system to go with a user system for a site, and when someone goes through paypal, paypal pushes info to this script. Problem is, the script does not log anything to MySQL, and I can't figure out why. Anyone here want to … |
| | Hi all, First of all I am new with server using. Below my virtual private server details: [LIST] [*]Processor : 2.8 GHz Dual Core [*]Processor Cores: 2 [*]RAM Memory : 4GB [*]Apache Version: Apache/2.2.3 (CentOS) [*]PHP Version 5.1.6 [*]MySQL Version: 5.0.77 [*]HDD: 100GB [*]Bandwidth: Unlimited [/LIST] Due to 3GB of … |
| | Hi, I have this error Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\Program Files\xampp\htdocs\nsubackend\lib\model\classLabType.php on line 9 & same in line 52. here's my code: [CODE]function __construct($id=0){ $con = new connection(); $query = "SELECT * FROM tbllabtype WHERE labtypeID='".$id."'"; $res = mysql_query($query); if(mysql_num_rows($res)>0){ $row = mysql_fetch_array($res); … |
| | hello, I have a simple problem. I need to create a new table "smaller" using the data from an old table "larger" table. When I say smaller I mean it will have the exact structure as the older table but will have only a few records. Now, i know that … |
| | Hi, I'm trying to write a script that allows me to insert a file into MySql. I would like it to work under the user's session. I am getting error:(You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right … |
| | PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xxxxxx/public_html/classes/users.php on line 162 PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xxxxxx/public_html/classes/user.php on line 62 Here is users.php [CODE=php]<?php class user{ var $user=array(); var $random_id; var $random_link; var $currentpoint; var $minspoint; … |
| | I've been working on a project lately that is written in python and I want to incorporate mysql into it. The python code is basically a sales report writing system in which every sales report will have it's own number such as 10-0001, 10-0002 and will contain customer information like … |
| | Hi, I'm hoping someone out there has the answer to this question: How does one convert a table column's data type from INT to CHAR/VARCHAR? Background: I'm trialing some ID card software and it uses Access as its backend. It has ODBC capability and I'm able to connect to my … |
| | Hi, If I run the following mysql_query: [ICODE]SELECT * FROM products WHERE product_name LIKE '%SOM%'[/ICODE] I get the following results: [INDENT]SOM 1 - Coloured option SOM 2 - Magnetic Roof Sign SOM 4 - Magnetic Roof Sign - Centre L SOM 6 - Magnetic Roof Sign - Curved Top SOM … |
| | Can anyone see where im going wrong with this code I keep hitting a brick wall with it. Its doing my head in. I think its more the sql code, It keeps showing all data instead of just showing the data based on the user_id which should be limited to … |
The End.