DaniWeb Forum Index > Web Development > PHP

Somebody please help me I'm going insane

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Jul 2009

Posts: 23

Reputation: Facte is an unknown quantity at this point

Solved Threads: 0

Facte

Offline

Newbie Poster

Somebody please help me I'm going insane

Oct 15th, 2009

Hi there, for the life of me I can't work out what is wrong with this script, but when it runs I get this message.

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in....

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?
 
$q6 = "select * from banners where lang = \"$_SESSION[lang]\" and section = \"top\" ORDER BY RAND() limit 1"; 
 
$r6 = mysql_query($q6) or die(mysql_error(Error5));
 
while($a6 = mysql_fetch_array( $r6 )) 
 
{ 
 
echo "$a6[content]";
 
}
 
?>
<?

$q6 = "select * from banners where lang = \"$_SESSION[lang]\" and section = \"top\" ORDER BY RAND() limit 1"; 

$r6 = mysql_query($q6) or die(mysql_error(Error5));

while($a6 = mysql_fetch_array( $r6 )) 

{ 

echo "$a6[content]";

}

?>

If anyone can help it would be greatly appreciated.

•

Join Date: Jun 2005

Posts: 60

Reputation: pclfw is an unknown quantity at this point

Solved Threads: 5

pclfw

Offline

Junior Poster in Training

Oct 15th, 2009

have you done a mysql_connect()?

•

Join Date: Jul 2009

Posts: 23

Reputation: Facte is an unknown quantity at this point

Solved Threads: 0

Facte

Offline

Newbie Poster

Oct 15th, 2009

•

Originally Posted by pclfw

have you done a mysql_connect()?

Hi, yes I have a mysql_connect() it's part of a much larger script, but this is the section it says it has a problem with.

Thanks for your help though.

•

Join Date: May 2008

Posts: 525

Reputation: Will Gresham is on a distinguished road

Solved Threads: 86

Will Gresham Will Gresham is offline

Offline

Posting Pro

Oct 15th, 2009

Try this:

Help with Code Tags

PHP Syntax (Toggle Plain Text)

$q6 = "SELECT * FROM banners WHERE lang='{$_SESSION['lang']}' AND section='top' ORDER BY RAND() LIMIT 1";

AJAX is not a programming language, scripting language or any other sort of language.
It is acheived by using JavaScript http functions.
So, AJAX = JavaScript.

•

Join Date: Oct 2009

Posts: 15

Reputation: webexpertzhere is an unknown quantity at this point

Solved Threads: 6

webexpertzhere webexpertzhere is offline

Offline

Newbie Poster

Oct 15th, 2009

Please check if this works:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$lang = $_SESSION['lang'];
 
$q6 = sprintf("SELECT * FROM banners WHERE lang='%s' AND section='top' ORDER BY RAND() LIMIT 1",mysql_real_escape_string($lang));
$lang = $_SESSION['lang'];

$q6 = sprintf("SELECT * FROM banners WHERE lang='%s' AND section='top' ORDER BY RAND() LIMIT 1",mysql_real_escape_string($lang));