[mysql] Forum Topics

Hi everyone, First of all let me just tell you that I have never done database programming myself, and this is the first time I'm setting up a MySQL database via phpMyAdmin, so I could be missing something small but I'm sure someone will know the answer, anyways... I have …

Hi, everyone... I have a question about sql .. Question: Customer | jan-april | may - august| september - december A |quantity | | B | | | C | | | How to use the SELECT command to retrieve data and the output is show like above. please give …

Hi everyone I'm trying to extract an address in three lines. But its giving it to me in one line. I'm creating a pdf form using mysql and php. e.g: 252 westend drive Sommerset west 0185 I don't want it like this. 252 westend drive Sommerset west 0185 I want …

Hello guys, My question is not very direct and clear but i'll try to explain it nicely. I have a database running on MySQL with 1 important table which i need to use. Then I put this table into my C# application (I'm using Microsoft Visual Studio 2010). The only …

I am writing a script that locates stores in a 20 mile radius of a given zip code. That part works fine. I am adding the functionality to also choose a product that those stores carry and display only the stores in a 20 mile radius that sell that product. …

how can i print specified number of records in using data report?? example, i enter number 5 in a text field. then, when i click a button, the first five records will be generated into a data report with their corresponding data and has it's templte per record. meaning, the …

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 keep getting this error what do i do

Hi, I'm a bit of a noob with PHP. I am trying to retrieve information from multiple tables with the following code [CODE] <?php function check_input($id) { // Stripslashes if (get_magic_quotes_gpc()) { $id = stripslashes($id); } // Quote if not a number if (!is_numeric($id)) { $id = "'" . mysql_real_escape_string($id) …

[CODE] // connect to database $con = mysql_connect('localhost', 'root', ''); if (!$con) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; $db_selected = mysql_select_db("template", $con); if (!$db_selected) { die ("Can't use template : " . mysql_error()); } // cek login session_start(); //undefined index: login if (isset($_SESSION['login'])){ echo "Anda …

I am having a bit of difficulty in getting the right value. What I want to query is, the users who expire in 7 days, for example on 4th Oct 2011, the query should display the result of that particular day only. Right now I am querying as below: select …

I have an html page that gets data from 'hs_hr_employee' table and lays the info in a table on a web page. Then I have another table 'rights' which gets info from 4 columns from the 'hs_hr_employee' table and stores them in columns. In addition to those 4, the 'rights' …

[CODE] <?php //LOAD USER $result = mysql_query("SELECT * FROM event"); while ($data = mysql_fetch_array($result)){ ?> <tr> <td><?php echo $data['event'];?></td> <td><?php echo $data['tempat'];?></td> <td><?php echo readDate($data['mulai']);?></td> <td><?php echo readDate($data['selesai']);?></td> <td> <a href="./event_manager.php?id=<?php echo $data['id']; ?>&mode=delete">Hapus</a> | <a href="./event_manager.php?id=<?php echo $data['id']; ?>&mode=edit">Edit</a> </td> </tr> <?php } ?> </table> [/CODE] Warning: mysql_fetch_array() expects …

[CODE] // connect to database $con = mysql_connect('localhost', 'root', ''); if (!$con) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; $db_selected = mysql_select_db("template", $con); if (!$db_selected) { die ("Can't use template : " . mysql_error()); } // cek login session_start(); //undefined index: login if (isset($_SESSION['login'])){ echo "Anda …

hi there Below is my code for a webmethod which checks if data is existent in a table and then amends if bool is true or adds new if bool is false For some reason my amend works fine but it seems to jump the else condition altogether. Only passes …

hello guys .. here i go again .. i'm having a problem with my registration form .. my reg. form has 'password' field and 'confirm password' password field .. now i want to compare if the 2 passwords are entered the same but it doesn't seem to work .. its …

