10,940 Topics
 | |
| | hello! i want to know about maximum mysql strength, that how many users can login and use database at same time. waht is the maximum size of table and maximu rows in table. what are the security risks and how can i overcome on security risks. and how can i … |
| | Hi I'm getting **mysql_fetch_array() expects parameter 1 to be resource, boolean**, I check the white space and maybe some can tell me what I did so I can corrrect the mistake. Thanks <?php session_start(); header("Cache-control: private"); require_once ('../include/init.php'); include_once("../ckeditor/ckeditor.php");?> $page = $_GET['page']; $sqlcats="SELECT * FROM pages WHERE pagename = '".$page."'"; … |
| | How would I go about importing several CSV files into a single table? Any advice is greatly appreciated! |
 | Hello, if you can help with a query about coursework here the condition Requirements: The base is WordPress. The aim is to survey. Each user registers and selects names of courses they want to attend. Explore the structure! A. For each course, how many people have written? 2. For each …  |
| | I need to select a value on a MYSQL table using PHP. Basically I have PDATE column (which I need to make sure it's today's date) then STKNO column (if the value there is 11, then it's Price Index and if the value there is 10 then it's Weighted Index). … |
| | I am trying to build a query that will display the Amount of people that signed up in a certain month. I am adding the date_time to the database at the time someone signs up for a course. I want to display the months and total sign-ups for the month. …  |
| | Hi all, I'm hoping someone here might be able to give me some advice. My current client has hired me to create a product importer for their shopping cart. The problem I am having is that there is a total of 7,154 products which need to be inserted into the … |
| | Hello, I am familiar with PHP and MySQL and teaching myself how to create a login script, I am not sure if I am simple missing something or something is worong with the code. I am able to signup a user and submit the data to the MySQL table, It … |
| | I know this is a simple quetsion but I am stuck. I need to create a view that displays the discount house price by 5%. CREATE VIEW v_hou_discount AS SELECT hou_price - (hou_price * '.05') as '5% Discount Price' from house; What am I doing wrong?  |
| | Never had this problem before, and i am not sure how this happened. I got a Mysql sql database for my project. The id field is set as auto increment, which seems to function correctly. But on the form in my text field and datagrid i see a negative number, …  |
| | long blob size is way too small for me. how can i make it bigger??? i want thing when i making col image. i can set Attributes to or lenth/value? but i dont know what to type in help plz  |
 | hi, i posted this in the javascript forums but didn't get any replies, maybe this is a better place. i have a website for properties (rent, sell, etc), using php and mysql. i allow the admin to manage existing properties by selecting the property id from a dropdown that lists … |
 | i m working on a linux server and my part of the code is this- $post = mysql_real_escape_string($_POST['post']); echo $post; but my $post variable is not getting printed. and when i print $post variable without using mysql_real_escape_string function ,it is working. i.e. echo $post; its a weird problem . can …  |
| | Good evening I'm running a tipping competition, and am hoping to make the updating slightly less tedious. The code currently reads as follows: <?php $query = " SELECT SUM(comptipsterselections.profit) as Profit, comptipsterselections.stable, comptipsterboard.link FROM comptipsterselections INNER JOIN comptipsterboard ON comptipsterselections.stable=comptipsterboard.stable WHERE comptipsterselections.comp = 'aintree 2010' GROUP BY comptipsterselections.stable, comptipsterboard.link ORDER … |
| | Hi I keep getting Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in and dont know how to fix. I have 1 table and need to display two colums awnser here is the code can any one olease point me in the right direction. <?php $result = mysql_query("SELECT … |
| | I'm trying to do a query that if mike isn't in the three highest bids for a keyword, then select the row(row that has been outbid). I tried below but i get no results, i should get rows with id 4 and 7. btw a keyword can be bidded on …  |
| | PHP, MySQL & ajax with data on default page default page is empty when page first load. how can i show data on default page? i mean when page first load i want to show all data then do the ajax after user select to filter Example is based off … |
| | I would like to alter the example provided [URL="http://www.w3schools.com/php/php_ajax_database.asp"]here [/URL]so that there is a second dropdown input for 'Male/Female'. I know the example itself does not provide a 'Sex' field in the MySQL db, but let's just pretend it does. Furthermore, assume we have a new in out select for … |
| | Hello guys, I tought this is simple at a very 1st place... but I didn't manage to do it .. Anyone of you can give me an idea on how to do this... I've created a web apps that required authentication. and yeah ... oh the user setting section I …  |
| | Hi There; I am learning how to establish a connection to mysql in c#. Here are my codes : using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using MySql.Data.MySqlClient; public partial class _06_web_form_elemanlari_08_button : System.Web.UI.Page { protected void connect(Object Sender, CommandEventArgs arguman) { try { MySqlConnection … |
| | Hi, I have table (MyIsam) and want to set an index but fail to do so. Field : Varchar(10) Not Null Index Type : Unique Index Method : Hash Everytime I try, index method automatically assigned as BTree. Is this combination wrong for setting an index defined above? Thanks |
 | Hi, I am designing a system wherein a student can search projects based on technology, project type, location etc etc. The search form goes like this :- Project Type - HTML Select Option - Example:- Automobile, Manufacturing, Marketing, Communication Technology - Text Input Type - Example:- HTML, CSS, Java Starting … |
| | okay.... I have been trying this stuff for a couple days and I think I have completely lost my way. I am trying to read data from an excel and import it into a MySQL DB. When I fetch the data from the cell, this is what I get.. >>> … |
| | Guys, I having problem converting the sql server function to mysql function. It work perfect at sql server now it now working at mysql. Please help.Thanks delimiter $$ CREATE FUNCTION SortingAlphanumeric(ColValue NVARCHAR(255)) RETURNS NVARCHAR(1000) BEGIN DECLARE p1 NVARCHAR(255); DECLARE p2 NVARCHAR(255); DECLARE p3 NVARCHAR(255); DECLARE p4 NVARCHAR(255); DECLARE Index1 TINYINT; … |
| | Ok, I'm developing a chat bot for a client. But I'm having a hard time figuring out the best way to do this. Because the bot isn't that big, I thought use a table with the phrase and the response. Then use LIKE. Not as easy as I thought though. … |
| | I am currently working on a simple survey system for educational purposes. I know it is subject to SQL Injection, but I am new to PHP/MySQL and wanted to learn something basic so I have something to build upon later. Basically, I have an HTML form that processes the PHP … |
| | Hi, hindi kruti 13 font is not working in form. I also installed again but getting same result. Need advice |
| | ``this code keeps kicking out the error Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/a2595218/public_html/login.php on line 49 with the out-put " The username you enterted was not found " I should be seeing the error " You must active your acount to play. $form";" … |
| | Is there a way to use Order by RAND() for a query so that it returns a list of results and guarantees that adjacent values will be at least 'x' from each other, on either side? The results are all numbers, no strings. So if it returns 5 results r1 … |
| | Hi, I have two tables and they have one to many relationship.The two tables are fares and fare preferences.Now in fares table there is a unique user id and username and the user id is related to multiple preferences.Now I want to make a query that displays the username once … |
The End.