10,940 Topics
 | |
| | script in file 1 <?php // Check if he wants to register // - Make sure that param exists // - Check length if (isset($_POST['username']) && strlen($_POST['username']) > 0) { // Check if passwords match. // - Make sure that params exist // - Check length // - Check matching …  |
 | i have a server called OAS-VB and a network pc what i need is the sql that installed on pc see the OAS-vb server to reach the database file ??? or some one can tell me how to configure the sql server for network to reah the pc ?? i …  |
| | Hi, I have been trying to create a login facility using PHP/mySQL and so far I have managed to get everything working apart from changing/updating the stored user password. The code I have used is basically just the registration script with a few changes so that it will update a … |
 | Hey guys, have a quick multiple database connection question I hope will be simple to answer. I've worked with this type of situation several times, but I must be missing something. I have a newspaper website that has 8 databases (news, obituaries, opinion, etc..) which can hold about 7 counties … |
| | this works fine $view_query = mysql_query("SELECT ip_address FROM view"); but this query below give me a error $view_query = mysql_query("SELECT ip_address FROM view WHERE ip_address = $user_ip") or die(mysql_error()); error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the … |
| | Hi, I have this website which I am developing, but it is having display problems. I have a directory called 'includes' which contains 'header.php', 'login.inc.php' and 'login_form.inc.php' 'header.php' - displays the normal doctype, meta tags, styles, etc. 'login.inc.php' - is the actual process of the login form once the form … |
| | I have a problem with retrieving a value from a query. I know what the problem is but not sure how to solve it. Pretend I have this code: $sql = mysql_query("SELECT * FROM sometable WHERE thisvalue = '$_SESSION["value"]'"); // This will always return one result. $result = mysql_fetch_row($sql); echo … |
| | Hello :D I am using the twitter API to perform a search for a certain author, and storing the results in a database so that I can perfrom an action on each entry. However, there are many duplicate results that have small differences at the beginning of the string or … |
| | when im test in my local machine i dont have any error but when im trying to test in web i have this error, the same DB, the same tables, the same data in both structures any idea???? Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in … |
| | I've been looking into security for PHP and came across MySQLi prepared statements. After doing some research I'm confused about why you would use these instead of normal SQL query. A prepared statement looks something like this: $quer=$db->stmt_init(); if($quer->prepare("INSERT INTO `test` (`first`,`second`,`third`) VALUES (?,?,?)")) { $quer->bind_param('iss',$aa,$bb,$cc); $aa=1; $bb="something"; $cc="testdata"; $quer->execute(); … |
 | hello guys how are you sorry i have another question i want to display images on left side and right side on my website for example in this code i have 9 images and i want to spread them 4 on the left side and 4 on the right side … |
 | Hello to everyone, im having trouble in inserting a date like "2012-12-06" into a database mysql, Im using phpmyadmin+wamp and adobe dreamweaver!I want to use 3 textfields, one for the year, other for the month and a last one for the day, but I always get an error by using … |
| | I am totally new to vb.net, still I am planning to try it for a project, in which there will be standalone machine using an access database to query and update different tables. While in VB6 I was able to define recordsets using Microsoft.jet.oledb.4.0, in VB.net I have become a … |
| | afternoon all! I am having some issue writing a log in script for a website! this is my first ever attempt so i am hoping it is something very straight forward!!!! I am getting the following error message - Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource …  |
| | Hi, In order to be able to display the graph I want I have to run two queries. The first query looks like this. SELECT PercentageScore,COUNT(*) AS 'IndividualFrequency' FROM resultsets GROUP BY PercentageScore I than want to take the IndividualScores and use them again in this Query. SELECT PercentageScore,CONCAT(100*(IndividualFrequency/32),"%") AS … |
 | Hi, This has been troubling me for the last hour and I cant think of a way around it. My SQL table looks like this: **Name, Cost** Matt, $5.00 Carl, $4.50 Tom, $6.00 Tom, $7.50 I need to make a query so that it puts anything with the same **Name** … |
 | Hello, I am a newb all the way around and I hope that I explain this thoroughly in order to get the help I need. I have a mysql db inside of my python program that generates a hint. I need to have a random number (which will later be …  |
 | I habe table one with Col 1 (PK) Col 2 (NN) Col 3 (NN) Col 4 (NN) Col 5 (NN) Col 6 Col 7 Col 8 Then I create table two with Col 1 (PK) (AI) Col 2 Col 3 (FK) That col 3 from table two is col 1 …  |
| | I am creating a basic PM system for my website. I have just a basic table for a pm: mysql>describe PM; +--------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+---------+----------------+ | PMID | mediumint(9) | NO | PRI | NULL | auto_increment | | … |
 | I know that this forum is for HTML and CSS, but I have a problem and I am not sure where to take it, so here it is. I am using this code: <div class="edit"> <input type="button" id="bold" style="height:21px; width:21px; font-weight:bold;" value="B" onClick="fontEdit('bold')" /> <input type="button" id="italic" style="height:21px; width:21px; font-style:italic;" … |
 | Hello, How to add multiple data in mySQL 5.1 using vb.net 2008? Do it needs an array?  |
 | hi i have a dropdown which is connected with a database and containing some sort of items, and a gridview. i want to show only those values into the gridview which is select from the dropdown. for example if i have the following values in to the database: value item …  |
| | Why do I get the following error? and How to fix? Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in/home/gaogier/public_html/pages/monsters.php on line 217 If i add the or die part, I get this message. You have an error in your SQL syntax; check the manual that corresponds … |
 | Hey there, I need help with a query. The typical situation is like this: I expect, say, 1000 rows out of a query that is based, say, on lastName column. One column is, say, firstName. I know I only have like twenty unique names that occur on multiple rows. I … |
 | Hello Community, Is there a website that has a database like phpmyadmin that i can access from my website? Please help... |
| | Dear all, I would really appreciate your help and assistance with a bug i'm facing in myphpadmin Mysql table. I have a table which is named as total amount. I also have a front end php. interface where i do my data entry from. When I enter for example (100000) … |
| | I have the following code which is intended to supply the family and given names of people who are in the users table but not in the quiz table. Can I even do this, and this throws an error anyway? `$query = mysql_query("SELECT quiz.userGroup AS q_userGroup, quiz.userDate, users.userGroup AS u_userGroup, … |
| | Dear all, I would really appreciate your help and assistance with a bug i'm facing in myphpadmin Mysql table. I have a table which is named as total amount. I also have a front end php. interface where i do my data entry from. When I enter for example (100000) …  |
| | I have a table in a database that contains two columns username and bids.I want to select the unique and lowest value from the bids column.I tried using SELECT DISTINCT and then limiting with one,it shows the lowest value but the value is repeated a number of times in the … |
 | Hi, I have following code. Dim myData1 As MySqlDataReader Dim sqlquary1 = "INSERT INTO table1 (text1) Values (Value1); INSERT INTO table2 (text2) Values (Value2); INSERT INTO table3 (text3) Values (Value3)" Dim command1 As New MySqlCommand command1.Connection = mySqlConnection command1.CommandText = sqlquary1 myData1 = command1.ExecuteReader mySqlConnection.Close() I need to send few …  |
The End.