10,940 Topics

Member Avatar for
Member Avatar for LianaN

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 …

Member Avatar for LianaN
0
180
Member Avatar for jakizak

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 …

Member Avatar for jakizak
0
199
Member Avatar for mangel.murti

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 …

Member Avatar for smantscheff
0
73
Member Avatar for gikonyo

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 …

Member Avatar for gikonyo
0
124
Member Avatar for joshisumitnet

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 …

Member Avatar for smantscheff
0
559
Member Avatar for joshisumitnet

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 …

Member Avatar for joshisumitnet
0
107
Member Avatar for fobos

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 …

Member Avatar for arrgh
-1
955
Member Avatar for kakaliki

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 …

Member Avatar for kakaliki
0
108
Member Avatar for 1olga

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" …

Member Avatar for smantscheff
0
72
Member Avatar for ben.matthews18

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 …

Member Avatar for drjohn
0
102
Member Avatar for sah

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#?

0
83
Member Avatar for TechySafi

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 …

Member Avatar for TechySafi
0
135
Member Avatar for human2600

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!

Member Avatar for madiyasa
0
147
Member Avatar for jakizak

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 …

Member Avatar for n1csaf3
0
86
Member Avatar for wxflint

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 …

Member Avatar for monica singh
0
158
Member Avatar for shahab.burki

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

Member Avatar for Surreal_one
0
185
Member Avatar for i.connect

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 …

Member Avatar for smantscheff
0
157
Member Avatar for hoshumaruh

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!

Member Avatar for peter_budo
0
93
Member Avatar for druggeri1

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 …

Member Avatar for P0lT10n
0
400
Member Avatar for gunderjj

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, …

Member Avatar for gunderjj
0
72
Member Avatar for scofro

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 …

0
125
Member Avatar for roachae

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', …

Member Avatar for roachae
0
139
Member Avatar for Surreal_one

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 …

0
98
Member Avatar for alanlee9898

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!

Member Avatar for alanlee9898
0
98
Member Avatar for scofro

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 …

0
79
Member Avatar for benhowdle89

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

Member Avatar for pritaeas
0
241
Member Avatar for Venugopal Ravi

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, …

Member Avatar for blocblue
0
68
Member Avatar for SunnySideUp

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') …

Member Avatar for fobos
0
106
Member Avatar for JayGeePee

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 …

Member Avatar for smantscheff
0
196
Member Avatar for Bounty Hunter

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 …

Member Avatar for diafol
0
350

The End.