Members Login.
 

Please register HERE to be part of our Community
Contest of the Day.
 
Current Promotions.
 
Refer your friends to this forum and earn BRL per referred member.

Post a New Thread anywhere on Web Development Board to earn BRL$ 5 for every thread. Post a New Reply there and earn BRL$ 3 for every reply.

Post a New Thread anywhere on Search Engine Optimization Board and earn BRL$ 5 for every thread.
Earn By Posting
 
Participate in forum and Earn $$$.

Get Referrer Credit - BRL$ 20
Get Positive Rep Cr. - BRL$ 3
Get New Thread Cr.- BRL$ 3
Get Posting Cr. - BRL$ 2
Get Post size Credit

Full List of BRL$ Earnings
Sponsors.
 


mySQL Database Discussion related to mySQL database, mySQL queries, mySQL Commands, mySQL tutorials...

Expired Thread The thread "mysql_query statement not working !!!" has not received any replies for a month. It has been automatically closed as a result. You may start a new thread on the topic if the information in this thread is not sufficient.

Closed Thread
  #1 (permalink)  
Old 09-24-2007
Senior Member

Join Date: Jun 2007
Posts: 1,413
BRL$: 4,217.66
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 172
mr_atom is on a distinguished roadmr_atom is on a distinguished road
Default mysql_query statement not working !!!

Hi every oneI have two tables (say xx and yyy) with both sharign aa common filed, which is part_number.I wonder if you would help me correct this mysql_query statement:Code:---------$pdf = mysql_query( " SELECT * FROM pn_quark


To view links or images in this forum your post count must be 1 or greater. You currently have 0 posts.
__________________

To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 03-15-2008
Jr. Member

Join Date: Mar 2008
Posts: 263
BRL$: -134.73
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 38
mira is on a distinguished road
Default Re: mysql_query statement not working !!!

I think you should try to modify your query with

$pdf = mysql_query( " SELECT * FROM xx WHERE part_number in(select part_number from yy)) or die("Could not execute")

Hope it helps.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Closed Thread
Expired Thread The thread "mysql_query statement not working !!!" has not received any replies for a month. It has been automatically closed as a result. You may start a new thread on the topic if the information in this thread is not sufficient.



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding WHERE statement breaks pagination? Rss_Feeds PHP 0 09-06-2007 10:10 PM
Best way to check if my Affiliate link is working fine Jason Affiliate Programs 0 09-05-2007 09:56 AM
CASE Statement Rss_Feeds Oracle Database 0 07-23-2007 09:26 PM
PercentLoaded Flash in Mozilla (not working) brl_admin JavaScript 0 07-23-2007 01:10 PM
How to convert date and currency in SQL statement brl_admin ASP / ASP.NET 0 07-09-2007 04:31 AM


 

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105