| Re: cause of error is what? [message #181585 is a reply to message #181576] |
Wed, 22 May 2013 21:05   |
Thomas 'PointedEars'
Messages: 701
Registered: October 2010
Karma:
|
Senior Member |
|
|
Scott Johnson wrote:
> On 5/22/2013 3:25 AM, Thomas 'PointedEars' Lahn wrote:
>> Scott Johnson wrote:
>>> On 5/21/2013 6:44 PM, richard wrote:
>>>> $result = mysql_query("SELECT atitle,artist,avid FROM A$year WHERE id =
>>>> $number");
>>>> if (!$result) { echo 'Could not run query: ' . mysql_error(); exit; }
>>>> $vid = mysql_fetch_row($result);
>>>>
>>>> echo $vid[0];
>>>>
>>>> }
>>>>
>>>> echo "</div>";
>>>>
>>>> ?>
>>>>
>>>
>>> *JTOL*
>>
>> -v
So, what does “JTOL” mean?
>>> I could be wrong but..
>>
>> You are. RTFMs.
>>
>> […]
>> <http://php.net/mysql_query>
>> […]
>> <http://dev.mysql.com/doc/refman/5.6/en/type-conversion.html> p.
>
> First off I have never been rude to you or anyone in this group so no
> idea why you feel you need to 'RTFM' to me, but if you have to then you
> have to.
<http://www.catb.org/~esr/faqs/smart-questions.html#not_losing>
And please quote only the relevant parts. Time and space are precious
goods.
> My original thought/idea was that if 'id' was an (int) in the Db then
> sending an empty value should not of caused a query error. But on
> elaborating on the thought, there is much more to it when not having
> $number set aside from the basic query. Stuff as simple as column set
> to not accept NULL values, etc..
I do not follow. MySQL will never see a NULL value in this case. It will
see *no* value at all, causing a MySQL syntax error.
> It was just a quick un-thought out thought (yes the existence of
> un-thought can be argued), nothing more, nothing less.
Well, I for one try to test my assumptions before I post them, thereby not
wasting other people's time with such thoughts. Many things are
conceivable; few are well-founded.
> Thanks however for expanding on the thought so as not to confuse anyone
> reading it.
You're welcome, I think.
PointedEars
--
Sometimes, what you learn is wrong. If those wrong ideas are close to the
root of the knowledge tree you build on a particular subject, pruning the
bad branches can sometimes cause the whole tree to collapse.
-- Mike Duffy in cljs, <news:Xns9FB6521286DB8invalidcom(at)94(dot)75(dot)214(dot)39>
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]