dharm

thank you for a quick response .. at the moment i am storing the path/filename within a database .. but i am willing to change this if necessary

Hi, can anyone give me some advice? i have a script where a user can upload images to different albums. should i upload the images under one folder or multiple sub directories? e.g. Option 1: images/imgID.jpeg (images/000123001cat.jpeg) Option 2: images/userID/imgID.jpeg (images/000123/001cat.jpeg) Option 3: images/userID/albumID/imgID.jpeg (images/000123/001/cat.jpeg) If i choose option 3 would'nt that make it difficult to manage, say if i wanted to delete or even transfer all images to a different loction, i would need to move all folders too? You advice would be much appreciated.. Thx!

yes i agree.. Another point i figured was by using the combined ID's will limit the maximum amounts of entries. so my above example would limit me to 999999 entries only whereas separate ID's can be limitless case closed (",)

Hi, bubblegum anarc, thanks for your response.. so if i had rows like.. 000001000001 000010000010 000100000100 001000001000 010000010000 and i search for $employer_ID = "000100"; employer ID LIKE '%{$employer_ID}' my return would be the one row 000100000100. could you please tell me how it would get more results then expected?

Hi, i have designed a database generally without using auto instruments.. Users have an option to create and account from 2 different options "employee" or "employer". each will be given a 6 digit account number which is stored as a CHAR(6). when both members interact, for example exchange messages, the messages table will have an unique id called id_id CHAR(12) made up from both employeeID and employerID (000001000001). Will it be ok to use the LIKE command to extract a message. so if i wanted all messages from a employee i would do this: WHERE id_id LIKE '".$employeeID."%' i have tested the structure so far with a few members interacting but i would like to get reassurance that this way of identifying rows will work on a larger scale? any advice would be much appreciated .. thank you

Hi, im having some trouble with this bit of code. im sure its an easy fix but i cnt seem to put my finger on it. $catline = "222,223,224,225,"; WHERE cat IN ('".substr(str_replace(",","','", $catline),0,-3)."') Any suggestions will be much appreciated. thx!

hummm.. will look into that. thx!!

Looks good!! i would maybe increase the font size for your headdings University Restructure, Programmes and so on.. Try a light background image (logo) it might make it look bit more busy.. 

Looks good! but maybe the login input fields may standout more with a white border?

Hi, i am having trouble with this bit of code. Im trying to get records from two different message tables "Q_Qestion" and "Msg_b". My aim is to display all New messages in Date order. But i seem to be getting all new messages displayed X 3!. Can anyone tell me where im goin wrong? thanks! $q = "SELECT q_questions.id, q_questions.date, q_questions.question, msg_b.id_project_id, msg_b.date_time, msg_b.msg FROM ".$DBprefix."msg_b, q_questions WHERE q_questions.id2_id2 LIKE '%".$row['id']."' AND(/OR not sure!) msg_b.id3_id3 LIKE '".$row['id']."%' AND msg_b.isRead='1' ORDER BY msg_b.date_time, q_questions.date"; $r = mysql_query($q); if (mysql_num_rows ($r)==0) {echo "<center>(Currently no messages!)</center><br>";} else { while ($rmsg = mysql_fetch_array($r)) { echo $rmsg['question']; } outputs: message 1 message 1 ( duplicated! this is not needed ) message 1 ( duplicated! this is not needed ) message 2 message 2 ( duplicated! this is not needed ) message 2 ( duplicated! this is not needed )

logo looks abit over powering... can we change the text size?

Is it accessible? can we change the text size?

Hi. I was wondering if anyone could help me with this jump menu.. The jump menu is part of a form that includes other fields which make up a search page. The jump menu works fine but the problem is with the other input text fields.. if for example when I input data in any of the other fields then select a option from the jump menu the page will refresh but the data from the text fields I entered will not appear.. Is there a way where I can save the data from the forms when the jump menu re-loads the page?.. Or is there a better alternative then using an old fashion jump menu ..?  Here is the code: [quote]<select name="category" onChange="window.location = this.options[this.selectedIndex].value"> <option value="search.php">Any</option> <option value="search.php?cats=1">1</option> <option value="search.php?cats=2">2</option> </select>[/quote] Any help will be much appreciated… 

Spot on mate!! thank you!!

Hi, im trying to find a way where I can get the highest profile_id number from a group of profiles owned by a particular user..The table “profiles” also contains other users profile(s). here is the part of the code im workin with: [quote] <?php $query = "Select MAX(profile_no)  from ".$DBprefix."profiles GROUP BY where pro_id='$cid'"; // $cid is the users unique account number. ?> [/quote] any help will be much appreciated .. thx!