Help needed.

[AdamSocial]

Basically, what I'm trying to do is create a text-only mirror of my PHP Nuke's calendar to use on cell phones. I've had a little bit of success, but I can't seem to get this right. Can someone scan my code and tell me exactly what I'm doing wrong?

<?php

$dbcnx = @mysql_connect('mysqlserver', 'myusername', 'mypass');

if (!@mysql_select_db('pittpunk')) {
 exit('<p>Unable to locate the joke ' .
     'database at this time.</p>');
}


$result1 = @mysql_query('SELECT title, categoryid, onetime_date FROM nuke_nucal_events WHERE onetime_date >= CURRENT_DATE ORDER BY `onetime_date` ASC');
if (!$result1) {
 exit('<p>Error performing query: ' . mysql_error() .
     '</p>');
}


$row = mysql_fetch_array($result1);
$row2 = mysql_fetch_array($result2);

$result2 = @mysql_query("SELECT id, title FROM nuke_nucal_categories WHERE id='$row[categoryid]' ORDER by id");
if (!$result2) {
 exit('<p>Error performing query: ' . mysql_error() .
     '</p>');
}

while ($row = mysql_fetch_array($result1))
 {
 echo 'Date: ' .$row['onetime_date']. '<br>';
 echo 'Bands Playing: '  .$row['title'].'<br>';

 echo 'Location: '  .$row2['title']. '</p>';
}


?>

All I can't figure out is how to get the results from the second SELECT statement to show up. I know I've worded this horribly, and I'm pretty new at this. If anyone could help, I'd owe you my life.

[onion2k]

Doing $row2 = mysql_fetch_array($result2); before you do the SQL query to actually create $result2 ain't never gonna work..

[Megahertza]

Try this. I don't do mysql but I aggree with onion2k and from my knowledge of it, this is my idea....

<?php 
$dbcnx = @mysql_connect /* Connect To database */ ('mysqlserver', 'myusername', 'mypass'); /* Username &password for db */
if (!@mysql_select_db('pittpunk')) { 
 exit('<p>Unable to locate the joke ' . 
     'database at this time.</p>'); 
} /* Exit connection to db on error */
$result1 = @mysql_query('SELECT title, categoryid, onetime_date FROM nuke_nucal_events WHERE onetime_date >= CURRENT_DATE ORDER BY `onetime_date` ASC'); /*Queryering db */
if (!$result1) { 
 exit('<p>Error performing query: ' . mysql_error() . 
     '</p>'); 
} /* Exit query to db on error */
$row = mysql_fetch_array($result1); /* Grabing Results from db */
$result2 = @mysql_query("SELECT id, title FROM nuke_nucal_categories WHERE id='$row[categoryid]' ORDER by id"); 
if (!$result2) { 
 exit('<p>Error performing query: ' . mysql_error() . 
     '</p>'); 
} /* Exit query to db on error */
$row2 = mysql_fetch_array($result2); /* Grabing Results from db */
while ($row = mysql_fetch_array($result1)) 
 { 
 echo 'Date: ' .$row['onetime_date']. '<br>'; 
 echo 'Bands Playing: '  .$row['title'].'<br>'; 

 echo 'Location: '  .$row2['title']. '</p>'; 
} 
?>

[AdamSocial]

Getting close... only my output is showing the location of the first event, for all events. Any ideas?