Jump to content

dynamic text using php and mysql


joepro0000

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;

?>



Link to comment
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]
Link to comment
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;
}

?>
Link to comment
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.
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.