[mysql] Forum Topics

Hi, i need help please! i have a page were users can upload images, the name and path to where the image is stored is stored in the database. I want the aministartor to be able to view all of the images. when i try this it returns the path …

hello everybody i have a big problem with the connection of mysql connect i want to connect to an other data base with out binding Ip adresse in the host server . i have an application and i want to manage 2 web sites with this appliction because the tow …

Hi Guys , Have you any idea what does mysql.sock used for and where we can find in windows system. rgds

Hi, I am a php newbie. I am doing a sports site, and trying to get the team name to display in an admin area. I have tried the code below and many variations of it, however it continues to error the message : Notice: Undefined index: team in ... …

hey guys, i had this working before, but when i added another bit, it stopped and now i can't get it to work again :( [code] //Put data into right tables mysql_query("SELECT* FROM inprogress"); mysql_query("INSERT INTO complete SELECT* FROM inprogress WHERE Status='Y' "); mysql_query("SELECT* FROM complete"); mysql_query("INSERT INTO inprogress SELECT* …

Right, so ive been meaning to do this for a while. anyway I'm Diz, been lurking here for awhile :D i'm at college finishing my course in IT and usually end up on here avoiding work and learning about all the goood stuuf ^_^ lol Oh and recently ive been …

hello and thank you in advance to anyone who can help me with this problem. I've scoured the internetz for a while trying to find a solution to what must be a common question, but I can't find anything that relates to what I am trying to do. I have …

Hi, i've been working on this simple homework assignment and the only thing stopping me from finishing it is passing a c++ variable to a mysql query using mysql_query. I've searched around for about an hour and every potential solution I have found hasn't worked, so I figured maybe if …

While I've been working with MySQL for years, this is the first time I've run across this very newbie-esq issue. Due to a client demand, I must host their website files (PHP) on a IIS server that is not running MySQL (instead, they are running MSSQL). However, I have developed …

I have the following php code: [CODE]$query = "INSERT INTO flashcards VALUES (null, '".$_POST['front0']."', '".$_POST['back0']."', ".$link.", ".$details.", NOW()); INSERT INTO bundleflashcardlink VALUES (null, ".$flashcardbundleid.", LAST_INSERT_ID());"; $result = mysql_query($query);[/CODE] which gives me the following error: [CODE]DB Connection error: You have an error in your SQL syntax; check the manual that corresponds …

I'm modeling a database for a competition website. Each tournament will have a even number of contestants, and they will be randomly assigned to a one vs one match. Each match winner will go for the next phase and compete against another match winner, until the tournament ends. I'm thinking …

Hey guys i'm having trouble with php. i made a script to check the database for simillar info and it was working fine until i added the " AND email = '$email ' " part in the mysql query . Now it just doesn't show anything ....no echo no nothing …

Hello guys Im from South Africa and have recently got into web development, im busy learning php, mysql and javascript and expanding my html and css knowledge. Please excuse any dumb questions from me you see floating around, im basically teaching myself so very much a junior here!

Hi guys, I hope you can help me with a bug. I have an update form to update data in a mysql database. Whenever a user wants to update the picture they uploaded it through the html form. For some reason my mysql querie on line 67 is not updating …

Hey I am using a trigger, if the trigger returns emtpy I want it to keep the data it already has. This is my trigger: [code]BEFORE INSERT SET NEW.calling_num = (SELECT users_name FROM cdr_phone_system_data WHERE extension_number = NEW.calling_num);[/code] How can I check if the return is blank? The idea is …

[code=php] $results = mysql_query("SELECT column1, column2, date, time FROM table ORDER BY RAND() LIMIT 1"); $row_table = mysql_fetch_assoc($results); [/code] For some odd reason this does not return data, however if I change it to: [code=php] $results = mysql_query("SELECT column1, column2, date, time FROM table ORDER BY RAND() LIMIT 2"); $row_table …

Salam to all. I m new to this forum. I m doing Php Mysql just for fun. I want to make a "login form and Register me" form . so plz tell me the simple code for it.

