Calling values from a DBase in to a variable...please help

nomadcelt

I am trying to create a very basic web page content management system.

I intend storing the texts for webpages (not HTML, plain text only) in to a table called 'pricing'.

I have created the table along with 7 fields, each named para_1, para_2,para_3,etc

In to each para_x I have put some of this plain text.

So far so good.

No I want to call this text from the variable in to the webpage concerned.

Using:

$query="SELECT * FROM pricing";
$result=mysql_query($query);

I had hoped that $result would be the text from the file BUT NO. It is 'Resource ID #3'. Having looked this up I am told that in order to actually read the value of this field I must use mysql_fetch_array($result)...not only that but I must use a for..next / while loop if I want more than just one line!

SURELY there is an easier way to call text from a database field?

stevesweetland

nomadcelt wrote:
$query="SELECT * FROM pricing";
$result=mysql_query($query);

I had hoped that $result would be the text from the file BUT NO. It is 'Resource ID #3'.

SURELY there is an easier way to call text from a database field?

you're so close, heres how you do it.

youv created a database result set ($result), and you can use that to get the desired value from the 'FieldName'

do this.

$query="SELECT * FROM pricing";
$result = mysql_query($query);
$myvalue = mysql_result($result,0,"FieldName");

result sets start from row number zero, if you want to read additional rows from that result set, say, in a loop, you could do this.

$query="SELECT * FROM pricing";
$result = mysql_query($query);
for ($row = 0; $row < mysql_num_rows($result); $row++){
  echo mysql_result($result,0,"FieldName")."<br>";
};

this second bit of code will output all the values for the chosen field, with a html line break after each value.

hth

stevesweetland

dont forget to click 'resolved'!

if you would rather use the fetch_array method... then read here.

http://www.w3schools.com/php/php_mysql_select.asp

nomadcelt

thanks for that, I knew I was close but it was when the output was 'ARRAY' that I clicked on.

If $result is an array then it was just a matter of calling the correct row from the array itself, hence:

<?php echo $result['para_1'] ?> where 'para_1' is the fieldname.

a simple for / next loop then fills brings all rows in to $result and then another to 'echo' them.

Thanks for the help. I now have a robust (if very basic) content management system to ship out with websites.

John