define variable by querying MySQL
| From: | Matt Nigh | Date: | Sun, 01 Jul 2001 21:55:15 +0000 |
| Subject: | define variable by querying MySQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-10001@lists.php.net to get a copy of this message | ||
hello list. i have a problem that is relatively simple, but I can't seem to figure it out.
is there any way to define a variable by querying a MySQL database?
here's an example of code I tried using:
----------------------------------------------------------------
<?
$WELCOME = "
echo "<?php
$link = mysql_connect("localhost","username","password");
if(!$link) die ("Could not connect to MySQL!");
mysql_select_db("database",$link);
$result = mysql_query("select * from table_name);
$num=mysql_numrows($result);
for($x=0;$x<$num;$x++) {
$row=mysql_fetch_object($result);
print "$row->my_name";
}
mysql_close($link);
?>
";
";
?>
<? echo($WELCOME); ?>
----------------------------------------------------------------
it kept coming up with the following :
----------------------------------------------------------------
Parse error: parse error, expecting
T_STRING' or T_VARIABLE' or
`T_NUM_STRING' in c:\apache group\apache\htdocs\page.php on line 5
----------------------------------------------------------------
i can't figure out what to do, so if anyone can assist me, i'd be greatful. I have a
feeling it's something with some quotes but i can't figure out which ones.
Thanks a lot,
Matt Nigh
matt@mattnigh.com