Ok, all I am new to PHP & MySQL. (please don't let this scare you off)
I had my site hosted with Gisol.com and due to their very poor service and
tech support I left them for Lunarpages.com who so far have a better service
and their tech support is excellent!! But my pages won't pass variables any
more.
When I started I purchased two books MySQL and PHP & MySQL both published by
O'Riely. So far the are excellent help and instructors. I wote some pages
where I track users and their characters from an on-line game called World
of Warcraft.
On the Gisol server they were working EXCELLENT!!
Once I moved to Lunarpages, the pages load ok but they don't pass the
variables from one page to another.
The below code queries the db and list's the user's in a table, and has a
hyperlink to the right of each, on Gisol I could click the link and it would
load the view_char.php page and it listed their character and the info i
needed, and gave options to delete and edit. Again it was working
beautifully.
VIEW USERS PAGE CODE:
$sql="SELECT f_name, l_name, char_id, char_name, char_level FROM t_char,
t_users where t_users.user_id = t_char.user_link ORDER BY char_name ASC";
mysql_select_db($db_select,$db);
$result = mysql_query($sql,$db);
echo "<TABLE border=2>";
echo"<TR><TD><B>Character Name</B><TD><B>Character
Level</B><TD><B>Owner</B></TR>";
while ($myrow = mysql_fetch_array($result))
{
echo
"<TR><TD>".$myrow["char_name"]."<TD>".$myrow["char_level"]."<TD>".$myrow["f_name"]."
".$myrow["l_name"];
echo "<TD><A href=\"view_char.php?charid=".$myrow["char_id"]."\">View</A>";
}
//$charid="[.$myrow["char_id"].]"; <----- I tried this line with no success.
Possibly have it in the wrong place??
echo"</TABLE>";
VIEW_CHAR PAGE CODE
$sql = "SELECT * FROM `t_char` WHERE `t_char`.`char_id` = '$charid'"; <--
now all this does is produce a blank page... used to work great!
//$sql = "SELECT * FROM `t_char` WHERE `t_char`.`char_id` = '21'"; <----- i
used this code to test the page w/o the $charid string and it works FINE!!
$result=mysql_query( $sql );
if (!$result)
{
die("Could not query the database: <br />".mysql_error());
}
I wrote a help ticket to Lunarpages where I am now hosted and asked them to
set the register_globals to ON thinking this was the problem based on what
I've read and the wrote back and told me that they use suPHP to parse php
files and I have the option of using custom php.ini files. That I could
create a .htaccess file or put individual php.ini files in the folder that
contains the files im running. In other words do it myself.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
