Please, please, help me out in rewriting my sub-query to some kind of JOIN for earlier MySQL version: The query should retrive any availble rooms from the database MY ATTEMPTED SUB-QUERY: Select * From Room R Where R.room_no NOT IN( Select B.room_no From R.room_no = B.room_no And R.room_type = ‘single’ And B.arrival_date = ‘2005-03-23’ And B.departure_date = ‘2005-04-30’ ) My ATTEMPTED JOIN: not working correctly Select * From room R, booking B Where R.room_no = B.room_no And R.room_type = ‘single’ And B.arrivel_date = ‘2005-04-23’ And B.departure_date=’2005-04-30’ I welcome any better ideaa or comments. For your information, this are the TABLES …

Member Avatar
Member Avatar
+0 forum 1

MySQL Experts, I have a UBBThreads forum that uses MySQL for the database. Recently a user's posts were accidentally deleted. We have a backup of the database but unfortunately it's quite old. We urgently need someone who is versed in MySQL operations and preferably is also familiar with UBBThreads to either try to undelete the user's posts (probably unlikely), and if not figure out a way to merge all of the user's posts from the database backup into the currently running database without overwriting any of the other information. If you are capable of doing this please email me at …

Member Avatar
+0 forum 0

Hey folks, I need your help. I stuck with my Database project. I have five tables on the database: These are Room, Guest, Booking, Employee and Admin Room (room_ no, room_ type, price) Guest (guest_ no, Fname, Sname, address,…) Booking (room_no, guest_no, Fname, Sname, arrival_date, departure_date, emp_no, user_name, password) Employee (emp_no, Fname, Sname, uaser_name, password) Admin (admin_no, fname, Lname, user_name, password) I used the fallowing query to search for available rooms: Select * From Room R Where R.room_no NOT IN (Select B.room_no From R.room_no = B.room_no And R.room_type = ‘single’ And B.arrival_date = ‘2005-03-16’ And Bdeparture_date = ‘2005-04-19’ Q1. Whenever …

Member Avatar
Member Avatar
+0 forum 4

I've been impressed by MySQL's ability to run as a database on a server with clients connecting using a client-server or web based architecture. I'm now wondering if a version of MySQL can be cost effectively licenced to run with application software (which might traditionally have used a Jet database) on a single user PC (rather than on a server serving multiple users). Any advice would be very greatfully recieved! W. Robertson

Member Avatar
Member Avatar
+0 forum 4

hi, please anyone help me with this.I have a database 'hbm' which contain a table called hitted having 2 columns(id,hit). I inserted a record with id=1. Now i need to query this database. define("hit_TBL","hitted"); "select hit from" . hit_TBL. " where id=1 and LIMIT=1"; throws error. request members to help me out.

Member Avatar
Member Avatar
+0 forum 5

I'm having trouble figuring out how to query multiple tables. (Note: I've greatly simplified the tables for clarity purposes) I have 2 tables: Invites and Purchases The invites table has the following fields: email & invitee The purchases table has the following fields: useremail & product Invites tables +------------------+----------------------+ | email | invitee | +------------------+----------------------+ | [email]joe@joe.com[/email] | [email]sam@sam.com[/email] | | [email]joe@joe.com[/email] | [email]max@max.com[/email] | | [email]joe@joe.com[/email] | [email]ken@ken.com[/email] | +------------------+----------------------+ Purchases table +------------------+----------------------+ | useremail | product | +------------------+----------------------+ | [email]joe@joe.com[/email] | gum | | [email]sam@sam.com[/email] | cheese | | [email]ken@ken.com[/email] | cheese | +------------------+----------------------+ It's a simple referral …

Member Avatar
Member Avatar
+0 forum 1

I am working on a site for a school project and all I have access to is php and html. I would like to be able to run some MySQL - but I am unable to find a place that will remotly host it for me. Does any one know of one?

Member Avatar
Member Avatar
+0 forum 3

