[not understanding]

I disagree.  You likely have 'local host' somewhere else.

 

~juddster

[not understanding]

localhost is 1 word not 2.

 

~juddster

[not understanding]

what 's wrong with the following code ? I declared the variables in the lines above this code.

 

$connetion = mysql_connect($host $username $password)
or die("connection could not be established"); 

 

 

That is a syntax error ...

 

It should be:

$connetion = mysql_connect($host,$username,$password)
or die("connection could not be established"); 

 

Other than that we need more information about the error you are getting.

 

@dougjohnson - you are missing a $ in front of password.

 

~juddster

[SQL INSERT]

You used the wrong quotes inside your query.  It should be ' not ".

 

~juddster

[SQL INSERT]

You are missing an ending " after your $q line.  As well as is $id numeric or a string?  If it is a string, then you need it in quotes ('').

 

Otherwise we need more information about the error.

 

~juddster

[Search from Multiple Table Query]

I agree entirely

 

~juddster

[Auto populate multiple list box..]

That is correct.  You should be sending back the id and comparing against it.  If the value isn't matching (and then adding the 'selected' attribute in) then that is where your problem may lie.

 

~juddster

[how to select multi tables]

SELECT User, credits, links
FROM table1 t1
JOIN table2 t2 ON t1.User = t2.user
WHERE t1.credits > 0

 

~juddster

 

 

Column 'credits' in field list is ambiguous

 

Not according to the table definition you provided us.

 

Please do not skip small details when providing us information because it just makes the responses you get back not as useful as they can be.

 

SELECT t1.User, t1.credits, t2.links
FROM table1 t1
JOIN table2 t2 ON t1.User = t2.user
WHERE t1.credits > 0 

 

[Auto populate multiple list box..]

If you look at it, after you select a value from the first drop down list and it auto posts back, the drop down list is back to 'Brand' which isn't correct.  As I mentioned you need to change the condition where you are marking it as selected to be based on the ID rather than the name because that is the value being returned.

 

Because of this, you are seeing the issue you mentioned.

 

~juddster

[how to select multi tables]

SELECT User, credits, links
FROM table1 t1
JOIN table2 t2 ON t1.User = t2.user
WHERE t1.credits > 0

 

~juddster

[Inner Join failed]

This is now because you are CROSS JOINing the results from all of your tables.

 

If you cross join against 3 tables each with 10 rows you are getting 1000 rows in your result set.  So given each table is larger than 10 rows that is why it is taking forever to return.

 

The LEFT JOINs all the way down except for against the KidsStudent table is the correct approach however, you just need to make sure your query is correct.

 

~juddster

[Search from Multiple Table Query]

On the separate pages you would grab where a specific news type is set.

 

SELECT * FROM knews_local WHERE summary LIKE '%keyword%'
UNION
SELECT * FROM knews_mnews WHERE summary LIKE '%keyword%'

[how to select multi tables]

If you add the SUM that fenway suggested then it'll return one row again and work however it is not user specific.

 

~juddster

[Auto populate multiple list box..]

$Brand_N == $row["Brand_N"]? " selected" : ""

 

That should be looking at the Brand_Id because that is the value that gets submitted.

 

~juddster

[Auto populate multiple list box..]

Please expand ...

 

~juddster

[Auto populate multiple list box..]

$sql = "SELECT * FROM products WHERE Brand_id = $Brand_id ";

 

That $Brand_id should be $Brand_N.

 

~juddster

[Auto populate multiple list box..]

Post updated code?

 

~juddster

[Auto populate multiple list box..]

Huh?

[Auto populate multiple list box..]

<select name="brand" onChange="autoSubmit();"> 

 

Please Note: lowercase "brand" as in the name attribute of the select box.

 

~juddster

[Auto populate multiple list box..]

add

print_r ( $_POST );

to your code and you can see everything being posted.

 

Edit: I said $_POST [ 'brand' ] not $_POST [ 'Brand' ] ... please note ... the array is case sensitive.

 

~juddster

[Auto populate multiple list box..]

$_POST [ 'Brand_N' ] should be referenced as $_POST [ 'brand' ] since that is the name of the drop down list being submitted.

 

~juddster

[Auto populate multiple list box..]

In your previous code you had:

 

<select name="brand" onChange="autoSubmit();"> 

 

PHP uses this name when posted in the $_POST array.  Because of that, you should be looking for $_POST['brand'] instead of $_POST['Brand_N'].

 

~juddster

[Auto populate multiple list box..]

Now you aren't setting the variables.  All you needed to change in your last post was the posted value you were looking for (i.e. 'Brand_N' to 'brand').  To get that value.

 

~juddster

[Auto populate multiple list box..]

Your select for brand's name is 'brand' not 'Brand_N', so the value will never be viewed as posted.

 

~juddster

[Nede help with Select WHERE]

Your query is wrong ... using ' instead of `.

 

$db="SELECT * FROM `$tble` WHERE `b1#` = '{$b1_num}' AND`c1#` = '{$c1_num}'" ;
$db="SELECT * FROM `$tble` WHERE `a1#` = '{$a1_num}' AND `b1#` = '{$b1_num}'  AND  `c1#` = '{$c1_num}'" ;

 

~juddster