[mysql] Forum Topics

Anyhelp with code below would be greatly appreciated Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /usr/home/rconn/domains/dadpop.net/htdocs/online-bookmarks/register.php on line 44 you have been successfully registered. Read your email and click the link to activate your account. [code=language] <?php require_once ("./header.php"); $secret = "dDWUc72sCcs20cXskcw"; $reg_register = set_post_bool_var …

Hi all, I am fairly new when it comes to SQL... and i would like some help I would like to run 2 select statements in the same time...in order to get my results in a table with 2 columns and 2 rows that shows me the result of my …

Hi All, I was trying to research my problem, but wasn't getting any results to satisfy me. The problem is: I am storing data in a mysql database (the server time is stored as well), I am also uploading data into this database from a file that was downloaded from …

hi how can access romote Mysql database from local mysql database. like oracle dblinks will also work in mysql.

Hi guys, A few months ago i installed a version (5.0 i believe) of MySQL on my machine with no problems at all. Two weeks ago i had to format my hard drive and reinstall my OS. I have successfully installed Visual Studio 2005 and tried to install MySQL last …

Hello. I have a MYSQL database and I receive CSV files throughout the day. At present I have to open up my database and import the CSV file. Is there a exe file that can run so the CSV file can be imported as and when it arrives on the …

Hi, I need to fetch 5th top and 6th max from my database table... asssume everything are integer datatype. Thanks

Hi, I am trying to use MySQL full text search in my application, but surprisingly the query doesn't seem to be working for keywords like 'ASP.net','Vb.net' The query is given below, [CODE] SELECT * FROM tbl_postedjobs WHERE MATCH (keySkills) AGAINST ('ASP.net') [/CODE]

Hi, I'm a website developer. I need importable .sql files for coutry/state and city list of the World. 3 Separate list with the support of foreign keys will be ok. Best if you can send me a single table. I specially need, Indian state and city list .sql files. Any …

Hi, I have a table like this: [code] name +------------------------------------+ | name | +------------------------------------+ | This is an rna-binding protein. The data which is useful is available from the desired location. | +------------------------------------+ 1 row in set (0.00 sec) [/code] I want to remove extra space i.e in between binding …

Hi All, I have four different tables in my database with following structure: //=================================================================== 1. [B][U]customer[/U][/B] [I][INDENT]customer.CustomerName, customer.CustomerHouseNo, customer.AreaID, customer.CustomerID, customer.CustomerType, customer.CustomerBalance, customer.CustomerAdvance, customer.CustomerMonthlyFee, customer.Remarks, customer.CustomerConnectionDate, customer.CustomerStatus, customer.CustomerTelephone, customer.EUserID, customer.USerID, customer.EditDate, customer.CDDate, customer.DisRemarks, customer.CtypeID, customer.CIP, customer.CMAC[/INDENT][/I] 2. [B][U]payments[/U][/B] [I][INDENT]payments.Amount, payments.PaymentMonth, payments.PaymentDate, payments.CustomerID, payments.PaymentYear, payments.CustomerAReaID, payments.ReceiptNo, payments.USerID[/INDENT][/I] 3. [B][U]area[/U][/B] a[I][INDENT]rea.AreaID, area.AreaDesc …

I have joined a few tables together and all seems to work well.. [code] SELECT * FROM products JOIN underwriters ON (products.underwriter_lookup = underwriters.id_uw) JOIN countries ON (products.country_lookup = countries.id_co) JOIN repay_types ON (products.repay_type_lookup = repay_types.id_repay) JOIN base_rates ON (products.base_rate_lookup = base_rates.base_rates_id) [/code] However, I have been asked if I …

