DaniWeb Forum Index > Web Development > PHP

Run time error!!!!!! Pls help...

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

Thread Solved

•

Join Date: Feb 2008

Posts: 77

Reputation: jino is an unknown quantity at this point

Solved Threads: 5

jino

Offline

Junior Poster in Training

Run time error!!!!!! Pls help...

Feb 18th, 2008

Dear All,,

My php page having a search query is not displaying the result when it is loaded...

But when i check this same query in php my admin it is working correctly...

for ex: If i search with the field "Marital Status" Single... There are totol 3 records having marital status "single", but the result will be getting only of 1...

The miracle is that when i test this same query in the php myadmin then i get the full 3 records.....

This means there is no prob in mysql_connection();
Please help me i am very confused!!!!!!!!!

Jino.

•

Join Date: Nov 2007

Posts: 3,739

Reputation: nav33n is a jewel in the rough

Solved Threads: 330

nav33n

Offline

Senior Poster

Re: Run time error!!!!!! Pls help...

Feb 18th, 2008

Code please.

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: Feb 2008

Posts: 77

Reputation: jino is an unknown quantity at this point

Solved Threads: 5

jino

Offline

Junior Poster in Training

Re: Run time error!!!!!! Pls help...

Feb 18th, 2008

This is the query

$query ="SELECT SQL_CALC_FOUND_ROWS * FROM reg_personal inner join reg_english_level inner join reg_services inner join reg_status ON(reg_personal.personal_code=reg_english_level.english_code AND reg_english_level.english_code=reg_services.services_code AND reg_services.services_code=reg_status.status_code)WHERE $query_string LIMIT 0, 30";

and it is working in php myadmin correctly and not working when the page is loaded!!!!!!

///echo statements are given below..

echo"
<tr>
<td width='503' height='19'>
$row[personal_name];($row[personal_code]),$row[personal_present_address],Tel: $row[personal_phone], E-mail:
<a href='mailto

email'>
$email</a>,Joined $course_name1,$course_name2,$course_name3,  at
$eng_date - Total Paid $total_paid/-. Balance $balance/- payment $payment_date.</td>
<td width='169' height='19'>

<a href='registration-result-reports.php?id=$p_code'>Continue to Payment >></a></td>
</tr>";

waiting for ur reply.!!!
Jino.

•

Join Date: Feb 2008

Posts: 158

Reputation: richie513 is an unknown quantity at this point

Solved Threads: 11

richie513

Offline

Junior Poster

Re: Run time error!!!!!! Pls help...

Feb 18th, 2008

Hi jino, you are not returning your query. try adding this line directly after your query.

$result = mysql_query($query) or die(mysql_error());

and see if this works

Technology is just a tool. In terms of getting the kids working together and motivating them, the teacher is the most important.

richie513

•

Join Date: Nov 2007

Posts: 3,739

Reputation: nav33n is a jewel in the rough

Solved Threads: 330

nav33n

Offline

Senior Poster

Re: Run time error!!!!!! Pls help...

Feb 18th, 2008

Where is the while loop ? Let me show you an example.

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$query="select * from table";
$result=mysql_query($query);
$row=mysql_fetch_array($result); //This will fetch only 1 record
echo $row['name'];
...
//to fetch all the records, loop through it.
while($row=mysql_fetch_array($result)){
echo $row['name'];
....
}
$query="select * from table";
$result=mysql_query($query);
$row=mysql_fetch_array($result); //This will fetch only 1 record
echo $row['name'];
...
//to fetch all the records, loop through it.
while($row=mysql_fetch_array($result)){
echo $row['name'];
....
}