10,939 Topics

Member Avatar for
Member Avatar for showman13

Hi, I have been searching for a couple of days now for a resolution to this issue, and while I find a few references to it in google, nothing really defines the entire process. I have a MySql table called 'product_distribution' When a customer orders a product, all pertinent information …

Member Avatar for showman13
0
1K
Member Avatar for ichinpogs1

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 = …

Member Avatar for ruby21
0
308
Member Avatar for teedoff

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 …

Member Avatar for rch1231
0
2K
Member Avatar for phplover

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. …

Member Avatar for phplover
0
154
Member Avatar for gcarvalho

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 …

Member Avatar for diafol
0
448
Member Avatar for Red_Rain

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 …

Member Avatar for simplypixie
0
260
Member Avatar for RazorRamon

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 …

Member Avatar for pritaeas
0
115
Member Avatar for vinay.tmr
Member Avatar for jwenting
-1
2K
Member Avatar for kgizo

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 …

Member Avatar for kgizo
0
116
Member Avatar for joy39

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 …

Member Avatar for StephNicolaou
0
88
Member Avatar for divsok

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 …

Member Avatar for StephNicolaou
0
121
Member Avatar for swebdizajn

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 …

Member Avatar for hericles
0
958
Member Avatar for algeriano

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'; …

Member Avatar for algeriano
0
323
Member Avatar for Wolxhound90

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 …

Member Avatar for Wolxhound90
0
188
Member Avatar for richaell

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 …

Member Avatar for mikulucky
-1
230
Member Avatar for Wolxhound90

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 …

Member Avatar for Wolxhound90
0
251
Member Avatar for Behi Jon

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 ...

Member Avatar for mikulucky
0
220
Member Avatar for bflack

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); ?> …

Member Avatar for bflack
0
147
Member Avatar for chuck_dezmond

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 …

Member Avatar for chuck_dezmond
0
111
Member Avatar for intelgy

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 …

Member Avatar for HasNor
-1
173
Member Avatar for richaell

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 …

Member Avatar for richaell
0
111
Member Avatar for tuse

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 …

Member Avatar for pritaeas
0
252
Member Avatar for felix001

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 …

0
73
Member Avatar for rotten69

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) …

Member Avatar for rotten69
0
160
Member Avatar for sidra 100

i want to increase the size of the column [CODE]ALTER TABLE employee ALTER COLUMN department_name VARCHAR(50)[/CODE]

Member Avatar for pritaeas
0
85
Member Avatar for sidra 100

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)) …

Member Avatar for pritaeas
0
88
Member Avatar for bflack

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 …

Member Avatar for bflack
0
206
Member Avatar for rotten69

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 …

Member Avatar for rotten69
0
170
Member Avatar for kgizo

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 …

Member Avatar for kgizo
0
156
Member Avatar for RazorRamon

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)"; …

Member Avatar for pritaeas
0
93

The End.