Nov 7, 2009
Pages: 1, 2

MySQL Output Database Question

 		free web hosting

Read Latest Entries..: (Post #19) by iGuest on Nov 1 2009, 03:49 PM.
How to display data from a field in mysql table MySQL Output Database Question I'm new in mySQL, I have already a table named 'article' with some field: 'id' int NULL //for article id 'title' varchar 50 //for article title 'content' varchar 10240//for article content 'read' int with default =0 //for record how many times the article viewed How to inserting and outputting data to field 'read' as numeric value? Please help me -reply by Lukenda  ...
read more.
Read the FIRST post of this Topic. - Express your Opinion! Contribute Knowledge :-).

Open Discussion & Free Web Hosting > Computers & Tech > Databases

MySQL Output Database Question

lonebyrd
Apr 22 2006, 02:45 PM
I am new to MySql and have just created a database after using a script. My problem is not the script, but what it says about putting it into the output file. I cant figure out the right terms to put it in, I keep getting errors. I try using; SELECT*FROM 'database name' WHERE 'location' but it isnt working. I'm lost with this stuff, I really am. Can someone please help me out?

Comment/Reply (w/o sign-up)

Houdini
Apr 22 2006, 03:32 PM
I am assuming that you are using a GUI like maybe phpMyAdmin so you want to select all rows from a database name then you have a where clause but nothing for the WHERE clause to work with
QUOTE
SELECT*FROM 'database name' WHERE 'location'
Where location equls what
do not put quotes around the database name or the field name you do put them around values like so
CODE
SELECT * FROM testdatabase WHERE location = '$somevariable'

if you are using php you would use
CODE
$query="SELECT * FROM testdatabase WHERE location = '$somevariable'";// or location ='My Home Town'
$result=mysql_query($query) or die("Could not execute query".mysql_error());
Does that help any?

Comment/Reply (w/o sign-up)

lonebyrd
Apr 22 2006, 03:41 PM
I did what you said and this is what it came up with, no error message, so I'm not sure if I did it right:

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0005 sec)
SQL query:
SELECT *
FROM cscp_mojt_prefs
WHERE 'admin.php'
LIMIT 0 , 30

The cscp... is the database I made and admin.php is where I wanted it to go. Does this look correct to you?

Comment/Reply (w/o sign-up)

coffeemug
Apr 22 2006, 03:46 PM
QUOTE(lonebyrd @ Apr 22 2006, 02:45 PM) *

I am new to MySql and have just created a database after using a script. My problem is not the script, but what it says about putting it into the output file. I cant figure out the right terms to put it in, I keep getting errors. I try using; SELECT*FROM 'database name' WHERE 'location' but it isnt working. I'm lost with this stuff, I really am. Can someone please help me out?


when i look at your post it seems like, you are very very new to mysql right? no offense intended, iam quite new to it too laugh.gif

i thin when you said SELECT*FROM 'database name' WHERE 'location', you are try ing to access the database? correct? because 'database name' is not a parameter of SELECT CLAUSE so is 'location'

if you are trying to access the database use there command
in mysql console command

CODE

use your_database_name;
Select * from your_table_name WHERE link = '$your_search_parameter';


in php
CODE

        $host                =    "your_hostname";
        $user                =    "your_userid";
        $pass                =    "your_password";
        $db                    =    "your_Database_name";
        $connection = mysql_connect($host, $user, $pass) or die ("Unable to connect 1!");
        
        mysql_select_db($db) or die ("Unable to select database!");
        $query    = "Select * from your_table_name WHERE link = '$your_search_parameter'";


there you go ^^

Regards
Coffeemug

 

 

 


Comment/Reply (w/o sign-up)

lonebyrd
Apr 22 2006, 03:53 PM
No, actually I'm trying to get the typed in answers given to the database to go to 'admin.php'. I'm not looking to access the database with that script. And yes I am VERY new to this, no offence taken. What this is, is a login script that I downloaded, so the results from the database need to go to an admin file. But thanks for that info.

Comment/Reply (w/o sign-up)

coffeemug
Apr 22 2006, 03:58 PM
SELECT *
FROM cscp_mojt_prefs
WHERE 'admin.php'
LIMIT 0 , 30

like i said SELECT clause do not use database name as parameter... and why do you need admin.php in where clause?

are you at all familiar with SQL ? or is this your first time using SQL?

may i ask what do you wish to accomplish with those commands?

Comment/Reply (w/o sign-up)

