[mysql] Forum Topics

Hello there, I have problem as: have two tables **Candidate** and **candidate_interview** for perticular vacancy_ID , Candidate's status becomes "In Proces" and when his interview is schedule , entry is added in candidate_interview table againt that vacancy with status In Process. now what i want is , such candidates whose …

Forgive me if this is something obvious or a simple question. I am having issues with my date field when loading data into my database. I am having it load using a python script using the below command and once complete the date is 0000-00-00. the file I am loading …

its my Data base structure , I want to create login for admin , franchisor , distributor , seller , its gives me a problem that when i take a user name 'David' for franchisor then can i also registor 'David' as a seller . i want a user name …

im trying to do this : alter table project_info change column number proj_id int not null auto_increment, add primary key (proj_id); but mysql tells iv got an error. any help with whats wrong here ? i followed this from head first sql book (page 210 if anyone's interested ) .

HI, I have a table with three columns id,history_nr,value. Now I want to make a query that should concat value with different nr. I have tried this syntax but it is not working. SELECT CONCAT((SELECT value FROM table WHERE history_nr=63 and id=1),'',(SELECT value FROM table WHERE history_nr=803 and id=1)) FROM …

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 …

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?

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 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 …

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 …

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>'; …

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> …

hi guys, am trying to make a simple PHP form submission and insert some data to MySQL, my tables are: category: -id -category_name table1: -category_id(FK) -title -description table2: -table1_id(FK) -filetype -filesize -filedate -filename Form: -Date -Title -description -category(drop down) -upload file (get the file info like type,ext,size,filename) Or is there …

hey guys... i know this is a very common problem and has been posted earlier also... but nobody seems to have figured out a solution... i am making a program using PHP/MySQL. I need to update 3 columns in a table. when i use a single UPDATE-SET command(using commas/AND etc …

Hi! Got errors on site... Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/content/13/11394913/html/header.php on line 30 Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/content/13/11394913/html/config.php on line 4 Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/content/13/11394913/html/index.php on line 16 …

Hello. I created a little recover page. Users write the email and a random password is sent to them. The random password is successfully send in their emails but when they login with the new password it doesn't login. I think the new password does not updates in my database. …