10,944 Topics

Member Avatar for
Member Avatar for TechySafi

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 …

Member Avatar for TechySafi
0
53
Member Avatar for kokfui

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 …

Member Avatar for anilashanbhag
0
110
Member Avatar for jmckumar

<?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>"; …

Member Avatar for jmckumar
0
150
Member Avatar for Venom Rush

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 …

Member Avatar for debasisdas
0
211
Member Avatar for JimBobUKII

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 …

Member Avatar for happytogether
0
153
Member Avatar for dschuett

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 …

Member Avatar for tinymark
0
2K
Member Avatar for jacob21

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..

Member Avatar for cwarn23
0
29
Member Avatar for vijaygupta

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

Member Avatar for tinymark
0
227
Member Avatar for mikecronauer

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

Member Avatar for mikecronauer
0
155
Member Avatar for ashvamedh

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 …

Member Avatar for davidchilders
0
207
Member Avatar for TeddyBear2155

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 …

Member Avatar for davidchilders
0
143
Member Avatar for Acute

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

Member Avatar for smantscheff
0
92
Member Avatar for klemme

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 …

Member Avatar for klemme
0
84
Member Avatar for dschuett

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 …

0
83
Member Avatar for xxreenaxx1

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"] > …

0
62
Member Avatar for patrickm129

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.: …

Member Avatar for happytogether
0
110
Member Avatar for woolm110

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 …

0
157
Member Avatar for rom.

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), …

Member Avatar for diafol
0
169
Member Avatar for klemme

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 …

Member Avatar for joban.ali
0
120
Member Avatar for adamworld

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 …

Member Avatar for adamworld
0
94
Member Avatar for devinodaniel

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 …

Member Avatar for macneato
0
204
Member Avatar for jrotunda85

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 …

Member Avatar for jrotunda85
0
114
Member Avatar for ohgee

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 …

Member Avatar for javaAddict
0
139
Member Avatar for vijaygupta

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

Member Avatar for jkon
0
154
Member Avatar for GreaseJunkie

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 …

Member Avatar for GreaseJunkie
0
255
Member Avatar for JerieLsky

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

Member Avatar for pratik_garg
0
145
Member Avatar for arsheena.alam

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!!

Member Avatar for arsheena.alam
0
126
Member Avatar for josephbeluan

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 …

Member Avatar for Jx_Man
0
121
Member Avatar for quincy.89

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

Member Avatar for debasisdas
-1
1K
Member Avatar for manutd4life

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

Member Avatar for debasisdas
0
88

The End.