PHP forums, MySQL forums, Web Development resources - View topic - Problem with PHP/MySQL

Problem with PHP/MySQL - error message on line 13

WeberForums.com Forum Index -> PHP General

View previous topic :: View next topic

Author

Message

whitestream6

Joined: 14 Dec 2009
Posts: 3

Posted: Mon Dec 14, 2009 1:34 pm Post subject: Problem with PHP/MySQL - error message on line 13

I get this error in my PHP script (which is included as a file within a main PHP file):

Quote:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\www\vhosts\myradiostation.co.uk\showfile.php on line 13

This is the full code of the script (line 13 is highlighted in bold text):

Quote:

<?php
//connect to mysql
//change user and password to your mySQL name and password
mysql_connect("localhost","root","PASSWORDREMOVED");

//select which database you want to edit
mysql_select_db("myradio");

//select the table
$result = mysql_query("select * from presenters");

//grab all the content
while($r=mysql_fetch_array($result))
//the format is $variable = $r["nameofmysqlcolumn"];
//modify these to match your mysql table columns
{
$shows=$r["shows"];
$onair=$r["onair];
$images=$r["image"];
$showdesc=$r["showdesc"];
echo "<div class=\"divider\"></div>
<div class=\"main\" style=\"width:552px;\">
<img src=\"$images\" width=115 height=60>
<div class=\"time\">$onair</div>
<div class=\"show\"><h3><b>$shows</b></h3>
<p>$showdesc</p></div>
<div class=\"footer\"></div>
</div>";
}
?>

How do I fix this error myself - I have tried to look it up on Google and fix it myself, but so far I haven't had much luck!

I'm running Apache on localhost, if that's of any interest, with PHP 5.25.

lostboy

Joined: 02 May 2004
Posts: 5920
Location: toronto, canada

Posted: Mon Dec 14, 2009 5:22 pm Post subject:

Its usually an error in the query or connection. Try this

Code:

$result = mysql_query("select * from presenters") or die(mysql_error());

_________________
Lostboy

Cat, the other other white meat

Please read Posting Etiquette before posting

You can always try Google

Display posts from previous:

WeberTrivia Questions
	Think you are smart? Prove it!. Try your skills with these questions :
	Recursive arrays and multi-dimensional arrays are one and the same. (PHP and MySQL)
	The \"cache_dir\" tag of the squid configuration has a default of /var/spool/squid. (Linux)

	WeberForums.com Forum Index -> PHP General	All times are GMT + 2 Hours
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum