[mysql] Forum Topics

hi all, i am trying to create a room booking system in php. now i want to check if a period exists within a given month. i ask the user for the month and how many days they want to come, now i want to look in mysql (where i …

PHPMYSQL - How do you perform a double SELECT query or check against multiple fields? Does anyone know how this can be achieved? What i want is from a search page that has multiple search areas such as name / description / functions and be able to type multiple search …

I'm looking to re-order a table while keeping the table's id column constant. ie, Links has entries in no particular order, whereas LinksPopular is a duplicated table but I want it ordered by category X, while leaving the id category unchanged. That way the first most popular is at id …

I have a query which generates an xml file from data collected. There are 2 columns in the data (reason, TotTime) but they are joined together into one column using the concat command. Currently the results are ordered by reason, but I want to limit my results to only the …

So let me start by saying I am new to PHP so any extra advice is helpful, working on a large scale personal project hoping to get better with PHP because of it. Now I have a script that displays my database just as I like, and next to each …

how is MYSQL works and i want to know how set up database table with MYSQL

is call procedurename() is work in php version:5.2.4 mysql:5.0.45 server version:5.0.27

Hi All, I need to use the results of this query as an array to exclude files from a tree. The file and folder names that I enter into $exclude work fine but I can not seem to add the results from the query to the array. Below is the …

Hey everyone.. I am relatively new to PHP and JS and I need help. I need to populate a dropdown list from a db(mysql). I can do it just with PHP. The problem arises when I add another of the same dropdown to my form using javascript. I need the …

hey everyone i need your help i want to create a mailling list in php and mysal but i dont know how to do it , so please if you know how to do it please tell me or if you know where i can get it also tell me …

Hi, I am developing a program which requires access to my websites' MySQL. I keep getting errors trying to connect to it. My firewall is allowing the connection but MySQL won't accept it. How can I solve this problem? Thanks in advanced Kieran :)

Hi * I have spent the last 18 hrs or so trying to get the wright sql code or think of an alternative but I just can't get my head around it. If any one can help me it would be awsome. What I am trying to acheive is getting …

Im Writing a c# Code that Takes an Excel Sheet ,creates the Corresponding SQl table and Dumps the data in a new table in SQL. Now My problem is: In the " create table" command , i have to specify the DATATYPE for the column !i.e. CREATE TABLE "table_name" ("column …

Hi, My sql database contains a video table which has a video 'adddate' field. I need to change the code [COLOR="Red"].$video['adddate'].[/COLOR] from the following format: 2010-11-02 to 11-2010 I've changed it in .tpl files doing the following: {assign var='vidMthYr' value=$videos[i].adddate} {$vidMthYr|date_format:"%m-%Y"} However that does not work in my .php code …

Hi guys, I'm trying to create the simplest of databases. The database needs all the standard tasks, such as: add record, delete record, show all records. I need this accessible on the internet, so anyone can check it out. I will probably put it in a password protected directory, unless …

Hi, I have a table `Categories` with fields (category_id, category, parent_category_id) I want to write in a single query to replace the parent_category_id with the corresponding category_name. [CODE] // OBJECTIVE: To return all category names and parent category names // if category is root (no parent), parent category name is …

Would someone please try & modify this query in a way that it shows the count for how many users have registered for the current day ? So like right now it should display a count of 2 and then come midnight it would show 0 and then incrementally go …

Hi! I've downloaded the MySQL Server 5.1 and developed a small database using the MySQL Command Line Client. However, now I must update a structure of some tables, include some foreign keys, etc. In my opinion, it is not very comfortable to use the MySQL Command Line Client and the …

Hi guys, me again. Having an issue with a multiple select form object that is generated through PHP and retrieves and displays MYSQL values. it displays and retrieves correctly and PHP produces is correctly, however, the form submission to post the values to MYSQL do not, instead it posts the …

Hi ,all i have two field one is checkin date and other is checkout date . i have table structure as i attached jpg file here. when user enter dates i have to show his season on the basis of hotel id? note:user can enter any date checkin date and …

Dear Friends, I want to know that how can we compare two hebrew string in MySQL database? I tried and search a lot on net but still could not found the answer. My website is dealing with Hebrew(main) and English as well. So please let me know How can I …

Dear Friends, I want help to generate [url]www.bestuff.com[/url] like paging in my application because my client want same thing and in today's era this thing is found everywhere. I searched a lot but still could not found help. Here I am providing link to that paging so that you can …

Could anyone help and advise me on how to create a new sql database and then connect it to my html webpage. I would like to have a search window on my webpage with text search by Languages, Country or Services so as when a customer enters for example "french" …

I have created a very basic database in 'MySQL Workbench' just as a test.. This is the SQL it produced - [CODE]CREATE TABLE IF NOT EXISTS `CustomerOrder` ( `OrderID` INT NOT NULL AUTO_INCREMENT , `OrderDate` VARCHAR(45) NOT NULL , `ProductName` VARCHAR(70) NOT NULL , `ProductCost` VARCHAR(45) NOT NULL , PRIMARY …

If I put this line [ICODE]$friends = $connection->get('followers/ids', array('screen_name' => '2020volt'));[/ICODE] Twitter api returns something like this : [CODE]Array ( [0] => 173605790 [1] => 187372244 [2] => 17535566 [3] => 190756198 [4] => 184577861 [5] => 119247538 [6] => 183813521 [7] => 18013082 [8] => 149601084 [9] => 186491393 …

I seem to be having difficulties when using the following query: [CODE]$query = mysql_query("SELECT * FROM `products` WHERE `name` RLIKE '%$s1%' OR `name` RLIKE '%$s2%' OR `name` RLIKE '%$s3%' OR `name` RLIKE '%$s4%' OR `description` RLIKE '%$s1%' OR `description` RLIKE '%$s2%' OR `description` RLIKE '%$s3%' OR `description` RLIKE '%$s4%' OR …

Hi, I am new to web development. I am xampp package for development. First I was able to access MYSQL through CLI and PhpMyAdmin. But when I set the root password for the MYSQL, I am unable to access it. Any clue? Thanks

I am in the process of designing a Database structure for a project. And i am stuck at a particular design decision. Ive searched quite a lot on google but not able to find a satisfactory answer. I am looking out for something like “TableSpaces” (like in Oracle) to use …

I am using cake php I have a table called relates that holds the primary id values from the other tables. I used cakephp to generate the crud. it works fine. if you click on the number in the relates table it goes to the appropriate table and displays the …

Hi all, I'm looking for some help with a PHP / MySQL scheduling component that our website users will use to schedule our services. I've drawn out 2 calendars that sit side by side using PHP. One for the current month, and one for the following month...to give users the …