11,093 Topics
 | |
| | Hi sir pls help i have an error in line 13 .. and still i don't no where can i find this error... Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\wamp\www\login.php on line 13 [CODE]<?php $username = $_POST['username']; $password = $_POST['password']; if ($username&&$password) { $connect = … |
| | Just curious, and well hoping to save myself months of time..lol I've seen databases online already set up to purchase. I know a little about databases...very little, and could probably wing my way through creating a database for car lighting applications for the last 100 years, but thought there might …  |
| | Hello, I am going to be building a blog and have rattled my brains out on this but could someone please explain in much detail as possible how i would go about building a blog archive ? I don't mean i want the php code just the logic behind it. … |
| | Hey, DaniWeb friends! I've a problem with my login.php: When an error occurred, the [CODE]mysql_error();[/CODE] doesn't appear the error. Tested the [CODE]mysql_errno()[/CODE] also, it appears as 0, saying it doesn't have any errors. Take a look at the script: [CODE] <?php $username = $_POST['username']; $pass = $_POST['password']; require "conf/connection.php"; require … |
 | All, Im guessing this is going to be easy for any one to answer bc im such a fucking noob but here goes. I have mysql fields set to DATETIME and i just want to pull out that data and have it display in my form. And i would also …  |
| | Ok i have a lot of tables that are created when a user inputs information. Some info gets stored in a "Main" table while the majority is saved in its own self created table. I do not know the number of "topics" in Main table. so in way i'm trying …  |
| | i want to Read DATA From A text file and save it in database and print the logs by using JAVA.? PLSSSSS HELP....  |
| | Hello, I would love to display the values of 65 columns which have been added and then display them on the screen, at the moment only 59 of the 65 columns added appear. here is my code. $result = mysql_query("SELECT SUM(segment) AS segment, SUM(funct) AS funct,SUM(pronoun) AS pronoun.............. right up … |
| | i have to write a c program which connects with the mysql database. i have installed visual studio c++ express 2010 and the mysql installer for windows. i have widows xp os. can anyone tell me the step by step process to connect to the mysql database. and give me … |
| | create table Course ( courseId char(5), subjectId char(4) not null, courseNumber integer, title varchar(50) not null, numOfCredits integer, primary key (courseId) ); create table Student ( ssn char(9), firstName varchar(25), mi char(1), lastName varchar(25), birthDate date, street varchar(25), phone char(11), zipCode char(5), deptId char(4), primary key (ssn) ); create table … |
| | I have a problem at login to the site: Constantly message appears: Deprecated: Function mysql_db_query() is deprecated in /home/vebsajt/public_html/hosting/config/functions.php on line 53 Deprecated: mysql_db_query() [function.mysql-db-query]: This function is deprecated; use mysql_query() instead in /home/vebsajt/public_html/hosting/config/functions.php on line 53 the file in line 53 functions is: $check_login = mysql_db_query($db, "SELECT * FROM …  |
| | Hello, can anyone help me on this when i try to hit an invalid link to my site it gives me this : [B]Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/nadia/public_html/showarticle.php on line 39[/B] here's my showarticle.php [CODE]<?php require_once ("includes/config.php"); require_once ("includes/functions.php"); $script_name = 'showarticle'; … |
| | Hey guys, So, I have a CheckedListBox that will be used to choose what columns they want to select from a database. Is it at all possible to display it in the format of [Table Name].[Column Name]? So far I have this: [CODE]con.Open() theQuery.Connection = con theQuery.CommandText = strColumns theAdapter.SelectCommand … |
| | Hey again, posted the same code but seems like no one really answered, solved most erros alone, but still need help. What shows up on localhost: Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\Projeto\all.php on line 71 Showing 1 - 0 results from the total of …  |
| | Hey all, Apologies for this question, as I imagine it will be very easy. I'm creating a form that will be used to update fields in a table. I don't want the user to be able to update primary keys though, so I'm trying to disable the textbox so it … |
 | Hi, How could I find a sample web application with php for a database in mysql ? I just don't know how it will look like ! thanks in advance ... |
| | Hello guys, [CODE] <?php include 'dbconnect.php'; echo 'under profile.php'; $username=$_SESSION['username']; //I think i have to put a query here like "SELECT username FROM accntinfos WHERE username='$username'". But confused since if I do there would be two queries $query="SELECT userprofile.profpic FROM userprofile INNER JOIN accntinfos ON accntinfos.accntnum=userprofile.accntnum"; $result=mysql_query($query, $DBconnect); $numrows=mysql_num_rows($result); ?> … |
| | Hi everyone, im just new in php and mysql. I have a form where i add list of member details then submit it to my db and redirect it back to the same page and echo the the list of data at the bottom. but the problem is after redirect … |
| | Hello everyone, I'm working on adding checkboxes to the edit_profile section where members should be able choose with checkboxes the multiple options of massage techniques offered... When I checked only one, either, option 1, or option 2 or option 3 I'm able to see it in the column in the … |
| | I keeep getting this error: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\Projeto\search.php on line 7 How do I fix? [CODE] if (isset($_POST['action']) == 'Search') { $search = $_POST['search']; require 'conf/connection.php'; $selection = mysql_query("SELECT * FROM users WHERE name '%$search%'"); $number = mysql_num_rows(mysql_query("SELECT * FROM users WHERE … |
 | Hi all! I am trying to connect to a remote MySQL database in a VB.NET application. This database is located on my LAN at the address 192.168.1.2. I am using MySQL Connector/ODBC 3.51 (MyODBC 3.51) for the connection. The connection string that I am using is the following- Driver={MySQL ODBC … |
| | Ive been developing a new website for the last few months. Initalling I configured all my databases to use the root account. Now I need to change all the passwords along with changing the web UI login. Ive tried changing the password for root within the gui but it doesnt … |
 | I'm trying to make a table and mysql is giving me this error: [QUOTE] #1005 - Can't create table 'likes.users' (errno: 150) [/QUOTE] That would be great to see a website that explains mysql errors like this for oracle [url]http://ora-code.com/[/url] [CODE] CREATE TABLE IF NOT EXISTS `users` ( `user_id` int(2) … |
| | i want to increase the size of the column [CODE]ALTER TABLE employee ALTER COLUMN department_name VARCHAR(50)[/CODE] |
| | hey m making a projec in one of its page i want to get the data from the table and display it on screen in the form of table. allthough the data appears but how can i display the headings. [CODE] $num=mysql_num_rows($result); print "<table width=600 border=1>\n"; while ($get_info = mysql_fetch_row($result)) … |
| | Hey guys, Can you all help and teach me how to retrieve image file which is stored on database?.. I had an image stored on database in the column i called 'profpic'. By the way, I am needing this information for profile picture on a users page. I've started testing … |
| | Hi everyone, I have created tables and deleted some rows and then inserted new rows. The IDs of the later created rows didn't start at 0 or 1. I dropped my entire database then recreated the same one with the same tables and fields. Unfortunately, newly entered rows started from … |
| | Hi I need to represent data from my mysql table into a graphical format. I summed all the columns I needed then I need to represent the addition of each individual column onto a graph, but I want to print the correct data onto my screen first then represent the … |
| | I have a variable [ICODE]$topic = $POST_['topic'][/ICODE] that is entered by the user, it can possibly have spaces. I want to create a table based on this variable. Right now the code creates the table but only uses the first word. [CODE] $create="Create TABLE $topic (I know this part works)"; … |
| | i am starting to learn to connect a cprogram to a mysql database. i have got this elementary program to connect to server , create a database and disconnect from it. [code]#include <stdio.h> #include<windows.h> #include <mysql.h> static char *opt_host_name = NULL; /* server host (default=localhost) */ static char *opt_user_name =NULL; … |
| | i had a database with 4 column and each column has a value, below are the sample. ---------------------- col1-col2-col3-col4 -- 1------4-----7--------- 5------3----------10--- 6------------5----12--- my question is how can i get the lowest value in each row? here's an output that i wanted to get: 1 3 5 and here's my … |
| | I need some help with radio button data and how to code it in PHP to insert the data into MySQL. Here is my [B]Form Code[/B]: [CODE]<form method="post" action="update.php"> First Name: <br /> <input type="text" name="fname" size="35" /><br /> Last Name: <br /> <input type="text" name="lname" size="35" /><br /> Phone … |
| | Hi, I'm doing an app that adds info to a MySQL BD [CODE] Imports MySql.Data.MySqlClient Public Class curso_add Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click OpenFileDialog1.Filter = "Ficheiros de Imagem |*.jpg;*.bmp;*.png;*.gif" OpenFileDialog1.FilterIndex = "2" OpenFileDialog1.Title = "Escolha uma imagem..." OpenFileDialog1.InitialDirectory = "C:\" OpenFileDialog1.ShowDialog() End Sub … |
| | I have a loop that writes out data for franchises. It works the first time through, but not the 2nd. Here is the page where the data is written out: [URL="http://184.172.137.97/~royl21st/1.php"]http://184.172.137.97/~royl21st/1.php[/URL] Here is the code that spits out the wrong data after the first successful loop. Any ideas? [code] $areaCodeData … |
| | Hi all, I haven't changed anything in the config file in phpMyAdmin folder. I don't know why the WAMP server gives me this error. Although everything was working perfectly yesterday. Does anyone know how I can fix this problem? [CODE] You don't have permission to access /phpmyadmin/ on this server. … |
| | hi, I developed one web application and I have created div in JavaScript and on that div I have created more than one images and when I click on save button i want to save all images on to the database and when I retrieve that image from database as …  |
| | Before I really dig in ----- HAPPY NEW YEAR EVERYONE! A few of you may remember that I have been working on producing a large wood knowledge base (woodsoftheworld.org). It is totally none profit. I am getting much closer to having enough working that soon I hope to be able … |
 | Hello fellow daniwebians, I seem to have run into a problem echoing MySQL/HTML and am hoping one of you may be able to point me in the right direction. I'm trying to echo portions of HTML(if there is an event for that date) inside HTML that's not echoed, so it … |
| | I created a foreign key on a table just using this statement. When I wanted to drop it, phpMyAdmin didn't allow me to do so. Would anyone suggest a nice way of getting away with it? [code] ALTER TABLE `likes` ADD CONSTRAINT (fk_user_id) FOREIGN KEY REFERENCES `users` (user_id); [/code] This … |
| | hi everyone, i encounter problem when trying to create a form page to upload images to images folder and imagelocation will store information for the pathname where the image will be located ( will be used for display image in future) the code below does not have any error when … |
 | I am getting an access denied error when I am writing to the database I am using this line [CODE] LOAD DATA INFILE 'upload.txt' REPLACE INTO TABLE Test FIELDS TERMINATED BY ',' [/CODE] I have made sure I allowed remote SQL, and I made sure to give the user all … |
 | Hey, I'm running a mysql query, and would like to run a script if the query returns no results. But what do I use to test for no results? Something like: [PHP] if (!$query) { do this } [/PHP] But just not sure how to implement it. Little help? |
| | hi! another query! i want to insert values into the table 'employee' for the 'adddress' field in such a way that the large address comes in two or three lines like this [code] empid empname address mobile grade basic Joyban1 Joy banerjee 5/67, 1234567890 2000 10000 nehru colony, kolkata 700045 … |
 | I have a very simple wish, to dump all databases so I can lock up a backup of the databases, tables, users and so on. It looked like [CODE]mysqldump -v --all-databases -u root -p secret > "${directory2}""$h"_mysql_dumpall.sql[/CODE] worked, however the file contained a little error message telling me I had … |
 | is it possible to move a database from one machine to another? maybe like copying the tables... |
| | Hi I have a database of information and the code to get that data out of the database based on the url, it will be some like [url]www.website.com/thekooks[/url] and then will display the information in the database for them. The bit I am struggling with is where do I put …  |
| | Hi, I am trying to make a link based on info stored in MySQL, the code I have got so far is [CODE] if (isset($_POST['search_now'])) { $result = mysql_query("SELECT * FROM bands WHERE BandName LIKE '%$BandName%'"); $page = "<a href=\"http://www.website.com/$row['PageName']\">$row['BandName']</a>"; while($row = mysql_fetch_array($result)) { echo 'Band Name: '; echo $row['BandName'] … |
| | i am creating a table employee which looks like this [code]use employeemaster; drop table if exists employee; create table employee ( serial int unsigned NOT NULL auto_increment, empid tinytext NOT NULL , empname varchar(255) NOT NULL, address text NOT NULL mobile bigint unsigned NOT NULL, grade char(2) NOT NULL, basic … |
| | So I'm having this weird issue, where I can do SELECT statements and INSERT statements just fine, but when I do this UPDATE statement, it sorta works. It runs without errors, and even outputs that 1 row is affected. But when I check the MySQL, nothing is updated. I've echo-ed … |
| | I need a tooltip where I can show content dynamically using (Query String [B]demo.php?id=12[/B]; id will change) jQuery, AJAX and MySQL. |
The End.