Hi i downloaded this script and need help with the way i'm pulling up my data, because of the way the script is set up when you add extra fields it does it in a very strange way. i have 3 extra fields (webcal_site_extras) but because of the way this all works it pulls it up like so:
This is the address
1234567 - (phone number)
9 - (cal id)
This is the address
general notes - (general notes)
9 - (cal id)
This is the address
145 a4 - (map ref)
9 - (cal id)
as you can see it just makes 3 entrys instead of modifying the database. how can i combine the tree rows into just one so it would look like:
This is the address
1234567 - (phone number)
general notes - (general notes)
145 a4 - (map ref)
9 - (cal id)
this is the code i'm running:
$sql = ' SELECT webcal_entry.cal_id, webcal_entry.cal_create_by, webcal_entry.cal_date, webcal_entry.cal_time, webcal_entry.cal_duration, webcal_entry.cal_name, webcal_entry.cal_description, webcal_site_extras.cal_id, webcal_site_extras.cal_data, webcal_entry_user.cal_id, webcal_entry_user.cal_login'
. ' FROM webcal_entry'
. ' INNER JOIN webcal_site_extras ON ( webcal_entry.cal_id = webcal_site_extras.cal_id )'
. ' INNER JOIN webcal_entry_user ON ( webcal_entry_user.cal_id = webcal_entry.cal_id )'
. ' AND ('
. ' webcal_entry_user.cal_id = webcal_site_extras.cal_id'
. ' )'
. ' LIMIT 30 ';
$result = mysql_query($sql, $conn) or die(mysql_error());
while ($list = mysql_fetch_array($result)) {
echo "{$list['cal_name']} <br>";
echo "{$list['cal_data']} <br>";
echo "{$list['cal_id']} <br>";
echo "{$list['cal_description']} <br>";
echo "<br><br>";