Hi, I've managed to piece together an SQL query (not literate in the language), but it isn't giving quite the data I expected. Here is the code: [CODE]SELECT products_description.products_name, products_description.products_description, products_description.products_id, products.products_image, products.products_price_sorter FROM products_description INNER JOIN ( products, salemaker_sales ) ON ( products_description.products_id = products.products_id AND products.master_categories_id = salemaker_sales.sale_categories_selected …

pls, help! how can i connect to mysql 5.0 database with vb6 and how do i connect to mysql database from php5.Where do i download the necessary drivers.

I am having trouble with one thing on my project. I have already created the following table and inserted all of the information into it. Items ItemID Description BidFloor 100 1943 Monopoly game 80 101 1972 Ford Pinto Station Wagon 80 102 1.5 L 1921 Chateau Neuf du Pape 1,000 …

Hi frnds.. Currently i am working as a php developer.i know php,mysql and smarty... i am interested to change my domain from [B]web developer to mysql admin..[/B] plz give me some suggestions to me... how can i need to follow? and where can i get information regarding mysql totally.....what should …

Hello Everyone, I have a pretty simple problem for an expert. I want to access the database on the server from my localhost, I don't know how to do it. On our localhost the way is mysql_connect("localhost","name","password"); But how I will access the database on a server from my localhost?? …

how can we take backup of a database with shutdown the server in mysql.

Hello All. I am working on Mac OS X. I installed Python 2.5.4 and Mysql 5.1.31. For the interface, i installed Mysql-Python 1.2.2. I did the right steps for the installation. But , getting some warnings. So, i checked in Python shell for the modules. Python 2.5.4 (r254:67917, Dec 23 …

Hi I was wondering what the syntax would be to have a left join from one table to a resulting query without the view. Currently I use a view and it works fine but I was wondering how to achieve this without creating the view. Here is the current view's …

I need help with structuring a mysql database query so that if a certain condition extists, then a further condition is applied to the "WHERE" clause. This is my standard query: [CODE]SELECT * FROM products LEFT JOIN access ON product_id = access_product_id LEFT JOIN manufacturers ON product_manufacturer_id = manufacturer_id LEFT …

I don't have a clue how to do this. Have a PHP web site template, that has a 'submit ad' form. Works just fine for that web site. What I want to do, is to include a number of additional sub-domains, so that one can run the same ad on …

I know this is for MySQL, but there really isn't a forum for 'other databases.' I was wondering if anyone could point me in the right direction for learning SQLite. I tried googling it, and I did find some helpful things, but nothing that shows me how to use it. …

Hello everybody!! I am a newbie with MySQL but I still need to do this: 1. MySQL should be listening on a port, waiting for an XML document. 2. When it arrives, parse the XML file or just take the contents I am interesting in and insert them into the …

i have thisnew script if anyones interested i have lots of questions just pm me i get emailed if someone pms me and im online a lot so ill get notified fast see i have an emil checker on my firefox browser. i need help with lots thanks guys!

I'm new to mysql and I need some more practice with this stuff since were going to have a test soon ([I]this is not a homework assignment[/I]). One thing I still don't get is how to check if two tables contain an equal set of values. Heres the practice problem …

Hi I need to store binary data in a MySQL database from a web page. Basically it the web page will ask user to upload an image, and on submit, it should store this image in a MySQL database on the server. Could someone please let me know how to …

Hi, This T-SQL works fine but i just want to make sure that it is also reliable. Do you think this is reliable? Thanks [code] CREATE DEFINER=`root`@`localhost` PROCEDURE `addNewUser`(IN username_in varchar(15), password_in varchar(40), name_in varchar(25), surname_in varchar(25), dob_in date, address_in varchar(50), postcode_in varchar(8), city_in varchar(20), phone_in varchar(14), email_in varchar(50)) BEGIN …

I had a mysql table with a field named "age". And I need to search it using php form. ie with two text fields called "age_from" and "age_to". In simple words i want to do a search like this... [code=sql]search * from profile where age>= age_from and age <= age_to …

Hi, I am thinking to create an e-commerce web site. I just want to find out about the logic behid processing the order that have more than one order. How do we place an order? Stock check and update before and after placing order. I am asking this question because, …