flashyflashy

Okay, I'm a little confused - this code works perfectly fine in mysql; however, in php it keeps repeating the first person for about 15 rows. Can someone point me to what I'm missing here. [code] $queryUsers = "SELECT user_id, zipcode, gender, housing_status, active, username FROM users WHERE user_id != …

[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 …

Hi everyone! Im actually doing my final year project which is an ecommerce application for a specific business. there is another student who is working on the MIS part of this business. we have to use the same database. I am using PHP and MySQL and he is using ASP.net …

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 { …