How to display info from and Mysql table using php

Hi,


I need to pull out some info from a table in my data base using php.

PHP:

1.  
2.  
3. <?php
4. $result = mysql_query("SELECT 'giftlog.name', 'giftlog.image' FROM giftlog")
5.  
6.  
7.  
8.  
9.  
10. LEFT JOIN    gifts
11.  
12. USING (giftid)
13.  
14. WHERE    giftlog.recipientid = " . $userid"
15.  
16. ?>
17.  

This is the code but it doesnt work.....lim a noob at the whole sql/php thing.

 

Thats because you have part of the MySQL query outside of the section that is being queried.

 

You must use following code

PHP:

1.  
2. $result = mysql_query("SELECT 'giftlog.name' AS name, 'giftlog.image' AS image FROM giftlog LEFT JOIN gifts USING (giftid) WHERE giftlog.recipientid = " . $userid);
3.  
4. $row = mysql_fetch_assoc($result));
5.  
6. echo $row['name'];
7. echo $row['image'];
8.  

 

I get this -



Parse error: parse error, unexpected ')' in /home/p/i/picturest/public_html/mygifts.php on line 5

 

Any1 got any idea's

 

Sorry, I put redundant bracket.

Correct line is:

PHP:

1.  
2. $row = mysql_fetch_assoc($result);
3.  

 

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result

 

there is a problem with your $result

try this

PHP:

1.  
2. $result = mysql_query("SELECT `giftlog`.`name` AS name, `giftlog`.`image` AS image FROM `giftlog` LEFT JOIN `gifts` ON `giftlog`.`giftid` = `gifts`.`giftid` WHERE `giftlog`.`recipientid` = " . $userid);
3.  
4.  

However, i see you dont' pull any fields from the gifts table, so i can't see why you are using the LEFT JOIN

 

ok it displays nothing --which is better then an error !

 

If you can provide access to your database for example via phpMyAdmin maybe I will be able to help you.