11,093 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 … |
| | can someone help me or give me codes on how to save images into database i'm a new user of java. |
 | Hello Friends, I am new with asp.net.How to use mysql backend in asp.net please answer with code example.  |
| | Not sure if its the sql query or what, but I have a pagination class and a function I am trying to put together if some one would be able to point be in the wright direction it will be very appreciated. :) The following is the function which I … |
| | Hi.. I'm having problem with my website, and I just cannot figure it out what's the problem with my code. Any ideas? Thanks. [CODE=PHP] // get related files from database if ($settings['related_files'] == 1) { $related_query = mysql_query('SELECT f.fileid, f.title, f.description, f.icon, f.iconlocation, f.timesplayed from '. $tbl_prefix .'related AS r … |
| | Hi, ( I have attached a screen grab of what it looks like ) I am trying to collect tags for tagged photos based on the photo id. I get duplicates when i do [B]GROUP BY tag_name[/B] or [B]DISTINCT tag_name[/B]. [LIST=1] [*]The first query is set up like that because … |
| | I'm trying to create a query for a report but I don't seem to come with the right query for it, I'm kinda new at doing queries and reports, anyway here's what I have. I have two tables that looks like this: t1 ------------- |id | date | | 1 … |
 | Hello All, I have two tables. One for messages and one for comments. For each entry in messages table there will be multiple records in comments table. Now I want to select the top 5 messages and top 10 comments for each message. My table structure is Messages ---------- MID … |
| | Hi Im pulling a list of users out of a user table and want to include photos, from the photo table, for each user. But not all users have a photo in the photo table... If I left join 'photos' onto 'users' i only get users who have photos... is … |
| | I am looking to build a fairly straight forward internal recruitment site which will include a job search. I need to be able to search on keywords in one field and postcode/location in another similar to guardian jobs ([URL="http://jobs.guardian.co.uk/"]http://jobs.guardian.co.uk[/URL]) Ideally there would also be an option to define radius of …  |
| | Hi everybody! Please,help! My problem is as following: in a file XXX1.php we have a form with checkboxes: { echo '<form action ="XXX2.php" method= "post"> What you are looking for: <br /> <p><input type="checkbox" name = "wordprop[]" value ="Option1" >Option1<br/> <p><input type="checkbox" name = "wordprop[]" value ="Option2" >Option2<br/> <p><input type="checkbox" … |
| | I have a PHP page opened directly from a URL with params in it: http://subdomain.domain.com/phppage.php?id=123456 The PHP page is [I]supposed to [/I]execute a very simple SQL statement to retrieve a single data row based on the id variable. The SQL execution is done this way: [CODE] $id = $_REQUEST['id']; $sql … |
| | Good day forum: I need some assitance retrieving and displaying an image. I have stored image in a directory on my server and saved its name in mysql. I'm able to retrieve and display all images on a page in the following way. [CODE]<?php // Connects to your Database include … |
| | Hi, I am trying to get my date field in a table to display as a long date (%W, %D %M %Y) format, but when I change the query variable using the FORMAT_DATE function it doesn't work at all, I just get a warning error. [CODE]die('Could not connect: ' . … |
| | give me complete code to see content of table and after tat edit data everytime diff an update it in same table of database |
| | Hi, Im trying to print out section titles and instructions from a database, however the first section title gets printed twice, I've no idea what I'm doing wrong. Here's a code snippet: $query = $this->db->query('SELECT DISTINCT SectionTitle FROM SECTION WHERE SurveyID= '.$number ); $j=1; foreach ($query->result() as $row) { $secTitle= … |
| | Hi, I want the db to return records which have either "bmw" or "audi". Below is my code but the db only shows records which have bmw. [CODE]SELECT * FROM `details` WHERE BRAND = 'bmw' OR 'audi'[/CODE] Thank you in advance. Cheers, Vishal |
| | So, I need to let a Visual Basic application connect to my XAMPP MySQL server. I set up the .Net/SQL Connectors, XAMPP, and all that other good stuff. When I try to connect to the server using 192.168.1.2 (my static IP) it will work. When I try to connect to … |
| | I am just trying to make a php edit script using a combo box or any other method. But I am not sure how to write a script when selecting a sportsid and fetch the related data at the same time. [CODE] $sql = "SELECT * FROM sports WHERE sport_id=2"; … |
| | Hi, I want the db to return records which have either "bmw" or "audi". Below is my code but the db only shows records which have bmw. [CODE]SELECT * FROM `details` WHERE BRAND = 'bmw' OR 'audi'[/CODE] Thank you in advance. Cheers, Vishal |
| | Hi, Myself and a couple of other programmers have decided to make an online email client (similar to Horde or RoundCube...). And we're going to need all the help we can get. The whole thing is an open source project. So, if you know your way around MySQL and/or PHP, … |
| | Hi everyone. I'm trying to export my C program that used MySQL from Linux to WindowsXP and to make the exportation simpler, I'm thinking of downloading Cygwin. May I ask if I still need to download anything to help me use MySQL in Cygwin? Links to download sites and/or tutorials … |
The End.