Ad:

PHP Discussion Thread
Marked Solved
Views: 536

Oct 15th, 2009

Somebody please help me I'm going insane

Expand Post »

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....

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.

Similar Threads

svchost.exe error in Windows NT / 2000 / XP
OMFG I need help with endless reboot cycle / freeze up... insane please help! in Windows NT / 2000 / XP
Add or Remove Programs... Removed? in Windows NT / 2000 / XP
Restarting a windows 2000 computer from the command line in Windows NT / 2000 / XP
Seti@Home in Geeks' Lounge

Facte

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

29 posts
since Jul 2009

Permalink

Oct 15th, 2009

Re: Somebody please help me I'm going insane

have you done a mysql_connect()?

pclfw

Reputation Points: 33

Solved Threads: 9

Junior Poster

Offline

132 posts
since Jun 2005

Permalink

Oct 15th, 2009

Re: Somebody please help me I'm going insane

Click to Expand / Collapse Quote 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.

Facte

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

29 posts
since Jul 2009

Permalink

Oct 15th, 2009

Re: Somebody please help me I'm going insane

Try this:

PHP Syntax (Toggle Plain Text)

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

Will Gresham

Reputation Points: 96

Solved Threads: 124

Master Poster

Offline

728 posts
since May 2008

Permalink

Oct 15th, 2009

Re: Somebody please help me I'm going insane

Please check if this works:

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));

Last edited by webexpertzhere; Oct 15th, 2009 at 1:20 pm.

webexpertzhere

Reputation Points: 11

Solved Threads: 9

Light Poster

Offline

27 posts
since Oct 2009

Permalink

Oct 15th, 2009

Re: Somebody please help me I'm going insane

That fixed the problem. Thank you very much for your help.

Facte

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

29 posts
since Jul 2009

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: PHP equivalent for unescape()

Next Thread in PHP Forum Timeline: template system

DaniWeb Message

Cancel Changes

User Name
Password