brady.k — Thu, 11 Sep 2003 00:29:50 +0000

no i didn't...lol

i thought since i included the $ tags inside the print(' ') (which i had the whole table inside) that it would automatically interpret, since i didn't use the "amperstand" symbol for the dollar sign ($).

thanks for dealing with me. lol.

Mark Hensler — Wed, 10 Sep 2003 08:01:15 +0000

Quote: Originally posted by nike_guy_man
<?= means open, then echo, right? [/B]

Ya, that's one of the ideas they stole from ASP.

nike_guy_man — Wed, 10 Sep 2003 02:58:19 +0000

Uhm... you know you have to open a PHP tag before it'll print that instead of $may29morn1 right?
It has to be either

<?php
echo $may29morn1;
?>

or the much easier
<?=$may29morn1 ?>
<?= means open, then echo, right?

brady.k — Wed, 10 Sep 2003 02:10:14 +0000

http://guards.dscpool.com is the basic idea, not the finalized design, but the basic idea/premise

the php file that is includes-ed is as follows:

<?php
$connect= mysql_connect (\"localhost\", \"...\", \"...\") or die ('Database failure: ' . mysql_error($dbh));
mysql_select_db (\"...\");
$get=mysql_query(\"SELECT * FROM may\");
if ($get) {
$info=mysql_fetch_assoc($get);
}
else {
echo \"Error:\" . mysql_error();
}
mysql_close($connect);
?>

nike_guy_man — Tue, 09 Sep 2003 23:31:22 +0000

This is direct from one of my pages

<?php
## Connection info ##
$query = \"SELECT * FROM users \";
$result = mysql_query($query);
if ($result) {
$row = mysql_fetch_assoc($result);
} else {
echo \"Error \" . mysql_error();
}
echo \"$row[name]\";
mysql_close();
?>

I have no idea where I came up with the variables query result and row... i've been doing it that way for 3 years now...
A link and a .phps file would be nice so we could see what you are doing... put the dbase connection info on another page and include it so we don't see that....

brady.k — Tue, 09 Sep 2003 01:47:10 +0000

lol...i'd have to say it still doesn't work.

i removed "set" and i changed all the "table fields" to the corressponding values. i have tried two ways:
#1- just having the file name .php and the only php inside it is the includes and echo (so, its

<?php
 include...echo  
?>

)

#2- having

<?php
 start after the body tag, the code (includes and echos), then having a print ('<table....');
?>

neither works. i also tried adding $ to the echo statement in front of the table field ($info[$may29morn1])...i'm not getting any error statements either...argh gagagagagah (Popeye quote...lol)

nike_guy_man — Sun, 07 Sep 2003 15:52:22 +0000

Idiot mistake #2: remove "SET"
Table field is the name of the table field... in tihs case, $info[may29morn1]

brady.k — Sun, 07 Sep 2003 15:18:59 +0000

ok i've got a question...what do you mean by "table field"? when run the script saying "table field" (even though i know thats not what it should say), I get an error that says I should look for the proper syntax near "SET" and "table field". thanks

nike_guy_man — Sun, 07 Sep 2003 02:24:42 +0000

Sigh... i'm an idiot
Move the mysql_close(); to the end of the loop

nike_guy_man — Sun, 07 Sep 2003 02:23:59 +0000

Well for one thing you aren't executing the $get, so that's why
Just do it like this:

<?php
PHP
$connect= mysql_connect (\"localhost\", \"...\", \"...\") or die ('Database failure: ' . mysql_error($dbh));
mysql_select_db (\"...\");
$get=mysql_query(\"SELECT * FROM may SET \");
if ($get) {
$info = mysql_fetch_assoc($get);
mysql_close;
} else {
echo \"error \" . mysql_error();
}

**other page**

include('otherpage.php');
echo \"$info[table field]\";
?>

That's how I do it....