DaniWeb Forum Index > Web Development > PHP

dosent like query

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

Thread Solved

•

Join Date: Jan 2006

Posts: 3

Reputation: alex905 is an unknown quantity at this point

Solved Threads: 0

alex905

Offline

Newbie Poster

dosent like query

Jun 17th, 2007

well here is the part of my script that is malfuctioning.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
require "config2.php";
require "config.php";
$result = mysql_query( "SELECT `sum` FROM `subs`" );
 
$sq = mysql_fetch_assoc($result);
 
 
$value = $sq['sum'];
 
$val = preg_replace('/$/', '', $value);
?>
<br>
<?php
echo $val;
 
$query = mysql_query( "SELECT title, threadid FROM `thread` WHERE forumid = '10' ORDER BY threadid LIMIT '". $val ."' , 10" );
 
while( $row = mysql_fetch_assoc( $query ) ) {
 
?>
require "config2.php";
require "config.php";
$result = mysql_query( "SELECT `sum` FROM `subs`" );

$sq = mysql_fetch_assoc($result);


$value = $sq['sum'];

$val = preg_replace('/$/', '', $value);
?>
<br>
<?php
echo $val;

$query = mysql_query( "SELECT title, threadid FROM `thread` WHERE forumid = '10' ORDER BY threadid LIMIT '". $val ."' , 10" );

while( $row = mysql_fetch_assoc( $query ) ) {

?>

i get thsi error

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in

and from the code above this is the line it is refering to

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
while( $row = mysql_fetch_assoc( $query ) ) {
while( $row = mysql_fetch_assoc( $query ) ) {

i am compleatly lost. i have no idea what so ever is wrong.

•

Join Date: Dec 2006

Posts: 160

Reputation: w_3rabi is an unknown quantity at this point

Solved Threads: 8

w_3rabi

Offline

Junior Poster

Re: dosent like query

Jun 17th, 2007

man echo the sql syntax to have a clearer view

programming is an art ,only for those who can understand it.
- th3 php wr3nch -

•

Join Date: Jun 2007

Posts: 3

Reputation: coolkartik is an unknown quantity at this point

Solved Threads: 1

coolkartik coolkartik is offline

Offline

Newbie Poster

Re: dosent like query

Jun 17th, 2007

Man have u checked the type of parameter to be passed for the function. In php just check the type u have declared for $result and $query. and check wat type mysql_querry is returning.

•

Join Date: Jan 2006

Posts: 3

Reputation: alex905 is an unknown quantity at this point

Solved Threads: 0

alex905

Offline

Newbie Poster

Re: dosent like query

Jun 17th, 2007

i found the problem. because like all good problems 2 mins after you post it you solve it yourself.

it was the config files. they contain conecxtion deatils for two diffrent dbs and if you look were they are you can see that it will run my secound query of the file config file not the secound like i wanted.

•

Join Date: Jun 2007

Posts: 3

Reputation: coolkartik is an unknown quantity at this point

Solved Threads: 1

coolkartik coolkartik is offline

Offline

Newbie Poster

Re: dosent like query

Jun 18th, 2007

man i need a small help. i m in vth sem of mca. i need some gud mini project titles. can i suggest some. i want some gud titles and which are small and effective.???