Simple MySQL Question

[OnyxChase]

This questions is probably extremely simple for one of you programming gurus out there! I'm working on an addon for my vbulletin and I'm trying to get some information from the SQL database but I am getting an entire string instead of rows.

For example: if I do $title I will get "Signature of the MonthMember of the Month" which is two rows. How can I split these rows into different variables? Or to atleast get a break line between the two?

Thanks, any help will be greatly appreciated!

$query = $db->query_read("
SELECT candvoting_nominee.boothid, candvoting_nominee.userid, candvoting_pollbooth.title, candvoting_pollbooth.candvoting_pollboothid
FROM " . TABLE_PREFIX . "candvoting_nominee as candvoting_nominee
LEFT JOIN " . TABLE_PREFIX . "candvoting_pollbooth as candvoting_pollbooth on (candvoting_nominee.boothid = candvoting_pollbooth.candvoting_pollboothid)
WHERE userid = $memberid"
);

while ($row = $db->fetch_array($query))
{

$title = $row['title'];

[Opserty]

The problem is not with your query then it sounds more like a problem with your output code. You should check (if possible) using phpMyAdmin or something of the sort, what the data looks like in the Database. If the titles are split up like "Signature of the Month" "Member of the Month" then the problem lies with your output code and not the query.

Also, on a side note, when you use the AS keyword it allows you to use a different name for reference to that table so you can say
FROM ... candvoting_nominee AS cdv_nom
Then you just use cdv_nom in the rest of your query, just to make it easier for you and make the query a bit shorter (visually)

[OnyxChase]

Ah, thanks! I appreciate your help! I got it working by changing and fizzling with my code! :)

mySQL is so complicated when you don't know what you're doing. LOL!