Jump to content

Archived

This topic is now archived and is closed to further replies.

joepro0000

dynamic text using php and mysql

Recommended Posts

I want to pull info out mysql and put it on a php page, but I keep getting errors. heres the script I got.



<?php
// this line connects to database
include_once("connections/connections.php");

$result = mysql_query("SELECT sample, Category FROM category");
// we use the names of columns as <row> properties.
echo "colors=";
while ($row=mysql_fetch_array($result)
$line = $row[C].'.';
echo $line;

?>



Share this post


Link to post
Share on other sites
What errors? MySQL errors?

Share this post


Link to post
Share on other sites
[!--quoteo(post=365374:date=Apr 16 2006, 08:24 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Apr 16 2006, 08:24 PM) [snapback]365374[/snapback][/div][div class=\'quotemain\'][!--quotec--]
What errors? MySQL errors?
[/quote]
is it your php syntax by any chance?..

try
[code]
while($row = mysql_fetch_array($result))
{
$line = $row[c];
echo $line;
}
[/code]

Share this post


Link to post
Share on other sites
[!--quoteo(post=365374:date=Apr 16 2006, 03:24 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Apr 16 2006, 03:24 PM) [snapback]365374[/snapback][/div][div class=\'quotemain\'][!--quotec--]
What errors? MySQL errors?
[/quote]


>> Parse error: parse error, unexpected T_VARIABLE in /home/content/j/o/e/joepro0000/html/display.php on line 3<<

My code is-

<? php
// Vars - fill these in
$address = "localhost"; // The address of your database server. Leave as "localhost" if it's on the same machine, otherwise put the IP or domain name of the machine it's on.
$username = "Username"; // MySQL username
$password = "Password"; // MySQL password
$db = "joepro0000"; // The database to use
$table = "Category"; // The table your data is in


// Connect to the server
$conn = mysql_connect($address, $username, $password);
// Select database
$rs = mysql_select_db($db, $conn);
while($row = mysql_fetch_array($result))
{
$line = $row[c];
echo $line;
}

?>

Share this post


Link to post
Share on other sites
First, that's definitely a PHP error -- are you sure you can use barewords for hash keys? And which line is 3?

Share this post


Link to post
Share on other sites
First, that's definitely a PHP error -- are you sure you can use barewords for hash keys? And which line is 3?<<

not sure about barewords, I'm a php newbie.

I just want content drawn out my mysql table/database and be placed on a php page. I want to make dynamic text.

Share this post


Link to post
Share on other sites
I understand -- is the "c" a column name? Where does it come from?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.