10,940 Topics
 | |
| | Hi, I would like to know how to export my schema WITH the table rows/content into a .sql script in MySQL (If it's possible). I tried using Forward Engineering with MySQL Workbench but when I select "GENERATE INSERT statements for Tables" it doesn't do it... I tried googling and finding …  |
 | Hi, I just downloaded TinyMCE WYSIWYG, and I am doing an insert query into MySQL using PHP. Everytime I submit the form it returns false. and if I toke out the textarea everything goes ok. I am pretty sure it's TinyMCE. Have any of you came across this problem, am … |
| | Is it possible to use Kohana ORM with MySQL AND Oracle DB? More wider questions is is it possible to use two different databases (RDBMS) with Kohana? |
 | I have this code am when i try to execute it give an error where am i going wrong Set Rs = New ADODB.Recordset Rs.Open "Select stank from sidetank where job_id='" & Label18.Caption & "'", FrmMother.Db, adOpenKeyset, adOpenDynamic Rs(0) = Val(Rs(0)) + Val(Text7) Rs.Update Rs.Close Will be glad if i …  |
| | Hi All, I was following a tutorial online that showed how to imput info into a MySQL database from an app, and I decided to edit it a little so that I could post what I wanted as opposed to the provided example. The problem im having is that the … |
 | Hey Guys, What i want it to do : 1. Combobox is displayed with a list of countys ie Limerick Dublin Cork 2. Choose County brings up second Combobox with countys towns and villages. 3. Hit search brings up relevant towns and vilages from the county chosen. What it does: … |
| | Hello, help me please. I have a db sample ( http://i.imgur.com/JRZ2ojP.png ) I have 1 combobox and 1 textbox If the combobox select "Notebook" then on the textbox it must be display the corresponding itemStock (3) Please :( By the this my simple code for my combobox Try Query = …  |
| | If got a problem in a mysql select string. I get some data from a mysql table and want use some data to pull data from another table. When I use static (i typed it in) it works good but when i use the data that i got from the …  |
 | I have multiple columns I wish to order by. I have columns: # # # # (1, 2, 3, 4) A 0 0 0 0 B 1 0 1 3 C 1 0 2 3 I want to ORDER BY 4, 3, 2, 1. Syntax I am using: [code] "SELECT … |
 | Hi, so I have been trying to create a Login and Register system, but the thing is every time I try to login using the system nothing really happens. You can check it out at http://edwinjoseph.co/logintest/ if you click login and use **user** for the username and **password** for the … |
| | hi in my registration page i got about 20 input fields everythings are working fine except this multiple checkboxes. i read the articles related to my isses but no joy yet becouse my code is very complecated for example the register.php datas will be validate and process by process.php and … |
| | I don't know what I'm doing wrong here, but I'm having hard time trying to insert data from a form into the database.The $_session['username'] is set and the database is included and working Here is my table CREATE TABLE IF NOT EXISTS `accounts` ( `accid` int(11) NOT NULL AUTO_INCREMENT, `acc_number` … |
| | //page2 edit button code.. page2 send the data back to page1 if user wants to edit <a href="purchase_form1.php?id=<?php echo $id; ?>" class="button4">Edit</a> //page1 php code. here the form is on this page //This GET[id] is sent from page2 which is user view page of the form on page1. //If user …  |
| | hello friends I have three tables with similer structure and same column name id,sname,ssno,grade. I want to copy rows from table1 to table2 and table3 based on column grade . I am getting an error No value given for one or more required parameters. can someone kindly tell me how … |
| | $query= "SELECT * FROM games where games.league='".$receivedleague."' AND games.gamedate >='".$todaydate."' AND '".$elnowla."' <= games.eldatetime AND (Not EXISTS(SELECT gameplayed.gameid,gameplayed.userid FROM gameplayed WHERE games.id=gameplayed.gameid AND gameplayed.userid='".$Userid."')) order by games.eldatetime asc limit 0,2" or die(mysql_error()) ; Hello gurus ! Can anyone help me to improve this query below ? I am no experty … |
 | hi, seems mysql_escape_string was deprecated ([http://php.net/manual/en/function.mysql-escape-string.php](http://php.net/manual/en/function.mysql-escape-string.php)) is there any alternative method? hope php developers can share with me. tq |
 | Hey boys and girls, I need help, I am working on a project that requires me to build a business tier (.dll) for a c# program, I've only ever used SQL server. The problem comes in as follows, at university I was tuaght how to import a datasource via the …  |
 | Hello, I have two tables one for the company staff and one for their projects(table name objecte). The table objekte has 4 colums that are connected with the id of the staff. The problem is that I want a query that shows all staff's names. I have also included the … |
 | Does'nt say could not connect. This is a new one for me. Don't know what to submit other than <?php $MySqlHostname = "mysql1.000webhost.com"; //the name of your host - if its local leave it as is. $MySqlUsername = "a8271678_unet7c3"; //the username to your database. $MySqlPassword = "pw"; //the password to … |
| | <?php include ( './includes/template_pageTop.php' ); if (isset($_POST['submit'])) { $username = $_POST['username']; $password = $_POST['password']; $check_username = mysql_query("SELECT username FROM users WHERE username='$username'"); $numrows = mysql_num_rows($check_username); if ($numrows != 1) { echo 'That User doesn't exist.'; } else { $check_password = mysql_query("SELECT password FROM users WHERE password='$password' && username='$username'"); while ($row …  |
| | I'm curious about write locks with MySQL and how they are prioritized with eachother. Specifically, I'm wondering if "low priority write" locks have lower priority than "normal" write locks, or if they are equal. The only documentation I can find states that the low priority locks have lower priority than …  |
| | Hey everyone having some troubles here with an update statement. I want to update a value(scanISN) if it exists and show information updated and if it doesn't exist show an error right now it show information updated even if it doesn't exist. How would I do that? <?php if(!isset($_POST['addMe'])){ //show … |
 | Is there a setting in the MySQL Administrator to set the file upload size? |
| | hi,i am a web developer and i have recently designed a new website [fitnizz.com](http://fitnizz.com). Now i am facing some problem related to database ,i have recentky added a new application of diet plan ,you have to just enter your weight and height in the text box and click ok,then it …  |
| | I have a table with over a thousand records that I need to update a field I have called "id". I need each record's ID to be unique. I am using the uniqid() function which works just fine. When I use the code below (and several other variations of it), … |
| | attach is my code for search.php but i have error on line 9, can someone pleasee help me to fix it ? Thnk you XAMPP said Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\series\insert\Search.php on line 9 line 9 code: while($row = mysql_fetch_array($results)){ below is my … |
| | Hello I got one problem. I have a site where people can add movies. Its possible to add up to 10 different hosts. Every host can have up to 2 parts. html <TABLE> <TR><TD width=120>Hoster*:</TD> <TD> <SELECT class="interfaceforms" name="addmovie[][hoster]"><OPTION value="">Please select</OPTION> <?PHP foreach($hoster_list AS $aKey => $aValue) { echo'<option value="'.$aKey.'">'.$aValue.'</option>'; … |
 | $cartOutput = ""; $cartTotal = ""; $ctr= 0; $collector = array(); $product_id_array = ''; if (!isset($_SESSION["cart_array"]) || count($_SESSION["cart_array"]) < 1) { $cartOutput = "<h2 align='center'>Your shopping cart is empty</h2>"; } else { $i = 0; foreach ($_SESSION["cart_array"] as $each_item) { $item_id = $each_item['item_id']; $sql = mysql_query("SELECT * FROM products WHERE … |
 | im on win 8. neither can i find the bin folder as i could on my xp machine , nor do i get any command line. googleing didnt help much either. either i got some really hard to understand mysql doc page , with no specific answer to my problem … |
| | my insert php cannot save data to phpmyadmin when it enter the details. localhost:locahost , username:root password: databasename:b_database tablename:my_library tablecolumn:2 contains : isbn(primary key) and title. index.php <html> <head> <meta name="description" content="Php Code for View, Search, Edit and Delete Record" /> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Search Library Record</title> </head> …  |
The End.