10,940 Topics
 | |
| | well I am having a problem with my class I made to connect to my DB ok here is the class[CODE]class database { private $db_host = 'localhost'; private $db_user = 'root'; private $db_pass = 'McSteel8'; private $db_database = 'cmte'; public function connect() { $this->link = mysqli_connect($this->db_host, $this->db_user, $this->db_pass); mysqli_select_db($this->link, $this->db_database … |
| | Hello, I'm building an ecommerce site and I was wondering if developers usually use mysql to store credit card information? Or do they use some other service to store credit card information? I want my website to be secure for my users. Thank you |
 | I have two tables representing two forms that are connected each other but a form number. The second form records a number and a timestamp. This form can record multiple entries with a timestamp for each entry. I need a SQL statement that will return the first entry on Form2 … |
| | Hey all, new to this site but i'm trying to call multiple values from multiple mysql databnases to show up in one table, but its throwing up an error at line 55, or [CODE]while($row = mysql_fetch_array($result));[/CODE] so i was wondering if I'm causing havoc with this statement here, im new … |
 | Good day! May i ask? This is the scenario: The main purpose of daily activity report is to monitor the library transactions and to find out borrowers who are overdue. The report should be generated at the end of each business day and should contain the following data items: for …  |
| | hye...I'm having a problem to retrieve data from Jcombo Box... the combo box have a list from A-Z..for example when the user pick 'A' from the list,it will get all the A% data from MySQL this is the code that i have right now.[CODE]JButton Edit = new JButton ("EDIT SYNONYM"); … |
| | Hello All, I had installed MySQL 5.1. But due to instance problem I deleted some registries from REGEDIT. Now, I cannot run setup files of MySQL as well MySQL GUI tools.I am getting this error "Configuration data for this product is corrupt. Consult the Administrative Personnel". I tried to restore …  |
| | Hi iam using CI 1.7 and doctrine 1.2 and trying to make some search. But default search with indexes for me is not enough, because search keywoard must exect with indexed word. Is there any chance to make that more flexible where doctrine will detect with similar meanings not the … |
| | Dear ajax expert, [URL="http://www.w3schools.com/php/php_ajax_php.asp"]http://www.w3schools.com/php/php_ajax_php.asp[/URL] Refer to the link, using the sample, I'm able to use php ajax to populate 1 text box which I've already pre-define (not using "echo '<input type='text'..") -- the info came from a table e.g. Search: [jo ] Name: [John doe] sql --- select name from … |
 | I can validate the captcha successfully, but when I set the button property 'Action' to 'Submit form, the captcha does not work, nor does the validation on username and password. When I set it back to 'None", Captcha works, Data not validated. The code below is quite long, but it … |
| | Hi why do i have errors in updating a column using where? this is my code [CODE]"Update inventory Set isExpired='1' from inventory where expirationDate= '" & DateTimePicker1.Text & "'"[/CODE] my date format is yyy-MM-dd can anyone help me pls? |
| | hi people. i am building a simple social network for my CAS (i am doing IB diploma) and when i came to the home page where i all the friends statuses are viewd i got a problem here is my home page's code: [CODE] <?php if(!isset($_COOKIE['ln'])) { header("location : index.php"); …  |
| | [CODE]SELECT movie_id, movie_title, movie_release_year, movie_genre, movie_plot, (SELECT AVG(sum_movie_rate) FROM (SELECT SUM(movie_rate) AS sum_movie_rate FROM user_movie_rate WHERE movie_id = ?) AS t1) AS average_rating FROM movie WHERE movie_id = ?[/CODE] when I retrieve a specific information of a movie, I want to calculate the average ratings of the movie. user_movie_rate looks … |
| | I need some help. I want to make a secure loginsystem and here is my script for the system that checks how many times you tried to login ($try). db.php is the script for connecting with my database. The system isn't in connecton with the loginsystem it is only the … |
| | Hi, I am working on a Inventory management system. No I would like to have a [B]custom bill no, which will be changed on each month[/B], i.e. the first bill of March, 2011 will have a no like "[B]Mar/2011/01[/B]", the next will be "[B]Mar/2011/02[/B]" and so on, until it is … |
| | HI all Experites can you help me on this Query How to get perfect result set I have three table. [CODE] 1)vitalsigns ID DisplayName DisplayShort ToMetrics ToEnglish 1 Temp Temp (0.556*({1}-32)) ({1}/0.556)+32 2 BP(Systolic) BPH (NULL) (NULL) 3 Wt WtH {3}/2.2 {3}*2.2 4 Height Height 2.54*{4} {4}/2.54 5 Pulse Pulse … |
 | Hi I'm trying to display wordpress posts in October 2010. My best attempt was SELECT * FROM 'wp_posts' WHERE 'post_date' < 31/10/2010; but it shows an empty result and I think the dates need to be in a range. Any suggestions? Thanks, Kevin |
 | Hi, i am making a search engine in php and i just get a warning that i cant understand: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/eoopoedt/public_html/sok/search.php on line 27 See it your self: [url]http://eoop.org/sok/[/url] My code: [CODE]<?php $button = $_GET['submit']; $search = $_GET['search']; if … |
| | I have a Java application which uses a MySQL select query i want to use java array elements for In condition.for eg [CODE]select * from table where shortcode IN (aray[]);[/CODE] is it posible to use java array in mysql |
| | Hi to all, I created the following table --------------------------------- create table publisher(name varchar(20), city varchar(20)) --------------------------------- I want to put following constraint, 'name is having unique with city taken only from 'mumbai', 'pune', 'nasik', 'panji''. I know about unique constraints with name. I searched many about constraint with city, but … |
| | I have a table in visual foxpro. I want to import the table to mysql. I tried to do it by making an ODBC dsn for a blank mysql database and trying the export wizard from VFP, but it has no option for writing to an ODBC database. Is there … |
| | Hello, I have a problem, I'm interfacing C# with MySQL it seems to be that a lot of connections are left open even when the close() function and the dispose() functions are called. Also I've notice that the server only resists like 80 queryes at the time, then it halts …  |
| | I have a script that I am using to retrieve zip codes within a certain radius using a foreach php statement. However, with these zip codes that I am getting, I want to add a comma between each value (for example: 11111,22222,33333) to use in a SQL query using the …  |
| | I have a database that is filled with time series data points on different items. I would like to calculate the difference between values by item for the time series and then store it in a difference column. My table is as follows: id | Ticker | Date | SO … |
| | Hello, I'm trying to get mysql_num_rows from 4 tables where user id is being selected as session . My question is very simple : Is this sql is correct : ""SELECT * FROM users_tbl,events_tbl,players_tbl,sales_tbl,teachers_tbl WHERE events_tbl.user_id & players_tbl.user_id & sales_tbl.user_id & teachers_tbl.user_id = '$whois_id'"; ? user_id - The user id … |
| | I suspect there isn't a way to do this, but in case there is: Does anyone know how to pick up all the possible set values for a particular field from php? The reason I'm asking is that it means adding a new set value will not break all the … |
| | I have an online MySQL database, and I need to connect to it using Visual Basic. I have to read the values in the table and edit them. Any ideas? |
| | hi, i am create one application and then automaticallly server machine is shut down and then it gives error like this how to solve this error Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [MySQL][ODBC 5.1 Driver]Host 'computer1' is not allowed to connect to this MySQL server how to solve … |
 | If I'm not mistaken using library that is GPLed will force your app to go GPL. Is there a way to get away with MySQL GPL licence and use it in closed source (Not necessarily commercial)? Two scenarios here: 1. libmysqlclient is linked dynamically 1. libmysqlclient is linked statically Thanks! |
| | Hi to all, I created following table --------------------------------------- crate table publisher(name varchar(20), city varchar(20)) --------------------------------------- I want to run following query. [U]'list all the positions of charcter 'a' from name.'[/U] for this, i ran following query, ---------------------------------------- select patindex('%a%', name) from publisher; --------------------------------------- But, it doesn't show proper output. When … |
The End.