Hi all, I am learning to write with PHP and am stuck and need some wise souls help. In a nutshell I need to be able to take grab a DB coulmn status and then count how many times it gets updated and output that number to a file and then have that number add to what the number was before. I have every thing working but getting the number. Here is the bit of code I have so far so it will be easier to figure what I need function CountDefUpdates () { //GetICMSData UpdateICMS("UPDATE desktops SET status = …

Member Avatar
+0 forum 0

Please tell me the difference between the two thankz

Member Avatar
Member Avatar
+0 forum 8

could someone provide me with the sql for the following code: Dim i As Integer Dim countvar As Integer If Number_of_Panels.Text > 1 And Number_of_Panels.Text < 27 Then For i = 1 To Number_of_Panels.Text countvar = (countvar + 1) Project_Number.SetFocus MsgBox Project_Number.Text & countvar Number_of_Panels.SetFocus Next i Else End If i'd be very grateful for any help. thanx in advance mick

Member Avatar
Member Avatar
+0 forum 1

Okay, not new to MySQL, or PHP, but I'm really lost on this one. I have a query (simple one really) that is supposed to return the requested values from a database. I've tested the query with MySQL direct and it works fine, but when used via the web interface, it chokes and doesn't get a valid result resource. I don't understand how a valid query can work with MySQL directly but not with the web interface. I've added the query below: SELECT GUID, FirstName, LastName, Address, Address1, City, State, Zip, Phone, Email, Company, Remove FROM databasename WHERE GUID = …

Member Avatar
Member Avatar
+0 forum 5

I am using mysql 4.0 server. But in the database I can not use special characters (i.e. latin characters, root sign etc.) or can not use superscript or subscript. In the front end I am using VB. When I am copying the text from Ms word and pasting it the character changes. Presently I am using field type Varchar. Please help me in this matter.

Member Avatar
Member Avatar
+0 forum 1

hi folks, i am creating a database in access 97. I have designed 5 different forms which are all linked to the same table. the forms share some of the same fields but not all, except for the admin form which sees them all. my forms are made up of textboxes and i need to create rows in my table when a value over 1 is enetered in one of these textboxes, (number_of_panels.text). for example if the number 4 is entered into this textbox, 4 rows should be added to the table, using the same primary key but adding a …

Member Avatar
+0 forum 0

how would you check if a value exists in a database? i want to use this for ip blocking so it will check if your ip is on the list and if so, it will not let you access a specfic page.

Member Avatar
Member Avatar
+0 forum 1

i'm having a problem with my SQL query. i'm trying to create another column with values based on the values of the other columns and call it sTitle. Every time i try to execute my SQL statement it brings back this error: Illegal mix of collations for operation 'concat' Error No. 1271 I can't see anything wrong with my syntax but then again i'm kinda new to this. Here's my SQL: [code]SELECT CONCAT(rgMake,' ',IF(rgModel='ST','',CONCAT(rgModel,' ')),IF(rgWheels='2','Two','Single'),' Wheel Roll Grinder ',ROUND(inDiaCenter*25.4,0),IFNULL(CONCAT('/',ROUND(inDiaMax*25.4,0)),''),' mm Dia. ',ROUND(inFace*25.4,0),' mm Roll Face') AS sTitle FROM tblMachine WHERE rgBecameAvailable IS NOT NULL ORDER BY rgWheels, ROUND(inDiaCenter*25.4,0), ROUND(inFace*25.4,0)[/code] any …

Member Avatar
Member Avatar
+0 forum 1

I have the following code: [php]$rebate_query = tep_db_query("select * from " . TABLE_REBATES . " where product_id = " . (int)$HTTP_GET_VARS['products_id']); $rebate_information = tep_db_fetch_array($rebate_query);[/php] This should return only 1 row of data I have this code - " [php]$rebate = $rebate_information['rebate_amount'];[/php] " for extracting the rebate amount. For the life of me I cannot understand why this isn't working. It doesn't error out, but nothing is returned, and I know that the value exists. I would very much appreciate any help you can give. Thanks.

Member Avatar
Member Avatar
+0 forum 5

Dear friends! We are asking your opinion on alpha-version of our MySQL Client Some people ask what is the point of yet another My SQL client (there are dozens of them). We see our niche as low cost solution-a set of several tools with everything a web-master might need. It is still a long way to our dream, but we are working hard. This is a public alpha-version and still needs to be tailored to your needs. So we would be happy if you throw in your opinion or feature request. Everybody who participates will get a key for the …

Member Avatar
Member Avatar
+0 forum 1

Helo everyone, I have installed a php directory script similar to this at: [[url]http://www.dentalarticles.com/directory/add_url.php?c=303][/url] and I wonder if someone could possible tell me how to add 3 additional fields to the submission form. Is this something that could be done by someone with almost zero programming knowledge? !!! Thanks all.

Member Avatar
Member Avatar
+0 forum 1

I have a web portal from a buddy's website using PHPNuke that I administer. The site has user accounts for the site itself and for the forums. I recently purchaced my own domain and am currently designing it the same way using PHPNuke. Is there any way I can transfer all of the posts in the forums and user accounts so that all is not lost and we can pick up on the new site where we left off from the old one?

Member Avatar
Member Avatar
+0 forum 3

I'm trying to figure out if this is possible, and cannot find any information about it. Specifically what I want to do, for example, is allow a web-based user to search for a particular value in one field the first time around. If that returns an overwhelming number of results, I'd like for them to be able to search from within the results of the first query. I suppose I could have the prior query statement POSTed with the results and nest a bunch of statements, but this seems like it could get really ugly in a hurry. :eek: Any …

Member Avatar
Member Avatar
+0 forum 4

This may sound stupid but I am very new to MySQL. I am thinking of using this for a database driven site on a Linux server with a new, (hopefully more reliable) host. My current host can supply a MySQL database for £25.00 per year, (seems too cheap) my proposed host is quoting £160.00 per month just for the MySQL database and set up. The existing is co-hosted and the new one will be on a dedicated server but the prices above do not include hosting, just the MySQL. I have looked around to see if MySQL is something I …

Member Avatar
Member Avatar
+0 forum 12

I want to install my own php script into my server (shared) but the moment I test my page, the following errors occurs. [CODE]Warning: main(): Unable to access ../includes/global.php in /home/linkme2u/public_html/paidmail/site/index.php on line 3 Warning: main(../includes/global.php): failed to open stream: Permission denied in /home/linkme2u/public_html/paidmail/site/index.php on line 3 Warning: main(): Unable to access ../includes/global.php in /home/linkme2u/public_html/paidmail/site/index.php on line 3 Warning: main(../includes/global.php): failed to open stream: Permission denied in /home/linkme2u/public_html/paidmail/site/index.php on line 3 Warning: main(): Failed opening '../includes/global.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/linkme2u/public_html/paidmail/site/index.php on line 3 Fatal error: Unknown function: dbconnect() in /home/linkme2u/public_html/paidmail/site/index.php on line 9[/CODE] Please sombody give me step by …

Member Avatar
Member Avatar
+0 forum 2

I'm getting ready to make a database of my baseball cards and wanted to know how would I go about making a searchable database of my cards?

Member Avatar
Member Avatar
+0 forum 2

I know how to do MySQL connections, queries etc. with PHP but I want to do some MySQL stuff with an offline language - I know C++, VB and Java - but I'm not sure which one to do it with. Is it even possible? Can someone please recommend one for me? Thanks & Regards, Jonnie

Member Avatar
Member Avatar
+0 forum 1

Hi, I have a small problem I have a flash game SWF file not the fla and it sends and recieves values from a PHP file send - update and recieve is INIT Great except the person who gave me the SWF and PHP file did not tell me how to set up the database If I was to post the code could someone tell me the table layout to wright with PHP My Admin? I know its only a small database we are talking 4 or 5 objects in 1 table but I just cant get my head around …

Member Avatar
Member Avatar
+0 forum 4

hi, in order to install my php gallery, i have to "Run the photos.sql script in your MySQL database" what does this mean? i know i have mysql, as i have a phpBB2 forum running. but how do i do this? thanks

Member Avatar
Member Avatar
+0 forum 6

What I'm attempting is to have database driven links on my page. It is all ok except one thing and that is this error when my page comes up in the browser. Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/admin/public_html/index.php on line 114 Here is my code. [code] <html> <head> <style> .root_td { background-color: #000000; color: #FFCF00; font-family: Verdana; font-size: 8pt; font-weight: bold; height: 22; padding-left: 5; } .child_td { background-color: #D1D1D1; color: #000000; font-family: Verdana; font-size: 8pt; font-weight: bold; text-decoration: underline; height: 22; padding-left: 10; padding-right: 10; padding-bottom: 3; } body { color: #000000; …

Member Avatar
Member Avatar
+0 forum 1

ok i am getting the error that my fields i want to full text search are not in my index but in phpmyadmin it lists them in my index! i do not understand y it is doing this:( also does it automatically order results by relevance and how i change the relevance score to a percentage?

Member Avatar
+0 forum 0

I'm new in script installation and I am trying to install several free scripts in my testing server. I always have problem running install.php. The moment I enter my mySQL information, it always returned blank.. Please try to visit this page and enter the following MySQL server information if you can do it. [url]http://www.linkme2u.com/servertest.php[/url] MySQL host: localhost MySQL user: linkme2u_junvalasek MySQL pass: yakuza55 DB: linkme2u_phpbb1 Note: I created a username and password as "junvalasek" and "yakuza55" . Should I use "linkme2u_junvalasek" and "linkme2u_yakuza55" or just "junvalasek" and "yakuza55"? I'm always having problems in number of scripts that I installed. I …

Member Avatar
Member Avatar
+0 forum 1

Hello again =) Now i have a question about vbulletin and its usergroup manager and some mysql questions that goes with it. We have a clan site and vbulletin forum. I have created a specific usergroup for our clan members. Now i want to display those users on a none forum page by grabing the information from the database using dreamveawer. Whenever i try i cant since i have all members on registered membergroup as main group and the clan member group as secondary and it will not display the secondary groups if i try to grab it from the …

Member Avatar
Member Avatar
+0 forum 2

The End.