10,940 Topics
 | |
| | Hi, How can I delete from multiple tables? I'm using this query and its not working: "DELETE FROM table1,table2 WHERE $localTime > table1.Time OR $localTime > table2.Time"; What I hope to achieve is deleting rows from table1 and table2 where their Time Field is less than $localTime. Thanks very much. |
| | |
| | I am completely new to phpMyAdmin and relatively new to MySQL, so this may be a dumb question. Please forgive me if it is. I have MySQL running successfully, no problems that I am aware of. I have IIS running on the same server with PHP installed and am successfully … |
| | I am a student and am developing my knowledge of MySQL and am practicing using it as a backend for some of my apps. I can run MySql on my laptop (Windows XP Pro) and use my apps referring to the local host. We have a wireless network in our … |
| | Hey, I am having a really stupid yet annoying problem. I have a simple database stracture (I'll give an example below) and I want to do a query that will loop through it's elements trying to display the list amount of times each element (trying to make it the most … |
| | I have a form that should write to MyDQL Database but isn't I have been looking at it for hours and it is driving me crazy. [CODE]$sqlquery = "INSERT INTO $table VALUES '$id','$Name','$DoB_Day','$DoB_Month','$DoB_Year','$Address_1','$Address2','$Town','$Postcode','$Telephone','$Mobile','$Email','$6th_Form','$6th_Form_Year','$6th_Form_Institution','$6th_Form_Course_Title','$College','$College_Year','$College_Name','$College_Course','$E2E','$E2E_Provider','$Apprenticeship','$Apprenticeship_Level','$App_Employer_Name','$App_Work_Area','$Employment','$Employment_Basis','$Emp_Employer_Name','$Emp_Job_Title','$Emp_Training','$University','$University_Name','$Uni_Course_Title','$Gap_Year','$Unemployed','$Other')";[/CODE] I have used this method before and it worked fine but it just isn't playing nicely today. … |
| | I bought a book called PHP/MySQL Programming for the absolute beginner by Andy Harris, Premier Press. This book is great for a beginner. It walks you through a refresher on HTML and then goes step by step into PHP and MySQL. Great examples and VERY challenging "homework" assignments. Great for … |
 | When attempting to compile PHP 5.0.4 with MySQL 4.0, I received some strange errors from attempting to use --with-mysql and --with-mysqli. After getting it to configure correctly, where it finds mysql and mysqli support, when I run make I get these odd compile errors: == /usr/src/php-5.0.4/ext/mysqli/php_mysqli.h:48: error: syntax error before … |
| | I am doing an SQL statement that tries to get the [B]percentage[/B]..but i dont know how to do it in MySQL here is the sample of my code: SELECT count( * ) , rating, percentage.... FROM `acne_prod_rating` WHERE prod_id =5 GROUP BY rating the output should be like this: count(*) … |
| | I have a link per customer for mrtg graph and remote reboot access. I need to be able to integrate the login to be password protected, connected to ModernBill database where the client can use their MB login info to access the mrtg / remote reboot page as well. How … |
| | Hi. I want to escape any special characters in the input field before inserting the data into mysql tables in C++. Here is how I am using this function [QUOTE]// Escaping special characters in the Subject field char * S = new char[strlen(m_headerSubject.c_str())*3 +1]; mysql_real_escape_string(conn, S, m_headerSubject.c_str(), m_headerSubject.length()); m_headerSubject = … |
| | 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’ … |
| | I installed PHPDev5 and can run my php files no problem on localhost. However, since I'm the only who can seem them, I wanted to setup IIS so that my site could be seen by others on the internet. (until i move to an actual dedicated server) I believe the …  |
| | 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 … |
| | 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 …  |
| | 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) … |
| | 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 … |
| | 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 +------------------+----------------------+ | …  |
| | 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 … |
| | 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 … |
| | 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 … |
 | |
| | Ok, heres an odd situation. I've been using a code for a few years to basically add edit, and delte content from my site. I have taken this bit of code and once again am using it to add some content. ARGH! I can't figure this out for the life … |
| | I am very new to php & mysql. i have made a webste with a database in mysql. i have developed a search engine to search my database. I just discovered a weakness in my current search engine. It won't show results if I don't have an exact match or … |
| | how is access used versus mySQL? i know access isnt much of a web database but what are its advantages/disadvantages over mysql?  |
| | 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 …  |
| | 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, … |
| | 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 … |
| | 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 … |
| | 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. |
The End.