lonebyrd
Apr 22 2006, 10:16 PM
O.K. you caught me, this is my first time using SQL. Anyway, what I was trying to do was make sure the info input into the database named 'csps....' went to the 'admin.php' file. As I said, this is a login script I got, so what it is essentially doing is getting the users name, email, etc..., and that info would go to my admin file to keep track of. Hope that helps.

Comment/Reply (w/o sign-up)

Houdini
Apr 23 2006, 12:59 AM
If you are connected to your database then all you need to do to see all the tables that are in that database,
CODE
SHOW TABLES

If you do have tables that have been created then to see all the rows that are in those tables just do
QUOTE
SELECT * FROM tableName

Comment/Reply (w/o sign-up)

lonebyrd
Apr 23 2006, 03:25 AM
I don't understand why you are telling me to show the database. I'm using a script that has a specific data form that goes with the database I just made that is in the admin.php folder. That is why I want the data in the database to go to the admin.php folder when it is calculated.

Comment/Reply (w/o sign-up)

Quatrux
Apr 23 2006, 03:01 PM
I read all of your problems and still don't really understand what you're trying to do, others I think does not understand too. So I assume You have a database with a table and all the infos for your login script, so you want that people could login by using admin.php ? If so when write a script into it and when you fetch all the stuff, check the pass and user-name and let him login or else show some other page. ??? and admin.php is a file or a folder/directory ? smile.gif

Comment/Reply (w/o sign-up)

Latest Entries

iGuest
Nov 1 2009, 03:49 PM
How to display data from a field in mysql table
MySQL Output Database Question

I'm new in mySQL, I have already a table named 'article' with some field: 'id' int NULL //for article id 'title' varchar 50 //for article title 'content' varchar 10240//for article content 'read' int with default =0 //for record how many times the article viewed How to inserting and outputting data to field 'read' as numeric value? Please help me

-reply by Lukenda

 


Comment/Reply (w/o sign-up)

iGuest
Aug 18 2008, 09:41 PM
Field name does not appear at the php mysql output
MySQL Output Database Question

Hello,

I have installed Apache2Triad in Vista. Created table and a php script to see my table data. Php output shows table data but it does not show the field names !

Could you please help me about this.

Thanks.

Murshed

-question by Murshed

Comment/Reply (w/o sign-up)

vhortex
May 19 2006, 07:11 PM
QUOTE(yordan @ Apr 25 2006, 12:44 AM) *

I'm afraid you are confusing two things.
The info is not stored inside admin.php
the info is stored in a table.
admin.php is the program that puts or retrieves the data from the table.
And the table is in the database.
So, lonebyrd, you have to first understands that you have a database, inside the database you have tables, the date are inside the tables, and the php files are programs allowing to add, remove, display or delete the data which are inside the tables.


hey i got your point, i will post the solution later since i got very custom to using my wrapper in accessing the database. For awhile here is what he needs to do so that all of you can understand.

He wants to select a certain group of data in the database and he wants to display the data to admin.php

what you need to do is to capture the result set and store the values in it using indexes to the result set.

--

"hard to solve simple questions if we have been used to solved complex problems.."
=)



Comment/Reply (w/o sign-up)

CaptainRon
Apr 25 2006, 09:46 PM
see its perfectly logical to believe that admin.php is just some sort of control panel. since the script is a downloaded one, every php developer keeps logical names of their files, and in this case, admin.php is a logical backend access name.

If we could get the source of the script, or incase lonebyrd could post the script somehow, we could infer what the file is trying to do.

Comment/Reply (w/o sign-up)

Houdini
Apr 25 2006, 03:13 AM
CODE
Admin.php is where, according to the script I downloaded, all of the input info was to be stored

It is possible that stored and saved are causing confusion, I think of storing as putting something into the database but saving is what I do with a file. I might edit the file and then save the changes. It might be possible that the admin.php of this script contains the database connection data even though usually it would be in an include file like config.php or db.php possibly something along those lines.

Probably after seeing the code i question it would be easier to determine just what lonebyrd is talking about and be better able to assist in any questions about the script and what it is supposed to be doing.

Comment/Reply (w/o sign-up)

Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.
Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

This textarea will convert to Rich-Text automatically (IE, Firefox, Chrome)

Pages: 1, 2
Similar Topics

