10,944 Topics
![]() | |
![]() | I wan't to check if a user is listed as permitted in a particular group. How'd you do that? Should I do something like this? [CODE]group_id | permitted_users 1 | mark,jon 2 | maria,warren,mila[/CODE] now I gotta retrieve the value of permitted_user column of a specific group then separate every … ![]() |
http://i325.photobucket.com/albums/k392/sarjan123/name.jpg hi all, for the picture above,i am currently writing a code to check if the seller_name is match with current login user name,it will show the item name in a page, i have following code now <?php $check =$_SESSION['username']; $query = "SELECT id, seller_name "; $query .= "FROM items … | |
<?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("db_ldlp", $con); $result = mysql_query("SELECT * FROM LB_table"); echo "<table border='8' color='white' > <tr> <th>Person Id</th> <th>Name</th> <th>Participant Status</th> <th>Organiztion</th> <th>Arrival Date</th> <th>Departure Date</th> <th>No Of Days</th> <th>Room Status</th> <th>Room Charge</th> <th>Registeration</th> <th>Total Expense </th> </tr>"; … | |
Hi all I've been trawling the net trying to find out how MySQL would handle partitioning if I don't specify any values for RANGE. My code is as follows: [CODE=MySQL]PARTITION BY RANGE(vehicle_id) PARTITIONS 10()[/CODE] The table will most likely end up having roughly 50 000+ records. Can anyone perhaps give … | |
Hi, I am having a few issues trying to get this to work. When I click the link delete i want the record to be deleted from MySQL if 2 parameters are true. The following is the delete link: [url]http://domain.com/records.php?url=21313[/url] So the first parameter is "url" the second will be … | |
I have a database of invoices that have multiple attachments(which are stored in a different table) per each invoice. I have it returning the row of invoices just fine. But now I want a way to click the "view" link to call a php script to open up a jquery … | |
Hi, SELECT * FROM admin INNER join category on category.cat_id=admin.cat_id where cat_id=5; showing an error. #1052 - Column 'cat_id' in where clause is ambiguous need suggestions.. | |
hello, I have build an code for opening a map in thick box but i have problem closing it ,i have to click outside a thickbox please help | |
Hi, I am trying to use AJAX to pull back mysql table information. I tried to alter an example I found (w3 schools) where they showed how use a selection table to pull a specific line out of a mysql table, using the "q" (not really sure if the "q" … | |
hey friends... i am using fedora 13... when i am trying to access a database i am getting this error-- mysql> use bgm_scr; ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'bgm_scr' --------------------------------------- i also tried accessing by switching to superuser.. but i get this error -- [CODE][user@localhost … | |
Well this is what I have done so far I ran these 2 lines first, they worked: VARIABLE g_total NUMBER VARIABLE g_prod NUMBER Next I ran these 4 lines and they worked: BEGIN :g_total := 100; :g_prod := 4; END; Then I ran these and that is when the problems … | |
Hello there, I'm selecting only one column, so if I have 20 rows in result, how to merge all these rows into [U]one row[/U] where all the rows will be [U]comma separated[/U]? Thnx in advance | |
Hey All! I am trying to update some records using forms - But something gets mixed up when I send my info to the database: [B]My form with the info I wish to update, look like this:[/B] [CODE] //Getting the info from a dropdown list, where the user has picked … | |
I know this is kind of a jquery/ajax question, but I figure it wouldn't hurt to ask here since someone may have done something similar. I have a database of invoices that have multiple attachments(which are stored in a different table) per each invoice. I have it returning the row … | |
I can read from files that are uploaded but now I would like to INSERT the data entered on the file to be inserted to mysql database. But not sure how this work. Tried to search few term and I have tested few methods. Nothing works. [CODE]<?php if ($_FILES["file"]["error"] > … | |
Hi all, I'm working on a login system for my site. But when I use mysql_num_rows I get an error [CODE]"Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/patrickm129/patthepcwizard.com/login02.php on line 25"[/CODE]. I'd really appreciate it if you would be able to solve this with me. P.S.: … | |
Hey Everyone, I'm currently creating a simple shopping cart with interaction to PayPal. I've set up a database with a table named orders. I'm using the PayPal sandbox and what I'm looking to do is to post the order details into my database on payment completion. I have a script … | |
I'm making a simple IP logger. I've tested the script, but the database doesn't seem to filling up. It could be a problem with the database format etc, details below. Otherwise, I must have made an newbie oversight in the PHP. Some fresh eyes would be greatly appreciated! id: INT(10), … ![]() | |
Hi All! I have a table with different kinds of customers information. With the code I have posted below, I want to pull out all the records from the database. When I progress to make the "create_record" page, my intention is that it should automatically be added as an extra … | |
I am working on a site and I want to be able to query the appropriate table based on their location. For example, if they input they live in NY, it should query the NY table. If they input they live in CA, it should query the CA table and … | |
I have a site the generated a row of data from MySQL db. The parent element DIV is called "enclosure". This shows up as hidden when page loads. I have a link "show/hide" that I'm using to show the data when click using jQuery. My problem: Since all the rows … | |
I keep getting the following error whenever I try to run this query on my "spot" table: [CODE]#1054 - Unknown column 'a.Longitude' in 'field list'[/CODE] The weird thing is though that the column DOES in fact exist, is spelled the same way, and has thousands of rows of data. Even … | |
On a project I am currently working on, we are supposed to differentiate between different classes of users based off their IDs (which are 10 digits). For example, one group's IDs should all start with a 9 (marking them as belonging to that group) and the other groups should start … | |
hello , I am writing a validation code in which i have validate two feilds and check if the feild username and email already exist in the database. please help | |
Hi, I've looked around and cannot find an answer to this. I want every email that comes in to a certain email address to get stripped of everything but the subject and email address and get stored into a MySQL database. First, is this possible? If so, how? If someone … | |
Hi, I'm having a problem on how to query from the following tables. Here are the tables. PATIENT: PK - PatientNo - FirstName - LastName - MiddleName - Address - Age FK - PageNo PAGE PK - PageNo BOOK PK - BookNo BOOKPAGE 'Junction Table PK - BookNo PK - … | |
Hi, I have a variable @FranchiseId declared in my stored procedure If I try the following select command, will it work???? SELECT @FranciseId=(select FranchiseName FROM franchise WHERE username=@username),username FROM MyTable I hope you Understood My problem!! | |
HI, I'm new to VB6 programming and i need some help of anyone to please help with my problem. I want to know what do I need to do or know before to create a code that connect VB6 to my SQL. and if you desire please give a sample … | |
<?php ob_start(); include("sys.php"); session_start();//when nid use session nid put tis ?> <html> <title></title><head></head> <script type="text/javascript"> function addRowToTable() { var tbl = document.getElementById('tblSample'); var lastRow = tbl.rows.length; // if there's no header row in the table, then iteration = lastRow + 1 var iteration = lastRow; var row = tbl.insertRow(lastRow); var … | |
Hello, i hav no idea abt MySQL, but i have a program with access database. Is it possible to convert it to MySQL database?? Any HELP please.. and i wanted to know also that all the code also will need to be change?? any way how should i start..?? thanks |
The End.