Hi all.. Can anyone help me with this problem? This code already said successfully update and successfully delete but actually there is no data updated or deleted. There is no error shows too.. These are the code for update and delete data.. update_user.php [CODE]<?php $con = mysql_connect("localhost","root","root"); if (!$con) { …

Hey all, I'm new-ish at MySQL and Navicat. I'm trying to import a file with about 1.16 million records and Navicat keeps "working" (I see the timer moving) but it actually stops processing records at 850,825 records. The log shows no errors whatsoever but I know there are many more …

The following code is used to connect C# with mysql server connectionParam = "SERVER=" + DbServer + ";DATABASE=" + dbName + ";UID=" + uName+ ";PASSWORD=" + pass; MySqlConnection mConnection = new MySqlConnection(connectionParam ); But what will be the code, if MySql can only be accessed through HTTP Tunneling. Tunneling URL: …

i want a field to be fetched from the database of one form and display it in another form i tried but the simple program works that to the text in the textbox appears in another forms textbox on button click event how to retrieve a value from a database …

hey there, I am trying to build a small around soccer/football matches. So, I have built a class that models a Match (Match.java). It only contains field variables like hostid, guestid, matchid, result, and such, and setter and getter methods. When I retrieve matches from my sqlite database, I build …

Can anyone help me with an Inventory System Design? Its got to track the location of items in the warehouse (and shop floor) for stocktake/empty peg etc... It has to handle refunds and sales. So far ive come up with: Product (ProductID, Name, ProductCategory,Description,Price,SupplierID) ProductCategory(ProductCategory) Location (LocationID, Description) ProductLocation (ProductID, …

I'm looking to create a battles, Explanation: I want to create a place on my website where users can vote on two users on a certain category, such as (example: best eyes, smartest person, etc) then other users have the option to vote, but only once, and who ever has …

Hi everyone, I'm trying to tweak some PHP code on my own without the programmer's help... actually it's just an addition that I want. Basically, I'm trying to enter object_id... into a classes_entered table which has class_id & object_id. There is also a classes table with class_id and show_id. I'm …

Hi all, I have 4 (four) tables using MySql database, ie: [CODE]tb_item ( id_item, (varchar) --> PK item_name, (varchar) price, (double) ) tb_order ( id_order, (varchar) --> PK id_item, (varchar) -->FK date_order, (date) lead_time, (float) order_quantity, (double) ) tb_use ( id_use, (varchar) --> PK id_item, (varchar) -->FK date_use, (date) use_quantity, …

category_manager.php [CODE] <?php //LOAD USER $result = mysql_query("SELECT * FROM kategori_berita"); while ($data = mysql_fetch_array($result)){ ?> <tr> <td><?php echo $data['kategori'];?></td> <td> <a href="./category_manager.php?id=<?php echo $data['id']; ?>&mode=delete">Hapus</a> | <a href="./category_manager.php?id=<?php echo $data['id']; ?>&mode=edit">Edit</a> </td> </tr> <?php [/CODE] Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\php_template2\category_manager.php on line …

Hello, I have been learning php stuff for the last few days. Recently, I have learned how to allow user registration, and I have made this simple voting code that allows people to "like" or "upvote" something on my site. The way the site is set up is there is …

Hi, I installed MySQL from the MySQL site. The setup procedure required me to set an username and password, which I set as X and Y respectively (say). Then when I opened the mySQL command line client, it asked for password, and after providing Y, I was allowed in. Once …

[CODE] <?php // connect to database $con = mysql_connect('localhost', 'root', ''); if (!$con) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully <br>'; $db_selected = mysql_select_db("template", $con); if (!$db_selected) { die ("Can't use template : " . mysql_error()); } else echo 'database connected <br>'; mysql_close($con); //LOAD USER $result …

Hi, i am just adding the last component to my registration page, but i am having a little trouble with it. Basically my website includes a referal based system, wherebye when the user signs up they can add a referal that benefits the referal later on. The code i am …

Hi all, I have this code that seems to work fine for the order but cant get it to pass the invoice side of things. the trouble im having is when i do the order its fine, but when i do an invoice it sends me back to the order …

Hi There, I would like to know if it's possible to use or what I could use to get the required results. The values [code] +2711 081 076 086 080 9011 6547082 9013 9039 9086 9041 +27084 substring(table,length(tbl_code),length(tbl_code))=trim(tbl_code) [/code] I have different values lengths in my MySQL table that's not …

hello every1 actually m new to vb.net, i have installed oracle 9i on my system and i dont knw how to connect even a simple form to my sql table in which i have two fields named first_name and last_name, the name of the table in sql is user. can …

Hi, Can someone give an example how the following task can be achieved smartly? I have this Database Table with 2 fields [B]1. Brand_ID 2. Brand_Name[/B] [B]SQL[/B] = SELECT Brand_ID, Brand_Name from brands limit 0,12; and I have to loop through it and place the values in the following HTML …

hi .. i need help .. i'm making a login page with sign-up feature .. meaning if you are not already registered in the database you have to sign-up on the sign-up page .. i know how to make the pages but my only problem is .. how can i …

Hi all. As a hobby I've been working on making a website with PHP and MySQL, both of which I am new to. I'm having some trouble with the comments system as I can't seem to be able to insert a date into the database. After the "insert", when I …

hi all, i have a problem with multiline json file that i wish to insert into an sql db. my problem arose as i went from one data set to two in the JSON file. the one data set was sucked from the json file to the sql db via …

Hi guys, We have a situation where our client has requested us to centralize their branch wise operations through a single system so franchises cannot falsify data. The DB is MySQL 5.1+. Right now what we have implemented is for each branch to access a centralized DB and access and …

Hi Guys, I have imported an excel document into MySQL to tidy up and make better use of the data but I am having problems running an update. All tables used as examples below; [U]Tables[/U] asset_register phone sim team The asset_register contains the following cols; [CODE] id INT, serialNo VARCHAR, …

Hi all, I am working on a Chart showing the activity per customer for the last 12 months + the current month (I work in a technical support team). Basically, my SQL query is providing me with the right result most of the time. It looks like this: Sep 10 …

how to update single row from table by using a single sql query. here im using library system.when a book is issued to the user,it should be updated to database, only which book is issued

Hello guys! [CODE]"SELECT * FROM $tableName WHERE cata != 'abc' AND ORDER BY times desc LIMIT $start, $limit";[/CODE] Is there any reason as to why this block is not working? What is the rule for formating such queries? Thanks.

[CODE]import javax.swing.*; import java.awt.event.*; import java.awt.*; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.util.TimerTask; /** * @author Adrian BER (beradrian@yahoo.com) */ public class PopupAnkit extends JPanel implements ActionListener{ private JToggleButton invokePopupButton; private JFrame popupWindow; Statement stmt=null; ResultSet rs=null; // int tempCount=0; public static int count=0; /** * Constructor. …

Ok so my problem is I need to create a Page that a user can register on and also a log in page as well. The information i want to take in on the register page is: First Name Last Name email confirm email sex d of birth. and a …

Hi, I'm trying to populate an asp:menu from a database on my master page and keep getting the error: Object reference not set to an instance of an object Here's my code on the master page: [CODE] <asp:Label runat="server" ID="errLabel" /> <asp:Menu ID="Categories" runat="server" CssClass="menu" EnableViewState="false" Orientation="Vertical" DataSourceID="categoryListSrc"></asp:Menu> <asp:XmlDataSource ID="categoryListSrc" …

im having the same issue with the above "You have an error in your SQL syntax; check the manual that corresponds to your MySQL...line 1"..help! myform2.php [CODE]<? ob_start(); ?> session_start(); <?php $labels = array ( "comment" => "comment", "condition" => "condition", "cartype" => "cartype"); ?> <?php if($_POST['Submit'] == "Submit") { …

Hi guys, i'm trying to test my asp.net app. it works fine when in visual studio 2010 ide, connecting to Mysql database and running. but, when testing in IIS the published app get the message exception "no database selected". it's everything running local, windows xp, mysql 5.x, IIS 5.1 my …

Good day y'all.. I was never introduced properly to PHP so I come here a lot to seek for help. xd anyways, I have a problem at the moment.. I can't set my enum values properly.. This is how it was added to a table named "joke": [CODE]ALTER TABLE joke …

Hi, I have the following peice of code which pulls data from a database: [code=php]$rsfeed = mysql_query("select Title from Abstracts where (ID = '12')); $thearray = mysql_fetch_row($rsfeed);[/code] I can print the title using: [icode]print $thearray[0];[/icode] but theactual resultset is more then 1 row, and what i need to do is …

I am running a mysql query in mysql editor: select RegExCapture('sdfdj250043', '[a-zA-Z]{2}[0-9]{6}' ); Getting error: Function doesnot exist Trying to register the dll in mysql: CREATE FUNCTION RegExCapture1 RETURNS STRING SONAME 'RegExCapture.dll'; Getting error:SQL error(1126): Can't open shared library 'RegExCapture.dll'(errno:0) Can anybody help, where I am missing. Thanks in advance.

Hi guys, I have a script that displays a list of tasks a user has to complete. To complete the task they must check the radio button and enter text into the textarea named eidtext. Here is the form: [CODE] <form id="form151" name="form151" method="post" action="update/update-sales-taks.php?&user_id2=<?php echo $user_id2; ?>&user_id=<?php echo $user_id; …