10,940 Topics
 | |
| | I know this sounds strange, but I messed up in a 'Manual' change to a DB table, and need to find a couple of records that I have no pathway to find... Explanation We have a member table called 'members' several different position tables, one for each level called position_1, … |
| | if column name is course and check this column to db mysql that if course is match with text field name course so not enter this record in mysql db for exmple i m entering already csc1 course and im type csc 1 again then show message "you are already … |
| | Is there anyway i can link a session to a particular table within my database, well i think this is how i need to do it. I have different tables which hold information for different shifts. The user selects the Site from one page, then selects the shift from another … |
| | hello , can any one tell me how can i update a password using procedure in mysql , if the oldpassword is same other wise get any mgs by the procedure . plssssssssss help me out |
| | Hello, My db table is this (semester result table) [B]sem1 regno(int) s1(enum) s2(enum), s3(enum), s4(enum) [/B] I want to find number of subjects in which the student with given id has gotten a particular grade. (ie no of subjects he/she has failed). Is it possible or shld i change the … |
| | I have the following problem: I have sample form with reportViewer on it & report type is rdlc report on c#. I added a new dataset then selected tableadpater on it then selected the database from mysql and I selected the Filldata method & provided a query to retrieve data … |
| | if somebody can help me please i want to write a store procedure in mysql to insert,update and delete but it should be dynamically because i have many tables and columns in my database the store procedure should be call than it should take the table and column dynamically ,can …  |
| | Hi... I have two site both have different login, now i want to merge database of 2 sites. need to merge both database and unique login for both. same user can use both site via one login. Thanks Hem |
| | Hello all . I am working on a small search for my website. It requires that i query the database and then display search results. In my database i have multiples. For example john on one row and john on the other. I want to display both of them. For … |
| | I have created an online form and am trying to post the info into a mysql database and I keep getting back a query error. Below is my PHP code. If anybody can help me, that would be great. Thanks a lot. [CODE] <?php $property_type = $_POST['property_type']; $number_of_bedrooms = $_POST['#_of_bedrooms']; … |
| | Hello, Am new to php and I have a question that is probably very easy. I have been watching tutorials online to learn how to work with databases, but none of them speak on how to upload to server. This is my problem: am using vertrigoserv but specifically using PHPMyAdmin … |
| | i am using mysql for the first time and following an online tutorial. i am using the command prompt to connect to the mysql server. the problem is that , i want to create a new database named bookstore. so, in the mysql> prompt i am writing [CODE] create database … |
| | I am trying to link fields between 2 of my tables but its not working. I have a table called assets, which consists of Asset_ID and AssetType and a table called t5_week3_shift3 which also consists of these 2 plus others. Im not sure whether to do away with the assets … |
| | hello :) i wanted to know that how can i move my database here and there..?? i'm working on Sql using some 'xamp' named software.. i have to create few tables, then i need to give this database to my friend..he'll add few more tables in it..then finally, we have … |
 | I am trying to write a program that can access my database from a remote computer and change it. How can I figure out the url of my database? according to my source it should be something like this [CODE] jdbc:mysql://host_name:port/dbname [/CODE] Thanks for your help. |
| | i have got a project where i have to connect c program to mysql database. but, i have zero knowledge of mysql. so, iwas looking for a mysql tutorial with c language . but. most of the tutorials online are mysql with php. so, could you please provide me some …  |
| | Hi there, I was wondering if someone could tell me how to store multiple checkbox values into a MySQL table? I know how to work it with Python on its own but I need to store into a database. Any ideas? |
| | hello, I have a situation that i'm wondering if there's a solution. I have specific databases for different cities in texas. I plan on adding more but i do not nkow how many more or what their names will be. Every city is going to have the same tables in …  |
| | Hi! Im new to MySQL RDMBS. I know the basic CRUD if you know what i mean. Create Read Update Delete. I have 2 tables: Category table and Product Table Products should be categorized. Product table has PK as an ID and FK to Category Table How to INSERT INTO … |
| | [CODE]<?php $conn = mysql_connect("localhost","rentwall_rentwall",")X7zlBx)XgZ5") or die ("Could not connect MySQL"); mysql_select_db('rentwall_rentwall',$conn) or die ("Could not open database"); function post($postname) { $posted = mysql_real_escape_string($postname); return $posted; } ?>[/CODE] Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'rentwall_rentwall'@'localhost' (using password: YES) in C:\wamp\www\site2\db.php on line 3 Could not connect MySQL please someone help … |
| | My codes work in localhost but this error happens when I upload to a web site. [code]<?php # FileName="Connection_php_mysql.htm" # Type="MYSQL" # HTTP="true" $hostname_conn = "mysql4.000webhost.com"; $database_conn = "a3027257_ccbc"; $username_conn = "a3027257_ccbc"; $password_conn = "a123456"; $conn = mysql_pconnect($hostname_conn, $username_conn, $password_conn) or trigger_error(mysql_error(),E_USER_ERROR); mysql_select_db($database_conn, $conn) or die("cannot select Database"); mysql_query("SET NAMES … |
| | Hi everyone! I've been looking for a solution, but i just can't find it anywhere... Ok, so the problem is: i have a database which looks something like this: user_id product_id score 14 . 235 . 79 23 . 235 . 32 53 . 665 . 21 14 . 235 … |
| | for experiment i pull data from mysql to xml to use in flash how can i add ahref to id in xml to achieve like this [url]http://www.kalitekolik.x10.mx/product.php?id=1[/url] [url]http://www.kalitekolik.x10.mx/PHP_MySQL_Flash_FINISHED.swf[/url] my database like this id/ product_name/ price/ details [CODE] <?PHP $link = mysql_connect("localhost","lafamosa_kermis","lafamosa1000"); mysql_select_db("lafamosa"); $query = 'SELECT * FROM products'; $results = … |
| | i got 4 table which call addproduct, sellproduct, reportfoundproduct, productbalance i want to make a trigger to update the balance quantity of stock in productbalance table after insert data to those three table (addproduct, sellproduct, reportfoundproduct) below is my trigger : CREATE DEFINER=`root`@`localhost` TRIGGER `user`.`addtotal2` AFTER INSERT ON `user`.`addproduct` FOR … |
| | hi, when i insert date time into my database it insert server time not local time how can i change this? even i tried ; [CODE]$currntdate = date("F j, Y, g:i a");[/CODE] which didn't work either.. thanx in advance. |
| | Hi everyone, I'm trying to write a Python script, where it counts the specific results from a database. Running the following line in MySQL Client works: SELECT name, COUNT(*) FROM results WHERE name="bla bla"; And it returns all of the results fine. But I'm trying to put it into a … |
 | can anybody tell me what format of date 1311048886 is? how we insert and select in database.  |
| | Please someone should help me before I faint. I have been working with this login script and am getting this error on a server: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/utimate/public_html/PhpPractice1/index.php on line 32. When I test it with wampserver, I will get this … |
| | I am using MySQL to store the RSS feed contents that are updated every few hours. I truncate the database once a day. But during the day, whenever same feeds are updated every few hours I get duplicate entries piled up. Is there any PHP script that I can run … |
| | Does anyone know the SQL statement for replacing a string in the whole of a database. My database is called DB1 and I want to remove any instance of "Table/". Many Thanks, |
The End.