I'm trying to create a form that updates stock in mysql database. I have created the forms to upload new stcok and they work fine. However, i'm including a link that will take the user to an update php that will then update the required fields, but i can't seem …

Hi Guys! I am a Python noob. I wanted to merge data and eliminate duplicates. I have the solution. Now I am stuck at dumping the dict contents to MySQL. Any help is really appreciated. Data : [QUOTE]a b c d e f key dupe -------------------- 1 d c f …

[CODE]private void eaddbtnActionPerformed(java.awt.event.ActionEvent evt) { if(eaddbtn.getText().equals("Add")){ eaddbtn.setText("Save"); eupbtn.setVisible(false); // edeletebtn.setVisible(false); ecanbtn.setText("Cancel"); } else{ Enrollment e = new Enrollment(eid_txt.getText(),ecode_txt.getText(),egrade_txt.getText() , emarks_txt.getText() ); // ERROR APPEARS IN HERE e.SaveEnrollment(); } } [/CODE] i want to add int value to mysql database...how can i do that? how to convert int value to string …

I have looked everywhere, I've figured out how to add x amount of days to the current date, or take away x amount of days from the current date. But let's say I have a date stored in my database as "0000-00-00", that is not the current date. How can …

Hi, I’m going to calculate a ratio between two entities but are having some trouble with the query. The principal is the same to, say a forum, where you say: A user gets points for every new thread. Then, calculate the ratio of points for the number of threads. Example: …

i work with C#.net and mysql. i will fill a combo box with data from stored procedure. but i get only 1 value. how can i fill the combobox?

Hey , I'm having trouble showing data from my data base in php. i always get the " No database selected " line and also i was wondering why the second echo doesn't show the result is : first echo No database selected this is my code [code] <?php require($_server["DOCUMENT_ROOT"]."/config/db_config.php"); …

I have a table with about 150,000 rows. The table never changes and the rows are physically ordered by one of the columns. That column is the only column I ever need to query against. The values (TEXT) in that column are not distinct. Creating an index on this column …

Hello I need help to turn this Scenario normalized from 0nf-3nf Please thank you… [B][U]Scenario[/U][/B] Company details Swapsongs plc organises Record Fairs throughout the UK. They book and pay for venues eg hotel or leisure centre, each venue has a name, address, phone, contact name, cost per day, max – …

[QUOTE]hi all, i need to print the value in sql2.but it is not printing it. but if i execute the same query in mysql it is giving the value. so please check this. thank u.[/QUOTE] [CODE]$sql2="select allocatedmemory from projects where projectname='$projectassign'"; mysql_error(); $d=mysql_query($sql2); $data1=mysql_result($d,0); echo '$data1';[/CODE]

Dear all, I have a table in mysql and i want to insert records into the table without using "FOR" or "WHILE" loop..Can this be done?? Thanks in advance.. Jino.

Hi all, Im using hibernate in netbeans to map to a mysql database, but am having problems.... when I open a session: [CODE]Session session = SessionFactoryUtil.getInstance().openSession(); session.beginTransaction();[/CODE] it prints out this in the console:... [COLOR="Red"]12/04/2010 9:50:26 AM org.hibernate.cfg.annotations.Version <clinit> INFO: Hibernate Annotations 3.3.1.GA 12/04/2010 9:50:26 AM org.hibernate.cfg.Environment <clinit> INFO: Hibernate …

hi i have got a simple table in my database like this: [B]from[/B]|[B]to[/B] bangalore | delhi chennai | mumbai i am using two drop down list to display this data. here is my code: [CODE]<select name="From"> <?php while($row = mysql_fetch_row($result)) { ?> <option value="<?php echo $row[0];?>"><?php echo $row[0];?></option> <?php }?> …

I am trying to code an update sql command which can be seen in the code below, however, i am getting the following error: - Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/qchqsdju/public_html/project/lines/update_line.php on line 40. The code is: - [CODE] <? // Connect database. …

I am a bit of a newbie to PHP and have produced a dynamic form for a uni project, however, I am unsure how to code the PHP script which will insert the data inputted through the form into a SQL database. The code for the form can be seen …

Hi, I have a text data type field in MySQL table that I need to read out to a page. When the value is entered into this text field the value will have returns as follows: ------------------ TEST TEST aaaaaaaa asdasdasdfas 3rd lineasadas ---------------- When I read this value out …

hi, i have been trying to write a query which will return all clients and the related tables so that i can then allow the users to filter in a php website. at moment i tried this but returned no results even though there are records: [CODE]SELECT * FROM clients …

Hi guys, Here is my problem.. I have two computers with Win XP pro. The one has static IP and i want it to be used as a web server. I want to create a database such as Mysql and put it on the web server and using the application …

Hey guys. First of all, its been 2 days, and already 2:30am in the morning. I've eaten a steel fork, jumped over the moon, broke an arm, and cant get it to work. Will somebody please assist me in this; The end result sound simple, and maybe it is, but …

hi every one this is my first post in any forum i have got an error while inserting a row to mysql this is my code: $query = "INSERT INTO flight(date,from,to,depart_time_hr,depart_time_min,arr_time_hr,arr_time_min) VALUES('$_POST[date]','$_POST[from2]','$_POST[to2]','$_POST[hours1]','$_POST[minutes1]','$_POST[hours2]','$_POST[minutes2]')"; the error shown is: 1064 You have an error in your SQL syntax; check the manual that corresponds …

I am new to Daniweb. I come from a background of database programming in Health Care systems using proprietary Intersystems MUMPS and Cache. I am exploring the open source development community primarily Java, Linux and MySQL. I fortunately came upon Daniweb searching for some information on algorithms. I'm very impressed …

I running MySQL 5.1.30 on Solaris 10. As I have a table which I partition into 12 according to each month. The table structure as follow [CODE] mysql> desc my_events; +-----------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+--------------+------+-----+---------+----------------+ | event_id | bigint(20) | …

hello... i have 6 tables in database. now i am deleting product in product table. then how to delete all rows which is in another tables on this product id in single step.

Hello everyone, i working on a website and i wanna grab data from a table in my database . specifically the last 4 rows that are entered as the database is updated automatically by users. i wanna be able to display each row separately in different div tags. i'm getting …

Hello Friends.. i m inserting near about 20000 in db at a time.. i jst want to know how can i get the number of inserted rows and time taken to done that..!!! Thanks in advance..

hey guys - I'm sort of new to php5 and mysql5 but I'm pretty decent in php4 and mysql4 and thus far I've not seen that many differences. I am, however, new to SSL technology. I am building a site for a friend and am working on the login processing …

I am new to using php and mysql and am really enjoying the experience so far. I want to use an if statement where if the user fills in a field called gamertag and if it is less than 6 char, then it will display "No Gamertag Available" otherwise it …

Hey guys, I have the following table: persons - name - street - number - regioncode - state - city I want to count the amount of people per region per street. I can do it with the following query: [CODE=mysql] SELECT state, city, regioncode, street, COUNT(*) AS personsStreetRegion FROM …

General Question, no code: I have the daunting task of automating the import of mysql, ms sql and ms access into a central location. I've nailed the microsoft crap using ms sql DTS but even with mysql odbc drivers, cant seem to nail that one. The optional is that I …

Hey, I want to get a PHP based stucture for a .csv file and then provide the information to a table in editable form...and then populate the database table with the values from editable table.. how can i do it?

i need some help fixing this .. i've made the td id the counter, which works. In mysql i have a column named position. For this particular row in mysql the position is 1. how do i input this result into the td id='1'? i tried below but it for …

Hello, I have been trying to setup mysql API with C. I followed tutorials but I don't think I am installing the API correctly. Could someone tell me the package to download, and what to do with it. Thank you very much.

Hi everyone, I'm currently working on a assignment and have to write a short (max 3 lines) definition on some different kinds of queries. I've written a definition to all of them but I'm having a really hard time about one particular query: Scan Query. I've tried to look in …