10,940 Topics
 | |
| | how to get from table only one column and its downstair data? from this: [URL="http://lashatt.comoj.com/table1.JPG"]http://lashatt.comoj.com/table1.JPG[/URL] show only this: [URL="http://lashatt.comoj.com/table2.JPG"]http://lashatt.comoj.com/table2.JPG[/URL] what will be mysql code of this? |
| | invalid use of property [CODE] Dim search As String search = Trim(txtSearch.Text) Select Case cmbSearch Case "By: Customer Name": Call DataGrid("select * from list1 where CustomerName like '" & search & "%'") Case "By: Date": Call DataGrid("select * from list1 where Date like '" & search & "%'") Case "By: …  |
| | i have de following code [CODE] <?php require_once('Connections/conn.php'); ?> <?php $oras = $_POST['oras']; $zona = $_POST['zona']; $camere = $_POST['camere']; $tip_apartament = $_POST['tip_apartament']; $chirie = $_POST['chirie']; $tableName="anunturi"; $targetpage = "afiseaza.php"; $limit = 2; $query = "SELECT COUNT(*) as num FROM $tableName WHERE oras='$oras'"; $total_pages = mysql_fetch_array(mysql_query($query)); $total_pages = $total_pages[num]; $stages = … |
| | Hello, I have a problem using the MySQLdb library. I'm trying to insert values into my table but MySQL isn't showing them. What's more strange is the primary key is changing when I manually insert values using command prompt. Here's an example: [CODE] '786', '2011-02-16 14:52:38', NULL '787', '2011-02-16 14:52:52', …  |
| | Hi there, i am desperately trying to compile the MySQL++ library header & cpp files in order to create the actual lib. I do follow the exact instructions given in the ReadMe for MinGW. [ICODE]Prerequisite: MySQL C API DLL Import Library ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Before you can build MySQL++ with MinGW, you …  |
| | Hi, I'm a database novice and need a few pointers (please). I've created two tables in MySQL: [CODE]CREATE TABLE `Users` ( `Username` VARCHAR( 20 ) NOT NULL , `Password` VARCHAR( 18 ) NOT NULL , `Secret_Question` VARCHAR( 100 ) NOT NULL , `Secret_Answer` VARCHAR( 100 ) NOT NULL, `First_name` Varchar( … |
| | I have a script that calls up a picture stored in a database. I then have a script that displays said picture on another page. If there is no picture in the database I would like for their to be a no picture icon displayed. New to php but I … |
| | I tried to import a table intro a database and MySQL give me the next error message: "[COLOR="Red"]MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''table_ro2' INSERT INTO 'table_ro2' … |
| | Hi all, i have a problem in writing a block of SQL code in mysql. The block of code will have too delete a single row/record from about 23 related tables all at once. The code that i have written so far will only delete 1 row/record in 10 related … |
| | hello, I am new in perl..i am just trying to connect perl with mysql database. for this i installed xampp server in my system..and now perl,apache and mysql are running on my system. i also check server by running cgi program on it.. evrything is right.but i dont know why …  |
| | Dear All, I have a server with 16 cpus and 32g ram. The problem below when I run my top it show mysql %cpu is more than 100%. Below is my top results. The problem here I would like to why is mysqld is using up 137.2% of the cpu … |
| | Hi all, i have a problem in writing a block of SQL code in mysql. The block of code will have too delete a single row/record from about 23 related tables all at once. The code that i have written so far will only delete 1 row/record in 10 related … |
| | Hello. I'm working with a webpage where its going to a Google Store Locator. [URL="http://code.google.com/intl/no-NO/apis/maps/articles/phpsqlsearch.html"]Goolge Store Locator guide[/URL] I did follow. I got it working for a while, but here in Norway we have some characters, ÆØÅ that we use. This is the problem. When I search for a place, … |
| | Hi... I need to establish a connectivity for mysql in c++ on a linux fedora 12.0. please let me know a solution.  |
 | Please Explain me what is difference between cluster and non-cluster index. Also if i create a primary key on a Table which index will be created automatically, cluster or non cluster. Thanks in advance. |
| | Hello. I have gone through various checks, and I can't seem to figure this one out... [CODE]while($row_sizes = mysql_fetch_array($sql_sizes)); { $sizes = $row_sizes['size']; $product_list .= count($sizes); $product_list .= "<li>".$sizes."</li>"; }[/CODE] Its not outputting any sizes. However, my count($sizes) outputs 0. And that shouldn't because I have [CODE] $sql_colors = mysql_query("SELECT … |
| | Hi, I am trying to create a foreign key between 2 tables. I am using MySQL Workbench but every time I create the foreign key relationship, it just dissappears after clicking "apply"... Initially I thought it was Workbench so I tried the legacy Query Browser - but it does the … |
| | I'm trying to insert into MySql, using DBI/Perl... What I'm doing is storing all my Print statements into an array, then dumping them out to print, and inserting into a MySql table in a foreach loop... Print resolves ok, but the MySql inserts are being split into fields at the …  |
| | Hello! i have a very simple query: [CODE]SELECT * FROM fornitori ORDER BY ragSociale[/CODE] this works perfectly in localhost on my PC (windows 7 pro-apache 2.2.17-mysql 5.1.54-PHP 5.3.4) but on my VPS doesn't work and it give me a query error without number or error description (VPS: centOS 5.5-apache 2.2.16-mysql … |
| | Hi All, I'm very new to PHP and MYSQL and I'm having hard time trying to insert data from PHP form in MYSQL DB. I'm able to echo out the output on webpage but i'm not able to figure out how to insert the data in DB. Please help me … |
| | Hi, There are three tables involved here. A kind of quiz localhost site, i did for me. Table 1 contains questions. ========================== question_id (autoincrement) questions (varchar 250) category_id Table 2 contains choices ======================== Choice_id (autoincrement) Choice_value (varchar) question_id Table 3 contains answers ======================== question_id choice_id I am displaying 10 questions … |
| | i need to develop a search query for city portal ..select * from ....takes lot for time is there any good query to get fast retrieval form database??????? plz reply its urgent |
| | Hi again!!I wanted to know that is it possible to backup the mysql database just by running query?I am trying to find out the code so that if a user clicks backup button, the whole database will be stored somewhere. |
| | I'm trying to display a picture stored in a msyql database. I have the following script, picscript.php, to call the picture from the database: [CODE] <?php $username = ''; $password = ''; $host = ''; $database = ''; mysql_connect($host, $username, $password) or die("Can not connect to database: ".mysql_error()); mysql_select_db($database) or … |
| | [B]Can somebody help me to retreive one or more checkbox values from the database using php and MySQL? Thanks and I appreciate that.:)[/B] In checkbox.html file the checkbox as follow: [CODE] <form method="post" action="Process.php"> <fieldset> <legend>Choose feature(s) to search for apartment</legend> <table border="0"> <tr> <td><input type="checkbox" name="feature[]" value="walkincloset">Walk in closet</td> … |
 | I am creating a login script and I need to check that the username and e-mail don't current exist in the database otherwise it will print an error. I've tried the following but it's not working: [CODE=php]//Create Username Array $SQL = "SELECT Username from user" $Result = mysql_query($SQL); $Array = … |
| | I'm a php noob and I have a feeling that there is a simple solution to my question. I have a php mysql table search that returns a result sucessfully. What I would like to be able to do is select one of the results to be inserted into a … |
| | hi, i have found a few ways on the internet to import an excel sheet into mysql. one of which is save to a csv and upload to a site which creates the sql statements and this is great and i have used in past. however my problem is i … |
| | Hi, I've been racking my brain for the last few days to figure out what is wrong with my PHP coding. I've managed to get the default value from my combo box into my database, but when I change the option it is breaking on me. I have reduced my … |
| | Hi, I've been busy writing a script to upload photo's to my webserver, and after a lot of searching I finally managed to get the permissions correct, but now I'm having another problem. There are quite a lot of posts about it, but they all come down to having the … |
The End.