Portal Home > Knowledgebase > Articles Database > using php do display database
using php do display database
| Posted by bumpn, 10-23-2012, 05:35 PM |
| i50(dot)tinypic(dot)com/ea332q(dot)jpg
now lets say I wanted to display info from column 8, row5
in a div. How would I go about doing that? I know its php but im stuck. I want to create divs I have the connect done, I just need to figure out how to get and and dispaly data from the database
Last edited by bumpn; 10-23-2012 at 05:45 PM.
|
| Posted by zoid, 10-23-2012, 05:39 PM |
| http://lmgtfy.com/?q=select+in+php
|
| Posted by bumpn, 10-23-2012, 05:57 PM |
| yes that tells me how to pull from a column but not a row. how do you tell the php which row to pull from in that column
|
| Posted by zoid, 10-23-2012, 05:58 PM |
| where clause in your select statement
http://www.w3schools.com/sql/sql_intro.asp
|
| Posted by Herasil, 10-24-2012, 08:50 AM |
| This page tells you how to query a MySQL database and then display the information in PHP: http://www.w3schools.com/php/php_mysql_select.asp
Modify your query as necessary using a WHERE clause to restrict the number of rows.
|
| Posted by KMyers, 10-24-2012, 09:56 AM |
| It would look something like
$query = "SELECT * FROM `table_name` WHERE `row` = '12'";
Of course this would require that you are indexing the rows.
|
| Posted by bumpn, 10-24-2012, 12:19 PM |
| my data base looks like this
its ordered ascending by NO#
and col2 is the start of the database NO# is basically invisible and only used as a reference as to row number
so lets say I wanted to display on a web page the text in col8, row 5. What would the php code be?
Last edited by bumpn; 10-24-2012 at 12:23 PM.
|
| Posted by KMyers, 10-24-2012, 12:21 PM |
| Then a sample query would look like
$query = "SELECT * FROM `table_name` WHERE `NO#` = '5'";
And a simple while loop to set the output to a variable.
|
| Posted by Herasil, 10-24-2012, 12:28 PM |
| Expanding from KMyers' reply:
$query = "SELECT * FROM `table_name` WHERE `NO#` = '5'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$col8 = $row['col8'];
The Variable $col8 would then contain "2012".
|
| Posted by zoid, 10-24-2012, 12:45 PM |
| I posted two links answering exactly these question and other posters mentioned similar urls. It really shouldnt be too difficult now.
|
| Posted by bumpn, 10-24-2012, 05:06 PM |
| wow so simple
|
| Posted by KMyers, 10-24-2012, 05:09 PM |
| Yup, you can also do it like.
|
Add to Favourites 
Print this Article
Also Read
Shared Hosting
Shared Hosting
