 |  |  |  |  |  |  |  |
Run time error!!!!!! Pls help...
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
•
•
Join Date: Feb 2008
Posts: 84
Reputation: 
Solved Threads: 5
Junior Poster in Training
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\PHP5\www\registration-reports-result_testnet.php on line 137
•
•
Join Date: Feb 2008
Posts: 84
Reputation:
Solved Threads: 5
Junior Poster in Training
echo "query_join=".$query_join;
$result_join=mysql_query($query_join,$link);// or die(mysql_error());
137 //while($row_join=mysql_fetch_array($result_join))
while($row_join=mysql_fetch_array($result_join))
{
$name_n=$row_join['t1.personal_name'];
echo "name from page=".$name_n;
$result_join=mysql_query($query_join,$link);// or die(mysql_error());
137 //while($row_join=mysql_fetch_array($result_join))
while($row_join=mysql_fetch_array($result_join))
{
$name_n=$row_join['t1.personal_name'];
echo "name from page=".$name_n;
$result_join is not a valid resource. Check $query_join by printing it out and executing it in phpmyadmin.
Ignorance is definitely not bliss!
*PM asking for help will be ignored*
*PM asking for help will be ignored*
•
•
Join Date: Feb 2008
Posts: 84
Reputation:
Solved Threads: 5
Junior Poster in Training
Ok Nav it is now working correctly....
But the echo statements after the query
while($row_join=mysql_fetch_array($result_join))
{
$name_n=$row_join['t1.personal_name'];
echo "name from page=".$name_n;
is not working!!!!! There is no error messages displaying.. but there is nothing printing other than the query
But the echo statements after the query
while($row_join=mysql_fetch_array($result_join))
{
$name_n=$row_join['t1.personal_name'];
echo "name from page=".$name_n;
is not working!!!!! There is no error messages displaying.. but there is nothing printing other than the query
Whats t1.personal_name ? Is t1 a table name ? If yes, then I would suggest you to use an alias for that column. For example,
That ll solve your problem.
Cheers,
Naveen
php Syntax (Toggle Plain Text)
That ll solve your problem.
Cheers,
Naveen
Last edited by nav33n; Feb 8th, 2008 at 2:29 am. Reason: Added more.
Ignorance is definitely not bliss!
*PM asking for help will be ignored*
*PM asking for help will be ignored*
|
Similar Threads
- Help when running error (VB.NET)
- what does it mean A Runtime Error? (Windows NT / 2000 / XP)
- excpetion error (C++)
- windows xp installation error!! pls help! (Troubleshooting Dead Machines)
- JSP with MySql (JSP)
- RmDir and MsChart Have Problems in XP -Pls Help (Visual Basic 4 / 5 / 6)
- Please HELP newcomer - can't find server,DNS error, page cannot be displayed (Viruses, Spyware and other Nasties)
- Help Please (Visual Basic 4 / 5 / 6)
- pls help! programs don't work, scandisk error (Windows 95 / 98 / Me)
Other Threads in the PHP Forum
- Previous Thread: Data from mysql in a 3 columns table
- Next Thread: 2 Regex Questions
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Latest PHP Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
ajax apache api array beginner binary body broken buttons cakephp checkbox class cms code cron curl database date date/time display dynamic ebooks echo email error file files folder form forms function functions google href htaccess html image include insert integration ip java javascript joomla limit link login loop mail mediawiki menu mlm msqli_multi_query multiple mysql number oop paypal pdf php phpincludeissue phpmyadmin problem query radio random recursion regex remote script search server sessions sms soap source sp space speed sql static subdomain syntax system table tag tutorial update upload url validation validator variable vbulletin video web websphere white xml youtube
