Hi Raj,
Click on the 'Structure' Tab of the table where you need to make the change. Then click on the Pencil icon against the field that you want to change. This will show you the field & it's...

Hi,
Try the following:


if ($_SESSION['MEMBER_PERM'] == "2")
{
$author = $_SESSION['MEMBER_ID'];

$sql = mysql_query("SELECT *, * FROM show_archive, shows WHERE author = $author AND...

Hi there,
One common mistake a newbie makes is using *. From your query, I can see that you are using '*' to get all the fields. Do you really need all the fields in your query? To speed it up, you...

R -> Robothy
R -> Rocks
Robothy Rocks! :icon_wink:

That did the trick for me, robothy. I am able to do the search as needed & it's producing me the correct results. It's showing me the 100%...

Hi robothy,
I tried different combination of the query. It is


$count = count($skills_arr);

$query .= " HAVING count(employee.username) >= $count";


I appended this at the end of the...

Hi robothy,
I tried out that query. I now have a Skills table & an Employee Skills table as well. In Employee Skills table, I have an Employee with skills 1, 3, 5, 7 and 9 (all odd numbers chosen...

Thanks for the query, robothy. I will try that & let you know how it goes.

Thanks much.

Hi,
But I think I might have some problems trying to pass the array values. Could you please give me the query to do that? Much appreciate if you could please do so. (I had much trouble trying to do...

Hi robothy,
Thank you once again for a fast reply. I will follow likewise for the index. But I am confused here:

SELECT `skillId` FROM `employer_skills`WHERE `employerId` = '1221'

Where is it...

Thanks to both of you guys pritaeas & robothy for taking time to post your views/findings.

To pritaeas:
I tried using FIND_IN_SET syntax & it did not produce me the right result. I selected 1, 3,...

Hi all,
I using PHP & MySql. Here's the situation:

1. I have a website which is a meeting place for employees & employers. Employees can sign up for an account & select the skills they have....