10,940 Topics
| |
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 … | |
i am trying to connect a form to mysql database by using php code,but once a click submit button to submit the form this is the error am getting. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the … | |
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 … | |
Hey guys, i have looked all over the web on how to upload a file to MySQL database and retrieve using coldfusion. I know i can do it in PHP, but im not using that anymore. Is there a script or some place that someone can point me so i … | |
I need to do project about online banking. so i was told i need to learn php n mysql. I dont have access to any tutor coz its a distance program course. I know php.net website. and mysql.com. I am assuming i just need these two sites and a book … | |
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 … | |
i found the way to store wave file in mysql database as blob format. But how to retrieve the wave file from the database and store it as audio Stream in c#? | |
| 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 … |
Hello, I want to ask you if you can give me an advice in how to make a secure login and register application in php and mysql. If you can give me a link or an idea I would be very thankful. Thank you! | |
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 … | |
Hello i am trying to pull the hosted domains from my sql database i am able to pull them and see them I just cant get the links to Phrase properly the link to the working script is here [URL="http://www.a1khosting.com/test/index2.php"]http://www.a1khosting.com/test/index2.php[/URL] as you can see the links are not correct when … | |
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 … | |
Hi! Is it possible to retrieve XML data and input it to mysql database using JSP? If so, how will I do it? I'm new to java by the way. Thanks in advance to those who will reply! | |
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 … | |
I have read many posts like this and can not get this to work right. The box always remains empty, yet there are rows in the table. Any help would be appreciated. Thanks. [CODE] <?php //Variables for mysql database connection $user='testuser'; $password='testpass'; // connect to MySQL $connection = mysql_connect(localhost, $user, … | |
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 … | |
I have a MySQL query that's using SUM() to take the sum of a column, BUT what I need it to do is basically this: If the string in another column is 'BUY', then I want to add the number in my column, but if this other column has 'SEL', … | |
I've having very much trouble with the last piece of my site. I retrieve my database including checkboxes. From here I want to check/ucheck the boxes and save it back into the database. The problem I run into is when I check some boxes it doesnt take any notice witch … | |
I have all the php coding Insert, view, delete. The problem now is user only can use once email address to register at my website. I would want them to register with same email at my website. is it possible? Thanks! | |
Hi all, I'm somewhat of a PHP noobie so be kind:) I have a MySQL table that contains the latitude and longitude coordinates to several different service areas, as well as an 'AreaCode' field. I'm using a PHP point in polygon function to loop through each of the service areas … | |
I'm populating a dropdown from a mysql table with php but some cells in the column are blank, so in the dropdown there are gaps where these blanks are. Can i choose not to show blank cells or something? Thanks | |
i have two different tables table1 - property ================= id,name, address, city state, zip table2 - floorvalue =================== id, rentmin, rentmax, bedrooms, bathrooms i need a query to fetch first min rent values from the two tables query i have : select p.id, p.name, p.address, p.city, p.state, p.zip, f.id, f.rmin, … | |
Hi, I am looking for some help with my script, since only half of it is working. The image path will not be put in the database for some reason and when I process the form all I get is white space: [CODE] $reg_errors = array(); if ($_SERVER['REQUEST_METHOD'] == 'POST') … | |
| I have mySQL v.5.3 I think... I cannot figure out what is going on. Ive searched high and low and cant find an answer as to why i keep getting a syntax error. Heres the error I keep getting. [code] You have an error in your SQL syntax; check the … |
| I am filling a dropdown list and an HTML page with the contents of a MySQL database (the tablename is in the variable $tablename2). The file contains a single field, "BusinessCat", with 20 or so unique records. The code below is an attempt to display every category on an HTML … |
The End.