Hi, All.
I have a table that contains a varchar(10) column named weird_field. In this column, only integers reside (e.g., 3010101009). When I do this:
Line number On/Off | Expand/Contract select * from table where weird_field = '3010101009'
no records are returned, even though there is a record with weird_field = '3010101009'.
However, if I do this:
Line number On/Off | Expand/Contract select * from table where weird_field = 3010101009
the appropriate records are returned. I don't think this should be the case, right? Because it's a varchar column, shouldn't the 3010101009 be quoted? It's messing up some joins I'm trying to do, and I just don't get it.
Thanks
PHP Programming error. Please help!
Hi there,Am making a website for a friend and have encountered a problem that i need fixing fast.I get this error when i try to run the code below: QuotePHP Error MessageWarning: Unexpected character
mySQL and PHP search
Hello,I am trying to code a project and ran into a brick wall with one of my pages. I am pretty new at php/mySQL and can not figure this out. Now I know that you are not going to sit there and type my
Need help Updating SQL Server Express DB from c# :(
Please can anyone help with:-
Two warning messages
Quote<b>Warning</b>: mysql_real_escape_string() expects parameter 1 to be string, array given in
Trouble with a select list
Hello All! I was wondering if any of you guys could help me with a small problem I'm having!I'm trying to add a select list to a form on my webpage.The select list is generated from information
Displaying image pathname instead of image
HelloIm trying to upload and then display images from a mysql database - Its only basic and i only need one pic per user on the database hence why using mysqlI really need osme help as ive been going
split values
I have values that are returned to me in this format:name=>test,age=>49What I want to get out of this is an array like thisarray('name'=>'test','age'=>'49');I was hoping
ctype() validation - allowing illegal characters
Hello,I use ctype() to filter and validate a user form. However, I am trying to allow certain characters.Example:Code: //Validate Copay $allow = array('$', '.'); if (!empty($copay)
code help - pagination
Hi all, I have this code, basically a user logs into my site and they get this page. The problem I have is that the pagination isn't working, and I can figure out why. I dont get any errors.Can you
HeaderSelectedCssClass not working
I have an accordian where I have a drop down list in the first pane and a grid in the second pane. When the ddl selection is changed, I programatically change the selected index of the accordian to