flashyflashy

[icode]$_SESSION['user_id'][/icode], I guess this is causing problem. Try [code=php]$session_user=$_SESSION['user_id']; $queryUsers = "SELECT user_id, zipcode, gender, housing_status, active, username FROM users WHERE user_id != '" . $session_user. "' AND active = 1";[/code]

[CODE] EXPLAIN SELECT post FROM `table` WHERE id = '123' LIMIT 1[/CODE] There are 411 records in table for id=123, even though limit of 1 is forced in the syntax, explain syntax shows that there are 411 rows in the table for the above query. Does that mean mysql will …

Please be more clearer, If an user submits application what exactly has to happen? do you have to perform two functions of which one is in your php page and another in asp page of your friend? Or do you have to update two tables (or columns ) with the …

I have a table with 15,00,000 rows which has a column PERMLINK which is used in 'where' clause of my select queries. To speed up query I have used it as INDEX. What size of index is optimum for names.? and I have a new idea but don't know how …

I have multiple tables, table_a, table_b, table_c. Each having the same structure. i.e ID, title, rating, content. I'm using [code=sql](select * from table_a order by rating DESC) union (select * from table_b order by rating DESC) union (select * from table_c order by rating DESC) [/code]to list all titles from …

I'm in a situation where I have to pass javascript variable to php without redirect (no $_get[]). The code I'm working around is like [ICODE] <script> var screen_width=screen.width </script> <?php $screen_width=[B]javascript_variable[/B] ?> [/ICODE] I want to pass value of this variable to a new php variable.Please suggest me a way …

Hi I'm using the 2 pieces of code typed below to set the character set to utf8 (so that I can output russian characters on page, and then to output it on web pages. I have tried to set the character set to utf8 so that russian characters appear properly …

Can we arrange a single table in two ways within a page .? I'm in a situation where I need to arrange a single table in two ways within a page, When I test the first piece it works ,even the second piece works great when tested alone, but when …

I have 3 pages a.php ,b.php and c.php .How can I use the variable of b.php in c.php [B]a.php[/B] [ICODE]<script type="text/javascript"> var width; width = screen.width; if (width > 0) { location.href = "b.php?width=" + width; } else exit(); </script>[/ICODE] [B]b.php[/B] [ICODE]<?php if($_GET['width']) { public $screen_width; $screen_width=$_GET['width']; } else { …