[Video Gallery For Community Builder]

Hi
can anyone suggest me any video gallery plugin for community builder /joomla

[link for community builder]

hi
can any one plz suggest me some good links for community builder so tht it can be helpul in understanding its functionality
thanks

[Exporting 2 MySQL tables into an Excel Spreadsheet]

hi
wht u could do is use a query with join but u will have to specify field names in select statement

<?php
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=spreadsheet.xls");
header("Pragma: no-cache");
header("Expires: 0");

define(db_host, "localhost");
define(db_user, "root");
define(db_pass, "root");
define(db_link, mysql_connect(db_host,db_user,db_pass));
define(db_name, "person");
mysql_select_db(db_name);

$select = "SELECT general.id,name,address,hobbies,interest FROM general,interest where general.id=interest.id ";
$export = mysql_query($select);
$fields = mysql_num_fields($export);

for ($i = 0; $i < $fields; $i++) {
$header .= mysql_field_name($export, $i) . "\t";
}

while($row = mysql_fetch_row($export)) {
$line = '';
foreach($row as $value) {
if ((!isset($value)) OR ($value == "")) {
$value = "\t";
} else {
//$value = str_replace('"', '""', $value);
$value = $value . "\t";
}
$line .= $value;
}
$data .= trim($line)."\n";
}
$data = str_replace("\r","",$data);

if ($data == "") {
$data = "\n(0) Records Found!\n";
}
// print the db
echo "$header \n $data" ;
?>

[Exporting 2 MySQL tables into an Excel Spreadsheet]

wht abt the other columns are they same or diff can u tell me the schema of ur tables

[automatically synchrozing users to contact in joomla+civicrm]

hi
I have installed civicrm on joomla
i want to automatically synchronize new users who register on joomla as civicrm contact
thanks

[configuring civicrm on joomla]

i have installed civicrm on joomla1.0.11 the installation completed successfully but when i am trying to access any item frm civicrm menu
error is coming
Sorry. A non-recoverable error has occurred.

Database Error Code: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) ORDER BY name' at line 4, 1064
plz help me solve this problem
thanks
sapna

[configuring civicrm on joomla]

i have installed civicrm on joomla1.0.11 the installation completed successfully but wheni am trying to acess civicrm any page
error is coming
Sorry. A non-recoverable error has occurred.

Database Error Code: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) ORDER BY name' at line 4, 1064
thanks
sapna

[civicrm and civicspace]

can any one suggest me some helpful links regarding civic crm

[Techniques for shortening URL with passed variables...]

i think u can try url redirection (mod_redirect)

[mod_rewrite]

hi
thanks
now wht the problem i am facing is it is working on my system but not online
can i load mod_rewrite module frm my code because it is not enabled on my domain(online)
thanks
sapna

[mod_rewrite]

hi
thanks
actually i am working with the mod_rewrite for the first time
so for checking whether its working or not
i had written the following in .htaccess

RewriteEngine On
RewriteRule ^/alice\.html$ bob\.html

if user try to access alice.html bob.html should be called but its not working
thanks
sapna

[Database unlink code]

This code might help u

<?php

if (isset($_GET['ID'])) {
  $vidID = $_GET['ID'];
  $Vidfile = $_GET['ID'];
} else {
  $vidID = NULL;
  $Vidfile = NULL;
}
$query2 = "SELECT * FROM videos WHERE ID = ('$vidID')";
$result=mysql_query($query2);
while($row=mysql_fetch_array($result)
{
extract($row);
//for example if ur field name is $filename
    unlink($filename);
}

$query = "DELETE FROM videos WHERE ID = ('$vidID')";
$result = mysql_query($query);


echo "The video has been deleted.";

?>

[Database unlink code]

select code should be first then delete because if first we will delete the record then how we can find the filename

[mod_rewrite]

hi
actually wht i want is as soon as user register his homepage should be created(dynamic)
example if user registers by the name john
then he can visit his home page by the following url
http://domainname/john
thanks
sapna

[Database unlink code]

first u need to run the select query to find the name of the file then use unlink(pass the name of the variable in which file name is stored) and then delete the record

[mod_rewrite]

can anyone tell me how mod_rewrite works
actually i have uncommented the line in httpd file also but it is not woking
thanks
sapna