Thanks, i've just taken a look and i've made the changes advised and I still appear to be receiving php/mysql errors.
For example...
Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/virtual/site3/fst/var/www/html/forums/setups/mysqltest.php on line 11
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/virtual/site3/fst/var/www/html/forums/setups/mysqltest.php on line 13
PHP Code:
<?php require_once('Connections/seatcupra.php'); ?>
<?php
chdir("../");
error_reporting(E_ALL & ~E_NOTICE);
require_once("global.php");
$colname_rs_test = "1";
if (isset($HTTP_GET_VARS['userid'])) {
$colname_rs_test = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['userid'] : addslashes($HTTP_GET_VARS['userid']);
}
mysql_select_db($database_seatcupra, $seatcupra);
$query_rs_test = sprintf("SELECT * FROM setup_photos WHERE userid = %s", $colname_rs_test);
$rs_test = mysql_query($query_rs_test, $seatcupra) or die(mysql_error());
$row_rs_test = mysql_fetch_assoc($rs_test);
$totalRows_rs_test = mysql_num_rows($rs_test);
?>
<html>
<head>
<title>MySQL/VB Test</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php echo $row_rs_test['photo_id']; ?>,<?php echo $row_rs_test['filename']; ?>,<?php echo $row_rs_test['caption']; ?>,<?php echo $row_rs_test['userid']; ?>,<?php echo $row_rs_test['username']; ?>
</body>
</html>
<?php
mysql_free_result($rs_test);
?>
Any ideas?
04-30-2004, 05:48 PM
Hybrid Mode