Keywords : mysql, output, database, question

  1. Login System
    I want to make a login system using Mysql. I am amateur in these thing (12)
  2. Free Or Opensource Database/schema Browser?
    Alternatives to TOAD or PL/SQL Developer (6)
    I was wondering if there were any alternatives to TOAD or PL/SQL Developer that allows you to browse
    through a database(s), the different schema objects, and perhaps the stored
    procedure/function/packakge editors. One thing I have tried is to the use the Data Tool Plugins set
    for my Eclipse but that brings my machine's performance to crawl. One a further note, I am
    basically looking for Windows environment, with connections to remoate databases.....
  3. Mysql Overhead
    (3)
    Sometimes in a table especially if i do alot of things in it i start seeing overhead then a size
    near it? what is overhead? and is it essential to optimize the table to fix it? I know its just a
    press of a button but i'd like to know what happens when i optimize a table. Also when you make
    a new table you can limit the size of VARCHAR to a number, that number would be the number
    characters allowed in that column per entry. I'd like to know how the limit works for texts, is
    it in KB? or number of characters? Cuz i made a messaging system. And i remember reading s....
  4. How To Understand A Database Schema
    A very nice and simple tutorial (9)
    Yesterday while i'm seaching for a data model and database schema at the Library of Free Data
    Models for a new project of a friend of mine i found there this nice and simple tutorial on How to
    Understand a Database Schema . As its name says, this tutorial will help you to better understand a
    Database Schema and covers the following basics topics that every Database Schema must define:
    QUOTE Primary and Foreign Keys. One-to-Many and Many-to-Many Relationships. Inheritance.
    "Rabbit's Ears", (Recursive relationships). The Scope of this tutorial is ....
  5. Best Database
    (16)
    What is the best free database if some one trying built a social networking website? And how to
    operate it with dreamweaver 8?....
  6. Some Useful Database Links.
    (7)
    I thought I would take a moment to point the users here to some of the database resources available
    for reference and learning. First I will start with actually designing the database. This site by
    R937 covers the basics of database design. The author is professional database guru and a frequent
    helper at the at DB forums listed below. The Library of Free Data Models is an excellent
    resource for finding data models for projects you may have or as examples of well put together data
    models. With around 500 data models the chances are you find something at least cl....
  7. Mysql Multiple Tables
    (3)
    It is good practice to use multiple tables to sort out big amounts of data. But once you do that it
    becomes increasingly hard to cross reference the tables. Mysql has a little beautiful command
    structure that they have added. You can select multiple tables within one sql query. Example of a
    basic sql query CODE $sql = "SELECT * FROM table WHERE row=1"; If you noticed that I selected
    all of the rows in the table. Normally you will try to not select the entire table from the database
    unless you absolutely want all of the table. I would recommend against it; just gra....
  8. Any Website Provide Free Host Mysql Host?
    (4)
    any website provide free host mysql host? i need it because i am using 000webhost.com now but it
    only provide 2 mysql database... can i know where or how can i get more databases regards....
  9. Database Access On Remote Server W/jsp
    (2)
    Hello: I am new to JAVA and server-side applications and have a dumb question. I have set up
    Tomcat on my machine and created a JSP program to query an Access database using a DSN-Less
    connection. If I publish the page to a webserver and include the .MDB file will it work? I'm
    not sure exactly what needs to be packaged with my Java application to make it work. Since I
    don't have a remote server that supports .jsp I cannot really test it. I'm assuming that
    JDBC driver would be bundled with my site but not sure. Thanks!....
  10. Space Needed For Database
    (10)
    Iam assuming the information in the databases i will create will be stored in the 500 MB space i
    get, but since 500MB isn't enough iam wondering if you guys can tell me how much bytes the
    following take: Varchar(x),Tinyint,Text,date,smallint,mediumint,bigint,float.... And the rest
    present when you add/edit a row in a table. Also what are the ranges of tinyint,smallint,mediumint
    and big int....
  11. Mysql On Computer
    XD (9)
    I posted PHP on computer? , but for some reason it doesn't show :/. Anyways I am wondering if
    there is MYSQL on my computer, meaning can i make a data base on my computer? that way i make what i
    want and upload it when i get hosted =)....
  12. Mysql Database Entry By Excel Sheets
    (2)
    Hello .. I would like to ask if i can use use Microsoft excel files in order to make entries to
    mysql database. Thanks....
  13. Mysql Database Management
    (1)
    Hi i am new, I have a problem in understanding the query decomposition in D-DB. Can anyone help me
    to understand the first question of the exercise 25.21 of Elmasri-Navath 4th edition? Consider the
    following relations: BOOKS (Book#, Primary_author, Topic, Total_stock, $price) BOOKSTORE (Store#,
    City, State, Zip, Inventory_value) STOCK (Store#, Book#, Qty) Consider a distributed database for a
    bookstore chain called National Books with 3 sites called EAST, MIDDLE, and WEST. Consider that
    BOOKS are fragmented by $price amounts into: B1:BOOK1:up to $20. B2:BOOK2:from ....
  14. Mysql And User File_priv
    (0)
    HI, I've hit the grain while trying to import file to mysql database - I need to enable file
    permissions of the database user but this seems not possible with most of the hosting providers.
    The problem is to set file_priv of the database user to "Y" . This is done in the "user" table of
    the maintanance database named "mysql". cPanel doesn't allow this. Via the cPanel you can only
    allow privileges on table querries but you cannot grant host file privileges to the database user -
    which makes querries like: "LOAD DATA INFILE 'filename' INTO TABLE tablen....
  15. Accessing Ms Access Database From A Centralized Location?
    (10)
    Hi I am a manager at a trading/wholesaling company (and have no programming background). I
    customized the Northwind sample access database to make invoices and keep accounts for my company.
    We now opening another office at a distant location. So, the order entry will be done at two
    points(we plan to use the same Access database). I am not able to figure out how to access the same
    MS Access database from two different location(as LAN can't be used). Moreover, we can't
    afford to pay huge sums to the software developers. Can intranet or uploading the database t....
  16. Login System Using A Mysql Db
    How do i do this? (5)
    Hi guys, ive got a registration system that looks something like the one below: Firstname:
    Lastname: Then i have inset.php, which looks like the following: $con =
    mysql_connect("localhost","autobot","abc123"); if (!$con) { die('Could not connect: ' .
    mysql_error()); }mysql_select_db("my_db", $con);$sql="INSERT INTO person (username, password) VALUES
    ('$_POST ','$_POST ')";if (!mysql_query($sql,$con)) { die('Error: ' .
    mysql_error()); } echo "1 record added";mysql_close($con) ?> Now my question is, how do i creat....
  17. Mysql And Php
    When trying to install Joomla (16)
    I don't know if this is the correct forum, but here is my question: I'm trying to test
    Joomla and some forums in my computer, I have already installed MySQL with the GUI tools, Apache,
    and PHP with the MySQL and MySQLi extensions, but when I'm trying to install Joomla I get this
    error: Required Settings Check: ------------------------------------- PHP version >= 4.1.0
    Yes - zlib compression support Available - XML support Available - MySQL support
    Unavailable configuration.php Writeable Session save path Unwriteable Not ....
  18. Navcat For MySQL
    is Navcat any good? (9)
    Hello all, i ve recently come across NavCat (GUI tool) for MySQL. I have not bought a copy yet, just
    played around with the demo. Has any one used it beore, if so please let me know if its worth
    buying. I already have PhpMyadmin, Just wanna know if NavCat is better than PhpMyAdmin in usibility
    and functionality. Regards....
  19. Is It A Good Practice To Store Image Or Other Binary Files Directly In A Mysql Database
    (6)
    Hello to all of you beautifull people out there, I am new to MySQL, i just wanted to know if its a
    good practice to directly store images and other binary files in a MySQL database. Any one with
    help? Thanks....
  20. MySQL, Multiple Tables
    (27)
    Ok, I'm coding a project which is a leap than what I'd normally do. Before, I've always
    learned ONE table... put EVERYTHING in one database table. I'm making a profile system so there
    needs to be at least two tables: 1 for users, 1 for content. My problem is, how do I link the two
    together? I could probably figure this out faster if someone explained and posted sample SQL code
    that shows how the two are linked together. Thanks!! F....
  21. MS-database To MySQL
    I'd like to batch them (6)
    Hi, maybe one of you already came across this, so I ask. I'll continue searching on. I've
    got two vocable trainers, one is Windows-native, the other one is on the web. While I can't
    control the output of the Windows-thing (so I can't export them to a *csv or something), I can
    write an import script. But since I'm not that great with Regular Expressions and don't know
    anything about *.mdb (that is MS SQL, isn't it?) files, I would need some finished thing to make
    out the field information and put it in arrays or something more readable. It wou....
  22. What Are The Alternatives To MySQL
    (7)
    Hi. i'm interested in alternatives to MySql combined with php. what database else can i use to
    create a webbased managment system with a lot of entries. maybe more than mysql can handle fast
    enough. it should be more powerful than mysql and should have nearly the same features. i hope
    there is a webbased administration program like phpmysqladmin thanks for your help ! greetings c.....
  23. Mirror My MySQL Database To Another Mysql Server
    (7)
    Hi..I want to ask if its possible to automatically mirror my mysql databases into another mysql
    server?or create a small php script to do this? The reason is because, we all know that database is
    very improtant if we have dynamic website. I have my forum hosted and i want to automatically
    mirror this or backup into another mysql server(free). Like in freesql.org. So that im not afraid
    that i forgot to backup my database..also i have one central backup database. Thanks for the
    help..Im looking forward for this posibility.....
  24. Recover Tables From A MySQL .frm File
    (9)
    I have a couple of .frm files with no corresponding data or index files. Is it possible to recover
    the table structure (field names, types, sizes, rows,col, etc) from these files? The table type is
    innodb....
  25. MySQL Database Problems
    (8)
    My friends have a little forum running here . The problem is that quite often we get the following
    message when we try to open the page: QUOTE Warning: mysql_connect(): Can't connect to
    local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in
    /home/vhosts/rohit.bizhat.com/forums/db/mysql4.php on line 48 Warning: mysql_error(): supplied
    argument is not a valid MySQL-Link resource in /home/vhosts/rohit.bizhat.com/forums/db/mysql4.php on
    line 330 Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in
    /home/vhosts/roh....
  26. Error In Installing MySQL Server
    MySQL server cannot be started (9)
    I try to upgrade my MySQL server from 4.018 to 4.1.10a. Firstly, I downloaded mysql-4.1.10a (not the
    essential one) for win XP Then I install the new version after the old version was uninstalled.
    After the installation process, Instance Configurator comes up to help for the configuration. But an
    error occured when it try to start the MySQL service. Error messageis "cannot create windows
    service for MySQL. Error:0" So my MySQL server cannot be started. It is running win XP on my
    computer. Does anybody can tell me what is wrong?. Thanks (sorry for my bad english)....
  27. How Can I Import Csv Files To My MySQL Database?
    I was able to export but where's import? (3)
    I am having hard times finding that import csv in the mysql phpmyadmin. I once worked on some csv
    files and someone imported it on the mysql server. I was not able to ask him. Does someone know how
    can I import csv files in mysql server?....
  28. MySQL Datetime --> VB.NET Datetime Conversion Prob
    Any solutions ?? (4)
    Hi, Can anyone provide me with a quick example of fetching a MySQL Datetime Field and converting it
    into native VB.NET DateTime format ?? Say for example my db contains a couple of fields: Field1,
    Field2, DateField... one of which is the default MySQL DateTime. Say I'm using the following
    code to connect... CODE ConnectionString = "....." QueryString = "SELECT * FROM SomeTable" Dim
    myConnection As New MySql.Data.MySqlClient.MySqlConnection(ConnectionString) Dim myCommand As New
    MySql.Data.MySqlClient.MySqlCommand(QueryString, myConnection) Dim myReader As MySq....
  29. MySQL Realtime Replication
    how to replicate mysql in realtime (4)
    i dont know if this might be useful to ppl here, but this is a very good knowledge for serious
    siteadmins. while i was digging for mysql backup techniques, i've found that mysql is able to
    do realtime replication. the idea is that there are master server and slave server. both are having
    the same version of mysql installed. the data flows; Master >copy> Slave ( in realtime!)
    you'll never have to manually copy the database file of wasting your time to manually use the
    mysqldump command. here are the links; http://dev.mysql.com/doc/mysql/en/Replication_HOWTO.h....
  30. MySQL - Trouble With Bulk Insert Statements
    (3)
    I'm trying to insert about 500 rows into mysql, but I keep getting errors. If I copy and paste
    too many (about 50) insert statements at a time I get errors sometimes. I sometimes even get errors
    but then the row is skipped so I don't know there was an error (I'm using linux and SSH).
    What's the best way to get my insert statements to put the data in MySQL? Is there anyway that I
    can have it tell me if there where any errors all the statements are executed? Thanks for your
    help.....


      31. Looking for mysql, output, database, question

See Also,

*SIMILAR VIDEOS*
Searching Video's for mysql, output, database, question
advertisement



MySQL Output Database Question

Affordable Web Hosting, Low cost Web Hosting - ComputingHost.com