10,940 Topics
 | |
| | Hello all, Im looking for a tool that allows me to visualise a single entry in a database, so i can see that entry, and all entries that have a foreign key to it, and foreign keys to those etc. Im not talking about an ERD, but more like a …  |
| | Hi, Doing a bit of research at the moment on how to structure my web App. So far I've decided on using PhoneGap with jQueryMobile client-side, which will request and update information in a database hosted on a remote server running php and mysql. From the tutorials I've seen online, … |
 | I've written this code to <?php $getnamequery = "SELECT cat_title FROM store_categories WHERE id = '$catid'";?> <?php $cat_name = mysql_query($getnamequery) or die(mysql_error());?> What would happen is the variable `$catid` would be filled in with a number, for instance 1. The table store_categories looks like this id cat_title 1 Humor 2 … |
| | This is my SQL statement.. SQL Statement: SELECT tbl_subjectsenrolled.SubjectID, tbl_subject.SubjectDesc, studentsubjectgrade.Finals FROM tbl_subject INNER JOIN tbl_subjectsenrolled ON tbl_subject.SubjectID=tbl_subjectsenrolled.SubjectID INNER JOIN studentsubjectgrade ON tbl_subjectsenrolled.SubjectID=studentsubjectgrade.subjectID WHERE studentsubjectgrade.StudentID='04-0044' But the OUTPUT is this: SubjectID1 SubjectDesc1 Finals1 SubjectID1 SubjectDesc1 Finals1 SubjectID2 SubjectDesc2 Finals2 SubjectID2 SubjectDesc2 Finals2 Instead of this: SubjectID1 SubjectDesc1 Finals1 SubjectID2 SubjectDesc2 … |
| | Hi I finally screwed up.In order to get rid of a minor problem I uninstalled Wamp Server and reinstalled it.Now when I try to start it it will not accept my old password.What can I do? Do I have to uninstall everything mySql, Workbench,Wamp server and maybe php? Another thing, … |
| | Hi.. I want call data from table in mysql database using javascript How to do it? [EDIT: Moved from Java to JavaScript] |
 | i had make php file into it function [getLink()] make connection with mysqli_connect and return link of connection to use it in another php file to get result from database with mysqli_query() connection.php ` <?php $userName="root"; $serverName="localhost"; $userPassword="*****"; $nameOfDataBase="ITI_System"; function getLink(){ $link=@mysqli_connect($serverName,$userName,$userPassword,$nameOfDataBase); if(!$link){ echo "connection Error".mysqli_connect_errno(); } return $link; } … |
| | |
 | Hi There, Ive been searching everywhere in google but i got nothing. What i need is to be able display user datail after he login on a certain textbox Login.php page code: <?php session_start(); ob_start(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> </head> <body> <?php … |
| | Just a quick question. I am using Workbench to export a database stored on my hoting providers server, will the server experience any downtime whilst I am exporting the data? The only reason I ask is because when I back up my local SQL database my server needs to be …  |
| | Hi everyone, i am designing database for books application. I have main table **Books** and its child table is **Chapters**, chapters child table is **Sections**, So here is the problem, that some chapters has also divided into 3 steps **chapter Name -> Part 1 -> Divisions 1** and each chapter … |
| | Hi guys I need some explanation from you experts on php.I succeeded in installing MySql vers.5.5, workbench, myPhpAdmin and Wamp Server.I gave up installing Apache, too complicated, I use IIS7 anyway and works fine.All these tools work fine, I can create databases, tables, update them etc.and I am doing all … |
| | I was just curious if this is just me or what but it's extremely annoying. I have installed Apache2 and PHP on my Linux Mint 14.1 Cinnamon machine fine, but when I use `apt-get install mysql-server` (as super user), this happens. Reading package lists... Done Building dependency tree Reading state … |
| | Hey guys I'm new to this I bought this script yesterday and on my site I keep getting this Warning need help!!! Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\Hosting\6967501\html\config.php on line 13 [CODE]<?php // Provide Values for Database $dbhost="MYHOST"; $dbname="DB_NAME"; $dbuser="DB_USER"; $dbpass="DB_PASSWORD"; //Don't change … |
 | Hi, I'm using this SQL statement to retrieve Value and Date which will then be plotted on a graph: SELECT DISTINCT assets.SEDOL,assets.Quantity,stock_names.value,stock_names.Fileid,date_header.dateid FROM assets,stock_names,date_header WHERE assets.Client_ref = '$clientref' AND stock_names.SEDOL = assets.SEDOL AND date_header.fileid = stock_names.fileid I'm also selecting Quantity. Instead of having to multiply out the arrays, how can …  |
| | I am working on a PHP project in which a mysql table needs to be updated with lots of rows in a single update. A set of parameters will be assigned for a product. Please find my present steps below: 1. **Delete** all rows with the product_id in the table … |
| | Hello, I have a Mysql table, where i want that after i execute the update query in the JSP form, an automated mail is send to the email id in the record.Can anyone tell me how to do this?  |
| | I have problem updating my MySQL database. The user can edit a form in my page and once they press 'send', the php script should be able to update all the information. However the database doesn't seem to be updated after pressing the 'send' button in the form but only …  |
| | Hi guys, I have been racking my brain for a while now trying to sort out a problem I have been having with my mysql query and thought this would be the best place to get some help and learn how to edit my query! So, users are able to … |
 | I'm having a problem with a MYSQL Join accross three tables. I'm new to MYSQL Join functions, and can't quite figure out how to write the code. My current code is horribly innefficient and does not implement explicit joins, which I believe is much of the problem. Here it is(in … |
 | Hi, In my ubuntu 11.10 system Mysql Workbench not opening, but while using mysql-workbench --verbose command in terminal it opens. Please I need it to opened by clicking the button for Mysqlworkbench. Thanks in Advance. Velhassan. |
| | I'm using this PDO query to fetch all the data I need from Value and dateid: $pdo = new PDO('mysql:host=localhost;dbname=contisec_portal', 'root', ''); $date = date("o-m-d"); $stmt = $pdo->query("SELECT stock_names.Value,stock_names.Fileid,date_header.dateid FROM stock_names,date_header WHERE SEDOL = '$stocksel' AND date_header.fileid = stock_names.FileID"); Does anybody know how I can sort the two columns into … |
 | Hello. I have two tables, the itinerary table and location table. The itinerary table consists of all the itinerary: * A - B * B - A * B - C * C - B * C - A * A - C The user will select from the itinerary … |
| | Hi I am having an issue trying to run an sql query from a php script. I have checked the query through phpmyadmin and it runs fine but whenever I run it through php i get an error. The error is "Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean … |
| | I am trying to update multiple rows in my database using php and mysql. Here is my php mysql statment: $sql = "UPDATE book_store SET". "title = '$_POST[title]', isbn = '$_POST[isbn]', price = '$_POST[price]', quantity = '$_POST[quantity]' ". "WHERE ID = '$_POST[id]' "; Here is my Error: Error: You have … |
| | Hello All! This question probably has a really simple answer but I am fairly new to PHP and I'm not very farmiliar with generating numbers yet. This is what I'm having trouble with: * Check MySQL to make sure that this UNIQUE number is not already stored. If it is, … |
| | I am building a web for ordering stock for a small company. I wanted to add data into a table for user to view before confirm the order. Tried to use excel but can only display data and not add data on the website. I'm currently using Dreamweaver to develop … |
| | Hello guys, For my final year project I decide to develop an app for android. I have done some research and stuff for first semester and have to present the working app at the end of second semester. To be honest I'm not that great developer however I'm still interested …  |
 | i would like to be able to upload a pdf to a database then later be able to download the book and view it. i want the names of the books to appear as links which when clicked will open the book. the uploading is being done but the downloading … |
| | hi, i am very new in php programming. Pls help me how to store session variable into my sql database. Below is my code <?php function userIsLoggedIn() { if (isset($_POST['action']) and $_POST['action'] == 'login') { if (!isset($_POST['loginid']) or $_POST['loginid'] == '' or !isset($_POST['password']) or $_POST['password'] == '') { $GLOBALS['loginError'] = … |
The End.