[Resolved] mysql_fetch_array problem

Anthony_john5

I've used mysql_fetch_array using similar code to below for quite a few script now, however for this particular script when I try to echo $author_id it merely echos author_id

while( $row = mysql_fetch_array($result) )   

		{
		$title = $row['title'];
		$content = $row['content'];
		$author = $row['author'];
		$author_id = $row['author_id'];
		$date = $row['date'];

	}

The only thing that I can think of is that there might be problems because mediumint whereas all the others are tiny or mediumtext. Is this a possibility and if so what else should I be using?

Anthony

njm

What does the SQL query look like? If it's dynamically created, try echoing it to the screen.

hth, njm

Anthony_john5

My query is

SELECT title , content , author , date, 'author_id' FROM phpbb_content_jokes WHERE id = $id LIMIT 0 , 30

and I've already tried echoing it which produces the same result!

Anthony

LordShryku

Show us all of the code there. From the SQL query down to the part where you echo the variable

Anthony_john5

<?php

include("/home/www/teenonyM/scripts/database_functions.php");
	# Open Connection
	OpenConnection();
$id = $_GET['id'];
$query = "SELECT `title` , `content` , `author` , `date`, 'author_id' 
FROM `phpbb_content_jokes` 
WHERE 1 AND `id` = $id LIMIT 0 , 30 ";
	@mysql_query($query, $connection)
		or ThrowError("error with query: " . mysql_error() . "\n\nQuery: " . $query);
			$result = mysql_query($query);
		while( $row = mysql_fetch_array($result) )   

		{
		$title = $row['title'];
		$content = $row['content'];
		$author = $row['author'];
		$author_id = $row['author_id'];
		$date = $row['date'];

	}

	?>

<html>
<head>
<title>
<?php
echo $title;
?>
</title>
<link rel="stylesheet" href="http://www.gravity.me.uk/subSilver.css" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div align="center"> 
  <p><b><a href="/forum/index.php">Home</a></b></p>
  <p><b> 
    <?php
  echo $title;
  ?>
    </b></p>
  <p> 
    <?php
  echo $content;
   ?>
  </p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>Submitted by: 
    <?php
  echo '<a href="http://www.gravity.me.uk/forum/profile.php?mode=viewprofile&u='.$author_id.'">'.$author.'</a>';
  ?>
    on 
    <?php
	echo $date;
	?>

🙂

LordShryku

author_id is in single quotes, not backticks

$query = "SELECT title , content , author , date, 'author_id'

Anthony_john5

Works perfectly thanks 😃